[
https://issues.apache.org/jira/browse/DERBY-5121?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rick Hillegas updated DERBY-5121:
---------------------------------
Attachment: 5121_upgrade.sql
5121_create.sql
Proc_5121.java
Attaching a repro for the new problem I am seeing. I haven't had time to trim
this down to a smaller case, but I wanted to get this posted quickly Before
running this repro, first compile Proc_5121.java. Then do the following:
1) Using 10.7.1.1, run 5121_create.sql through ij. This will create a 10.7
database with a table which has a bad update trigger. The last statement in the
script fails--it is the original statement which disclosed the original problem.
2) Using the trunk, run 5121_upgrade.sql through ij. You will have to set
-Dderby.database.allowPreReleaseUpgrade=true in order to get the soft upgrade
to run. The script contains one command, namely, the statement which disclosed
the original problem. Now this statement fails with the following error:
ERROR 38000: The exception 'java.sql.SQLException: Column '6' not found.' was
thrown while evaluating an expression.
ERROR S0022: Column '6' not found.
> Data corruption when executing an UPDATE trigger
> ------------------------------------------------
>
> Key: DERBY-5121
> URL: https://issues.apache.org/jira/browse/DERBY-5121
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.7.1.1, 10.8.0.0
> Reporter: Rick Hillegas
> Assignee: Mamta A. Satoor
> Labels: derby_triage10_8
> Attachments: 5121_create.sql, 5121_upgrade.sql,
> DERBY_5121_backoutDerby1492_changes_patch3_trunk_diff.txt,
> DERBY_5121_patch2_trunk_diff.txt, DummyProc.java, Proc_5121.java,
> Test_5121.java, derby-5121-01-aa-runTimeRemapping.diff,
> derby5121_patch1_diff.txt, releaseNote.html, triggerBug.sql, triggerBug.sql,
> triggeredBug2.sql, triggeredCorruption.sql
>
>
> 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'.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
