[jira] [Created] (DERBY-6553) Sequence generator makes CREATE TRIGGER fail with internal error

["Knut Anders Hatlen (JIRA)" <ji...@apache.org>]

Knut Anders Hatlen created DERBY-6553:
-----------------------------------------

             Summary: 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


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)