View Incident Report

Serious

Reported By: Carter Moss
Reported On: 7/16/2003
For: Version 3.24 Build 1

# 1379 Certain Combinations of Non-Join Expressions in SQL Joins Can Cause Improper Results

The following SQL should work in DBISAM, but produces and empty record set.

SELECT *
FROM 
"SCHEDULE.DAT" SCHEDULE
left join "Reserved.Dat" reserved on (RESERVED.SCHID = SCHEDULE.
SCHID)
left join "ROOMS.DAT" ROOMS on (ROOMS.RMSID = RESERVED.ID) AND 
(RESERVED.TYPE = 1)
left join "EQUIPMNT.DAT" EQUIPMNT on (EQUIPMNT.EQID = RESERVED.ID) 
AND (RESERVED.TYPE = 2)

Resolution

Fixed Problem on 7/20/2003 in version 3.25 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap