Hi, I'm pushing to update this page https://h2database.com/html/migration-to-v2.html that contains the changes and things to consider when updating to v2. Can you have a look on that? If you have new findings, can you contribute them? ( https://github.com/h2database/h2database/blob/master/h2/src/docsrc/html/migration-to-v2.html) I think it would be really helpful for the community.
Best, Marcello Il giorno martedì 21 dicembre 2021 alle 10:07:41 UTC+1 [email protected] ha scritto: > Never mind, I read the documentation correctly this time, arrays are typed > now. > > On Tuesday, 21 December 2021 at 10:22:50 UTC+2 [email protected] wrote: > >> Hi, >> >> Running >> >> CREATE TABLE "PUBLIC"."V_Person" ("ID" IDENTITY NOT NULL PRIMARY KEY, >> "age" ARRAY); >> >> fails with >> >> Syntax error in SQL statement "CREATE TABLE ""PUBLIC"".""V_Person"" >> (""ID"" IDENTITY NOT NULL PRIMARY KEY, \000a\0009""age"" ARRAY[*]);"; >> expected "IDENTITY, data type"; SQL statement: >> CREATE TABLE "PUBLIC"."V_Person" ("ID" IDENTITY NOT NULL PRIMARY KEY, >> "age" ARRAY); [42001-202] >> >> This work on 1.4.200, >> Can someone show me the correct syntax please? >> >> The same sql works for other data types. >> >> Thanks >> Pieter >> > -- 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/4029327d-9d6d-4d18-8904-1ef88fcdc637n%40googlegroups.com.
