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'.

      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:
              Mamta A. Satoor
              Reporter:
              Rick Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development