Reported By: Elevate Software Reported On: 11/8/2001 For: Version 3.03 Build 1
# 956Executing a SQL Query that Mixes SQL-92 and SQL-89 Joins in a Certain Order Can Cause an AV Executing the following SQL can cause an AV:
SELECT a.*
FROM TABLE4 a
INNER JOIN TABLE5 d ON T4_SFLD1 = T5_SFLD1, TABLE2 b
LEFT OUTER JOIN TABLE1 c ON c.T1_KEY = b.T2_KEY1
WHERE a.T4_KEY = c.T1_SFLD1 AND a.T4_KEY = 'Abbott'
CommentsThis query was from the Advantage Database benchmarks posted on their site. It's not a very likely scenario since the result set is 8000+ empty rows. Basically the problem was that the ordering of the joins confused DBISAM's internal join re-ordering code.
ResolutionFixed Problem on 11/8/2001 in version 3.04 build 1