View Incident Report

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

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

Resolution

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

Products Affected

DBISAM Additional Software and Utilities
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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap