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 <[email protected]>wrote: > 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 [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. > -- 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.
