Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.2, 10.3, 10.4, 10.5
-
None
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.