View Incident Report

Serious

Reported By: Oliver Bock
Reported On: 7/8/2004
For: Version 3.29 Build 1

# 1817 Specifying SQL JOIN Conditions On Tables Not Involved in the JOIN Directly Causes AV

DBISAM crashes when I attempt a particular join. I can work around it by swapping the two tables in the FROM clause.

select * 
from GLNew mN, SystemGLAccount SA
join PaySlip PS on mN.SourceID = PS.PaySlipID
join Tax T on SA.PAYGTaxID = T.TaxID

Resolution

Fixed Problem on 8/10/2004 in version 3.30 build 1

More Support Options