Thanks for your explanation. Obviously, syntax check has been more lenient in previous releases.
Evgenij Ryazanov schrieb am Donnerstag, 3. Februar 2022 um 01:34:40 UTC+1: > Hello! > > INT GENERATED BY DEFAULT AS IDENTITY should be used for identity column of > INT (INTEGER) data type. Additional NOT NULL clause isn't needed, but may > be specified. H2 intentionally supports this standard-compliant syntax in > all compatibility modes to have possibility to use the same syntax in all > of them. > > INT IDENTITY is a syntax from SQL Server, H2 supports it only in > MSSQLSERVER and LEGACY compatibility modes. You can't use in in any other > mode. > https://h2database.com/html/features.html#compatibility > > LEGAGY mode is based on REGULAR modes, but it is less restrictive and > provides better compatibility with H2 1.4.200. You can use it if you can't > change definition of your table. > -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/6ffc9208-d6b6-4953-978e-94afcc387324n%40googlegroups.com.
