Add tests for filtered SortMergeJoin output size #14239

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