-
Notifications
You must be signed in to change notification settings - Fork 2k
Closed
Labels
bugSomething isn't workingSomething isn't working
Description
Describe the bug
The query
SELECT t1_id, t1_int, t2_int FROM t1 LEFT JOIN t2 ON t1_id = t2_id AND t1_int >= t2_intin the sort_merge_join.slt file fails in my PC.
Its expected result is
11 1 NULL
22 2 1
33 3 NULL
44 4 3
However, it produces following result
11 1 NULL
22 2 1
44 4 3
It seems like CI works without failing. Hence it might be related to my PC (MAC M1).
Exactly same query under join.slt file works as expected. (Where only difference is either HashJoin or SortMergeJoin is used in for join.) Hence the problem might be related to the left join implementation of SortMergeJoin
To Reproduce
No response
Expected behavior
No response
Additional context
No response
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't working