diff options
| author | kaa@kaamos.(none) <> | 2008-02-13 12:12:00 +0300 |
|---|---|---|
| committer | kaa@kaamos.(none) <> | 2008-02-13 12:12:00 +0300 |
| commit | 9f194149b85c38744670decd4e859b8574f4335b (patch) | |
| tree | 32093b4d9c9eff7578d39bb14fee8bbbdcf1dc4b /mysql-test/t/range.test | |
| parent | a44413741a3e1195b92ea10e394a7d2e60079fd3 (diff) | |
| parent | 1a67148ccdcfe894b23e1fa022e2f246864b68df (diff) | |
| download | mariadb-git-9f194149b85c38744670decd4e859b8574f4335b.tar.gz | |
Merge kaamos.(none):/data/src/opt/mysql-5.0-opt
into kaamos.(none):/data/src/opt/mysql-5.1-opt
Diffstat (limited to 'mysql-test/t/range.test')
| -rw-r--r-- | mysql-test/t/range.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/range.test b/mysql-test/t/range.test index e20f0370e2c..514e3074292 100644 --- a/mysql-test/t/range.test +++ b/mysql-test/t/range.test @@ -955,6 +955,23 @@ explain select * from t1 where dateval >= '2007-01-01 00:00:00' and dateval <= ' drop table t1; +# +# Bug #33833: different or-ed predicates were erroneously merged into one that +# resulted in ref access instead of range access and a wrong result set +# + +CREATE TABLE t1 ( + a varchar(32), index (a) +) DEFAULT CHARSET=latin1 COLLATE=latin1_bin; + +INSERT INTO t1 VALUES + ('B'), ('A'), ('A'), ('C'), ('B'), ('A'), ('A'); + +SELECT a FROM t1 WHERE a='b' OR a='B'; +EXPLAIN SELECT a FROM t1 WHERE a='b' OR a='B'; + +DROP TABLE t1; + # End of 5.0 tests # BUG#22393 fix: Adjust 'ref' estimate if we have 'range' estimate for |