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

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Cannot Reproduce
Affects Version/s: 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
Fix Version/s: N/A
Component/s: Data types, GIS
Labels:
- datatype
- upstream

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.