Re: Query that returns 2 different results in 9iRAC and 10gRac

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 10 Mar 2005 00:29:24 +0100
Message-ID: <il1v21lnufj8bk8ojtn1prlc1rjh0l2rec@4ax.com>

On 9 Mar 2005 12:58:44 -0800, "Brian" <brian_at_databaseknowledge.com> wrote:

>Try this query on 9iRac and 10gRac, it returns 2 differnet results.
>
>with qw as (select inst_id from gv$session),
>y as (
> select unique inst_id
> from qw
> union all
> select unique inst_id
> from qw
> )
>
>I logged a tar and was told this is not a bug. The explanation made no
>sense whatsoever.

Nor does the query. What is the business need you are mixing unique's with union all's

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Mar 09 2005 - 17:29:24 CST