Hi,
This is explained in the docs for create sequence:
http://h2database.com/html/grammar.html#create_sequence
While inserting, many times, the identity columns jumps by 32 and random
sometimes.
It should only jump when you kill the process or on power failure. Unless
it's a bug, in which case you need to provide a simple, complete,
reproducible test case program (not just a textual description).
Regards,
Thomas
On Tue, Oct 2, 2012 at 1:33 PM, Jashveer Anand jashveeran...@gmail.comwrote:
Hi,
H2 is very fast, and really fantastic to work.
Recently, I migrated to 1.3.168 and changed all my auto_increment columns
to Identity.
I am using scope_identity() to get the primary key created and also have
trigger for that table.
While inserting, many times, the identity columns jumps by 32 and random
sometimes.
Please help.
Jashveer Anand
--
You received this message because you are subscribed to the Google Groups
H2 Database group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/oueR3k9SNpgJ.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.