diff options
| author | Alexey Botchkov <holyfoot@montyprogram.com> | 2014-09-02 11:31:26 +0500 |
|---|---|---|
| committer | Alexey Botchkov <holyfoot@montyprogram.com> | 2014-10-21 12:25:47 +0500 |
| commit | c3db4459561bc491582bef6bea7b83e9fe464a10 (patch) | |
| tree | a3308648bcde663b43f703a1a52051e95ce13ebe /mysql-test/t/gis.test | |
| parent | c1f5f61c9b651cac80f22319beed13733963c632 (diff) | |
| download | mariadb-git-c3db4459561bc491582bef6bea7b83e9fe464a10.tar.gz | |
MDEV-12 OpenGIS: create required tables: GeometryColumns, related views.
GEOMETRY_COLUMNS and SPATIAL_REF_SYS tables added to the INFORMATION_SCHEMA.
Diffstat (limited to 'mysql-test/t/gis.test')
| -rw-r--r-- | mysql-test/t/gis.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test index d20e4c1711e..5dc5b48f32c 100644 --- a/mysql-test/t/gis.test +++ b/mysql-test/t/gis.test @@ -1473,3 +1473,12 @@ insert into t1 values(Geomfromtext('POLYGON((1 1, 2 2, 2 1, 1 1))')); drop table t1; --echo End of 5.5 tests + +SHOW CREATE TABLE information_schema.geometry_columns; +SHOW CREATE TABLE information_schema.spatial_ref_sys; + +create table t1(g GEOMETRY, pt POINT); +create table t2(g LINESTRING, pl POLYGON); +select * from information_schema.geometry_columns; +drop table t1, t2; + |