WL#9348: INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS

Affects: Server-8.0   —   Status: Complete   —   Priority: Medium

Spatial reference system (SRS) definitions were implemented by WL#8579 and are stored in the data dictionary table mysql.st_spatial_reference_systems. This table is not meant to be used by users/DBAs and will be hidden by future WLs.

In order to inspect the SRS definitions, to find out which SRSs are supported and which SRID refers to which SRS, the users need an INFORMATION_SCHEMA view to this information.

This WL implements the view INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS as defined in SQL/MM Part 3, Sect. 19.3.

The view is not updatable. Support for creating and dropping SRSs will be implemented.

User Documentation

Interface INSTR03 INFORMATION_SCHEMA is extended with one more view: INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS.