-
-
Notifications
You must be signed in to change notification settings - Fork 2k
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
[Question] 不支持mysql8的新类型POINT #1021
Comments
Title: [Question] The new type POINT of mysql8 is not supported Describe the problem recurrent Desired results Additional log information Audit failed | 2 | line 4 column 27 near "POINT NOT NULL SRID 4326 comment 'position coordinate', PRIMARY KEY (`id`), spatial index `spi_position` (`position`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE= utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='test table';" | CREATE TABLE `aomi_article_position` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'Auto-increment primary key', `position` POINT NOT NULL SRID 4326 comment 'Position coordinates', PRIMARY KEY ( `id`), spatial index `spi_position` (`position`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='test table'; -- | -- | -- | -- |
描述问题
不支持mysql8的新类型POINT
复现
重现该行为的步骤:
CREATE TABLE
aomi_article_position
(id
bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',position
POINT NOT NULL SRID 4326 comment '位置坐标',PRIMARY KEY (
id
),spatial index
spi_position
(position
)) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT = 'test表';
期望的结果
支持mysql8的新类型POINT
额外的日志信息
审核失败 | 2 | line 4 column 27 near "POINT NOT NULL SRID 4326 comment '位置坐标', PRIMARY KEY (`id`), spatial index `spi_position` (`position`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='test表';" | CREATE TABLE `aomi_article_position` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键', `position` POINT NOT NULL SRID 4326 comment '位置坐标', PRIMARY KEY (`id`), spatial index `spi_position` (`position`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='test表'; -- | -- | -- | --The text was updated successfully, but these errors were encountered: