GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — [FEAT]: MySQL `SPATIAL KEY` not supported · Issue #2367 · JSQLParser/JSqlParser

[FEAT]: MySQL SPATIAL KEY not supported #2367

New issue
Copy link
New issue
Copy link
Closed
Feature
#2388
Closed
[FEAT]: MySQL SPATIAL KEY not supported#2367
Feature
#2388
Copy link
Labels
DDLDDL statement relatedDDL statement relatedMySQLMySQL specific issueMySQL specific issueSponsor needed

Description

@wxpid1
wxpid1
opened on Jan 17, 2026
Issue body actions

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.

Activity

  1. manticore-projects commented on Feb 24, 2026

    @manticore-projects
    manticore-projects
    on Feb 24, 2026
    Contributor
    More actions

    SPATIAL KEY is not supported and you statement works w/o it.

    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*/ UNIQUE KEY SPATIAL_geo (geo),
    KEY NORMAL_name (name) COMMENT 'normal索引',
    FULLTEXT KEY fulltext_name (name)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='测试表';
  2. manticore-projects
    added
    MySQLMySQL specific issueMySQL specific issue
    DDLDDL statement relatedDDL statement related
    Sponsor needed
    on Feb 24, 2026
  3. manticore-projects
    added the
    Feature
    issue type on Feb 24, 2026
  4. manticore-projects
    changed the title [-][BUG] JSQLParser Version : 5.3 : sql Parser Error![/-] [+][FEAT]: MySQL `SPATIAL KEY` not supported[/+] on Feb 24, 2026
  5. manticore-projects
    closed this as completedin #2388on Feb 25, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    DDLDDL statement relatedDDL statement relatedMySQLMySQL specific issueMySQL specific issueSponsor needed

    Type

    Feature

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions

      You are visitor 01402503 — GeezerVison does not store the pages you look up.
      Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.