diff options
| author | Alexey Botchkov <holyfoot@askmonty.org> | 2014-12-03 14:07:43 +0400 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2014-12-04 16:09:34 +0100 |
| commit | c4cb15e87ba8cf4f1e7fd8e7cda5c88098ecd515 (patch) | |
| tree | 042b437f82a3368aa8c9d5b3c894182f75ec93bf /mysql-test/t/gis.test | |
| parent | c4655cf862b24fe040280e38cb71d3b5d25f049b (diff) | |
| download | mariadb-git-c4cb15e87ba8cf4f1e7fd8e7cda5c88098ecd515.tar.gz | |
MDEV-60 Support for Spatial Reference systems for the GIS data.
The GEOMETRY field metadata is stored in the FRM file.
SRID for a spatial column now can be stored, it was added to the CREATE TABLE syntax,
so the AddGeometryData() stored procedure is now possible. Script adding the required Add/DropGeometryColumn sp-s added.
Diffstat (limited to 'mysql-test/t/gis.test')
| -rw-r--r-- | mysql-test/t/gis.test | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test index 2cc9f0c930b..2679874ddff 100644 --- a/mysql-test/t/gis.test +++ b/mysql-test/t/gis.test @@ -1453,3 +1453,8 @@ create table t2(g LINESTRING, pl POLYGON); select * from information_schema.geometry_columns; drop table t1, t2; +--echo 10.1 tests +create table t1(g GEOMETRY(9,4) REF_SYSTEM_ID=101, pt POINT(8,2), pg GEOMETRY REF_SYSTEM_ID=102); +SELECT SRID from information_schema.geometry_columns WHERE G_TABLE_NAME='t1'; +drop table t1; + |