alamb commented on code in PR #4923: URL: https://github.com/apache/arrow-datafusion/pull/4923#discussion_r1081365754
########## datafusion/core/tests/sqllogictests/test_files/join.slt: ########## @@ -42,3 +42,42 @@ SELECT s.*, g.grade FROM students s join grades g on s.mark between g.min and g. Amina 89 5 Salma 77 4 Christen 50 3 + +# two tables for join +statement ok +CREATE TABLE t1(t1_id INT, t1_name TEXT, t1_int INT) AS VALUES +(11, 'a', 1), +(22, 'b', 2), +(33, 'c', 3), +(44, 'd', 4); + +statement ok +CREATE TABLE t2(t2_id INT, t2_name TEXT, t2_int INT) AS VALUES +(11, 'z', 3), +(22, 'y', 1), +(44, 'x', 3), +(55, 'w', 3); + +# left semi with wrong where clause Review Comment: 👍 -- 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]
