View Incident Report

Serious

Reported By: Guenter Angerer
Reported On: 12/11/2000
For: Version 2.05 Build 1

# 683 Multiple 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

Comments

We were overrunning an internal structure limit by not properly checking the bounds of a list of tables used in the joins.

Resolution

Fixed Problem on 12/12/2000 in version 2.06 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap