Re: [Firebird-devel] Using DISTINCT and ORDER BY together andunpredictable results

[Claudio V. C. <cv...@us...>]

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of Milan
> Babuskov
> Sent: Martes, 28 de Noviembre de 2006 17:54
>
> Suppose you have a table:
>
> X   Y
> --- ---
>    1   3
>    1   5
>    2   4
>
> What should the following query return: SELECT DISTINCT X ORDER BY Y?
>
> 1
> 2
>
> or
>
> 2
> 1

The user asked for a hidden field to drive the order, then I don't care.

I can be convinced that people are afraid of DISTINCT v/s SORT on hidden
field and forbid it, but not the general case.

C.