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

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1.2
    • 10.1.10
    • GIS
    • 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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.