View Incident Report

Serious

Reported By: Oliver Bock
Reported On: 12/28/2008
For: Version 4.27 Build 2

# 2888 Using NOT Operator in a Left Outer Join Condition Can Cause AV

If you use DBSYS to run the attached query on the attached tables then DBSYS will crash upon exit. I have tried this with tables from two different databases so I think there is no corruption problem.

select *
from Contract Crt
left outer join Vendor V on V.PartyID = Crt.PartyID and Crt.
IsForPurchases
left outer join Customer C on C.PartyID = Crt.PartyID and not Crt.
IsForPurchases
where Crt.Superseded is null and coalesce(V.PartyID, C.PartyID) is null

Resolution

Fixed Problem on 12/30/2008 in version 4.27 build 3

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