|
DROP TABLE IF EXISTS t1,t2;
|
CREATE TABLE t1 (a POINT REF_SYSTEM_ID=10 );
|
CREATE TABLE t2 (a POINT REF_SYSTEM_ID=11) AS SELECT * FROM t1;
|
SELECT G_TABLE_NAME,G_GEOMETRY_COLUMN,SRID FROM INFORMATION_SCHEMA.GEOMETRY_COLUMNS WHERE G_TABLE_NAME IN ('t1','t2');
|
+--------------+-------------------+------+
|
| G_TABLE_NAME | G_GEOMETRY_COLUMN | SRID |
|
+--------------+-------------------+------+
|
| t1 | a | 10 |
|
| t2 | a | 10 |
|
+--------------+-------------------+------+
|
The expected SRID value for t2.a should be 11 rather than 10.
|