View Incident Report

Serious

Reported By: Marilyn Fleming
Reported On: 3/23/2001
For: Version 2.08 Build 1

# 745 ORDER BY NOCASE Clause with a DISTINCT Query Causes NOCASE to be Ignored

Query results are not ordered properly when the DISTINCT keyword is present and the ORDER BY matches the DISTINCT fields but adds a NOCASE keyword.

SELECT DISTINCT field
FROM table
ORDER BY field NOCASE

Comments

This also applies when there is a GROUP BY clause with the same fields as the ORDER BY.

Resolution

Fixed Problem on 5/1/2001 in version 2.09 build 1

More Support Options