diff options
Diffstat (limited to 'mysql-test/r/gis.result')
| -rw-r--r-- | mysql-test/r/gis.result | 15 |
1 files changed, 9 insertions, 6 deletions
diff --git a/mysql-test/r/gis.result b/mysql-test/r/gis.result index 190795855dd..5a8571bb17e 100644 --- a/mysql-test/r/gis.result +++ b/mysql-test/r/gis.result @@ -230,7 +230,7 @@ fid AsText(Envelope(g)) 119 POLYGON((0 0,3 0,3 3,0 3,0 0)) 120 POLYGON((0 0,10 0,10 10,0 10,0 0)) 121 POLYGON((3 6,44 6,44 9,3 9,3 6)) -122 POLYGON((1.79769313486232e+308 1.79769313486232e+308,-1.79769313486232e+308 1.79769313486232e+308,-1.79769313486232e+308 -1.79769313486232e+308,1.79769313486232e+308 -1.79769313486232e+308,1.79769313486232e+308 1.79769313486232e+308)) +122 NULL explain extended select Dimension(g), GeometryType(g), IsEmpty(g), AsText(Envelope(g)) from gis_geometry; id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE gis_geometry ALL NULL NULL NULL NULL 22 100.00 @@ -396,13 +396,13 @@ FROM gis_geometrycollection g1, gis_geometrycollection g2 ORDER BY first, second first second w c o e d t i r 120 120 1 1 0 1 0 1 1 1 120 121 0 0 1 0 0 0 1 0 -120 122 0 1 0 0 1 0 0 0 +120 122 0 1 NULL NULL NULL 0 NULL 0 121 120 0 0 1 0 0 0 1 0 121 121 1 1 0 1 0 1 1 1 -121 122 0 1 0 0 1 0 0 0 -122 120 1 0 0 0 1 0 0 0 -122 121 1 0 0 0 1 0 0 0 -122 122 1 1 0 1 1 0 0 0 +121 122 0 1 NULL NULL NULL 0 NULL 0 +122 120 1 0 NULL NULL NULL 0 NULL 0 +122 121 1 0 NULL NULL NULL 0 NULL 0 +122 122 1 1 NULL NULL NULL 0 NULL 0 explain extended SELECT g1.fid as first, g2.fid as second, Within(g1.g, g2.g) as w, Contains(g1.g, g2.g) as c, Overlaps(g1.g, g2.g) as o, Equals(g1.g, g2.g) as e, Disjoint(g1.g, g2.g) as d, Touches(g1.g, g2.g) as t, @@ -1077,6 +1077,9 @@ SPATIAL INDEX i1 (col1, col2) ERROR HY000: Incorrect arguments to SPATIAL INDEX DROP TABLE t1; DROP TABLE t2; +select ST_AREA(ST_GEOMCOLLFROMTEXT(' GEOMETRYCOLLECTION(LINESTRING(100 100, 31 10, 77 80), POLYGON((0 0,4 7,1 1,0 0)), POINT(20 20))')); +ST_AREA(ST_GEOMCOLLFROMTEXT(' GEOMETRYCOLLECTION(LINESTRING(100 100, 31 10, 77 80), POLYGON((0 0,4 7,1 1,0 0)), POINT(20 20))')) +1.5 DROP DATABASE IF EXISTS gis_ogs; CREATE DATABASE gis_ogs; USE gis_ogs; |