Icon View Incident Report

Minor Minor
Reported By: Oliver Bock
Reported On: 10/6/2004
For: Version 4.12 Build 1
# 1857 IS 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



Resolution Resolution
Fixed Problem on 10/16/2004 in version 4.13 build 1
Image