Repository navigation
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "UNIQUE" "UNIQUE" #1893
Description
I tried using 3 versions: 4.5, 4.6, 4.7.
I want to get table name from this sql:
CREATE TABLE `sys_user`
(
`id` bigint NOT NULL,
`role_id` bigint NULL,
`name` varchar (255) NULL,
`age` int NULL,
`remark` longtext NULL,
`local` varchar (255) NULL,
`address` varchar (255) NULL,
PRIMARY KEY (`id`) ,
UNIQUE INDEX `ina_index` (`id`,`name`,`age`) USING BTREE COMMENT 'Unique index of id, name, age',
INDEX (`local`) USING BTREE COMMENT 'Index of local',
FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`role_id`)
)
They all gave me the same error
Exception in thread "main" net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "UNIQUE" "UNIQUE"
at line 10, column 3.
Was expecting one of:
"ACTION"
"ACTIVE"
"ALGORITHM"
"ARCHIVE"
"ARRAY"
"AT"
"BYTE"
"CASCADE"
When I modify the sql
CREATE TABLE `sys_user`
(
`id` bigint NOT NULL,
`role_id` bigint NULL,
`name` varchar (255) NULL,
`age` int NULL,
`remark` longtext NULL,
`local` varchar (255) NULL,
`address` varchar (255) NULL,
PRIMARY KEY (`id`) ,
UNIQUE (`id`,`name`,`age`) USING BTREE COMMENT 'Unique index of id, name, age',
INDEX (`local`) USING BTREE COMMENT 'Index of local',
FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`role_id`)
)
The execution was successful
The difference between the two SQLs lies in the UNIQUE part
Activity
manticore-projects commentedon Nov 24, 2023
Greetings,
your particular Index clause is unsupported. Please check the supported Syntax here:
http://manticore-projects.com/jsqlformatter/JSQLFormatter/syntax.html#createindex
You can also test your statement online and interactively here.
fix: allow UNIQUE INDEX in CREATE TABLE (JSQLParser#2457)