Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL), 10.4(EOL)
Description
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.
Attachments
Issue Links
- relates to
-
MDEV-12829 CREATE TABLE t1 (<defs>) SELECT... does not preserve new COMMENT
- Open
-
MDEV-12830 CREATE TABLE t1 (<defs>) SELECT... does not preserve new geometry type
- Open
-
MDEV-12831 CREATE TABLE t1 (<defs>) SELECT... does not preserve new CHECK constraint
- Open