I don't know since it predates my involvement with H2, but I'm guess it was added for compat with SQL-Server. see: http://msdn.microsoft.com/en-us/library/ms190315.aspx
Based on that description, it seems to be working largely correctly. On 2014-07-03 04:48 PM, cowwoc wrote:
Thank you. I assume SCOPE_IDENTITY() was added for compatibility with other databases. Is this behavior (only reflecting sequence values) consistent with that? Or do you need to open a bug report to improve its compatibility? (I'm happy to simply use IDENTITY() but others might care) Gili
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
