Icon View Incident Report

Serious Serious
Reported By: Ole Willy Tuv
Reported On: 3/23/2007
For: Version 1.01 Build 1
# 2281 COLLATE Clause Ignored in an ORDER BY or GROUP BY Clause

With the following SQL, the collate clause seems to be ignored. In fact, EDB doesn't complain about an invalid collation name.

select *
from test
order by col2 collate enu_CI



Resolution Resolution
Fixed Problem on 3/25/2007 in version 1.02 build 1


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image