diff options
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; |