For old sql queries in version 7.3 like:

select a.*,b.*,c.*,d.* from a,b,c,d where 
a.id1 = b.id1 and a.id2 = c.id2 <...> on so on.

if you alter this same query to use JOIN syntax instead of the equals
conditions then the query runs in 7.5.0.18 &.19. If you add the old style
join syntax (+) then the query will run.

I have a app (and some dbprocs) that are littered with these 'workaround'
queries to get past the join performance issues of 7.3 versions so now I am
stuck with a migrated instance but can't deploy the server because of the
non-functional queries. Are there some settings I can mod in the parameters
to allow .18/.19 to execute these old style queries without throwing the
-3007 error?

Reply via email to