[BUG] JSQLParser Version : 5.3 : sql Parser Error！

[wxpid1]

Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram

Failing SQL Feature:

D:\dev\java\jdk21\bin\java.exe -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:63674,suspend=y,server=n -javaagent:D:\file\JetBrains\IDEA\system\captureAgent\debugger-agent.jar=file:///C:/Users/18093/AppData/Local/Temp/capture13549605588364469093.props -Dvisualgc.id=32794114447599 -ea -Dcool.request.port=56783 -javaagent:C:\Users\18093.config.cool-request\request\lib\cool-request-agent.jar -Didea.test.cyclic.buffer.size=1048576 -javaagent:D:\file\JetBrains\IDEA\system\groovyHotSwap\gragent.jar -Dkotlinx.coroutines.debug.enable.creation.stack.trace=false -Ddebugger.agent.enable.coroutines=true -Dkotlinx.coroutines.debug.enable.flows.stack.trace=true -Dkotlinx.coroutines.debug.enable.mutable.state.flows.stack.trace=true -Ddebugger.async.stack.trace.for.all.threads=true -Dfile.encoding=UTF-8 -Dsun.stdout.encoding=UTF-8 -Dsun.stderr.encoding=UTF-8 -classpath "C:\Users\18093.m2\repository\org\junit\platform\junit-platform-launcher\1.11.3\junit-platform-launcher-1.11.3.jar;C:\Users\18093.m2\repository\org\junit\platform\junit-platform-engine\1.11.3\junit-platform-engine-1.11.3.jar;C:\Users\18093.m2\repository\org\opentest4j\opentest4j\1.3.0\opentest4j-1.3.0.jar;C:\Users\18093.m2\repository\org\junit\platform\junit-platform-commons\1.11.3\junit-platform-commons-1.11.3.jar;C:\Users\18093.m2\repository\org\apiguardian\apiguardian-api\1.1.2\apiguardian-api-1.1.2.jar;C:\Users\18093.m2\repository\org\junit\jupiter\junit-jupiter-engine\5.11.3\junit-jupiter-engine-5.11.3.jar;C:\Users\18093.m2\repository\org\junit\jupiter\junit-jupiter-api\5.11.3\junit-jupiter-api-5.11.3.jar;D:\app\JetBrains\Toolbox\IntelliJ IDEA Ultimate\lib\idea_rt.jar;D:\app\JetBrains\Toolbox\IntelliJ IDEA Ultimate\plugins\junit\lib\junit6-rt.jar;D:\app\JetBrains\Toolbox\IntelliJ IDEA Ultimate\plugins\junit\lib\junit5-rt.jar;D:\app\JetBrains\Toolbox\IntelliJ IDEA Ultimate\plugins\junit\lib\junit-rt.jar;D:\project\IdeaProjects\wxp-boot-2.0\wxp-dm\target\test-classes;D:\project\IdeaProjects\wxp-boot-2.0\wxp-dm\target\classes;D:\project\IdeaProjects\wxp-boot-2.0\wxp-common\target\classes;D:\dev\maven\jar\org\springframework\boot\spring-boot-starter-web\2.7.18\spring-boot-starter-web-2.7.18.jar;D:\dev\maven\jar\org\springframework\boot\spring-boot-starter\2.7.18\spring-boot-starter-2.7.18.jar;D:\dev\maven\jar\org\springframework\boot\spring-boot-starter-logging\2.7.18\spring-boot-starter-logging-2.7.18.jar;D:\dev\maven\jar\org\apache\logging\log4j\log4j-to-slf4j\2.17.2\log4j-to-slf4j-2.17.2.jar;D:\dev\maven\jar\org\apache\logging\log4j\log4j-api\2.17.2\log4j-api-2.17.2.jar;D:\dev\maven\jar\org\slf4j\jul-to-slf4j\1.7.36\jul-to-slf4j-1.7.36.jar;D:\dev\maven\jar\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;D:\dev\maven\jar\org\springframework\boot\spring-boot-starter-json\2.7.18\spring-boot-starter-json-2.7.18.jar;D:\dev\maven\jar\com\fasterxml\jackson\core\jackson-databind\2.16.1\jackson-databind-2.16.1.jar;D:\dev\maven\jar\com\fasterxml\jackson\core\jackson-core\2.16.1\jackson-core-2.16.1.jar;D:\dev\maven\jar\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.16.1\jackson-datatype-jdk8-2.16.1.jar;D:\dev\maven\jar\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.16.1\jackson-datatype-jsr310-2.16.1.jar;D:\dev\maven\jar\com\fasterxml\jackson\module\jackson-module-parameter-names\2.16.1\jackson-module-parameter-names-2.16.1.jar;D:\dev\maven\jar\org\springframework\boot\spring-boot-starter-tomcat\2.7.18\spring-boot-starter-tomcat-2.7.18.jar;D:\dev\maven\jar\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.83\tomcat-embed-websocket-9.0.83.jar;D:\dev\maven\jar\org\springframework\spring-web\5.3.31\spring-web-5.3.31.jar;D:\dev\maven\jar\org\springframework\spring-beans\5.3.31\spring-beans-5.3.31.jar;D:\dev\maven\jar\org\springframework\spring-webmvc\5.3.31\spring-webmvc-5.3.31.jar;D:\dev\maven\jar\org\springframework\spring-aop\5.3.31\spring-aop-5.3.31.jar;D:\dev\maven\jar\org\springframework\spring-context\5.3.31\spring-context-5.3.31.jar;D:\dev\maven\jar\org\springframework\spring-expression\5.3.31\spring-expression-5.3.31.jar;D:\dev\maven\jar\org\apache\tomcat\embed\tomcat-embed-core\9.0.83\tomcat-embed-core-9.0.83.jar;D:\dev\maven\jar\org\apache\tomcat\tomcat-annotations-api\9.0.83\tomcat-annotations-api-9.0.83.jar;D:\dev\maven\jar\ch\qos\logback\logback-core\1.2.12\logback-core-1.2.12.jar;D:\dev\maven\jar\ch\qos\logback\logback-classic\1.2.12\logback-classic-1.2.12.jar;D:\dev\maven\jar\org\junit\jupiter\junit-jupiter-api\5.11.3\junit-jupiter-api-5.11.3.jar;D:\dev\maven\jar\org\opentest4j\opentest4j\1.3.0\opentest4j-1.3.0.jar;D:\dev\maven\jar\org\junit\platform\junit-platform-commons\1.11.3\junit-platform-commons-1.11.3.jar;D:\dev\maven\jar\org\apiguardian\apiguardian-api\1.1.2\apiguardian-api-1.1.2.jar;D:\dev\maven\jar\org\slf4j\slf4j-reload4j\2.0.11\slf4j-reload4j-2.0.11.jar;D:\dev\maven\jar\ch\qos\reload4j\reload4j\1.2.22\reload4j-1.2.22.jar;D:\dev\maven\jar\org\slf4j\slf4j-api\1.7.36\slf4j-api-1.7.36.jar;D:\dev\maven\jar\org\yaml\snakeyaml\1.30\snakeyaml-1.30.jar;D:\dev\maven\jar\org\springframework\boot\spring-boot-configuration-processor\2.7.18\spring-boot-configuration-processor-2.7.18.jar;D:\dev\maven\jar\io\swagger\swagger-models\1.6.16\swagger-models-1.6.16.jar;D:\dev\maven\jar\com\fasterxml\jackson\core\jackson-annotations\2.16.1\jackson-annotations-2.16.1.jar;D:\dev\maven\jar\io\swagger\swagger-annotations\1.6.16\swagger-annotations-1.6.16.jar;D:\dev\maven\jar\io\springfox\springfox-boot-starter\3.0.0\springfox-boot-starter-3.0.0.jar;D:\dev\maven\jar\io\springfox\springfox-oas\3.0.0\springfox-oas-3.0.0.jar;D:\dev\maven\jar\io\swagger\core\v3\swagger-annotations\2.1.2\swagger-annotations-2.1.2.jar;D:\dev\maven\jar\io\swagger\core\v3\swagger-models\2.1.2\swagger-models-2.1.2.jar;D:\dev\maven\jar\io\springfox\springfox-spi\3.0.0\springfox-spi-3.0.0.jar;D:\dev\maven\jar\io\springfox\springfox-schema\3.0.0\springfox-schema-3.0.0.jar;D:\dev\maven\jar\io\springfox\springfox-core\3.0.0\springfox-core-3.0.0.jar;D:\dev\maven\jar\io\springfox\springfox-spring-web\3.0.0\springfox-spring-web-3.0.0.jar;D:\dev\maven\jar\io\github\classgraph\classgraph\4.8.83\classgraph-4.8.83.jar;D:\dev\maven\jar\io\springfox\springfox-spring-webmvc\3.0.0\springfox-spring-webmvc-3.0.0.jar;D:\dev\maven\jar\io\springfox\springfox-spring-webflux\3.0.0\springfox-spring-webflux-3.0.0.jar;D:\dev\maven\jar\io\springfox\springfox-swagger-common\3.0.0\springfox-swagger-common-3.0.0.jar;D:\dev\maven\jar\org\mapstruct\mapstruct\1.3.1.Final\mapstruct-1.3.1.Final.jar;D:\dev\maven\jar\io\springfox\springfox-data-rest\3.0.0\springfox-data-rest-3.0.0.jar;D:\dev\maven\jar\io\springfox\springfox-bean-validators\3.0.0\springfox-bean-validators-3.0.0.jar;D:\dev\maven\jar\io\springfox\springfox-swagger2\3.0.0\springfox-swagger2-3.0.0.jar;D:\dev\maven\jar\io\springfox\springfox-swagger-ui\3.0.0\springfox-swagger-ui-3.0.0.jar;D:\dev\maven\jar\com\fasterxml\classmate\1.5.1\classmate-1.5.1.jar;D:\dev\maven\jar\org\springframework\plugin\spring-plugin-core\2.0.0.RELEASE\spring-plugin-core-2.0.0.RELEASE.jar;D:\dev\maven\jar\org\springframework\plugin\spring-plugin-metadata\2.0.0.RELEASE\spring-plugin-metadata-2.0.0.RELEASE.jar;D:\dev\maven\jar\com\github\xiaoymin\knife4j-spring-boot-starter\3.0.3\knife4j-spring-boot-starter-3.0.3.jar;D:\dev\maven\jar\com\github\xiaoymin\knife4j-spring-boot-autoconfigure\3.0.3\knife4j-spring-boot-autoconfigure-3.0.3.jar;D:\dev\maven\jar\com\github\xiaoymin\knife4j-spring\3.0.3\knife4j-spring-3.0.3.jar;D:\dev\maven\jar\com\github\xiaoymin\knife4j-annotations\3.0.3\knife4j-annotations-3.0.3.jar;D:\dev\maven\jar\com\github\xiaoymin\knife4j-core\3.0.3\knife4j-core-3.0.3.jar;D:\dev\maven\jar\org\javassist\javassist\3.25.0-GA\javassist-3.25.0-GA.jar;D:\dev\maven\jar\io\swagger\swagger-core\1.5.22\swagger-core-1.5.22.jar;D:\dev\maven\jar\com\fasterxml\jackson\dataformat\jackson-dataformat-yaml\2.16.1\jackson-dataformat-yaml-2.16.1.jar;D:\dev\maven\jar\javax\validation\validation-api\2.0.1.Final\validation-api-2.0.1.Final.jar;D:\dev\maven\jar\com\github\xiaoymin\knife4j-spring-ui\3.0.3\knife4j-spring-ui-3.0.3.jar;D:\dev\maven\jar\org\springframework\boot\spring-boot-starter-data-redis\2.7.18\spring-boot-starter-data-redis-2.7.18.jar;D:\dev\maven\jar\org\springframework\data\spring-data-redis\2.7.18\spring-data-redis-2.7.18.jar;D:\dev\maven\jar\org\springframework\data\spring-data-keyvalue\2.7.18\spring-data-keyvalue-2.7.18.jar;D:\dev\maven\jar\org\springframework\data\spring-data-commons\2.7.18\spring-data-commons-2.7.18.jar;D:\dev\maven\jar\org\springframework\spring-tx\5.3.31\spring-tx-5.3.31.jar;D:\dev\maven\jar\org\springframework\spring-oxm\5.3.31\spring-oxm-5.3.31.jar;D:\dev\maven\jar\org\springframework\spring-context-support\5.3.31\spring-context-support-5.3.31.jar;D:\dev\maven\jar\io\lettuce\lettuce-core\6.1.10.RELEASE\lettuce-core-6.1.10.RELEASE.jar;D:\dev\maven\jar\io\netty\netty-common\4.1.101.Final\netty-common-4.1.101.Final.jar;D:\dev\maven\jar\io\netty\netty-handler\4.1.101.Final\netty-handler-4.1.101.Final.jar;D:\dev\maven\jar\io\netty\netty-resolver\4.1.101.Final\netty-resolver-4.1.101.Final.jar;D:\dev\maven\jar\io\netty\netty-buffer\4.1.101.Final\netty-buffer-4.1.101.Final.jar;D:\dev\maven\jar\io\netty\netty-transport-native-unix-common\4.1.101.Final\netty-transport-native-unix-common-4.1.101.Final.jar;D:\dev\maven\jar\io\netty\netty-codec\4.1.101.Final\netty-codec-4.1.101.Final.jar;D:\dev\maven\jar\io\netty\netty-transport\4.1.96.Final\netty-transport-4.1.96.Final.jar;D:\dev\maven\jar\io\projectreactor\reactor-core\3.4.34\reactor-core-3.4.34.jar;D:\dev\maven\jar\org\reactivestreams\reactive-streams\1.0.4\reactive-streams-1.0.4.jar;D:\dev\maven\jar\org\projectlombok\lombok\1.18.42\lombok-1.18.42.jar;D:\dev\maven\jar\org\apache\commons\commons-pool2\2.11.1\commons-pool2-2.11.1.jar;D:\dev\maven\jar\org\apache\commons\commons-text\1.10.0\commons-text-1.10.0.jar;D:\dev\maven\jar\org\apache\commons\commons-compress\1.28.0\commons-compress-1.28.0.jar;D:\dev\maven\jar\commons-io\commons-io\2.20.0\commons-io-2.20.0.jar;D:\dev\maven\jar\org\apache\commons\commons-lang3\3.12.0\commons-lang3-3.12.0.jar;D:\dev\maven\jar\com\google\guava\guava\33.3.1-jre\guava-33.3.1-jre.jar;D:\dev\maven\jar\com\google\guava\failureaccess\1.0.2\failureaccess-1.0.2.jar;D:\dev\maven\jar\com\google\guava\listenablefuture\9999.0-empty-to-avoid-conflict-with-guava\listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar;D:\dev\maven\jar\com\google\code\findbugs\jsr305\3.0.2\jsr305-3.0.2.jar;D:\dev\maven\jar\org\checkerframework\checker-qual\3.43.0\checker-qual-3.43.0.jar;D:\dev\maven\jar\com\google\errorprone\error_prone_annotations\2.28.0\error_prone_annotations-2.28.0.jar;D:\dev\maven\jar\com\google\j2objc\j2objc-annotations\3.0.0\j2objc-annotations-3.0.0.jar;D:\dev\maven\jar\cn\hutool\hutool-all\5.8.42\hutool-all-5.8.42.jar;D:\dev\maven\jar\org\springframework\boot\spring-boot-starter-actuator\2.7.18\spring-boot-starter-actuator-2.7.18.jar;D:\dev\maven\jar\org\springframework\boot\spring-boot-actuator-autoconfigure\2.7.18\spring-boot-actuator-autoconfigure-2.7.18.jar;D:\dev\maven\jar\org\springframework\boot\spring-boot-actuator\2.7.18\spring-boot-actuator-2.7.18.jar;D:\dev\maven\jar\io\micrometer\micrometer-core\1.9.17\micrometer-core-1.9.17.jar;D:\dev\maven\jar\org\hdrhistogram\HdrHistogram\2.1.12\HdrHistogram-2.1.12.jar;D:\dev\maven\jar\org\latencyutils\LatencyUtils\2.0.3\LatencyUtils-2.0.3.jar;D:\dev\maven\jar\org\springframework\boot\spring-boot-starter-validation\2.7.18\spring-boot-starter-validation-2.7.18.jar;D:\dev\maven\jar\org\apache\tomcat\embed\tomcat-embed-el\9.0.83\tomcat-embed-el-9.0.83.jar;D:\dev\maven\jar\org\hibernate\validator\hibernate-validator\6.2.5.Final\hibernate-validator-6.2.5.Final.jar;D:\dev\maven\jar\jakarta\validation\jakarta.validation-api\2.0.2\jakarta.validation-api-2.0.2.jar;D:\dev\maven\jar\org\jboss\logging\jboss-logging\3.4.3.Final\jboss-logging-3.4.3.Final.jar;D:\dev\maven\jar\org\springframework\boot\spring-boot-starter-test\2.7.18\spring-boot-starter-test-2.7.18.jar;D:\dev\maven\jar\org\springframework\boot\spring-boot-test\2.7.18\spring-boot-test-2.7.18.jar;D:\dev\maven\jar\org\springframework\boot\spring-boot-test-autoconfigure\2.7.18\spring-boot-test-autoconfigure-2.7.18.jar;D:\dev\maven\jar\jakarta\xml\bind\jakarta.xml.bind-api\2.3.3\jakarta.xml.bind-api-2.3.3.jar;D:\dev\maven\jar\jakarta\activation\jakarta.activation-api\1.2.2\jakarta.activation-api-1.2.2.jar;D:\dev\maven\jar\org\assertj\assertj-core\3.22.0\assertj-core-3.22.0.jar;D:\dev\maven\jar\org\hamcrest\hamcrest\2.2\hamcrest-2.2.jar;D:\dev\maven\jar\org\junit\jupiter\junit-jupiter\5.10.0\junit-jupiter-5.10.0.jar;D:\dev\maven\jar\org\junit\jupiter\junit-jupiter-params\5.10.0\junit-jupiter-params-5.10.0.jar;D:\dev\maven\jar\org\mockito\mockito-core\4.11.0\mockito-core-4.11.0.jar;D:\dev\maven\jar\net\bytebuddy\byte-buddy\1.12.23\byte-buddy-1.12.23.jar;D:\dev\maven\jar\net\bytebuddy\byte-buddy-agent\1.12.23\byte-buddy-agent-1.12.23.jar;D:\dev\maven\jar\org\objenesis\objenesis\3.3\objenesis-3.3.jar;D:\dev\maven\jar\org\mockito\mockito-junit-jupiter\4.11.0\mockito-junit-jupiter-4.11.0.jar;D:\dev\maven\jar\org\skyscreamer\jsonassert\1.5.1\jsonassert-1.5.1.jar;D:\dev\maven\jar\com\vaadin\external\google\android-json\0.0.20131108.vaadin1\android-json-0.0.20131108.vaadin1.jar;D:\dev\maven\jar\org\springframework\spring-core\5.3.31\spring-core-5.3.31.jar;D:\dev\maven\jar\org\springframework\spring-jcl\5.3.31\spring-jcl-5.3.31.jar;D:\dev\maven\jar\org\springframework\spring-test\5.3.31\spring-test-5.3.31.jar;D:\dev\maven\jar\org\xmlunit\xmlunit-core\2.9.1\xmlunit-core-2.9.1.jar;D:\dev\maven\jar\com\jayway\jsonpath\json-path\2.7.0\json-path-2.7.0.jar;D:\dev\maven\jar\net\minidev\json-smart\2.4.11\json-smart-2.4.11.jar;D:\dev\maven\jar\net\minidev\accessors-smart\2.4.11\accessors-smart-2.4.11.jar;D:\dev\maven\jar\org\ow2\asm\asm\9.3\asm-9.3.jar;D:\dev\maven\jar\com\alibaba\fastjson2\fastjson2\2.0.42\fastjson2-2.0.42.jar;D:\dev\maven\jar\org\dom4j\dom4j\2.1.3\dom4j-2.1.3.jar;D:\dev\maven\jar\pull-parser\pull-parser\2.1.10\pull-parser-2.1.10.jar;D:\dev\maven\jar\com\belerweb\pinyin4j\2.5.1\pinyin4j-2.5.1.jar;D:\dev\maven\jar\commons-codec\commons-codec\1.15\commons-codec-1.15.jar;D:\dev\maven\jar\org\apache\commons\commons-collections4\4.4\commons-collections4-4.4.jar;D:\dev\maven\jar\com\dameng\DmJdbcDriver18\8.1.3.140\DmJdbcDriver18-8.1.3.140.jar;D:\dev\maven\jar\com\baomidou\mybatis-plus-boot-starter\3.5.10\mybatis-plus-boot-starter-3.5.10.jar;D:\dev\maven\jar\com\baomidou\mybatis-plus\3.5.10\mybatis-plus-3.5.10.jar;D:\dev\maven\jar\com\baomidou\mybatis-plus-core\3.5.10\mybatis-plus-core-3.5.10.jar;D:\dev\maven\jar\com\baomidou\mybatis-plus-annotation\3.5.10\mybatis-plus-annotation-3.5.10.jar;D:\dev\maven\jar\com\baomidou\mybatis-plus-spring\3.5.10\mybatis-plus-spring-3.5.10.jar;D:\dev\maven\jar\org\mybatis\mybatis\3.5.19\mybatis-3.5.19.jar;D:\dev\maven\jar\org\mybatis\mybatis-spring\2.1.2\mybatis-spring-2.1.2.jar;D:\dev\maven\jar\com\baomidou\mybatis-plus-spring-boot-autoconfigure\3.5.10\mybatis-plus-spring-boot-autoconfigure-3.5.10.jar;D:\dev\maven\jar\org\springframework\boot\spring-boot-autoconfigure\2.7.18\spring-boot-autoconfigure-2.7.18.jar;D:\dev\maven\jar\org\springframework\boot\spring-boot\2.7.18\spring-boot-2.7.18.jar;D:\dev\maven\jar\org\springframework\boot\spring-boot-starter-jdbc\2.7.18\spring-boot-starter-jdbc-2.7.18.jar;D:\dev\maven\jar\com\zaxxer\HikariCP\4.0.3\HikariCP-4.0.3.jar;D:\dev\maven\jar\org\springframework\spring-jdbc\5.3.31\spring-jdbc-5.3.31.jar;D:\dev\maven\jar\com\baomidou\mybatis-plus-jsqlparser\3.5.10\mybatis-plus-jsqlparser-3.5.10.jar;D:\dev\maven\jar\com\baomidou\mybatis-plus-jsqlparser-common\3.5.10\mybatis-plus-jsqlparser-common-3.5.10.jar;D:\dev\maven\jar\com\baomidou\mybatis-plus-extension\3.5.10\mybatis-plus-extension-3.5.10.jar;D:\dev\maven\jar\com\github\jsqlparser\jsqlparser\5.3\jsqlparser-5.3.jar;D:\dev\maven\jar\org\openjdk\jmh\jmh-core\1.37\jmh-core-1.37.jar;D:\dev\maven\jar\net\sf\jopt-simple\jopt-simple\5.0.4\jopt-simple-5.0.4.jar;D:\dev\maven\jar\org\apache\commons\commons-math3\3.6.1\commons-math3-3.6.1.jar;C:\Users\18093.config.cool-request\request\lib\spring-invoke-starter.jar" com.intellij.rt.junit.JUnitStarter -ideVersion5 -junit5 com.wxp.dm.test.converter.MysqlToDmUtilsTest,createTableSqlTest
已连接到地址为 ''127.0.0.1:63674'，传输: '套接字'' 的目标虚拟机

