jayzhan-synnada commented on code in PR #13680: URL: https://github.com/apache/datafusion/pull/13680#discussion_r1899954923
########## datafusion/sqllogictest/test_files/sort_merge_join.slt: ########## @@ -647,6 +647,54 @@ NULL NULL 7 9 NULL NULL 8 10 NULL NULL 9 11 +query II +select * from ( +with +t1 as ( + select 31 a, 32 b union all + select 31 a, 33 b +), +t2 as ( + select 31 a, 32 b union all + select 31 a, 35 b +) +select t2.* from t1 right anti join t2 on t1.a = t2.a and t1.b = t2.b +) order by 1, 2; +---- +31 35 + +query II +select * from ( +with +t1 as ( + select 41 a, 42 b union all + select 41 a, 43 b +), +t2 as ( + select 41 a, 42 b union all + select 41 a, 45 b +) +select t2.* from t1 right anti join t2 on t1.a = t2.a and t1.b = t2.b Review Comment: DuckDB/PG failed because of not supported, in this case, I think it is fine that we have different result because we support the query. -- 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: github-unsubscr...@datafusion.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org
