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-6553) Sequence generator makes CREATE TRIGGER fail with internal error
Date Mon, 19 May 2014 17:52:38 GMT

     [ https://issues.apache.org/jira/browse/DERBY-6553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Rick Hillegas updated DERBY-6553:
---------------------------------

    Attachment: derby-6553-01-aa-verifyFix.diff

It appears that this bug has been fixed by the work on DERBY-6554.

Attaching derby-6553-01-aa-verifyFix.diff. This adds test cases for the repros for this bug.

Touches the following file:

M       java/testing/org/apache/derbyTesting/functionTests/tests/lang/SequenceGeneratorTest.java


> Sequence generator makes CREATE TRIGGER fail with internal error
> ----------------------------------------------------------------
>
>                 Key: DERBY-6553
>                 URL: https://issues.apache.org/jira/browse/DERBY-6553
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.11.0.0
>            Reporter: Knut Anders Hatlen
>         Attachments: derby-6553-01-aa-verifyFix.diff, derby.log
>
>
> I'm seeing this on trunk:
> {noformat}
> ij version 10.11
> ij> connect 'jdbc:derby:memory:db;create=true';
> ij> create table t1(x int, y int, z int);
> 0 rows inserted/updated/deleted
> ij> create table t2(x int, y int, z int);
> 0 rows inserted/updated/deleted
> ij> create sequence seq;
> 0 rows inserted/updated/deleted
> ij> values next value for seq;
> 1          
> -----------
> -2147483648
> 1 row selected
> ij> create trigger tr1 after insert on t1 insert into t2(x) values (next value for
seq);
> ERROR 40XT8: An internal error was identified by RawStore module. Internal state detail
from the transaction is as follows: savedEndStatus = 0
> needSync = false
> justCreated = false
> myGlobalId = null
> myId = null
> state = 0
> inComplete = null
> seenUpdates = false
> inPostCommitProcessing = false
> logStart = null
> logLast = null
> recoveryTransaction = false
> postCompleteMode = false
> sanityCheck_xaclosed = false
> transName = UserTransaction
> readOnly = false
> flush_log_on_xact_end = true
> backupBlocked = false
> dontWaitForLocks = false
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message