diff options
| author | unknown <ram@mysql.r18.ru> | 2003-03-06 16:25:06 +0400 |
|---|---|---|
| committer | unknown <ram@mysql.r18.ru> | 2003-03-06 16:25:06 +0400 |
| commit | 66d003302924862bb89f6f703f8b432d16530747 (patch) | |
| tree | 0fde70fc259ae0acd63f533e4d28ad69efced466 /mysql-test | |
| parent | a8c7a0833c6d6205534b2f605273982a9c01fc98 (diff) | |
| download | mariadb-git-66d003302924862bb89f6f703f8b432d16530747.tar.gz | |
Added IsClosed() tests for MultiLineString objects.
Added Centroid(), Area() tests for MultiPolygon objects.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/gis.result | 15 | ||||
| -rw-r--r-- | mysql-test/t/gis.test | 5 |
2 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/gis.result b/mysql-test/r/gis.result index d3ec335aac6..25c3d14212b 100644 --- a/mysql-test/r/gis.result +++ b/mysql-test/r/gis.result @@ -259,6 +259,21 @@ fid AsText(InteriorRingN(g, 1)) 108 NULL 109 LINESTRING(10 10,20 10,20 20,10 20,10 10) 110 NULL +SELECT fid, IsClosed(g) FROM mls; +fid IsClosed(g) +114 0 +115 0 +116 0 +SELECT fid, AsText(Centroid(g)) FROM mp; +fid AsText(Centroid(g)) +117 POINT(55.588527753042 17.426536064114) +118 POINT(55.588527753042 17.426536064114) +119 POINT(2 2) +SELECT fid, Area(g) FROM mp; +fid Area(g) +117 1684.5 +118 1684.5 +119 4.5 SELECT fid, NumGeometries(g) from mpt; fid NumGeometries(g) 111 4 diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test index 128d369b0b6..35bb682f732 100644 --- a/mysql-test/t/gis.test +++ b/mysql-test/t/gis.test @@ -89,6 +89,11 @@ SELECT fid, AsText(ExteriorRing(g)) FROM p; SELECT fid, NumInteriorRings(g) FROM p; SELECT fid, AsText(InteriorRingN(g, 1)) FROM p; +SELECT fid, IsClosed(g) FROM mls; + +SELECT fid, AsText(Centroid(g)) FROM mp; +SELECT fid, Area(g) FROM mp; + SELECT fid, NumGeometries(g) from mpt; SELECT fid, NumGeometries(g) from mls; SELECT fid, NumGeometries(g) from mp; |