com.wxp.common.exception.WxpException: 解析sql异常

at com.wxp.dm.utils.MysqlToDmUtils.createTableSql(MysqlToDmUtils.java:171)
at com.wxp.dm.test.converter.MysqlToDmUtilsTest.createTableSqlTest(MysqlToDmUtilsTest.java:44)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)

Caused by: net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "KEY" "KEY"
at line 11, column 11.

Was expecting one of:

"BINARY"
"CHAR"
"DATA"
"INTERVAL"
"JSON"
"NAME"
"PUBLIC"
"SET"
"STRING"
"XML"
<DT_ZONE>
<K_DATETIMELITERAL>
<K_DATE_LITERAL>
<S_IDENTIFIER>
<S_QUOTED_IDENTIFIER>

at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:352)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:125)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:91)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:64)
at com.wxp.dm.utils.MysqlToDmUtils.createTableSql(MysqlToDmUtils.java:133)
... 4 more

Caused by: java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "KEY" "KEY"
at line 11, column 11.

Was expecting one of:

"BINARY"
"CHAR"
"DATA"
"INTERVAL"
"JSON"
"NAME"
"PUBLIC"
"SET"
"STRING"
"XML"
<DT_ZONE>
<K_DATETIMELITERAL>
<K_DATE_LITERAL>
<S_IDENTIFIER>
<S_QUOTED_IDENTIFIER>

