diff options
| author | gluh@eagle.(none) <> | 2007-12-13 16:10:57 +0400 |
|---|---|---|
| committer | gluh@eagle.(none) <> | 2007-12-13 16:10:57 +0400 |
| commit | d504588e7948b1f8ed815a78aeb263471a1b6635 (patch) | |
| tree | 2c8c40e7d9d218e840756bed5ba5cbd07e40d13b /mysql-test/t/range.test | |
| parent | 4f5868114a1fe46f139f80d894dd28f1f7c180c1 (diff) | |
| parent | 9df070ed7c0f2877e71572e59aec871f4bc039fd (diff) | |
| download | mariadb-git-d504588e7948b1f8ed815a78aeb263471a1b6635.tar.gz | |
Merge mysql.com:/home/gluh/MySQL/Merge/5.0-opt
into mysql.com:/home/gluh/MySQL/Merge/5.1-opt
Diffstat (limited to 'mysql-test/t/range.test')
| -rw-r--r-- | mysql-test/t/range.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/t/range.test b/mysql-test/t/range.test index 06c2ef248c4..e20f0370e2c 100644 --- a/mysql-test/t/range.test +++ b/mysql-test/t/range.test @@ -935,6 +935,26 @@ SELECT * FROM t1 WHERE item='A1' AND started<='2005-12-02 00:00:00'; DROP TABLE t1; +--echo +--echo BUG#32198 "Comparison of DATE with DATETIME still not using indexes correctly" +--echo +CREATE TABLE t1 ( + id int(11) NOT NULL auto_increment, + dateval date default NULL, + PRIMARY KEY (id), + KEY dateval (dateval) +) AUTO_INCREMENT=173; + +INSERT INTO t1 VALUES +(1,'2007-01-01'),(2,'2007-01-02'),(3,'2007-01-03'),(4,'2007-01-04'), +(5,'2007-01-05'),(6,'2007-01-06'),(7,'2007-01-07'),(8,'2007-01-08'), +(9,'2007-01-09'),(10,'2007-01-10'),(11,'2007-01-11'); + +--echo This must use range access: +explain select * from t1 where dateval >= '2007-01-01 00:00:00' and dateval <= '2007-01-02 23:59:59'; + +drop table t1; + # End of 5.0 tests # BUG#22393 fix: Adjust 'ref' estimate if we have 'range' estimate for |