Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL), 10.2(EOL), 10.3(EOL)
-
None
Description
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 |
|
+-------+-----------------------------------------------------------------------------------------+
|
Attachments
Issue Links
- blocks
-
MDEV-4912 Data type plugin API version 1
- Closed
- relates to
-
MDEV-9405 SP do not preserve geometry type
- Open
-
MDEV-12560 Wrong data type for SELECT NULL UNION SELECT Point(1,1)
- Closed
-
MDEV-12668 SRID is not preserved in UNION, VIEW, MIN, MAX
- Closed