db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-5121) Data corruption when executing an UPDATE trigger
Date Tue, 22 Mar 2011 16:29:05 GMT

     [ 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

Mime
View raw message