Re: The job of a relational DBMS
From: Thomas Kellerer <OTPXDAJCSJVU_at_spammotel.com>
Date: Wed, 02 Dec 2009 10:00:50 +0100
Message-ID: <7nmoltF3lkrleU1_at_mid.individual.net>
Shakespeare, 02.12.2009 08:13:
> Thomas Kellerer schreef:
>
> Never? It did at least in Oracle 7. As a well known and too many times
> used side effect. I remember having to reprogram queries because
> developed programs relied on the sort....
Date: Wed, 02 Dec 2009 10:00:50 +0100
Message-ID: <7nmoltF3lkrleU1_at_mid.individual.net>
Shakespeare, 02.12.2009 08:13:
> Thomas Kellerer schreef:
>> Gene Wirchenko wrote on 01.12.2009 05:35: >>> For example, a group by in SQL forces the result to be sorted by >>> the grouping unless otherwise overridden. >> >> Never has been true. Group by does *not* sort the result. Not even in >> Oracle 8 and and certainly not for any Oracle version > 9 (and not for >> any Postgres as well) >> >> Thomas
>
> Never? It did at least in Oracle 7. As a well known and too many times
> used side effect. I remember having to reprogram queries because
> developed programs relied on the sort....
I don't know about Oracle 7, but check out these articles by Tom Kyte:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:74320098178823 http://tkyte.blogspot.com/2005/08/order-in-court.html
Thomas Received on Wed Dec 02 2009 - 03:00:50 CST