diff options
| author | Alexander Barkov <bar@mariadb.org> | 2015-08-13 14:25:51 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2015-08-13 14:25:51 +0400 |
| commit | 60985e5375ae7e8143f0ae4f6c70f1833d268f76 (patch) | |
| tree | 54f9055912004a483f2c24f215aa3b593a0f50c0 /mysql-test/t/gis-rtree.test | |
| parent | 9d884fd3d3fadd5ad31ecfee915877b98258e546 (diff) | |
| download | mariadb-git-60985e5375ae7e8143f0ae4f6c70f1833d268f76.tar.gz | |
MDEV-8610 "WHERE CONTAINS(indexed_geometry_column,1)" causes full table scan
Diffstat (limited to 'mysql-test/t/gis-rtree.test')
| -rw-r--r-- | mysql-test/t/gis-rtree.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/gis-rtree.test b/mysql-test/t/gis-rtree.test index 9c8dce50127..acd91a91c27 100644 --- a/mysql-test/t/gis-rtree.test +++ b/mysql-test/t/gis-rtree.test @@ -994,5 +994,19 @@ EXPLAIN SELECT * FROM t1 WHERE ST_INTERSECTS(Point(1,2),a); DROP TABLE t1; --echo # +--echo # MDEV-8610 "WHERE CONTAINS(indexed_geometry_column,1)" causes full table scan +--echo # +CREATE TABLE t1 (a GEOMETRY NOT NULL, SPATIAL KEY(a)) ENGINE=MyISAM; +INSERT INTO t1 VALUES (Point(1,1)),(Point(2,2)),(Point(3,3)); +EXPLAIN SELECT * FROM t1 WHERE CONTAINS(a,1); +EXPLAIN SELECT * FROM t1 WHERE CONTAINS(a,1.0); +EXPLAIN SELECT * FROM t1 WHERE CONTAINS(a,1e0); +EXPLAIN SELECT * FROM t1 WHERE CONTAINS(a,TIME'00:00:00'); +EXPLAIN SELECT * FROM t1 WHERE CONTAINS(a,DATE'2001-01-01'); +EXPLAIN SELECT * FROM t1 WHERE CONTAINS(a,TIMESTAMP'2001-01-01 00:00:00'); +DROP TABLE t1; + + +--echo # --echo # End of 10.1 tests --echo # |