Re: 10gR2 Upgrade .. Watch out

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