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

Data corruption when executing an UPDATE trigger

    XMLWordPrintableJSON

    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
          Richard N. Hillegas
        2. 5121_upgrade.sql
          0.1 kB
          Richard N. 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
          Richard N. Hillegas
        9. DummyProc.java
          0.2 kB
          Richard N. Hillegas
        10. Proc_5121.java
          0.2 kB
          Richard N. Hillegas
        11. releaseNote.html
          4 kB
          Richard N. Hillegas
        12. releaseNote.html
          4 kB
          Mamta A. Satoor
        13. Test_5121_Upgrade.java
          20 kB
          Richard N. Hillegas
        14. Test_5121.java
          17 kB
          Richard N. Hillegas
        15. triggerBug.sql
          0.7 kB
          Richard N. Hillegas
        16. triggerBug.sql
          0.8 kB
          Richard N. Hillegas
        17. triggeredBug2.sql
          0.8 kB
          Richard N. Hillegas
        18. triggeredCorruption.sql
          0.7 kB
          Richard N. Hillegas

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: