Add tests for filtered SortMergeJoin output size

[comphead]

Are you planning to add some tests to avoid someone breaking this coalescing behavior?

Originally posted by @berkaysynnada in #14160 (review)

Its needed to prevent the regression and cover SMJ and probably other joins with tests showing that query execution with the join outputs the batches close to batch_size

[comphead]

The discussion to make join execution output is #14238