Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mysql8中执行特定建表语句时,出现ParserException #5935

Closed
swiftlei opened this issue May 22, 2024 · 1 comment
Closed

mysql8中执行特定建表语句时,出现ParserException #5935

swiftlei opened this issue May 22, 2024 · 1 comment

Comments

@swiftlei
Copy link

dbtype: mysql
dbversion: 8.0
duird version: 1.2.22
error sql:
CREATE TABLE test_table (
id bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
latitude decimal(9, 7) NULL COMMENT '纬度,为空表示定位失败',
longitude decimal(10, 7) NULL COMMENT '经度,为空表示定位失败',
geo_point POINT GENERATED ALWAYS AS (ST_POINTFROMTEXT(CONCAT('POINT(', latitude, ' ', longitude, ')'), 4326)) STORED NOT NULL SRID 4326,
PRIMARY KEY (id)
);

error info:
com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'STORED NOT NULL SRID 4326,
', expect ), actual null, pos ..., line ..., column ..., token IDENTIFIER SRID

@lizongbo
Copy link
Collaborator

STORED NOT NULL 我能看明白,解析确实有点问题,但是这个 SRID 4326是啥? 官方语法没有这个。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants