diff options
Diffstat (limited to 'mysql-test/t')
| -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 # |