Re: [Firebird-devel] Using DISTINCT and ORDER

[Philippe M. <mak...@fi...>]

Le 28/11/2006 13:13, Vlad Horsun a dit :
>>> We can produce a warning, if you want.
>> Sounds good, although i'm not sure if this will be noticed by the user=
s.
>=20
> MS SQL 2000:
>=20
> Server: Msg 145, Level 15, State 1, Line 1
> ORDER BY items must appear in the select list if SELECT DISTINCT is spe=
cified.
>=20
and Oracle 10 :
ORA-01791: not a SELECTed expression

 SELECT
   DISTINCT
   d2.DISTINCTDATA
 FROM
   A_DISTINCT  d2
 ORDER BY
   <ERROR>d2.SORTDATA



--=20
Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird and InterBase
Firebird serveur SQL open-source en fran=E7ais http://firebird-fr.eu.org

Ma cl=E9 PGP : http://makowski.eu.org/pgpkey.html