You're correct. BTW this behavior is described in the CURRVAL() documentation on the H2 website - that's why I removed my original posting. My fault that I haven't RTFM first.
On Feb 16, 5:55 am, cowwoc <[email protected]> wrote: > My guess: a sequence's initial number denotes the number you'll get > the next time you ask the sequence for a number. You ask a sequence for > a number using NEXTVAL(), not CURRVAL() which is why you're getting N-1. > > Gili > > On 15/02/2012 5:04 PM, wburzyns wrote: > > > > > > > > > As of h2-1.3.162 if I do (substitute a non-negative integer for N, > > e.g. 5): > > > CREATE SEQUENCE IF NOT EXISTS A_SEQ_NAME START WITH N > > > then the created sequence starts with a value that is not N but N - 1; > > see a dump from H2 web console on jdbc:h2:mem:test below: > > ----- > > CREATE SEQUENCE IF NOT EXISTS A_SEQ_NAME START WITH 5; > > CALL CURRVAL('A_SEQ_NAME'); > > CURRVAL('A_SEQ_NAME') > > 4 > > (1 row, 0 ms) > > ----- > > > Isn't it a bug? I'd expect the sequence to return N instead of N - 1, > > e.g. as specified > > here:http://msdn.microsoft.com/en-us/library/ff878091%28v=sql.110%29.aspx > > ("START WITH<constant> The first value returned by the sequence > > object."). -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
