diff options
| author | monty@mysql.com <> | 2004-11-04 15:06:24 +0200 |
|---|---|---|
| committer | monty@mysql.com <> | 2004-11-04 15:06:24 +0200 |
| commit | 071001950efe9886a56ec8a365217f0d1cd92c1f (patch) | |
| tree | 9d4d27a72c18ead47fb83bd5ec0e2383cdd34ff6 /mysql-test/t/range.test | |
| parent | a1a27eb35a8ad7616cb08937dc4e959e2410c35b (diff) | |
| parent | f5e5dfb2f779cbb5468d63d94d659fa3d6a17e8a (diff) | |
| download | mariadb-git-071001950efe9886a56ec8a365217f0d1cd92c1f.tar.gz | |
Merge with 4.1 to get in latest bug fixes
Diffstat (limited to 'mysql-test/t/range.test')
| -rw-r--r-- | mysql-test/t/range.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/range.test b/mysql-test/t/range.test index d8794b2f394..e0d2e07bef2 100644 --- a/mysql-test/t/range.test +++ b/mysql-test/t/range.test @@ -418,3 +418,17 @@ select count(*) from t2 where x > -16; select count(*) from t2 where x = 18446744073709551601; drop table t1,t2; +# +# Bug #6045: Binary Comparison regression in MySQL 4.1 +# Binary searches didn't use a case insensitive index. +# +set names latin1; +create table t1 (a char(10), b text, key (a)) character set latin1; +INSERT INTO t1 (a) VALUES +('111'),('222'),('222'),('222'),('222'),('444'),('aaa'),('AAA'),('bbb'); +# all these three can be optimized +explain select * from t1 where a='aaa'; +explain select * from t1 where a=binary 'aaa'; +explain select * from t1 where a='aaa' collate latin1_bin; +# this one cannot: +explain select * from t1 where a='aaa' collate latin1_german1_ci; |