I updated to the latest H2 (h2-1.4.197) and now my existing create table script is failing. It is working with h2-1.4.196.
Unknown data type: "TINYINT"; SQL statement: create cached table VEHICLE ( VEHICLE_ID int not null, VIN varchar(255) not null, VEHICLE_TYPE_ID int not null, VEHICLE_CODE varchar(50) not null, LICENSE_PLATE varchar(30) default 'N/A' null, VEHICLE_COLOR varchar(30) null, VEHICLE_YEAR smallint null, VEHICLE_MAKE varchar(30) null, VEHICLE_MODEL varchar(30) null, INSPECTED_DATE date null, REGISTRATION_EXPIRE_DATE date null, PASSENGERS tinyint null, constraint PK_VEHICLE primary key (VEHICLE_ID), ) [50004-197] <http://localhost:8082/query.do?jsessionid=8845b00d7ad5662d1b8a2b5de6208f63#> HY004/50004 (Help) <http://h2database.com/javadoc/org/h2/api/ErrorCode.html#c50004> <http://h2database.com/javadoc/org/h2/api/ErrorCode.html#c50004> <http://h2database.com/javadoc/org/h2/api/ErrorCode.html#c50004> Thanks, <http://h2database.com/javadoc/org/h2/api/ErrorCode.html#c50004> Len <http://h2database.com/javadoc/org/h2/api/ErrorCode.html#c50004> -- 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 post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
