Re: v6/v7 differences - let's share the undocumented ones

From: Michael P. Stein <mstein_at_access.digex.net>
Date: 7 Nov 1993 20:58:03 -0500
Message-ID: <2bk93b$9ii_at_access.digex.net>


In article <1993Nov5.024944.21194_at_ugc.uucp>, Geoff Coleman <geoff_at_ugc.uucp> wrote:
> But did it work in V6? If this is the problem I'm thinking of it is
>documented as no longer working and if you find the section in the manual
>it also says that in V6 this case was ignored and no error returned (ie.
>it ignored the second outer join.

    What manual and what section? The actual query was actually a bit more complex, but it worked in V6 exactly as I expected it to;

    ( (a.foo = 'A' and a.x = b.code (+) ) or       (a.foo = 'B' and a.y = b.code (+) )     )

(Don't blame me for this abomination; *I* didn't design the database.) In V7 even this is rejected at parse time.

-- 
Mike Stein			The above represents the Absolute Truth.
POB 10420			Therefore it cannot possibly be the official
Arlington, VA  22210		position of my employer.
Received on Mon Nov 08 1993 - 02:58:03 CET

Original text of this message