Re: 9205 Query behavior

From: Darrell Landrum <darrell_at_landrum.com>
Date: Sun, 16 May 2004 20:10:28 -0500
Message-ID: <002701c43bab$be5feae0$6501a8c0@darrell1>

Query 3 doesn't have the issue on 10.1.0.2 personal on windows...

SQL*Plus: Release 10.1.0.2.0 - Production on Sun May 16 17:55:07 2004

Connected to:
Personal Oracle Database 10g Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> select * from ( select distinct deptno from ( select deptno, job, 2 min(sal) from scott.emp group by deptno, job ) where deptno = 20 ) 3 /

DEPTNO

SQL>

Original Message ----- From: "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com> To: <oracle-l_at_freelists.org> Sent: Sunday, May 16, 2004 4:55 PM Subject: 9205 Query behavior

> On 9205 database, load $OH/admin/utlsampl.sql
>
> run following query ... and observe ...
>
> prompt Step 3
> select * from ( select distinct deptno from ( select deptno, job,
> min(sal) from scott.emp group by deptno, job ) where deptno = 20 )
> /
>
> The output I see is as follows ...
>
> oraclei_at_rhea-FAMDEV1> sqlplus scott/tiger
> SQL*Plus: Release 9.2.0.5.0 - Production on Sun May 16 17:45:36 2004
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
> With the Partitioning, Real Application Clusters, OLAP and Oracle Data
> Mining options
> JServer Release 9.2.0.5.0 - Production
>

>>

> Step 3
>
> DEPTNO
> ----------
> 20
> 20
> 20
>
> 3 rows selected.
>
> What's up with the three rows in step 3??
>
> I noticed this first reported on Metalink so wanted to try it out.
> According to metalink posting, this can be observed on 10g as well. I
> just reproduced this under 9202.
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Sun May 16 2004 - 20:08:14 CDT