Icon View Incident Report

Serious Serious
Reported By: Larry Lustig
Reported On: 2/17/1999
For: Version 1.11 Build 1
# 309 IS NOT NULL SQL Operator Is Not Working Properly

Typing either of the following two SELECT commands into DBSYS:

SELECT * FROM Claims WHERE RefByAttorneyID IS NOT NULL
SELECT * FROM Claims WHERE RefByAttorneyID IS NULL

returns the same result set -- the one for the second statement (that is, both SELECTS return the one record in which RefByAttorneyID is in fact set to NULL).


Comments Comments
Problem was with the IS NOT NULL operator. This problem did not affect filters, only queries.


Resolution Resolution
Fixed Problem on 2/17/1999 in version 1.12 build 1
Image