View Incident Report

Serious

Reported By: Thomas Stahmer
Reported On: 12/17/2003
For: Version 4.01 Build 1

# 1514 Using 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

Comments

The 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.

Resolution

Fixed Problem on 12/19/2003 in version 4.02 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap