Re: EOF & DISTINCT/ORDER BY problem - need help...

Even more tantalizing comment from a plugin class file --
         // AK: using DISTINCT with ORDER BY UPPER(foo) is an error if 
it is not also present in the columns list...
         // This implementation sucks, but should be good enough for the 
normal case

Yep... looks like the problem I have.  Guess I'll be switching to the 
Wonder plugin (CVS version).

sim

On Jan 27, 2005, at 11:39 AM, Arturo Perez wrote:

> The SQL being generated is not really standard.  The SQL standard 
> doesn't allow sorting by a column that is not selected.  So I don't 
> think it's the DISTINCT that's getting you.  The plugin may help but I 
> don't know for sure.  Although there is this tantalizing CVS comment 
> from Anjo.
>
> Revision 1.15  - (view) (download) (annotate) - [select for diffs]
> Tue Jul 20 10:11:57 2004 UTC (6 months, 1 week ago) by anjo
> Branch: MAIN
> Changes since 1.14: +35 -11 lines
> Diff to previous 1.14
>
> fix for DISTINCT with caseInsensitive sort ordering