[MDEV-9405] SP do not preserve geometry type - Jira

XML

Word

Printable

DROP FUNCTION IF EXISTS f1;

CREATE FUNCTION f1() RETURNS POINT RETURN POINT(1,1);

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 SELECT f1() AS a;

SHOW CREATE TABLE t1;

returns

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

| Table | Create Table                                                                           |

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

| t1    | CREATE TABLE `t1` (

  `a` geometry DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

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

The expected column type is POINT.

relates to

MDEV-9425 Hybrid functions and UNION do not preserve spatial REF_SYSTEM_ID

MDEV-11303 MIN and MAX do not preserve GEOMETRY data type

MDEV-11304 SP do not preserve SRID

MDEV-12560 Wrong data type for SELECT NULL UNION SELECT Point(1,1)

MDEV-12665 Hybrid functions do not preserve geometry type

MDEV-12668 SRID is not preserved in UNION, VIEW, MIN, MAX

(1 relates to)

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.