Icon View Incident Report

Serious Serious
Reported By: Christian Sanggaard
Reported On: 4/8/2009
For: Version 4.27 Build 4
# 2975 LEFT OUTER JOINs with Non-Join Conditions Using OR Operator Return Incorrect Results

I've upgraded from DBISAM 4.26 to DBISAM 4.27.04 and discovered that where is a different between these two releases.

I tried executing the following SQL, and in DBISAM 4.26 it returns 6 rows, while in DBISAM 4.27 it returns 3 rows.

select t.EntryNo,t.TradeGroup,e.EmpNo,e.EmpName
from "Test1" t
left outer join "Test2" e on e.TradeGroup=t.TradeGroup or t.TradeGroup=null



Comments Comments
The issue was with the OR operator and the during-join condition for LEFT OUTER JOINs.


Resolution Resolution
Fixed Problem on 4/13/2009 in version 4.27 build 5


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image