Hybrid functions and UNION do not preserve spatial REF_SYSTEM_ID

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (g GEOMETRY REF_SYSTEM_ID=101);

DROP TABLE IF EXISTS t2;

CREATE TABLE t2 AS SELECT g AS g_column, COALESCE(g) AS g_coalesce FROM t1;

DROP TABLE IF EXISTS t3;

CREATE TABLE t3 AS SELECT g AS g_union FROM t1 UNION SELECT g FROM t1;

SELECT G_TABLE_NAME, G_GEOMETRY_COLUMN, SRID FROM INFORMATION_SCHEMA.GEOMETRY_COLUMNS;

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

| G_TABLE_NAME | G_GEOMETRY_COLUMN | SRID |

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

| t1           | g                 |  101 |

| t2           | g_column          |  101 |

| t2           | g_coalesce        |    0 |

| t3           | g_union           |    0 |

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