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

XML

Word

Printable

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.