diff options
| author | unknown <monty@hundin.mysql.fi> | 2002-03-22 14:03:42 +0200 |
|---|---|---|
| committer | unknown <monty@hundin.mysql.fi> | 2002-03-22 14:03:42 +0200 |
| commit | 8f2f1597500c4cf74d5d73a4ee04b54f440df695 (patch) | |
| tree | 41557706d9a6634dd90773de01ff3d7a12fd8d5f /mysql-test | |
| parent | 30016518c3444e92ac1e43cfd71fc335d760bc19 (diff) | |
| download | mariadb-git-8f2f1597500c4cf74d5d73a4ee04b54f440df695.tar.gz | |
Fix for bug in WHERE key='j' or key='J'
Docs/manual.texi:
Changelog
myisam/myisampack.c:
Delete tmp file on error.
mysql-test/r/range.result:
Updated test case
mysql-test/t/range.test:
Updated test case
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; |