diff options
author | Igor Babaev <igor@askmonty.org> | 2009-11-09 18:32:39 -0800 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2009-11-09 18:32:39 -0800 |
commit | d749c7e60061fd328e95f74d2d77fc59312da3b1 (patch) | |
tree | 152399c01e2cfe90637108d45146c48d9f4d6904 /mysql-test/t/gis-rtree.test | |
parent | 90a4a3dcd7049b65ba59c57bdb434cd8b9b3b823 (diff) | |
parent | 9b7a0fddbea952372adc04b1c098411b19cb173b (diff) | |
download | mariadb-git-d749c7e60061fd328e95f74d2d77fc59312da3b1.tar.gz |
Merge
Diffstat (limited to 'mysql-test/t/gis-rtree.test')
-rw-r--r-- | mysql-test/t/gis-rtree.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/gis-rtree.test b/mysql-test/t/gis-rtree.test index 19bbcf19cca..944a00f008f 100644 --- a/mysql-test/t/gis-rtree.test +++ b/mysql-test/t/gis-rtree.test @@ -17,12 +17,16 @@ SHOW CREATE TABLE t1; let $1=150; let $2=150; +--disable_query_log +begin; while ($1) { eval INSERT INTO t1 (g) VALUES (GeomFromText('LineString($1 $1, $2 $2)')); dec $1; inc $2; } +commit; +--enable_query_log 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))')); @@ -35,6 +39,8 @@ CREATE TABLE t2 ( g GEOMETRY NOT NULL ) ENGINE=MyISAM; +--disable_query_log +begin; let $1=10; while ($1) { @@ -46,6 +52,8 @@ while ($1) } dec $1; } +commit; +--enable_query_log ALTER TABLE t2 ADD SPATIAL KEY(g); SHOW CREATE TABLE t2; @@ -55,6 +63,8 @@ EXPLAIN SELECT fid, AsText(g) FROM t2 WHERE Within(g, SELECT fid, AsText(g) FROM t2 WHERE Within(g, GeomFromText('Polygon((40 40,60 40,60 60,40 60,40 40))')); +--disable_query_log +begin; let $1=10; while ($1) { @@ -67,6 +77,8 @@ while ($1) } dec $1; } +commit; +--enable_query_log DROP TABLE t2; |