derby's CREATE SEQUENCE statement

[john netzel <jo...@gmail.com>]

>From what I see, the sequence statements count every time
a prepared statement that has squence impeded in it, is built.  It would be
nice if this was in the Derby Reference Manual.

Re: derby's CREATE SEQUENCE statement

[Knut Anders Hatlen <kn...@oracle.com>]

john netzel <jo...@gmail.com> writes:

> From what I see, the sequence statements count every time
> a prepared statement that has squence impeded in it, is built.  It
> would be nice if this was in the Derby Reference Manual. 

Hi John,

I don't think the sequences are intended to be incremented each time a
statement is prepared, so you may have come across a bug. It would be
great if you could file a bug at
https://issues.apache.org/jira/browse/DERBY and post the steps needed to
reproduce the behaviour you're seeing.

For the record, I ran a simple test in my environment by executing
"create sequence s" and then compiling the statement "values next value
for s" repeatedly without seeing that the value of the sequence changed.

Thanks,
-- 
Knut Anders