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

[Question] 不支持mysql8的新类型POINT #1021

Open
nicai12222 opened this issue Mar 15, 2024 · 1 comment
Open

[Question] 不支持mysql8的新类型POINT #1021

nicai12222 opened this issue Mar 15, 2024 · 1 comment

Comments

@nicai12222
Copy link

描述问题
不支持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表'; -- | -- | -- | --


@Issues-translate-bot
Copy link

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿


Title: [Question] The new type POINT of mysql8 is not supported

Describe the problem
The new type POINT of mysql8 is not supported

recurrent
Steps to reproduce the behavior:
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';

Desired results
Support new type POINT of mysql8

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'; -- | -- | -- | --


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