Re: Full Join Problem

From: <pbewig_at_swbell.net>
Date: 5 Jan 2005 05:41:06 -0800
Message-ID: <1104932466.190630.326340@f14g2000cwb.googlegroups.com>

I am using version 9.2.0.3.0. I'll check with our DBA if there are any unapplied patches available.

Thanks for the help.

Phil

Andy Hassall wrote:
> On 4 Jan 2005 06:55:47 -0800, "pbewig_at_swbell.net" <pbewig_at_swbell.net>
wrote:
>
> >I am using Oracle 9.2.
>
> Which minor version?
>
> >I am having trouble writing a full join of
> >two sub-queries. The join looks like this:
> >
> >select *
> >from (select ...) a
> >full join (select ...) b
> >on a.xxx = b.xxx
> >and a.yyy = b.yyy
> >
> >This causes an ORA-600 internal error.
>
> ORA-600 indicates an Oracle bug. There were plenty of them in the
ANSI join
> support in early versions of Oracle 9.0 and 9.2. A lot of them are
fixed in
> later versions - can you upgrade?
>
> (Although having said that, 9.2.0.6 introduces a new bug relating to
FULL
> OUTER JOINS...)
>
> --
> Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
> <http://www.andyhsoftware.co.uk/space> Space: disk usage analysis
tool Received on Wed Jan 05 2005 - 07:41:06 CST