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

        Issue Links

          Activity

          No work has yet been logged on this issue.

            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