Re: 9205 Query behavior

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

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


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
----------
        20

SQL> 



----- Original Message ----- 
From: "Jamadagni, Rajendra" <Rajendra.Jamadagni@xxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: