WL#8582: INFORMATION_SCHEMA.ST_GEOMETRY_COLUMNS

General GIS applications need a way to locate geographical data in a database and to inspect the properties of geometry columns, e.g., to display a list to the user with things to plot.

This WL adds the INFORMATION_SCHEMA.ST_GEOMETRY_COLUMNS view as specified in SQL/MM Part 3, Sect. 19.2.

The view is backed by INFORMATION_SCHEMA.COLUMNS. The SRS_NAME and SRS_ID columns are always NULL (for now).

User Documentation

• http://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-1.html
• http://dev.mysql.com/doc/refman/8.0/en/st-geometry-columns-table.html

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

Add the required columns in the view.

Also add a non-standard extension: The column GEOMETRY_TYPE_NAME specifies the column type, either GEOMETRY or a more specific type. This is similar to the implementation in SQL Anywhere.