diff options
| -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; |