Left/full outer join incorrect for CollectLeft / broadcast

**Describe the bug**
See discussion here https://github.com/apache/datafusion/issues/12454

The "broadcast join" (CollectLeft) is wrong for certain join types which produce results on unmatched left rows.

**To Reproduce**
Run a broadcast join with left / full outer on more than one node

**Expected behavior**

**Additional context**

Start by reading the linked DataFusion discussion and reproducing a broadcast join with CollectLeft using left and full outer joins on more than one node. Compare the results for unmatched left rows and use that behavior to define done: those rows should be returned correctly for the affected join types.

Written by the indexing model from the issue text.