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

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.1(EOL), 10.2(EOL), 10.3(EOL)
Fix Version/s: 10.3.1
Component/s: GIS
Labels:
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

MDEV-9405 SP do not preserve geometry type

Closed

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

Closed

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

Closed

Activity

People

Assignee:: Alexander Barkov

Reporter:: Alexander Barkov

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2017-05-02 14:31

Updated:: 2017-05-05 03:24

Resolved:: 2017-05-05 03:24

Git Integration

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