diff options
| author | serg@serg.mylan <> | 2004-08-01 13:26:01 +0200 |
|---|---|---|
| committer | serg@serg.mylan <> | 2004-08-01 13:26:01 +0200 |
| commit | f4244cd00e0a97b1e92f78fef4da3cfdad2664ca (patch) | |
| tree | 6d221952b67a636cef97629f4983774c40f53206 /mysql-test/r | |
| parent | 22ca5582d005754d3907ce6bc088ba2d9710d1eb (diff) | |
| download | mariadb-git-f4244cd00e0a97b1e92f78fef4da3cfdad2664ca.tar.gz | |
bug#4816. index search for NULL in blob
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/myisam.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index 1fd64377f12..c55bacdd371 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -453,3 +453,12 @@ table type possible_keys key key_len ref rows Extra t1 system NULL NULL NULL NULL 1 Using temporary t2 index NULL PRIMARY 4 NULL 2 Using index; Distinct drop table t1,t2; +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; +table type possible_keys key key_len ref rows Extra +t1 ref idx idx 4 const 1 Using where +select count(*) from t1 where a is null; +count(*) +2 +drop table t1; |