Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: [SPAM] 10gR2 Upgrade .. Watch out
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-lReceived on Wed Dec 27 2006 - 17:21:32 CST
![]() |
![]() |