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/fadca281-3313-49b7-a4f3-11fa7e5ccb15n%40googlegroups.com.

Reply via email to