|
DROP FUNCTION IF EXISTS f1;
|
DROP TABLE IF EXISTS t1;
|
|
CREATE FUNCTION f1() RETURNS POINT REF_SYSTEM_ID=10 RETURN POINT(1,1);
|
CREATE OR REPLACE TABLE t1 SELECT f1() AS a;
|
SHOW CREATE TABLE t1;
|
SELECT G_TABLE_NAME,G_GEOMETRY_COLUMN,SRID FROM INFORMATION_SCHEMA.GEOMETRY_COLUMNS WHERE G_TABLE_NAME='t1';
|
+--------------+-------------------+------+
|
| G_TABLE_NAME | G_GEOMETRY_COLUMN | SRID |
|
+--------------+-------------------+------+
|
| t1 | a | 0 |
|
+--------------+-------------------+------+
|
The above looks wrong. The expected SRID value would be 10, as defined in the function return data type.
|