On 12/27/06, GovindanK <gkatteri_at_fastmail.fm> wrote:
>
> In an earlier posting , Juan Carlos had mentioned about having problem with "union all"; We encountered the following after upgrading to 10gR2. Thought i will share this with the list.
>
> 1. Group by was not doing the sort in the default order where as 9.2.0.6 / 9i Rel2 was doing so
>
>
This behavior has been documented for many years.
GROUP BY has never guaranteed SORT order, and likely never will.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 28 2006 - 13:36:55 CST
