Icon View Incident Report

Serious Serious
Reported By: Helmut Woess
Reported On: 7/26/2000
For: Version 2.03 Build 1
# 584 SQL 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)



Resolution Resolution
Fixed Problem on 7/27/2000 in version 2.04 build 1
Image