viirya opened a new issue, #10583: URL: https://github.com/apache/datafusion/issues/10583
### Describe the bug During working on https://github.com/apache/datafusion-comet/pull/437, a few Spark join tests are failed when delegating to DataFusion HashJoin. It is because that DataFusion HashJoin LeftAnti Join returns incorrect results when there are nulls in either left or right side. ### To Reproduce Added a test to `join.slt`: ``` statement ok CREATE TABLE IF NOT EXISTS test_table(c1 INT, c2 INT) AS VALUES (1, 1), (2, 2), (3, 3), (4, null), (null, 0); query II SELECT * FROM test_table t1 LEFT ANTI JOIN test_table t2 ON t1.c1 = t2.c2 ---- 4 NULL NULL 0 ``` ### Expected behavior Above query should return empty relation. ### Additional context _No response_ -- 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.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