Re: 10gR2 Upgrade .. Watch out

  • From: "GovindanK" <gkatteri@xxxxxxxxxxx>
  • To: "Gints Plivna" <gints.plivna@xxxxxxxxx>
  • Date: Wed, 27 Dec 2006 14:53:59 -0800

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@xxxxxxxxx> said:
> 2006/12/28, GovindanK :
> > 1. Group by was not doing the sort in the default order where as /
> > 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

Other related posts: