Re: 10gR2 Upgrade .. Watch out

In 9iRel2 (irrespective of what the manual used to say) the order by was taking place.. if the manual says it does not guarantee, it should not then sort it every time and produce the result .. yes i agree that unless "order by" is mentioned it should not sort .. but the 9iRel2 optimizer was doing it (so too 10.1.0) .. this was not happening with 10.2.0 ..

 Remember one thing .. if the manual says the same for 9.2 and 10.2 as  you had mentioned . the default behaviour should not change across  upgrades .. correct .. BUT that is not the case.. Hope this clarifies..

On Thu, 28 Dec 2006 00:45:58 +0200, "Gints Plivna" <gints.plivna_at_gmail.com> said:
> 2006/12/28, GovindanK :
> > 1. Group by was not doing the sort in the default order where as 9.2.0.6 /
> > 9i Rel2 was doing so
> > 2. Same problem with SELECT DISTINCT / SELECT UNIQUE
>
> Mhmmmm what is the default sort order for group by and distinct/unique?
> Docs at least for 9.2 and 10.2 have the same sentence for group by
> "The GROUP BY clause groups rows but does not guarantee the order of
> the result set. To order the groupings, use the ORDER BY clause."
> Cannot find on the spot the same for distinct/unique but I'm sure
> similar sentence applies here as well.
>
> I'm by no means saying that 10.2 has no problems/bugs, but to me these
> two seems quite normal behaviour :)
>
> Gints Plivna
> http://www.gplivna.eu

--
http://www.freelists.org/webpage/oracle-l