Starting number for a sequence wburzyns Wed Feb 15 14:01:42 2012
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.