alamb commented on code in PR #14245:
URL: https://github.com/apache/datafusion/pull/14245#discussion_r1929294151


##########
datafusion/sqllogictest/test_files/joins.slt:
##########
@@ -4247,8 +4247,10 @@ logical_plan
 physical_plan
 01)CoalesceBatchesExec: target_batch_size=3, fetch=2
 02)--HashJoinExec: mode=CollectLeft, join_type=Full, on=[(c1@0, c1@0)]
-03)----MemoryExec: partitions=1, partition_sizes=[1]
-04)----MemoryExec: partitions=1, partition_sizes=[1]
+03)----GlobalLimitExec: skip=0, fetch=2

Review Comment:
   I didn't think it is  correct to push a limit below a Full join -- a 
FullJoin will create null values to match any misisng rows 🤔  So even if you 
limited both sides you'll still get rows out of there that shouldn't be ...



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to