Unknown data type: "TINYINT"

[lgur...@gmail.com]

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] HY004/50004 (Help)

Thanks,

Len

[Andrei Tokar]

Does it work for you if CREATE statement is executed directly from web console?
I was not able to reproduce it.

[Evgenij Ryazanov]

TINYINT is disallowed in PostgreSQL mode since 1.4.197 because PostgreSQL does not have such data type. The smallest integer data type in PostgreSQL is smallint.

https://www.postgresql.org/docs/current/static/datatype-numeric.html

So you should either use normal mode instead of PostgreSQL one or use only data types that are supported by PostgreSQL if you need this mode.

[lgur...@gmail.com]

Thanks, Evgenij!

It makes sense now.