db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (Created) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5493) Same value returned by successive calls to a sequence generator.
Date Mon, 07 Nov 2011 13:58:51 GMT
Same value returned by successive calls to a sequence generator.
----------------------------------------------------------------

                 Key: DERBY-5493
                 URL: https://issues.apache.org/jira/browse/DERBY-5493
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.8.2.2, 10.8.1.2, 10.7.1.1, 10.6.2.1, 10.6.1.0, 10.9.0.0
            Reporter: Rick Hillegas


The following script shows the same value being returned from a sequence generator by two
successive NEXT VALUE FOR calls. Thanks to Knut for finding this:

connect 'jdbc:derby:memory:db;create=true';

create table t (x int);
create sequence s;
autocommit off;
select count(*) from sys.syssequences with rs;
values next value for s;
drop table t;
rollback;

-- same value as previous call
values next value for s; 


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message