diff options
| author | unknown <monty@mashka.mysql.fi> | 2002-09-18 02:04:56 +0300 |
|---|---|---|
| committer | unknown <monty@mashka.mysql.fi> | 2002-09-18 02:04:56 +0300 |
| commit | 081023e8fd9a5ab196ca56d55ea256f33ea76f3f (patch) | |
| tree | 8a07e18388ef6432b1dfbdd5138e6ad09fd57e21 /mysql-test/t/binary.test | |
| parent | 00b310fa54d6ab7dabcb626595ff35a980a85d9c (diff) | |
| parent | e4860747ebc5fddac571526d7c9c5e3f7452ab85 (diff) | |
| download | mariadb-git-081023e8fd9a5ab196ca56d55ea256f33ea76f3f.tar.gz | |
merge with 3.23.53 (only code cleanup and new test case)
Docs/manual.texi:
Auto merged
mysql-test/t/binary.test:
Auto merged
mysql-test/r/binary.result:
merge with 3.23.53
sql/item_strfunc.h:
Code cleanup
Diffstat (limited to 'mysql-test/t/binary.test')
| -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 be9917dc888..fc2d91e20fe 100644 --- a/mysql-test/t/binary.test +++ b/mysql-test/t/binary.test @@ -32,3 +32,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; |