diff options
Diffstat (limited to 'mysql-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; |