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

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

Transition	Time In Source Status	Execution Times

Alice Sherepa made transition - 2024-10-18 15:40

Open

Confirmed

2892d 2h 11m

Alexander Barkov made transition - 2024-10-23 05:01

Confirmed

Closed

4d 13h 20m

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

MariaDB Server