Re: [SPAM] 10gR2 Upgrade .. Watch out
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: gkatteri@xxxxxxxxxxx
- Date: Wed, 27 Dec 2006 16:16:21 -0700
At 03:42 PM 12/27/2006, GovindanK wrote:
You are correct .. order of output is not guaranteed unless one
specifies an 'order by' clause explicitly .. but it certainly looks
unacceptable when the default behaviour changes across upgrades .. in
9iRel2 Oracle was doing the sort implicitlly (which should not have been
the case) and they left it high and dry in 10gRel2 reverting back to the
"expected" behaviour .. this results in the mismatch of the output order
across upgrades.
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:
