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
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
Activity
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Alexander Barkov [ bar ] | Alexey Botchkov [ holyfoot ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Link |
This issue relates to |
| Link |
This issue relates to |
| Assignee | Alexey Botchkov [ holyfoot ] | Alexander Barkov [ bar ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Component/s | GIS [ 10105 ] | |
| Fix Version/s | 10.3.1 [ 22532 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 80571 ] | MariaDB v4 [ 152069 ] |