Bug #10176 problem with varchar keys

• Submitted: 26 Apr 2005 13:22
• Modified: 28 Apr 2005 2:05
• Reporter: Ramil Kalimullin
• Status: Closed
• Category: MySQL Server: MyISAM storage engine
• Severity: S3 (Non-critical)
• Version: 5.0
• 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.