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 Wed, 30 Mar 2011 19:48: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: Test_5121_Upgrade.java

Attaching Test_5121_Upgrade.java. This is a modification of the previous test of column subsets
and permutations. This splits the schema creation apart from the DML so that the schema can
be created under 10.7 and the UPDATE statements and trigger-firings can be tested under 10.8.

To run this test, do the following:

1) Create the schema by setting your classpath to include the 10.7 jars. Delete the db database.
Then do the following to create the schema for 3 column tables:

java Test_5121_Upgrade "jdbc:derby:db;create=true" 3 false

2) Now set your classpath to include the 10.8 jars. Test trigger-firing after soft-upgrade
by doing the following:

java -Dderby.database.allowPreReleaseUpgrade=true Test_5121_Upgrade "jdbc:derby:db" 3 false

I have verified that Mamta's latest patch fixes the soft-upgrade problem for 1, 2, 3, and
4 column tables.

> 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_NotReadForCommit_patch3_trunk_diff.txt,
DERBY_5121_NotReadForCommit_patch4_trunk_diff.txt, DERBY_5121_backoutDerby1492_changes_patch3_trunk_diff.txt,
DERBY_5121_patch2_trunk_diff.txt, DummyProc.java, Proc_5121.java, Test_5121.java, Test_5121_Upgrade.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