From e4860747ebc5fddac571526d7c9c5e3f7452ab85 Mon Sep 17 00:00:00 2001 From: unknown Date: Wed, 18 Sep 2002 02:00:56 +0300 Subject: 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 --- mysql-test/t/binary.test | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'mysql-test/t/binary.test') 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; -- cgit v1.2.1