diff options
| author | unknown <bar@mysql.com> | 2004-11-03 15:22:33 +0400 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2004-11-03 15:22:33 +0400 |
| commit | 0afed4c3eb914788528087405022878a2ef5bc95 (patch) | |
| tree | c5bf40ee83d4e86e49280ff78cf080946ca52bee /mysql-test/t/range.test | |
| parent | 78c4faa297539c95c33c69d00dfb5e129c2afcca (diff) | |
| download | mariadb-git-0afed4c3eb914788528087405022878a2ef5bc95.tar.gz | |
opt_range.cc, range.result, range.test:
Bug #6045: Binary Comparison regression in MySQL 4.1
Binary searches didn't use a case insensitive index, now they do.
mysql-test/t/range.test:
Bug #6045: Binary Comparison regression in MySQL 4.1
Binary searches didn't use a case insensitive index, now they do.
mysql-test/r/range.result:
Bug #6045: Binary Comparison regression in MySQL 4.1
Binary searches didn't use a case insensitive index, now they do.
sql/opt_range.cc:
Bug #6045: Binary Comparison regression in MySQL 4.1
Binary searches didn't use a case insensitive index, now they do.
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 cd6620f7126..44f55da5722 100644 --- a/mysql-test/t/range.test +++ b/mysql-test/t/range.test @@ -431,3 +431,17 @@ select count(*) from t1 where x = 18446744073709551601; drop table t1; +# +# 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; |