diff options
| author | unknown <ram@mysql.r18.ru> | 2003-03-18 17:01:38 +0400 |
|---|---|---|
| committer | unknown <ram@mysql.r18.ru> | 2003-03-18 17:01:38 +0400 |
| commit | fe8ea234c9c8cd29f487f839d9ec875043bc25ce (patch) | |
| tree | 7495b2ceb29935dd03bfa9a287a92dbb5af335d0 /mysql-test/t/gis-rtree.test | |
| parent | 3ccd93c704556d9496b643e580dca8a9fcd2f4d4 (diff) | |
| download | mariadb-git-fe8ea234c9c8cd29f487f839d9ec875043bc25ce.tar.gz | |
Should use GeometryFromWKB().
Diffstat (limited to 'mysql-test/t/gis-rtree.test')
| -rw-r--r-- | mysql-test/t/gis-rtree.test | 11 |
1 files changed, 4 insertions, 7 deletions
diff --git a/mysql-test/t/gis-rtree.test b/mysql-test/t/gis-rtree.test index 86fd5723e5a..0368ddb41cb 100644 --- a/mysql-test/t/gis-rtree.test +++ b/mysql-test/t/gis-rtree.test @@ -23,10 +23,8 @@ while ($1) } SELECT count(*) FROM t1; -EXPLAIN SELECT fid, AsText(g) FROM t1 WHERE Within(g, - GeomFromText('Polygon((140 140,160 140,160 160,140 160,140 140))')); -SELECT fid, AsText(g) FROM t1 WHERE Within(g, - GeomFromText('Polygon((140 140,160 140,160 160,140 160,140 140))')); +EXPLAIN SELECT fid, AsText(g) FROM t1 WHERE Within(g, GeomFromText('Polygon((140 140,160 140,160 160,140 160,140 140))')); +SELECT fid, AsText(g) FROM t1 WHERE Within(g, GeomFromText('Polygon((140 140,160 140,160 160,140 160,140 140))')); DROP TABLE t1; @@ -41,8 +39,7 @@ while ($1) let $2=10; while ($2) { - eval INSERT INTO t2 (g) VALUES (LineString(Point($1 * 10 - 9, $2 * 10 - 9), - Point($1 * 10, $2 * 10))); + eval INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point($1 * 10 - 9, $2 * 10 - 9), Point($1 * 10, $2 * 10)))); dec $2; } dec $1; @@ -62,7 +59,7 @@ while ($1) let $2=10; while ($2) { - eval DELETE FROM t2 WHERE Within(g, Envelope(LineString(Point($1 * 10 - 9, $2 * 10 - 9), Point($1 * 10, $2 * 10)))); + eval DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point($1 * 10 - 9, $2 * 10 - 9), Point($1 * 10, $2 * 10))))); SELECT count(*) FROM t2; dec $2; } |