Reported By: Stoian Ivanov Reported On: 10/6/2003 For: Version 3.26 Build 1
# 1450Executing 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.
ResolutionFixed Problem on 10/10/2003 in version 3.27 build 1