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