|
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 |
|
+-------+---------------------------------------------------------------------------+
|
|