Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7540

Information Schema SPATIAL_REF_SYS contents don't match the expected contents

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.2
    • Fix Version/s: 10.1.10
    • Component/s: GIS
    • Labels:
      None
    • Sprint:
      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.

        Attachments

          Activity

            People

            Assignee:
            holyfoot Alexey Botchkov
            Reporter:
            greenman Ian Gilfillan
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration