[#MDEV-12665] Hybrid functions do not preserve geometry type

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 |

+-------+-----------------------------------------------------------------------------------------+

[MDEV-12665] Hybrid functions do not preserve geometry type Created: 2017-05-02 Updated: 2017-05-05 Resolved: 2017-05-05
Status:	Closed
Project:	MariaDB Server
Component/s:	GIS
Affects Version/s:	10.1, 10.2, 10.3
Fix Version/s:	10.3.1

[MDEV-12665] Hybrid functions do not preserve geometry type Created: 2017-05-02 Updated: 2017-05-05 Resolved: 2017-05-05