|
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.
|