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