diff options
author | Alexey Botchkov <holyfoot@askmonty.org> | 2017-01-24 22:39:55 +0400 |
---|---|---|
committer | Alexey Botchkov <holyfoot@askmonty.org> | 2017-01-24 22:39:55 +0400 |
commit | 1782102d978caeea282147ff6ca89e325a3da512 (patch) | |
tree | 06b3ac9e2a3369b11c80be46811397de6a4a29fa /mysql-test/r | |
parent | 6cdbf2027e4f6dff40e0ea5da8d6cc6b9b6e255b (diff) | |
download | mariadb-git-1782102d978caeea282147ff6ca89e325a3da512.tar.gz |
MDEV-11042 Implement GeoJSON functions.
Typenames made into proper character case.
Diffstat (limited to 'mysql-test/r')
-rw-r--r-- | mysql-test/r/gis-json.result | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/r/gis-json.result b/mysql-test/r/gis-json.result index 14b532784f7..8625a5bfb74 100644 --- a/mysql-test/r/gis-json.result +++ b/mysql-test/r/gis-json.result @@ -1,24 +1,24 @@ select st_asgeojson(geomfromtext('POINT(1 1)')); st_asgeojson(geomfromtext('POINT(1 1)')) -{"type": "POINT", "coordinates": [1, 1]} +{"type": "Point", "coordinates": [1, 1]} select st_asgeojson(geomfromtext('LINESTRING(10 10,20 10,20 20,10 20,10 10)')); st_asgeojson(geomfromtext('LINESTRING(10 10,20 10,20 20,10 20,10 10)')) -{"type": "LINESTRING", "coordinates": [[10, 10], [20, 10], [20, 20], [10, 20], [10, 10]]} +{"type": "LineString", "coordinates": [[10, 10], [20, 10], [20, 20], [10, 20], [10, 10]]} select st_asgeojson(geomfromtext('POLYGON((10 10,20 10,20 20,10 20,10 10))')); st_asgeojson(geomfromtext('POLYGON((10 10,20 10,20 20,10 20,10 10))')) -{"type": "POLYGON", "coordinates": [[[10, 10], [20, 10], [20, 20], [10, 20], [10, 10]]]} +{"type": "Polygon", "coordinates": [[[10, 10], [20, 10], [20, 20], [10, 20], [10, 10]]]} select st_asgeojson(geomfromtext('MULTIPOLYGON(((10 10,20 10,20 20,10 20,10 10)))')); st_asgeojson(geomfromtext('MULTIPOLYGON(((10 10,20 10,20 20,10 20,10 10)))')) -{"type": "MULTIPOLYGON", "coordinates": [[[[10, 10], [20, 10], [20, 20], [10, 20], [10, 10]]]]} +{"type": "MultiPolygon", "coordinates": [[[[10, 10], [20, 10], [20, 20], [10, 20], [10, 10]]]]} select st_asgeojson(geomfromtext('multilinestring((10 10,20 10,20 20,10 20,10 10))')); st_asgeojson(geomfromtext('multilinestring((10 10,20 10,20 20,10 20,10 10))')) -{"type": "MULTILINESTRING", "coordinates": [[[10, 10], [20, 10], [20, 20], [10, 20], [10, 10]]]} +{"type": "MultiLineString", "coordinates": [[[10, 10], [20, 10], [20, 20], [10, 20], [10, 10]]]} select st_asgeojson(geomfromtext('multipoint(10 10,20 10,20 20,10 20,10 10)')); st_asgeojson(geomfromtext('multipoint(10 10,20 10,20 20,10 20,10 10)')) -{"type": "MULTIPOINT", "coordinates": [[10, 10], [20, 10], [20, 20], [10, 20], [10, 10]]} +{"type": "MultiPoint", "coordinates": [[10, 10], [20, 10], [20, 20], [10, 20], [10, 10]]} select st_asgeojson(st_geomfromtext('GEOMETRYCOLLECTION(POINT(100 0),LINESTRING(101 0,102 1))')); st_asgeojson(st_geomfromtext('GEOMETRYCOLLECTION(POINT(100 0),LINESTRING(101 0,102 1))')) -{"type": "GEOMETRYCOLLECTION", "geometries": [{"type": "POINT", "coordinates": [100, 0]}, {"type": "LINESTRING", "coordinates": [[101, 0], [102, 1]]}]} +{"type": "GeometryCollection", "geometries": [{"type": "Point", "coordinates": [100, 0]}, {"type": "LineString", "coordinates": [[101, 0], [102, 1]]}]} SELECT st_astext(st_geomfromgeojson('{"type":"point","coordinates":[1,2]}')); st_astext(st_geomfromgeojson('{"type":"point","coordinates":[1,2]}')) POINT(1 2) |