View Incident Report

Serious

Reported By: Stoian Ivanov
Reported On: 10/6/2003
For: Version 3.26 Build 1

# 1450 Executing a SELECT Statement with a False Constant Condition in the WHERE Clause Produces Records

While developing a Almost-Human-Language-Data-Search-Criteria-to-SQL- WHERE-Clause, I came across to the interesting behaviour of:

SELECT * FROM UDCALL WHERE FALSE; /*.EQU. SELECT * FROM UDCALL;*/

while 

SELECT * FROM UDCALL WHERE FALSE AND TRUE; 

works as expected.

Resolution

Fixed Problem on 10/10/2003 in version 3.27 build 1

More Support Options