Icon View Incident Report

Serious Serious
Reported By: Elevate Software
Reported On: 12/17/2003
For: Version 4.01 Build 1
# 1515 Mixing an ORDER BY and GROUP BY Clause Together Can Cause Incorrect Grouped Results

Mixing an ORDER BY and GROUP BY in the same SQL SELECT statement can cause the grouping to be incorrect, with repeated groups in some cases.

SELECT customerno, count(customerno)
FROM downlog
WHERE releasenumber=4.01
GROUP BY 1
ORDER BY 2 DESC



Resolution Resolution
Fixed Problem on 12/20/2003 in version 4.02 build 1
Image