Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL)
-
Not for Release Notes
Description
MariaDB [test]> create table t (a point(1,2)); |
Query OK, 0 rows affected (0.023 sec) |
 |
MariaDB [test]> show create table t; |
+-------+------------------------------------------------------------------------------------+ |
| Table | Create Table | |
+-------+------------------------------------------------------------------------------------+ |
| t | CREATE TABLE `t` ( |
`a` point DEFAULT NULL |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 | |
+-------+------------------------------------------------------------------------------------+ |
1 row in set (0.001 sec) |
Same with other geometry types.
I couldn't find in documentation why POINT(x,y) would be accepted as a data type.
If there is an intention behind it, maybe it needs to be documented.
MySQL 5.7, 8.0 return a syntax error.