Multi-source joins should still be partitioned even if not fully pushed

A deficiency in join planning with multi-source is that partitioning only occurs if the join is pushed. If not pushed then we'll union the results and process a join across all of the results.