View Incident Report

Serious

Reported By: Oliver Wiechens
Reported On: 3/10/2005
For: Version 4.17 Build 1

# 1971 SQL WHERE Clause <> Comparison On Integer Field Returns Incorrect Results

Running the following SQL Commands in a Query or in the DBSYS doesn't return all records:

select Artikel,ZuLiefern,ZuBerechnen from auftragpos
where (ZuBerechnen <> 0) and (ZuBerechnen is not null)

Comments

The ZuBerechnen column was indexed in this case. This issue was very similar to other optimized <> conditions for other column data types in 4.17.

Resolution

Fixed Problem on 3/10/2005 in version 4.18 build 1

More Support Options