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

Information Schema SPATIAL_REF_SYS contents don't match the expected contents

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

          Ascending order - Click to sort in descending order
          greenman Ian Gilfillan created issue -
          elenst Elena Stepanova added a comment -

          PostGIS has 3911 rows in the table. Examples:

          select * from spatial_ref_sys limit 2;
          		 
           
          		 
           3819 | EPSG      |      3819 | GEOGCS["HD1909",DATUM["Hungarian_Datum_1909",SPHEROID["Bessel 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],TOWGS84[595.48,121.69,515.35,4.115,-2.9383,0.853,-3.408],AUTHORITY["EPSG","1024"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","3819"]] | +proj=longlat +ellps=bessel +towgs84=595.48,121.69,515.35,4.115,-2.9383,0.853,-3.408 +no_defs 
           3821 | EPSG      |      3821 | GEOGCS["TWD67",DATUM["Taiwan_Datum_1967",SPHEROID["GRS 1967 Modified",6378160,298.25,AUTHORITY["EPSG","7050"]],AUTHORITY["EPSG","1025"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","3821"]]                                                                 | +proj=longlat +ellps=aust_SA +no_defs

          elenst Elena Stepanova added a comment - PostGIS has 3911 rows in the table. Examples: select * from spatial_ref_sys limit 2;   3819 | EPSG | 3819 | GEOGCS["HD1909",DATUM["Hungarian_Datum_1909",SPHEROID["Bessel 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],TOWGS84[595.48,121.69,515.35,4.115,-2.9383,0.853,-3.408],AUTHORITY["EPSG","1024"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","3819"]] | +proj=longlat +ellps=bessel +towgs84=595.48,121.69,515.35,4.115,-2.9383,0.853,-3.408 +no_defs 3821 | EPSG | 3821 | GEOGCS["TWD67",DATUM["Taiwan_Datum_1967",SPHEROID["GRS 1967 Modified",6378160,298.25,AUTHORITY["EPSG","7050"]],AUTHORITY["EPSG","1025"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","3821"]] | +proj=longlat +ellps=aust_SA +no_defs
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Fix Version/s 10.1 [ 16100 ]
          Assignee Alexey Botchkov [ holyfoot ]
          chidelmun Delveri Chick added a comment - - edited

          Hi
          Im Chick and I have dropped a proposal on melange for the GSoC GIS enhancement task mentored by holyfoot. However I wish to work on this related bug to add value to my proposal. I build mariadb from a github clone but when I run the bug query, SELECT * FROM INFORMATION_SCHEMA.SPATIAL_REF_SYS; I rather get something different from the results mentioned above.
          Here what I get.

          MariaDB [information_schema]> SELECT * FROM INFORMATION_SCHEMA.SPATIAL_REF_SYS;

          ERROR 1109 (42S02): Unknown table 'SPATIAL_REF_SYS' in information_schema

          MariaDB [information_schema]>

          chidelmun Delveri Chick added a comment - - edited Hi Im Chick and I have dropped a proposal on melange for the GSoC GIS enhancement task mentored by holyfoot. However I wish to work on this related bug to add value to my proposal. I build mariadb from a github clone but when I run the bug query, SELECT * FROM INFORMATION_SCHEMA.SPATIAL_REF_SYS; I rather get something different from the results mentioned above. Here what I get. MariaDB [information_schema] > SELECT * FROM INFORMATION_SCHEMA.SPATIAL_REF_SYS; ERROR 1109 (42S02): Unknown table 'SPATIAL_REF_SYS' in information_schema MariaDB [information_schema] >
          holyfoot Alexey Botchkov made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          chidelmun Delveri Chick made changes -
          Comment [ The table is not populated with the right references .
          In sql/sql_show.cc fill_spatial_ref_sys() needs to populate the table with the correct references

          #ifdef HAVE_SPATIAL
          static int fill_spatial_ref_sys(THD *thd, TABLE_LIST *tables, COND *cond)
          {
            DBUG_ENTER("fill_spatial_ref_sys");
            TABLE *table= tables->table;
            CHARSET_INFO *cs= system_charset_info;
            int result= 1;

            restore_record(table, s->default_values);

            table->field[0]->store(-1, FALSE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("Not defined"), cs); /*AUTH_NAME*/
            table->field[2]->store(-1, FALSE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN(""), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(0, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(0, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN(""), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(1, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("SR-ORG"), cs); /*AUTH_NAME*/
            table->field[2]->store(1, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"unnamed\",\
            GEOGCS[\"GRS 1980(IUGG, 1980)\",DATUM[\"unknown\",SPHEROID[\"GRS80\",\
            6378137,298.257222101]],PRIMEM[\"Greenwich\",0],UNIT[\"degree\",\
            0.0174532925199433]],PROJECTION[\"Lambert_Conformal_Conic_2SP\"],\
            PARAMETER[\"standard_parallel_1\",42.6833319],PARAMETER[\"standard_parallel_2\",\
            41.71666666666667],PARAMETER[\"latitude_of_origin\",41],PARAMETER[\"central_meridian\",\
            -71.5],PARAMETER[\"false_easting\",200000],PARAMETER[\"false_northing\",\
            750000],UNIT[\"Meter\",1]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(2000, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(2000, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"Anguilla 1957 / British West Indies Grid\",GEOGCS[\"Anguilla 1957\",DATUM[\"Anguilla_1957\",SPHEROID[\"Clarke 1880 (RGS)\",6378249.145,293.465,AUTHORITY[\"EPSG\",\"7012\"]],AUTHORITY[\"EPSG\",\"6600\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4600\"]],UNIT[\"metre\",1,AUTHORITY[\"EPSG\",\"9001\"]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"latitude_of_origin\",0],PARAMETER[\"central_meridian\",-62],PARAMETER[\"scale_factor\",0.9995],PARAMETER[\"false_easting\",400000],PARAMETER[\"false_northing\",0],AUTHORITY[\"EPSG\",\"2000\"],AXIS[\"Easting\",EAST],AXIS[\"Northing\",NORTH]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(2001, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(2001, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"Antigua 1943 / British West Indies Grid\",GEOGCS[\"Antigua 1943\",DATUM[\"Antigua_1943\",SPHEROID[\"Clarke 1880 (RGS)\",6378249.145,293.465,AUTHORITY[\"EPSG\",\"7012\"]],AUTHORITY[\"EPSG\",\"6601\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4601\"]],UNIT[\"metre\",1,AUTHORITY[\"EPSG\",\"9001\"]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"latitude_of_origin\",0],PARAMETER[\"central_meridian\",-62],PARAMETER[\"scale_factor\",0.9995],PARAMETER[\"false_easting\",400000],PARAMETER[\"false_northing\",0],AUTHORITY[\"EPSG\",\"2001\"],AXIS[\"Easting\",EAST],AXIS[\"Northing\",NORTH]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(2002, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(2002, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"Dominica 1945 / British West Indies Grid\",GEOGCS[\"Dominica 1945\",DATUM[\"Dominica_1945\",SPHEROID[\"Clarke 1880 (RGS)\",6378249.145,293.465,AUTHORITY[\"EPSG\",\"7012\"]],TOWGS84[725,685,536,0,0,0,0],AUTHORITY[\"EPSG\",\"6602\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4602\"]],UNIT[\"metre\",1,AUTHORITY[\"EPSG\",\"9001\"]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"latitude_of_origin\",0],PARAMETER[\"central_meridian\",-62],PARAMETER[\"scale_factor\",0.9995],PARAMETER[\"false_easting\",400000],PARAMETER[\"false_northing\",0],AUTHORITY[\"EPSG\",\"2002\"],AXIS[\"Easting\",EAST],AXIS[\"Northing\",NORTH]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(2003, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(2003, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"Grenada 1953 / British West Indies Grid\",GEOGCS[\"Grenada 1953\",DATUM[\"Grenada_1953\",SPHEROID[\"Clarke 1880 (RGS)\",6378249.145,293.465,AUTHORITY[\"EPSG\",\"7012\"]],TOWGS84[72,213.7,93,0,0,0,0],AUTHORITY[\"EPSG\",\"6603\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4603\"]],UNIT[\"metre\",1,AUTHORITY[\"EPSG\",\"9001\"]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"latitude_of_origin\",0],PARAMETER[\"central_meridian\",-62],PARAMETER[\"scale_factor\",0.9995],PARAMETER[\"false_easting\",400000],PARAMETER[\"false_northing\",0],AUTHORITY[\"EPSG\",\"2003\"],AXIS[\"Easting\",EAST],AXIS[\"Northing\",NORTH]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(2004, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(2004, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"Montserrat 1958 / British West Indies Grid\",GEOGCS[\"Montserrat 1958\",DATUM[\"Montserrat_1958\",SPHEROID[\"Clarke 1880 (RGS)\",6378249.145,293.465,AUTHORITY[\"EPSG\",\"7012\"]],TOWGS84[174,359,365,0,0,0,0],AUTHORITY[\"EPSG\",\"6604\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4604\"]],UNIT[\"metre\",1,AUTHORITY[\"EPSG\",\"9001\"]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"latitude_of_origin\",0],PARAMETER[\"central_meridian\",-62],PARAMETER[\"scale_factor\",0.9995],PARAMETER[\"false_easting\",400000],PARAMETER[\"false_northing\",0],AUTHORITY[\"EPSG\",\"2004\"],AXIS[\"Easting\",EAST],AXIS[\"Northing\",NORTH]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(2005, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(2005, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"St. Kitts 1955 / British West Indies Grid\",GEOGCS[\"St. Kitts 1955\",DATUM[\"St_Kitts_1955\",SPHEROID[\"Clarke 1880 (RGS)\",6378249.145,293.465,AUTHORITY[\"EPSG\",\"7012\"]],AUTHORITY[\"EPSG\",\"6605\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4605\"]],UNIT[\"metre\",1,AUTHORITY[\"EPSG\",\"9001\"]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"latitude_of_origin\",0],PARAMETER[\"central_meridian\",-62],PARAMETER[\"scale_factor\",0.9995],PARAMETER[\"false_easting\",400000],PARAMETER[\"false_northing\",0],AUTHORITY[\"EPSG\",\"2005\"],AXIS[\"Easting\",EAST],AXIS[\"Northing\",NORTH]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(2006, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(2006, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"St. Lucia 1955 / British West Indies Grid\",GEOGCS[\"St. Lucia 1955\",DATUM[\"St_Lucia_1955\",SPHEROID[\"Clarke 1880 (RGS)\",6378249.145,293.465,AUTHORITY[\"EPSG\",\"7012\"]],TOWGS84[-149,128,296,0,0,0,0],AUTHORITY[\"EPSG\",\"6606\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4606\"]],UNIT[\"metre\",1,AUTHORITY[\"EPSG\",\"9001\"]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"latitude_of_origin\",0],PARAMETER[\"central_meridian\",-62],PARAMETER[\"scale_factor\",0.9995],PARAMETER[\"false_easting\",400000],PARAMETER[\"false_northing\",0],AUTHORITY[\"EPSG\",\"2006\"],AXIS[\"Easting\",EAST],AXIS[\"Northing\",NORTH]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(2007, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(2007, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"St. Vincent 45 / British West Indies Grid\",GEOGCS[\"St. Vincent 1945\",DATUM[\"St_Vincent_1945\",SPHEROID[\"Clarke 1880 (RGS)\",6378249.145,293.465,AUTHORITY[\"EPSG\",\"7012\"]],TOWGS84[195.671,332.517,274.607,0,0,0,0],AUTHORITY[\"EPSG\",\"6607\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4607\"]],UNIT[\"metre\",1,AUTHORITY[\"EPSG\",\"9001\"]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"latitude_of_origin\",0],PARAMETER[\"central_meridian\",-62],PARAMETER[\"scale_factor\",0.9995],PARAMETER[\"false_easting\",400000],PARAMETER[\"false_northing\",0],AUTHORITY[\"EPSG\",\"2007\"],AXIS[\"Easting\",EAST],AXIS[\"Northing\",NORTH]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(2008, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(2008, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"NAD27(CGQ77) / SCoPQ zone 2\",GEOGCS[\"NAD27(CGQ77)\",DATUM[\"North_American_Datum_1927_CGQ77\",SPHEROID[\"Clarke 1866\",6378206.4,294.9786982138982,AUTHORITY[\"EPSG\",\"7008\"]],AUTHORITY[\"EPSG\",\"6609\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4609\"]],UNIT[\"metre\",1,AUTHORITY[\"EPSG\",\"9001\"]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"latitude_of_origin\",0],PARAMETER[\"central_meridian\",-55.5],PARAMETER[\"scale_factor\",0.9999],PARAMETER[\"false_easting\",304800],PARAMETER[\"false_northing\",0],AUTHORITY[\"EPSG\",\"2008\"],AXIS[\"X\",EAST],AXIS[\"Y\",NORTH]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(2009, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(2009, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"NAD27(CGQ77) / SCoPQ zone 3\",GEOGCS[\"NAD27(CGQ77)\",DATUM[\"North_American_Datum_1927_CGQ77\",SPHEROID[\"Clarke 1866\",6378206.4,294.9786982138982,AUTHORITY[\"EPSG\",\"7008\"]],AUTHORITY[\"EPSG\",\"6609\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4609\"]],UNIT[\"metre\",1,AUTHORITY[\"EPSG\",\"9001\"]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"latitude_of_origin\",0],PARAMETER[\"central_meridian\",-58.5],PARAMETER[\"scale_factor\",0.9999],PARAMETER[\"false_easting\",304800],PARAMETER[\"false_northing\",0],AUTHORITY[\"EPSG\",\"2009\"],AXIS[\"X\",EAST],AXIS[\"Y\",NORTH]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(2010, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(2010, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"NAD27(CGQ77) / SCoPQ zone 4\",GEOGCS[\"NAD27(CGQ77)\",DATUM[\"North_American_Datum_1927_CGQ77\",SPHEROID[\"Clarke 1866\",6378206.4,294.9786982138982,AUTHORITY[\"EPSG\",\"7008\"]],AUTHORITY[\"EPSG\",\"6609\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4609\"]],UNIT[\"metre\",1,AUTHORITY[\"EPSG\",\"9001\"]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"latitude_of_origin\",0],PARAMETER[\"central_meridian\",-61.5],PARAMETER[\"scale_factor\",0.9999],PARAMETER[\"false_easting\",304800],PARAMETER[\"false_northing\",0],AUTHORITY[\"EPSG\",\"2010\"],AXIS[\"X\",EAST],AXIS[\"Y\",NORTH]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(2011, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(2011, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"NAD27(CGQ77) / SCoPQ zone 5\",GEOGCS[\"NAD27(CGQ77)\",DATUM[\"North_American_Datum_1927_CGQ77\",SPHEROID[\"Clarke 1866\",6378206.4,294.9786982138982,AUTHORITY[\"EPSG\",\"7008\"]],AUTHORITY[\"EPSG\",\"6609\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4609\"]],UNIT[\"metre\",1,AUTHORITY[\"EPSG\",\"9001\"]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"latitude_of_origin\",0],PARAMETER[\"central_meridian\",-64.5],PARAMETER[\"scale_factor\",0.9999],PARAMETER[\"false_easting\",304800],PARAMETER[\"false_northing\",0],AUTHORITY[\"EPSG\",\"2011\"],AXIS[\"X\",EAST],AXIS[\"Y\",NORTH]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(2012, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(2012, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"NAD27(CGQ77) / SCoPQ zone 6\",GEOGCS[\"NAD27(CGQ77)\",DATUM[\"North_American_Datum_1927_CGQ77\",SPHEROID[\"Clarke 1866\",6378206.4,294.9786982138982,AUTHORITY[\"EPSG\",\"7008\"]],AUTHORITY[\"EPSG\",\"6609\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4609\"]],UNIT[\"metre\",1,AUTHORITY[\"EPSG\",\"9001\"]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"latitude_of_origin\",0],PARAMETER[\"central_meridian\",-67.5],PARAMETER[\"scale_factor\",0.9999],PARAMETER[\"false_easting\",304800],PARAMETER[\"false_northing\",0],AUTHORITY[\"EPSG\",\"2012\"],AXIS[\"X\",EAST],AXIS[\"Y\",NORTH]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(2013, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(2013, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"NAD27(CGQ77) / SCoPQ zone 7\",GEOGCS[\"NAD27(CGQ77)\",DATUM[\"North_American_Datum_1927_CGQ77\",SPHEROID[\"Clarke 1866\",6378206.4,294.9786982138982,AUTHORITY[\"EPSG\",\"7008\"]],AUTHORITY[\"EPSG\",\"6609\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4609\"]],UNIT[\"metre\",1,AUTHORITY[\"EPSG\",\"9001\"]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"latitude_of_origin\",0],PARAMETER[\"central_meridian\",-70.5],PARAMETER[\"scale_factor\",0.9999],PARAMETER[\"false_easting\",304800],PARAMETER[\"false_northing\",0],AUTHORITY[\"EPSG\",\"2013\"],AXIS[\"X\",EAST],AXIS[\"Y\",NORTH]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(2014, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(2014, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"NAD27(CGQ77) / SCoPQ zone 8\",GEOGCS[\"NAD27(CGQ77)\",DATUM[\"North_American_Datum_1927_CGQ77\",SPHEROID[\"Clarke 1866\",6378206.4,294.9786982138982,AUTHORITY[\"EPSG\",\"7008\"]],AUTHORITY[\"EPSG\",\"6609\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4609\"]],UNIT[\"metre\",1,AUTHORITY[\"EPSG\",\"9001\"]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"latitude_of_origin\",0],PARAMETER[\"central_meridian\",-73.5],PARAMETER[\"scale_factor\",0.9999],PARAMETER[\"false_easting\",304800],PARAMETER[\"false_northing\",0],AUTHORITY[\"EPSG\",\"2014\"],AXIS[\"X\",EAST],AXIS[\"Y\",NORTH]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(2015, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(2015, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"NAD27(CGQ77) / SCoPQ zone 9\",GEOGCS[\"NAD27(CGQ77)\",DATUM[\"North_American_Datum_1927_CGQ77\",SPHEROID[\"Clarke 1866\",6378206.4,294.9786982138982,AUTHORITY[\"EPSG\",\"7008\"]],AUTHORITY[\"EPSG\",\"6609\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4609\"]],UNIT[\"metre\",1,AUTHORITY[\"EPSG\",\"9001\"]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"latitude_of_origin\",0],PARAMETER[\"central_meridian\",-76.5],PARAMETER[\"scale_factor\",0.9999],PARAMETER[\"false_easting\",304800],PARAMETER[\"false_northing\",0],AUTHORITY[\"EPSG\",\"2015\"],AXIS[\"X\",EAST],AXIS[\"Y\",NORTH]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(2016, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(2016, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"NAD27(CGQ77) / SCoPQ zone 10\",GEOGCS[\"NAD27(CGQ77)\",DATUM[\"North_American_Datum_1927_CGQ77\",SPHEROID[\"Clarke 1866\",6378206.4,294.9786982138982,AUTHORITY[\"EPSG\",\"7008\"]],AUTHORITY[\"EPSG\",\"6609\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4609\"]],UNIT[\"metre\",1,AUTHORITY[\"EPSG\",\"9001\"]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"latitude_of_origin\",0],PARAMETER[\"central_meridian\",-79.5],PARAMETER[\"scale_factor\",0.9999],PARAMETER[\"false_easting\",304800],PARAMETER[\"false_northing\",0],AUTHORITY[\"EPSG\",\"2016\"],AXIS[\"X\",EAST],AXIS[\"Y\",NORTH]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            table->field[0]->store(2017, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(2017, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("PROJCS[\"NAD27(76) / MTM zone 8\",GEOGCS[\"NAD27(76)\",DATUM[\"North_American_Datum_1927_1976\",SPHEROID[\"Clarke 1866\",6378206.4,294.9786982138982,AUTHORITY[\"EPSG\",\"7008\"]],AUTHORITY[\"EPSG\",\"6608\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4608\"]],UNIT[\"metre\",1,AUTHORITY[\"EPSG\",\"9001\"]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"latitude_of_origin\",0],PARAMETER[\"central_meridian\",-73.5],PARAMETER[\"scale_factor\",0.9999],PARAMETER[\"false_easting\",304800],PARAMETER[\"false_northing\",0],AUTHORITY[\"EPSG\",\"2017\"],AXIS[\"X\",EAST],AXIS[\"Y\",NORTH]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;


            table->field[0]->store(3819, TRUE); /*SRID*/
            table->field[1]->store(STRING_WITH_LEN("EPSG"), cs); /*AUTH_NAME*/
            table->field[2]->store(3819, TRUE); /*AUTH_SRID*/
            table->field[3]->store(STRING_WITH_LEN("GEOGCS[\"HD1909\",DATUM[\"Hungarian Datum 1909\",\
            SPHEROID[\"Bessel 1841\",6377397.155,299.1528128,AUTHORITY[\"EPSG\",\"7004\"]],\
            TOWGS84[595.48,121.69,515.35,4.115,2.9383,-0.853,-0.7029504596901044],\
            AUTHORITY[\"EPSG\",\"1024\"]],PRIMEM[\"Greenwich\",0.0,AUTHORITY[\"EPSG\",\
            \"8901\"]],UNIT[\"degree\",0.017453292519943295],AXIS[\"Geodetic latitude\",\
            NORTH],AXIS[\"Geodetic longitude\",EAST],AUTHORITY[\"EPSG\",\"3819\"]]"), cs);/*SRTEXT*/
            if (schema_table_store_record(thd, table))
              goto exit;

            result= 0;

          exit:
            DBUG_RETURN(result);
          }

          ]
          chidelmun Delveri Chick added a comment -

          fill_spatial_ref_sys() in sql/sql_spatial.cc does not fill the table.
          Need to populate this with the references

          chidelmun Delveri Chick added a comment - fill_spatial_ref_sys() in sql/sql_spatial.cc does not fill the table. Need to populate this with the references
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 59500 ] MariaDB v3 [ 65550 ]
          serg Sergei Golubchik made changes -
          Sprint 10.1.6-1 [ 6 ]
          holyfoot Alexey Botchkov made changes -
          Rank Ranked lower
          holyfoot Alexey Botchkov made changes -
          Sprint 10.1.6-1 [ 6 ] 10.1.6-2 [ 7 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Sprint 10.1.6-2 [ 7 ] 10.1.6-2, 10.0.21 [ 7, 8 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Rank Ranked higher
          ratzpo Rasmus Johansson (Inactive) made changes -
          Sprint 10.1.6-2, 10.0.21 [ 7, 8 ] 10.1.6-2 [ 7 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Rank Ranked lower
          ratzpo Rasmus Johansson (Inactive) made changes -
          Sprint 10.1.6-2 [ 7 ] 10.1.6-2, 10.1.7-1 [ 7, 10 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Rank Ranked lower
          serg Sergei Golubchik made changes -
          Rank Ranked higher
          ratzpo Rasmus Johansson (Inactive) made changes -
          Sprint 10.1.6-2, 10.1.7-1 [ 7, 10 ] 10.1.6-2, 10.1.7-1, 10.1.7-2 [ 7, 10, 12 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Rank Ranked higher
          ratzpo Rasmus Johansson (Inactive) made changes -
          Rank Ranked lower
          serg Sergei Golubchik made changes -
          Rank Ranked higher
          ratzpo Rasmus Johansson (Inactive) made changes -
          Sprint 10.1.6-2, 10.1.7-1, 10.1.7-2 [ 7, 10, 12 ] 10.1.6-2, 10.1.7-1, 10.1.7-2, 10.1.8-1 [ 7, 10, 12, 13 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Rank Ranked lower
          serg Sergei Golubchik made changes -
          Sprint 10.1.6-2, 10.1.7-1, 10.1.7-2, 10.1.8-1 [ 7, 10, 12, 13 ] 10.1.6-2, 10.1.7-1, 10.1.7-2, 10.1.8-1, 10.1.8-2 [ 7, 10, 12, 13, 14 ]
          serg Sergei Golubchik made changes -
          Rank Ranked higher
          serg Sergei Golubchik made changes -
          Sprint 10.1.6-2, 10.1.7-1, 10.1.7-2, 10.1.8-1, 10.1.8-2 [ 7, 10, 12, 13, 14 ] 10.1.6-2, 10.1.7-1, 10.1.7-2, 10.1.8-1 [ 7, 10, 12, 13 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Sprint 10.1.6-2, 10.1.7-1, 10.1.7-2, 10.1.8-1 [ 7, 10, 12, 13 ] 10.1.6-2, 10.1.7-1, 10.1.7-2, 10.1.8-1, 10.1.8-2 [ 7, 10, 12, 13, 14 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Rank Ranked lower
          ratzpo Rasmus Johansson (Inactive) made changes -
          Sprint 10.1.6-2, 10.1.7-1, 10.1.7-2, 10.1.8-1, 10.1.8-2 [ 7, 10, 12, 13, 14 ] 10.1.6-2, 10.1.7-1, 10.1.7-2, 10.1.8-1, 10.1.8-3 [ 7, 10, 12, 13, 15 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Rank Ranked higher
          ratzpo Rasmus Johansson (Inactive) made changes -
          Sprint 10.1.6-2, 10.1.7-1, 10.1.7-2, 10.1.8-1, 10.1.8-3 [ 7, 10, 12, 13, 15 ] 10.1.6-2, 10.1.7-1, 10.1.7-2, 10.1.8-1, 10.1.8-3, 10.1.9-3 [ 7, 10, 12, 13, 15, 20 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Rank Ranked lower
          ratzpo Rasmus Johansson (Inactive) made changes -
          ratzpo Rasmus Johansson (Inactive) made changes -
          ratzpo Rasmus Johansson (Inactive) made changes -
          ratzpo Rasmus Johansson (Inactive) made changes -
          Sprint 10.1.6-2, 10.1.7-1, 10.1.7-2, 10.1.8-1, 10.1.8-3, 10.1.9-3 [ 7, 10, 12, 13, 15, 20 ] 10.1.6-2, 10.1.7-1, 10.1.7-2, 10.1.8-1, 10.1.8-3 [ 7, 10, 12, 13, 15 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Rank Ranked higher
          serg Sergei Golubchik made changes -
          serg Sergei Golubchik made changes -
          serg Sergei Golubchik made changes -
          serg Sergei Golubchik made changes -
          Sprint 10.1.6-2, 10.1.7-1, 10.1.7-2, 10.1.8-1, 10.1.8-3 [ 7, 10, 12, 13, 15 ] 10.1.6-2, 10.1.7-1, 10.1.7-2, 10.1.8-1, 10.1.8-3, 10.1.10 [ 7, 10, 12, 13, 15, 24 ]
          holyfoot Alexey Botchkov added a comment -

          Patch: http://lists.askmonty.org/pipermail/commits/2015-December/008775.html

          holyfoot Alexey Botchkov added a comment - Patch: http://lists.askmonty.org/pipermail/commits/2015-December/008775.html
          holyfoot Alexey Botchkov made changes -
          Fix Version/s 10.1.10 [ 20402 ]
          Fix Version/s 10.1 [ 16100 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 65550 ] MariaDB v4 [ 148774 ]

          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.