为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: 8.1.1.193
【操作系统】:
【CPU】:
【问题描述】*:
CREATE TABLE "test"
(
`id` BIGINT
not NULL
,
`test` VARCHAR
(255)
DEFAULT '1111',
not cluster primary key("id")
);
COMMENT ON TABLE "test" IS 'stg_sz_reg_bus_freeze_baseinfo_di1';
COMMENT ON COLUMN "test"."id" IS '主键';
COMMENT ON COLUMN "test"."test" IS 'test';
报错 at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
2025-04-14T16:25:46.143572628+08:00 at jdk.proxy2/jdk.proxy2.$Proxy192.update(Unknown Source)
2025-04-14T16:25:46.143575034+08:00 at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
... 119 common frames omitted
2025-04-14T16:25:46.143580274+08:00 Caused by: java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "NOT" "NOT"
at line 12, column 1.
2025-04-14T16:25:46.143584992+08:00
2025-04-14T16:25:46.143588028+08:00 Was expecting one of:
2025-04-14T16:25:46.143594137+08:00 "ACTION"
"ACTIVE"
2025-04-14T16:25:46.143600107+08:00 "ADD"
"ADVANCE"
2025-04-14T16:25:46.143604765+08:00 "ADVISE"
2025-04-14T16:25:46.143607064+08:00 "AGAINST"
"ALGORITHM"
"ALTER"
2025-04-14T16:25:46.143613887+08:00 "ANALYZE"
2025-04-14T16:25:46.143616176+08:00 "APPLY"
2025-04-14T16:25:46.143618407+08:00 "ARCHIVE"
"ARRAY"
2025-04-14T16:25:46.143623156+08:00 "ASC"
"AT"
2025-04-14T16:25:46.143627831+08:00 "AUTHORIZATION"
2025-04-14T16:25:46.143630136+08:00 "AUTO"
"BEGIN"
2025-04-14T16:25:46.143643392+08:00 "BINARY"
"BIT"
2025-04-14T16:25:46.143649923+08:00 "BUFFERS"
2025-04-14T16:25:46.143653452+08:00 "BY"
2025-04-14T16:25:46.143656708+08:00 "BYTE"
2025-04-14T16:25:46.143659868+08:00 "BYTES"
"CACHE"
"CALL"
"CASCADE"
"CASE"
"CAST"
2025-04-14T16:25:46.143678597+08:00 "CHANGE"
2025-04-14T16:25:46.143680879+08:00 "CHANGES"
"CHAR"
2025-04-14T16:25:46.143685418+08:00 "CHARACTER"
2025-04-14T16:25:46.143687715+08:00 "CHECKPOINT"
"CLOSE"
"COLLATE"
2025-04-14T16:25:46.143694620+08:00 "COLUMN"
"COLUMNS"
把id,test的单引号改成双引号或者数据库兼容mysql,可以执行成功