[
https://issues.apache.org/jira/browse/DERBY-5121?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rick Hillegas updated DERBY-5121:
---------------------------------
Attachment: derby-5121-01-aa-runTimeRemapping.diff
Attaching derby-5121-01-aa-runTimeRemapping.diff. This patch remaps columns at
run time in order to fix the bug. I think this at least demonstrates the
feasibility of column remapping. An improvement on this patch would be to
calculate the remapping at compile time rather than run time.
Some trickiness is involved because some of the compiled column maps are
0-based and others are 1-based. I have run Test_5121 on this patch and it
passes cleanly for 1, 2, 3, and 4 column tables. I stopped running experiments
then because the 4 column table gave rise to 61440 test cases.
I will run the full regression suite to see if that shows any problems.
Touches the following files:
M
java/engine/org/apache/derby/impl/sql/execute/TemporaryRowHolderResultSet.java
M java/engine/org/apache/derby/impl/sql/execute/InsertResultSet.java
M java/engine/org/apache/derby/impl/sql/execute/GenericTriggerExecutor.java
M java/engine/org/apache/derby/impl/sql/execute/TriggerEventActivator.java
M
java/engine/org/apache/derby/impl/sql/execute/StatementTriggerExecutor.java
M java/engine/org/apache/derby/impl/sql/execute/DeleteResultSet.java
M java/engine/org/apache/derby/impl/sql/execute/RowTriggerExecutor.java
M java/engine/org/apache/derby/impl/sql/execute/UpdateResultSet.java
> 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: DERBY_5121_patch2_trunk_diff.txt, DummyProc.java,
> Test_5121.java, derby-5121-01-aa-runTimeRemapping.diff,
> derby5121_patch1_diff.txt, 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
