summaryrefslogtreecommitdiff
path: root/mysql-test/t
diff options
context:
space:
mode:
authorAlexey Botchkov <holyfoot@askmonty.org>2014-12-03 14:07:43 +0400
committerAlexey Botchkov <holyfoot@askmonty.org>2014-12-03 16:45:02 +0400
commitae8237995790f5e3d4769f08db5324791e39c197 (patch)
tree323ba0713ab244b6551b40eac81b7046e22a5c63 /mysql-test/t
parentcfb7ee1cba9416a817708d4e93458668729a2668 (diff)
downloadmariadb-git-mdev-60-merge.tar.gz
MDEV-60 Support for Spatial Reference systems for the GIS data.mdev-60-merge
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')
-rw-r--r--mysql-test/t/gis.test5
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test
index 60642e5741c..9ab4cd5ea7a 100644
--- a/mysql-test/t/gis.test
+++ b/mysql-test/t/gis.test
@@ -1448,3 +1448,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;
+