diff options
| author | unknown <serg@serg.mylan> | 2004-08-01 13:26:01 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2004-08-01 13:26:01 +0200 |
| commit | d14a27fdadeec3cd7c29b04b7051f32e66320087 (patch) | |
| tree | 6d221952b67a636cef97629f4983774c40f53206 /mysql-test/t/myisam.test | |
| parent | 9ca47d047e5164515eac6fcae05ae9450cb94213 (diff) | |
| download | mariadb-git-d14a27fdadeec3cd7c29b04b7051f32e66320087.tar.gz | |
bug#4816. index search for NULL in blob
Diffstat (limited to 'mysql-test/t/myisam.test')
| -rw-r--r-- | mysql-test/t/myisam.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/myisam.test b/mysql-test/t/myisam.test index 59b86309d77..57b64e30bac 100644 --- a/mysql-test/t/myisam.test +++ b/mysql-test/t/myisam.test @@ -436,3 +436,13 @@ select sql_big_result distinct t1.a from t1,t2; explain select sql_big_result distinct t1.a from t1,t2 order by t2.a; explain select distinct t1.a from t1,t2 order by t2.a; drop table t1,t2; + +# +# index search for NULL in blob. Bug #4816 +# +create table t1 ( a tinytext, b char(1), index idx (a(1),b) ); +insert into t1 values (null,''), (null,''); +explain select count(*) from t1 where a is null; +select count(*) from t1 where a is null; +drop table t1; + |