DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 AS SELECT
|
Point(0,0) AS p0,
|
COALESCE(Point(0,0)) AS p1,
|
CASE WHEN 0 THEN Point(0,0) ELSE Point(1,1) END AS p2;
|
SHOW CREATE TABLE t1;
|
returns
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`p0` point DEFAULT NULL,
|
`p1` geometry DEFAULT NULL,
|
`p2` geometry DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------+
|
The expected behavior would be to the POINT data type for all three columns.
The same problem is demonstrated with LEAST and GREATEST:
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 AS SELECT
|
LEAST(Point(0,0),Point(0,0)) AS p1;
|
SHOW CREATE TABLE t1;
|
+-------+-----------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+-----------------------------------------------------------------------------------------+
|
`p1` geometry DEFAULT NULL
|
| t1 | CREATE TABLE `t1` (
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+-----------------------------------------------------------------------------------------+
|
Bug
Major
MDEV-4912 Data type plugin API version 1
