View Incident Report

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

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap