[h2] H2 Performance Windows vs Linux

2021-12-21 Thread Andreas Reichel
Greetings, incidentally I stumbled over a performance comparison related to H2 on Windows vs Linux:  https://www.phoronix.com/scan.php?page=article=ryzen7pro-windows-linux=3 The difference looks relevant to me and I am curios to ask: Any idea why there is such a difference? I would actually

[h2] Re: upgrade to 2.0.202 ARRAY issue

2021-12-21 Thread pieter...@gmail.com
Never mind, I read the documentation correctly this time, arrays are typed now. On Tuesday, 21 December 2021 at 10:22:50 UTC+2 pieter...@gmail.com wrote: > Hi, > > Running > > CREATE TABLE "PUBLIC"."V_Person" ("ID" IDENTITY NOT NULL PRIMARY KEY, > "age" ARRAY); > > fails with > >

[h2] upgrade to 2.0.202 ARRAY issue

2021-12-21 Thread pieter...@gmail.com
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