Re: Different results for the same query in 10g and 11g
From: Grzegorz <grzegorzof_at_interia.pl>
Date: Tue, 28 Jun 2011 17:27:06 +0200
Message-ID: <iucrsp$9h1$1_at_news.task.gda.pl>
On 2011-06-27 22:09, Santana wrote:
> Hi all.
> I need your help for the following query that return one row in 10g
> and dont return any row in 11g: I know which ther is others ways to
> implement
> this query but i wan understand what is wrong!
>
>
> This is mysterious query :
>
> select *
> from tests a
> where id=nvl(( select max(b.id)
> from tests b where b.id>2
> and a.id=b.id
> ),
Date: Tue, 28 Jun 2011 17:27:06 +0200
Message-ID: <iucrsp$9h1$1_at_news.task.gda.pl>
On 2011-06-27 22:09, Santana wrote:
> Hi all.
> I need your help for the following query that return one row in 10g
> and dont return any row in 11g: I know which ther is others ways to
> implement
> this query but i wan understand what is wrong!
>
>
> This is mysterious query :
>
> select *
> from tests a
> where id=nvl(( select max(b.id)
> from tests b where b.id>2
> and a.id=b.id
> ),
Answered at oracle-l by Timur Akhmadeev
It’s a “feature” 7215982 “unnest subquery embedded inside an expression”. Turning it off with the _fix_control will fix it.
Regards
GG
Received on Tue Jun 28 2011 - 10:27:06 CDT