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 | e7d138ecc250ccae8ccc86f2e5b10d8cb0c9dec7 (patch) | |
| tree | 41557706d9a6634dd90773de01ff3d7a12fd8d5f /mysql-test/t | |
| parent | bb4c1bf5a42eccac2e04051c9147d733e18daf8d (diff) | |
| download | mariadb-git-e7d138ecc250ccae8ccc86f2e5b10d8cb0c9dec7.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/t')
| -rw-r--r-- | mysql-test/t/range.test | 3 |
1 files changed, 2 insertions, 1 deletions
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; |