RE: 9205 Query behavior

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Mon, 17 May 2004 11:26:44 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF03B454E0@bosmail00.bos.il.pqe>

Hmmm, confirmed on 9.2.0.4 on Solaris8.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Darrell Landrum Sent: Sunday, May 16, 2004 9:10 PM
To: oracle-l_at_freelists.org
Subject: 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

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 =3D 20 = )
3 /

DEPTNO

SQL>=20

Original Message -----=20 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
> =20
> run following query ... and observe ...=20
> =20
> prompt Step 3
> select * from ( select distinct deptno from ( select deptno, job,
> min(sal) from scott.emp group by deptno, job ) where deptno =3D 20 )
> /
> =20
> The output I see is as follows ...=20
> =20
> 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
> =20

>> =20

> Step 3
> =20
> DEPTNO
> ----------
> 20
> 20
> 20
> =20
> 3 rows selected.
> =20
> What's up with the three rows in step 3??
> =20
> 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.
> =20

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
-----------------------------------------------------------------
----------------------------------------------------------------
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 Mon May 17 2004 - 10:23:56 CDT