Subject Re: [firebird-support] Re: Valid reasons for sorting on a column one doesn't select? - a BUG!
Author Martijn Tonies
> >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
> 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
> a positioned update on a DISTINCT cursor, it's irrelevant in terms of

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
Upscene Productions
Database development questions? Check the forum!