Re: SQL has me confused.
From: Ilmar Kerm <ilmar.kerm_at_gmail.com>
Date: Wed, 16 Oct 2013 14:26:07 +0300
Message-ID: <CAKnHwtep-Z_SbNWDs79=yZKjwPgf1mAKhSKJS0Noot=3pssQTA_at_mail.gmail.com>
Hi
We hit this issue 2 years ago when upgrading from 10.2.0.4 to 11.2.0.2, one SQL (with ANSI outer joins) that was previously working started giving ORA-918 on 11.2. Support found the following bugs relevant to our case: Bug 9479373: ORA-918 ON "SELECT FOR UPDATE OF" WITH ANSI SYNTAX Bug 9259407: ORA-00918: COLUMN AMBIGUOUSLY DEFINED ON SELECT FROM VIEW
Date: Wed, 16 Oct 2013 14:26:07 +0300
Message-ID: <CAKnHwtep-Z_SbNWDs79=yZKjwPgf1mAKhSKJS0Noot=3pssQTA_at_mail.gmail.com>
Hi
We hit this issue 2 years ago when upgrading from 10.2.0.4 to 11.2.0.2, one SQL (with ANSI outer joins) that was previously working started giving ORA-918 on 11.2. Support found the following bugs relevant to our case: Bug 9479373: ORA-918 ON "SELECT FOR UPDATE OF" WITH ANSI SYNTAX Bug 9259407: ORA-00918: COLUMN AMBIGUOUSLY DEFINED ON SELECT FROM VIEW
Ilmar
On Wed, Oct 16, 2013 at 2:06 PM, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk
> wrote:
>
> Step 1:
>
> Look at the execution plan and check the actual content of the predicate
> section.
> It may show you transitive closure generating extra copies of the constant
> predicate, it may should you alias of columns matched against the predicate.
>
> Like you, however, I would have expected "ORA-00918: column ambiguously
> defined".
> Which version of 10g ?
>
>
> Regards
> Jonathan Lewis
>
>
-- Ilmar Kerm -- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 16 2013 - 13:26:07 CEST