Icon View Incident Report

Serious 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 Resolution
Fixed Problem on 12/30/2008 in version 4.27 build 3


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