I have several script creating tables in a database. Was ok in 200, broken in 1056/210.
a Syntax Error is thrown: Syntax error in SQL statement "create table persons (mstb_per_no int [*]identity not null, mstb_father int, mstb_mother int, mstb_last_edit date, mstb_dsid int, mstb_ref_id int, mstb_reference varchar(12), mstb_spoulast int, mstb_scbuff varchar(10), mstb_pbirth varchar(30), mstb_pdeath varchar(30), mstb_relate int, mstb_relatefo int, mstb_tt varchar(1), mstb_sex varchar(1), mstb_living varchar(1), mstb_birthorder varchar(2), mstb_multibirth varchar(1), mstb_adopted varchar(1), mstb_ance_int varchar(1), mstb_desc_int varchar(1))"; expected "ARRAY, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, ON, NOT, NULL, AUTO_INCREMENT, DEFAULT, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, COMMENT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, AUTO_INCREMENT, ,, )"; SQL statement: create table persons (mstb_per_no int identity not null, mstb_father int, mstb_mother int, mstb_last_edit date, mstb_dsid int, mstb_ref_id int, mstb_reference varchar(12), mstb_spoulast int, mstb_scbuff varchar(10), mstb_pbirth varchar(30), mstb_pdeath varchar(30), mstb_relate int, mstb_relatefo int, mstb_tt varchar(1), mstb_sex varchar(1), mstb_living varchar(1), mstb_birthorder varchar(2), mstb_multibirth varchar(1), mstb_adopted varchar(1), mstb_ance_int varchar(1), mstb_desc_int varchar(1)) [42001-210] -- 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/8e7bbfe2-a5f7-4375-ad21-b18d27210127n%40googlegroups.com.
