View Incident Report

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap