Icon View Incident Report

Serious Serious
Reported By: Paul Malone
Reported On: 10/17/2000
For: Version 2.04 Build 1
# 639 >= or <= Join Operators Not Working Correctly in SQL SELECT Statements

The following simple query fails to give the correct results. It behaves as if the less than sign and greater than sign are backwards. That is with my test tables, the result when using (T1.Age < T2.Age) should have 3 records. When using (T1.Age > T2.Age) the result should have 0 records. But the actual results are 0 for <, and 3 for >.

{ Employees.DAT (SSN: Integer, Age: Integer)
  SSN  Age
  1      10
  2      20
  3      30

  Managers.DAT (SSN: Integer, Age: Integer)
  SSN  Age
  1      100
  2      200
  3      300 }

select T1.SSN, T1.Age,
T2.SSN, T2.Age
from Employees T1,
Managers T2
where (T1.SSN=T2.SSN) and (T1.Age < T2.Age)

Comments Comments
Initially thought to be fixed in 2.04, however we did not get the fix complete and needed to make an additional change on top of the existing changes in 2.04 that "partially" fixed the problem.

Resolution Resolution
Fixed Problem on 10/20/2000 in version 2.05 build 1