Bug #10176 problem with varchar keys
Submitted: 26 Apr 2005 13:22 Modified: 28 Apr 2005 2:05
Reporter: Ramil Kalimullin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S3 (Non-critical)
Version:5.0 OS:
Assigned to: Ramil Kalimullin CPU Architecture:Any

[26 Apr 2005 13:22] Ramil Kalimullin
Description:
see "How to repeat"

How to repeat:
create table t1(a int, b varchar(12), key ba(b, a));
insert into t1 values (1, 'A'), (20, NULL);
explain select * from t1 where a=20 and b is null;
select * from t1 where a=20 and b is null;

--> empty set returned.
[26 Apr 2005 14:53] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/24320
[26 Apr 2005 15:58] Ramil Kalimullin
fixed in 5.0.6
[28 Apr 2005 2:05] Paul DuBois
Noted in 5.0.6 changelog.