Add guards for unsupported subqueries join plan, was too ambitious.

Now I see the negative tests! good work!