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

In article <1993Nov5.024944.21194_at_ugc.uucp> geoff_at_ugc.uucp (Geoff Coleman) writes:

>In article <2b7ci6$qql_at_access.digex.net> mstein_at_access.digex.net (Michael P. Stein) writes:
>>
>> The two undocumented differences I have found (Oracle 7.0.12, HP-UX):
>>
>> - The outer join operator can no longer appear in an OR clause or the IN
>> operator; there is a new error message (ORA-01719) specifically rejecting such
>>statements. Example:
>>
>> select ... from t1, t2
>> where t1.foo = t2.foo (+)
>> or t1.foo = t2.bar (+)
>>
>>worked in v6 but gives an error on line 3 in v7. Workaround:
 

> But did it work in V6?

The outer join works fine in V6.0.33, we use it all over the place. Converting to V7 is a scary thought if we have to re-write all of our queries using multiple outer-join columns to do unions instead. We have a number of queries doing outer-joins based on up to 5 join columns. When you're selecting 30-40 columns at a time, having to

   select 30-40 columns from t1, t2
   where t1.foo = t2.foo (+)
   union
   select 30-40 columns from t1, t2
   where t1.foo = t2.bar (+)
   union
   select 30-40 columns from t1, t2
   where t1.foo = t2.blog (+)
   union
   select 30-40 columns from t1, t2
   where t1.foo = t2.stuff (+)
   union
   select 30-40 columns from t1, t2
   where t1.foo = t2.barff (+)

ends up being a real horrendous selct clause. PUKE !!! Time for a re-think of the database design ?? I think so.

--
Later...
Brian R. Wolkowski
  e-mail: wolkowsb_at_cuugnet.cuug.ab.ca
  voice:  (403) 242-7886