Re: 8i vs 9i: Difference in "group by" ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 31 May 2002 21:30:13 +0200
Message-ID: <qojffu4v4n1bdbr2b17iqqapp29gfi6v88@4ax.com>

On Fri, 31 May 2002 20:32:26 +0200, Andreas Koch <mail_at_kochandreas.com> wrote:

>Hi,
>
>is there some known difference in the group by directive
>between 9i and 8i?
>
>We have an application that runs well on 7.3 to 8i.
>One customer tried it on a 9i, and it seems a statement like
>
>select Decode(...about 3 lines of code...),foo
>from tblFoo
>group by Decode(...about 3 lines of code...)
>
>is GROUPED by the decode statement, but not ORDERED by it.
> From our previous experiences GROUP allways caused an
>ORDER (unless overwritten with an explizit ORDER BY) - is
>this "unofficial" behaviour, or is the missing ordering
>a bug?
>
>(well, we will probably use that chance to clean up
>that code a bit, using a view instead...)

The implict order by is just luck and according to the documentation *not* guaranteed.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri May 31 2002 - 14:30:13 CDT