Closed nicai12222 closed 5 months ago
Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑🤝🧑👫🧑🏿🤝🧑🏻👩🏾🤝👨🏿👬🏿
Title: [Question]
Describe the problem CREATE TABLE does not support the POINT type of mysql8
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 POINT
screenshot
Deployment method
Environment (please fill in environmental information):
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';" -- | -- | --
Please provide titles that are straightforward and concise. exp: [Question] How to use or [Feature] Add new feature