diff options
| author | unknown <monty@mashka.mysql.fi> | 2002-09-18 02:00:56 +0300 |
|---|---|---|
| committer | unknown <monty@mashka.mysql.fi> | 2002-09-18 02:00:56 +0300 |
| commit | e4860747ebc5fddac571526d7c9c5e3f7452ab85 (patch) | |
| tree | f22c90322c2755606b968a7823358f365eedc591 /mysql-test/t | |
| parent | 6f8b510a2b96637ecf7aa52353f1367212140cf8 (diff) | |
| download | mariadb-git-e4860747ebc5fddac571526d7c9c5e3f7452ab85.tar.gz | |
Fixed bug with BINARY NULL
Docs/manual.texi:
ChangeLog
mysql-test/r/binary.result:
Test of binary NULL
mysql-test/t/binary.test:
Test of binary NULL
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/binary.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/binary.test b/mysql-test/t/binary.test index 7853b013ae6..ef4249c39f8 100644 --- a/mysql-test/t/binary.test +++ b/mysql-test/t/binary.test @@ -31,3 +31,13 @@ select * from t1 where a="hello "; select * from t1 where b="hello "; select * from t1 where b="hello"; drop table t1; + +# +# Test of binary and NULL +# +create table t1 (b char(8)); +insert into t1 values(NULL); +select b from t1 where binary b like ''; +select b from t1 group by binary b like ''; +select b from t1 having binary b like ''; +drop table t1; |