An Oracle bug?

From: <lyle.chen_at_gmail.com>
Date: Fri, 14 Sep 2007 18:57:10 -0700
Message-ID: <1189821430.467816.22710@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~ Received on Fri Sep 14 2007 - 20:57:10 CDT