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

Data corruption when executing an UPDATE trigger

    Details

    • Urgency:
      Blocker
    • Issue & fix info:
      Release Note Needed, Repro attached
    • Bug behavior facts:
      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
          Rick Hillegas
        2. Test_5121_Upgrade.java
          20 kB
          Rick 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
          Rick Hillegas
        6. 5121_create.sql
          1 kB
          Rick Hillegas
        7. Proc_5121.java
          0.2 kB
          Rick 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
          Rick Hillegas
        11. DERBY_5121_patch2_trunk_diff.txt
          4 kB
          Mamta A. Satoor
        12. Test_5121.java
          17 kB
          Rick Hillegas
        13. derby5121_patch1_diff.txt
          4 kB
          Mamta A. Satoor
        14. triggeredBug2.sql
          0.8 kB
          Rick Hillegas
        15. triggeredCorruption.sql
          0.7 kB
          Rick Hillegas
        16. triggerBug.sql
          0.7 kB
          Rick Hillegas
        17. triggerBug.sql
          0.8 kB
          Rick Hillegas
        18. DummyProc.java
          0.2 kB
          Rick Hillegas

          Issue Links

            Activity

              People

              • Assignee:
                mamtas Mamta A. Satoor
                Reporter:
                rhillegas Rick Hillegas
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: