Icon View Incident Report

Serious Serious
Reported By: Tiago Ameller
Reported On: 12/11/2000
For: Version 2.05 Build 1
# 682 Using a Constant=Constant Comparison in SQL WHERE Clause Causes Incorrect Results

Look at that query. It should fetch 9 records, but the FIRST time it returns 0 records, and the SECOND and so on Opens it returns the correct 9 records. The cause of the "TRUE = True" is the result of a complicated (and bad dessigned) algorithm.

SELECT * FROM "disrecib.dat"
WHERE Fecha BETWEEN "2000-12-01" AND "2000-12-01"
AND ((Girado = false) OR (TRUE = True))

Resolution Resolution
Fixed Problem on 12/12/2000 in version 2.06 build 1