Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5121

Data corruption when executing an UPDATE trigger

    XMLWordPrintableJSON

Details

    • Blocker
    • Release Note Needed, Repro attached
    • Data corruption, Regression, Seen in production

    Description

      When executing an UPDATE trigger, the following error is raised. I will attach a test case:

      ERROR XCL12: An attempt was made to put a data value of type 'org.apache.derby.impl.jdbc.EmbedClob' into a data value of type 'INTEGER'.

      Attachments

        1. releaseNote.html
          4 kB
          Richard N. Hillegas
        2. Test_5121_Upgrade.java
          20 kB
          Richard N. Hillegas
        3. DERBY_5121_NotReadForCommit_patch4_trunk_diff.txt
          6 kB
          Mamta A. Satoor
        4. DERBY_5121_NotReadForCommit_patch3_trunk_diff.txt
          1 kB
          Mamta A. Satoor
        5. 5121_upgrade.sql
          0.1 kB
          Richard N. Hillegas
        6. 5121_create.sql
          1 kB
          Richard N. Hillegas
        7. Proc_5121.java
          0.2 kB
          Richard N. Hillegas
        8. releaseNote.html
          4 kB
          Mamta A. Satoor
        9. DERBY_5121_backoutDerby1492_changes_patch3_trunk_diff.txt
          12 kB
          Mamta A. Satoor
        10. derby-5121-01-aa-runTimeRemapping.diff
          13 kB
          Richard N. Hillegas
        11. DERBY_5121_patch2_trunk_diff.txt
          4 kB
          Mamta A. Satoor
        12. Test_5121.java
          17 kB
          Richard N. Hillegas
        13. derby5121_patch1_diff.txt
          4 kB
          Mamta A. Satoor
        14. triggeredBug2.sql
          0.8 kB
          Richard N. Hillegas
        15. triggeredCorruption.sql
          0.7 kB
          Richard N. Hillegas
        16. triggerBug.sql
          0.7 kB
          Richard N. Hillegas
        17. triggerBug.sql
          0.8 kB
          Richard N. Hillegas
        18. DummyProc.java
          0.2 kB
          Richard N. Hillegas

        Issue Links

          is broken by

          Bug - A problem which impairs or prevents the functions of the product. DERBY-1482 Update triggers on tables with blob columns stream blobs into memory even when the blobs are not referenced/accessed.

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              mamtas Mamta A. Satoor
              rhillegas Richard N. Hillegas
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: