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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/6ffc9208-d6b6-4953-978e-94afcc387324n%40googlegroups.com.
