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 NULL UNION SELECT POINT(1,1); |
SHOW CREATE TABLE t1; |
returns
+-------+-------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+-------------------------------------------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`NULL` geometry DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+-------------------------------------------------------------------------------------------+
|
This is wrong. The expected column type is POINT.
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-12495 Conditional jump depends on uninitialised value for: SELECT NULL UNION geom_expression
- Closed
-
MDEV-12665 Hybrid functions do not preserve geometry type
- Closed
-
MDEV-12668 SRID is not preserved in UNION, VIEW, MIN, MAX
- Closed