at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:205)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:345)
... 8 more

Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "KEY" "KEY"
at line 11, column 11.

Was expecting one of:

"BINARY"
"CHAR"
"DATA"
"INTERVAL"
"JSON"
"NAME"
"PUBLIC"
"SET"
"STRING"
"XML"
<DT_ZONE>
<K_DATETIMELITERAL>
<K_DATE_LITERAL>
<S_IDENTIFIER>
<S_QUOTED_IDENTIFIER>

at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:53111)
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:52929)
at net.sf.jsqlparser.parser.CCJSqlParser.ColDataType(CCJSqlParser.java:27215)
at net.sf.jsqlparser.parser.CCJSqlParser.ColumnDefinition(CCJSqlParser.java:25312)
at net.sf.jsqlparser.parser.CCJSqlParser.CreateTable(CCJSqlParser.java:26420)
at net.sf.jsqlparser.parser.CCJSqlParser.Create(CCJSqlParser.java:33425)
at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:556)
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:413)
at net.sf.jsqlparser.parser.CCJSqlParserUtil$1.call(CCJSqlParserUtil.java:341)
at net.sf.jsqlparser.parser.CCJSqlParserUtil$1.call(CCJSqlParserUtil.java:338)
at java.base/java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:317)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java)
at --- Async.Stack.Trace --- (captured by IntelliJ IDEA debugger)
at java.base/java.util.concurrent.FutureTask.<init>(FutureTask.java:132)
at java.base/java.util.concurrent.AbstractExecutorService.newTaskFor(AbstractExecutorService.java:113)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:144)
at java.base/java.util.concurrent.Executors$DelegatedExecutorService.submit(Executors.java:790)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:338)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:125)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:91)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:64)
at com.wxp.dm.utils.MysqlToDmUtils.createTableSql(MysqlToDmUtils.java:133)
at com.wxp.dm.test.converter.MysqlToDmUtilsTest.createTableSqlTest(MysqlToDmUtilsTest.java:44)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:767)
at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)
at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)
at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156)
at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147)
at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86)
at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103)
at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93)
at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)
at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)
at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)
at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)
at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92)
at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86)
at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$8(TestMethodTestDescriptor.java:217)
at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213)
at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138)
at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:156)
at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:146)
at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:144)
at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:143)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:100)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:41)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:160)
at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:146)
at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:144)
at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:143)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:100)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:41)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:160)
at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:146)
at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:144)
at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:143)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:100)
at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:35)
at org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57)
at org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:54)
at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:198)
at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:169)
at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:93)
at org.junit.platform.launcher.core.EngineExecutionOrchestrator.lambda$execute$0(EngineExecutionOrchestrator.java:58)
at org.junit.platform.launcher.core.EngineExecutionOrchestrator.withInterceptedStreams(EngineExecutionOrchestrator.java:141)
at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:57)
at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:103)
at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:85)
at org.junit.platform.launcher.core.DelegatingLauncher.execute(DelegatingLauncher.java:47)
at org.junit.platform.launcher.core.SessionPerRequestLauncher.execute(SessionPerRequestLauncher.java:63)
at com.intellij.junit5.JUnit5IdeaTestRunner.startRunnerWithArgs(JUnit5IdeaTestRunner.java:66)
at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38)
at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11)
at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35)
at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:237)
at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:58)

已与地址为 ''127.0.0.1:63674'，传输: '套接字'' 的目标虚拟机断开连接

进程已结束，退出代码为 -1

SQL Example:

• Simplified Query Example, focusing on the failing feature

CREATE TABLE test (
id int(11) NOT NULL COMMENT '数据id',
code varchar(100) NOT NULL COMMENT '编码',
name varchar(300) DEFAULT NULL COMMENT '名称',
geo geometry NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY index_code (code) USING HASH COMMENT '编码唯一索引',
UNIQUE KEY inx_code_name (code,name) USING BTREE COMMENT '编码名称唯一索引',
UNIQUE KEY inx_id_code_name (id,code,name) USING BTREE COMMENT '索引1',
SPATIAL KEY SPATIAL_geo (geo),
KEY NORMAL_name (name) COMMENT 'normal索引',
FULLTEXT KEY fulltext_name (name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='测试表';
```

Software Information:

• JSqlParser version
• Database (e. g. Oracle, MS SQL Server, H2, PostgreSQL, IBM DB2 )

Tips:

Please write in English and avoid Screenshots (as we can't copy and paste content from it).
Try your example online with the latest JSQLParser and share the link in the error report.
Do provide Links or References to the specific Grammar and Syntax you are trying to use.