Reported By: Oliver Bock Reported On: 10/6/2004 For: Version 4.12 Build 1
# 1857IS NOT NULL on Indexed Columns Causes Incorrect Results 'is not null' does not work on char/varchar columns that are indexed. Instead of filtering out null rows it leaves them in.
Workaround:
- not (s is null), or
- remove index
create table T (s char(1), primary key(s) );
insert into T values('A');
insert into T values(null);
select * from T
where s is not null
ResolutionFixed Problem on 10/16/2004 in version 4.13 build 1