Reported By: Thomas Stahmer Reported On: 12/17/2003 For: Version 4.01 Build 1
# 1514Using an ORDER BY Clause an SQL SELECT Statement Can Cause an Access Violation Executing an SQL SELECT statement where the ORDER BY attempts to order the result set according to a column that is located in the target table of a join can cause an AV.
SELECT *
FROM groups a
LEFT OUTER JOIN article b
ON a.article_id=b.id
WHERE group_id = 3
ORDER BY article_date <----- This column is in the target table
CommentsThe target table must have more columns than the driver table, and the ORDER BY column must be a column that is past the number of columns in the driver table.
ResolutionFixed Problem on 12/19/2003 in version 4.02 build 1