Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.2
-
None
-
10.1.6-2, 10.1.7-1, 10.1.7-2, 10.1.8-1, 10.1.8-3, 10.1.10
Description
Querying the table in 10.1.2, the following is returned
SELECT * FROM INFORMATION_SCHEMA.SPATIAL_REF_SYS;
|
+------+-----------------+-----------+--------+
|
| SRID | AUTH_NAME | AUTH_SRID | SRTEXT |
|
+------+-----------------+-----------+--------+
|
| -1 | Not defined | -1 | |
|
| 0 | Cartesian plane | 0 | |
|
+------+-----------------+-----------+--------+
|
According the specs, the table should contain:
srid: The numeric SRID. This should be the table's primary key.
auth_name: An authority name as a string. The documentation email suggested that this should be "EPSG" in most cases.
auth_srid: The numeric ID of the coordinate system in the above authority's catalog.
srtext: The Well-Known-Text (WKT) representation of the coordinate system.