RE: where 1=2

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 29 Jun 2015 19:23:22 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D9282984B5_at_EXMBX01.thus.corp>

That's correct - although the appearance of the internal_function() also suggests that there may be a further oddity to pursue (or that your c1 = '1' example was an over simplification).

Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
_at_jloracle

---

From: Johan Eriksson [valpis_at_gmail.com] Sent: 29 June 2015 19:53
To: Jonathan Lewis
Cc: knecht.stefan_at_gmail.com; oracle-l-freelists Subject: Re: where 1=2

from the v$sql_plan on 11.2.0.4
(:SYS_B_0<>:SYS_B_1 OR INTERNAL_FUNCTION("YFS_ORDER_LINE"."ORDER_LINE_KEY"))

Since that indicates that 1!=1 is present I did check the cursor_sharing on 11.2.0.3 : EXACT
11.2.0.4<http://11.2.0.4>: FORCE

which I think might explain the issue

On Mon, Jun 29, 2015 at 8:44 PM, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk<mailto:jonathan_at_jlcomp.demon.co.uk>> wrote:

Since you can query ASH I assume you can also get the runtime execution plan. What do the two predicate sections say.
If it's not cost the next obvious guess is NLS conversion or some other coercion issue.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 29 2015 - 21:23:22 CEST