Identity Column Jumps Randomly
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.
IDENTITY COLUMN JUMPING BY 32
Hi all, H2 is very fast and fantastic to work. I recently upgraded H2 1.3.168. And converted all my auto_increment columns to Identity(). I have tables with identity column and I am using scope_identity() to get the value, since I am using triggers. Some occasions, the identity column generating is incrementing by 32 and randomly sometimes. Can anyone help me solve this issue. ? Advance thanks and regards, Anand Jashveer -- 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/-/EcusiDoq3y0J. 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.