diff options
| author | Alexey Botchkov <holyfoot@askmonty.org> | 2014-12-03 14:07:43 +0400 |
|---|---|---|
| committer | Alexey Botchkov <holyfoot@askmonty.org> | 2014-12-03 16:45:02 +0400 |
| commit | ae8237995790f5e3d4769f08db5324791e39c197 (patch) | |
| tree | 323ba0713ab244b6551b40eac81b7046e22a5c63 /mysql-test | |
| parent | cfb7ee1cba9416a817708d4e93458668729a2668 (diff) | |
| download | mariadb-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')
| -rw-r--r-- | mysql-test/r/gis.result | 16 | ||||
| -rw-r--r-- | mysql-test/t/gis.test | 5 |
2 files changed, 17 insertions, 4 deletions
diff --git a/mysql-test/r/gis.result b/mysql-test/r/gis.result index baedf17152c..bab1e8d23b1 100644 --- a/mysql-test/r/gis.result +++ b/mysql-test/r/gis.result @@ -1710,8 +1710,16 @@ create table t1(g GEOMETRY, pt POINT); create table t2(g LINESTRING, pl POLYGON); select * from information_schema.geometry_columns; F_TABLE_CATALOG F_TABLE_SCHEMA F_TABLE_NAME F_GEOMETRY_COLUMN G_TABLE_CATALOG G_TABLE_SCHEMA G_TABLE_NAME G_GEOMETRY_COLUMN STORAGE_TYPE GEOMETRY_TYPE COORD_DIMENSION MAX_PPR SRID -def test t1 def test t1 g 1 0 2 0 0 0 -def test t1 def test t1 pt 1 1 2 0 0 0 -def test t2 def test t2 g 1 2 2 0 0 0 -def test t2 def test t2 pl 1 3 2 0 0 0 +def test t1 def test t1 g 1 0 2 0 0 +def test t1 def test t1 pt 1 1 2 0 0 +def test t2 def test t2 g 1 2 2 0 0 +def test t2 def test t2 pl 1 3 2 0 0 drop table t1, t2; +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'; +SRID +101 +0 +102 +drop table t1; 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; + |