upgrade to 2.0.202 ARRAY issue

pieter...@gmail.com

unread,

Dec 21, 2021, 3:22:50 AM12/21/21

to H2 Database

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

pieter...@gmail.com

unread,

Dec 21, 2021, 4:07:41 AM12/21/21

to H2 Database

Never mind, I read the documentation correctly this time, arrays are typed now.

Marcello Rinaldo Martina

unread,

Jan 17, 2022, 7:44:01 AM1/17/22

to H2 Database

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.