Bug #10176 problem with varchar keys
Submitted: 26 Apr 2005 15:22 Modified: 28 Apr 2005 4:05
Reporter: Ramil Kalimullin
Status: Closed
Category:Server: MyISAM Severity:S3 (Non-critical)
Version:5.0 OS:
Assigned to: Ramil Kalimullin Target Version:

[26 Apr 2005 15: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 16: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 17:58] Ramil Kalimullin 
fixed in 5.0.6
[28 Apr 2005 4:05] Paul DuBois 
Noted in 5.0.6 changelog.