> >Where should I report this bug in Firebird?
>
> Nowhere. It isn't a bug, it's an opinion. :-)
>
> The standard declares the question of *which* row is taken as "the one" in
> a DISTINCT set as implementation dependent. So - where Oracle and

Firebird

> might happen to take the first one encountered (taken in no particular
> order) and discard the rest, another engine might process the candidates
> differently, discarding all but the last. Since it is impossible to

perform

> a positioned update on a DISTINCT cursor, it's irrelevant in terms of

output.

What does the standard say about an "order by" on a column
not in the resultset?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com