Re: [SPAM] 10gR2 Upgrade .. Watch out
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Dec 2006 15:21:32 -0800
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@xxxxxxxxxxxxx> 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
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
