Re: HASH GROUP BY
Date: Wed, 23 Apr 2008 13:51:51 -0700
Ah, ok. Didn't get that from your post.
Many people have relied on this 'feature' in the past, only to see it
with a new version.
On Wed, Apr 23, 2008 at 1:40 PM, Elliott, Patrick < patrick.elliott_at_medtronic.com> wrote:
> That is correct. My point is that what Rob is calling wrong results is
> actually just unexpected results based on invalid assumptions.
> *From:* Jared Still [mailto:jkstill_at_gmail.com]
> *Sent:* Wednesday, April 23, 2008 3:34 PM
> *To:* Elliott, Patrick
> *Cc:* Rob.Dempsey_at_5one.co.uk; oracle-l_at_freelists.org
> *Subject:* Re: HASH GROUP BY
> On Wed, Apr 23, 2008 at 12:20 PM, Elliott, Patrick <
> patrick.elliott_at_medtronic.com> wrote:
> > Now I understand what you mean by buggy. It no longer sorts the rows.
> > If you have code that relies on a group by being in sorted order, then the
> > code will no longer work. If you have had to disable this in the past to
> > get correct results, then you will need to continue disabling it
> > indefinitely. The only way to fix it and reenable the hashing group by is
> > to change the code.
> GROUP BY has never been documented to provide rows in sorted order.
> From the docs:
> 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.
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
> [CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this email
> is proprietary to Medtronic and is intended for use only by the individual
> or entity to which it is addressed, and may contain information that is
> private, privileged, confidential or exempt from disclosure under applicable
> law. If you are not the intended recipient or it appears that this mail has
> been forwarded to you without proper authority, you are notified that any
> use or dissemination of this information in any manner is strictly
> prohibited. In such cases, please delete this mail from your records. To
> view this notice in other languages you can either select the following link
> or manually copy and paste the link into the address bar of a web browser:
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 23 2008 - 15:51:51 CDT