Two clarifications: 1. I am using version 1.3.176. 2. This behavior contradicts the documentation: http://www.h2database.com/html/datatypes.html#bigint_type
Please also take this opportunity to clarify the difference between IDENTITY and BIGINT in the documentation. As far as I understand it, IDENTITY is equivalent to "BIGINT AUTO_INCREMENT PRIMARY KEY" but it's not clear if there are any other differences. For example, the documentation reads "Used values are never re-used, even when the transaction is rolled back" for IDENTITY but not for BIGINT AUTO_INCREMENT so it's not clear if there is some magic under the hood. Gili On Friday, August 29, 2014 4:53:16 PM UTC-4, Gili wrote: > > Hi, > > If I run: > > CREATE TABLE connection (id BIGINT AUTO_INCREMENT(-9223372036854775808, > 1) PRIMARY KEY); > > I get: > > Syntax error in SQL statement "CREATE TABLE CONNECTION (ID BIGINT > AUTO_INCREMENT(-9223372036854775808[*], 1) PRIMARY KEY)"; expected "long" > > I've successfully initialized all other types at their minimum values. > BIGINT seems to be the only type that has a problem with this. > > 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.