Yes .. it did expose bug in the application code .. some developers did
not put the order by clause explicitly .. That is exactly the reason why
i am posting it here .. so that one will do a "pre-upgrade" check of
their code ..
On Wed, 27 Dec 2006 16:16:21 -0700, "Wolfgang Breitling"
<breitliw_at_centrexcc.com> said:
> As far as I'm concerned it merely exposes a bug in your application
> code, relying on group by to return the result set in a certain
> order. Just because it happens to work in some cases (here Oracle pre
> 10gR2) does not make it the default behaviour. It was just a side
> effect of an implementation detail. The default behaviour is that
> without the order by caluse Oracle can return the resultset in any
> order it darn well pleases, including in the group by order, but it
> doesn't have to. And Oracle warned all along not to rely on it.
>
>
> Regards
>
> Wolfgang Breitling
> Centrex Consulting Corporation
> www.centrexcc.com
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 27 2006 - 17:21:32 CST
