[
https://issues.apache.org/jira/browse/DERBY-6553?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13980865#comment-13980865
]
Knut Anders Hatlen commented on DERBY-6553:
-------------------------------------------
The same CREATE TRIGGER statement does not fail on head of 10.10, so it looks
as if this is a regression in trunk.
The CREATE TRIGGER statement does not fail on trunk if no value has been
fetched from the sequence generator first. That is, if the "values next value
for seq" statement is commented out in the repro, CREATE TRIGGER does not raise
this error.
> 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)
