Reported By: Helmut Woess Reported On: 7/26/2000 For: Version 2.03 Build 1
# 584SQL SELECT Statement Not Working Properly with Column-to-Column Comparisons in WHERE Clause Column-to-column comparisons in an SQL SELECT statement's WHERE clause are causing the query to return the wrong results.
rec1: f1 = 1, f2 = 2, f3 = 3
rec2: f1 = 2, f2 = 2, f3 = 2
select * from test where f1 = 2 or (f1 = 1 and f2 < f3)
ResolutionFixed Problem on 7/27/2000 in version 2.04 build 1