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

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Not a Bug
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: GIS
Labels:
None

MIN and MAX do not preserve the GEOMETRY and create a LONGBLOB instead:

CREATE OR REPLACE TABLE t1 AS SELECT MAX(POINT(1,1)) AS p;

SHOW CREATE TABLE t1;

CREATE OR REPLACE TABLE t1 AS SELECT MAX((SELECT POINT(1,1))) AS p;

SHOW CREATE TABLE t1;

Both return:

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

| Table | Create Table                                                              |

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

| t1    | CREATE TABLE `t1` (

  `p` longblob

) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

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

relates to

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

MDEV-9405 SP do not preserve geometry type

MDEV-11304 SP do not preserve SRID

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