diff options
| author | monty@hundin.mysql.fi <> | 2002-03-22 14:03:42 +0200 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2002-03-22 14:03:42 +0200 |
| commit | ed040fe21e981bae96f0b81fa8a8dfcae67a9995 (patch) | |
| tree | 41557706d9a6634dd90773de01ff3d7a12fd8d5f /mysql-test | |
| parent | 82d87ebd16825e9237f541bf3d966e9c7d132c49 (diff) | |
| download | mariadb-git-ed040fe21e981bae96f0b81fa8a8dfcae67a9995.tar.gz | |
Fix for bug in WHERE key='j' or key='J'
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/range.result | 10 | ||||
| -rw-r--r-- | mysql-test/t/range.test | 3 |
2 files changed, 12 insertions, 1 deletions
diff --git a/mysql-test/r/range.result b/mysql-test/r/range.result index e0e43f44a4b..1a45c252b7c 100644 --- a/mysql-test/r/range.result +++ b/mysql-test/r/range.result @@ -55,3 +55,13 @@ believe believe in love aString believe in myself +count(*) +602 +count(*) +602 +count(*) +602 +count(*) +389 +count(*) +213 diff --git a/mysql-test/t/range.test b/mysql-test/t/range.test index ccb66506efd..278807eeea4 100644 --- a/mysql-test/t/range.test +++ b/mysql-test/t/range.test @@ -105,7 +105,6 @@ drop table t1; # Problem with binary strings # -DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( t1ID int(10) unsigned NOT NULL auto_increment, art char(1) binary NOT NULL default '', @@ -161,4 +160,6 @@ INSERT INTO t1 (art) VALUES ('j'),('J'),('j'),('J'),('j'),('J'),('j'),('J'),('j' select count(*) from t1 where upper(art) = 'J'; select count(*) from t1 where art = 'J' or art = 'j'; select count(*) from t1 where art = 'j' or art = 'J'; +select count(*) from t1 where art = 'j'; +select count(*) from t1 where art = 'J'; drop table t1; |