Test: enable semi-join processing for cases of semi-joins and outer joins, except for the case when the 
subquery is in the ON clause.