maria-developers team mailing list archive

[Alexander Barkov <bar@xxxxxxxxxxx>]

Hello Alexey,

I have a question about REF_SYSTEM_ID.


DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a POINT REF_SYSTEM_ID=10);
SELECT G_TABLE_NAME,G_GEOMETRY_COLUMN,SRID FROM 
INFORMATION_SCHEMA.GEOMETRY_COLUMNS WHERE G_TABLE_NAME='t1';

The above script returns:
+--------------+-------------------+------+
| G_TABLE_NAME | G_GEOMETRY_COLUMN | SRID |
+--------------+-------------------+------+
| t1           | a                 |   10 |
+--------------+-------------------+------+

This looks correct. The REF_SYSTEM_ID (which is 10) is correctly 
displayed in the SRID column.


But now if I do:

SHOW CREATE TABLE t1;

It prints:

+-------+-------------------------------------------------------------------------------------+
| Table | Create Table 
                      |
+-------+-------------------------------------------------------------------------------------+
| t1    | CREATE TABLE `t1` (
  `a` point DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+-------------------------------------------------------------------------------------+


It does not display the REF_SYSTEM_ID part of the column definition.

Looks like a bug from a glance.


Can you comment please?