"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message
news:QJbgc.3043$hw5.3108_at_attbi_s53...
> > | always keep in mind that default behavior can change from version to
> > version
> > |
> > | how much pre-9i SQL do you think broke when the GROUP BY clause
stopped
> > | ordering the rows?
> > |
> > | ;-{ mcs
> > |
> > |
> >
> > reference: MetaLink Note:224815.1
> It was a stupid thing to rely on. It was never stated that group by
without
> an order by would sort in a particular order. It was not a good behavior
to
> rely on. Gosh the ANSI standard says that without the order by
> specification the order is indeterminate.
> Jim
I'm amazed that a support analyst ever filed a bug for it...
--
Niall Litchfield
Oracle DBA
Audit Commission UK
http://www.niall.litchfield.dial.pipex.com/
Received on Mon Apr 19 2004 - 04:02:08 CDT
