Reported By: Guenter Angerer Reported On: 12/11/2000 For: Version 2.05 Build 1
# 683Multiple INNER JOINs in Certain SQL Queries Can Cause an AV I get an AV with a Query containing 2 inner joins. Delphi stops in
"function TSourceTable.NextTableJoinRead: Boolean;"
on line
Result:=TargetTable.NextRecordRead;
SELECT Cld_vai1.K981_7842 Instrument_Key,
Cld_clb2clc3.F2811 Pre_Maturity
FROM CLD_VAI1
INNER JOIN CLD_VAI1CLB2
ON Cld_vai1.VAI1 = Cld_vai1clb2.VAI1
INNER JOIN CLD_CLB2CLC3
ON Cld_vai1clb2.CLB2 = Cld_clb2clc3.CLB2
CommentsWe were overrunning an internal structure limit by not properly checking the bounds of a list of tables used in the joins.
ResolutionFixed Problem on 12/12/2000 in version 2.06 build 1