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, 29 Mar 2011 19:56: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: 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

Mime
View raw message