Re: An Oracle bug?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 15 Sep 2007 10:12:55 +0200
Message-ID: <46eb9406$0$7327$426a74cc@news.free.fr>

<lyle.chen_at_gmail.com> a écrit dans le message de news: 1189843183.704877.185790_at_r29g2000hsg.googlegroups.com... On Sep 15, 1:25 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:

> <lyle.c..._at_gmail.com> a écrit dans le message de news: 1189821430.467816.22..._at_g4g2000hsf.googlegroups.com...

> | When running the following query on Ora10.2.0.3 32bits Win., I got a
> | ORA-00904 error, which said "BB"."S" is not a valid identifier.
> |
> | with a as ( select 'x' r, 'x' t from dual ),
> | b as ( select 'x' s, 'x' t from dual)
> | select ( select 'x'
> | from ( select r
> | from a
> | where a.t = ( select b.t
> | from b
> | where b.s = bb.s )))
> |
> | from b bb;
> |
> | However, if I try it on the 64bits version 10.2.0.1, it works. I need
> | to keep those scripts (many queries have the same form as the
> | simplified one) working on both platform. I've tried three days to
> | work around this problem, but failed in the end. :-(
> |
> | How can I work around it? Help~
> |

>
> Not a bug, a limitation, bb is known only at the first sublevel and
> not the subsequent ones.
>
> Regards
> Michel Cadot

Thank you, Michel!

However, as I found, on 64bits Oracle database, the limitation seems disappeared. So, I wonder if some adjustments on 32bits Oracle database can help me work around this problem (at least, weaken the limitation)?

---

No it is in 64-bit but a 10.2.0.1 bug fix in the next patchset. I had this discussion AskTom 2 years ago. see:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:48704116042682#50678380017237
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:48704116042682#64283169182746
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:48704116042682#65718645306451

Regards
Michel Received on Sat Sep 15 2007 - 03:12:55 CDT