#366 mysql script - unexpected token: UNSIGNED : line: 3

[Sergio Lissner]

hsqldb 2.7.2

I'm trying to create a table in a db and I've got an error:

PUBLIC.PUBLIC> create table mh_ids
(
ID int unsigned NOT NULL PRIMARY KEY,
STUB varchar(1) null
)
[2023-09-29 10:10:15] [42581][-5581] unexpected token: UNSIGNED : line: 3

my url is
jdbc:hsqldb:file:db/mh;ifexists=true;close_result=true;sql.syntax_mys=true;

is there some limitation on using mysql script?

[Fred Toussi]

Just don't use UNSIGNED as it is not supported in most database engines.

[Fred Toussi]

Ticket moved from /p/hsqldb/bugs/1690/