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