hareshkh opened a new issue, #21124: URL: https://github.com/apache/datafusion/issues/21124
### Describe the bug The substrait join consumer produces incorrect logical plan for queries like ```sql SELECT t1.id AS t1_id, t2.id AS t2_id, t1.val, t2.val FROM t1 JOIN t2 ON t1.id = t2.id AND t1.val IS NOT DISTINCT FROM t2.val ``` where it assumes the null semantics of one of the join conditions to be the null semantics of the entire join ### To Reproduce Convert this substrait plan - datafusion/substrait/tests/testdata/test_plans/mixed_join_equal_and_indistinct.json from https://github.com/apache/datafusion/pull/21121/changes ### Expected behavior If a join with join_keys having mixed null handling i.e. a few join keys with `NullEqNull` and a few with `NullEqNothing` then the resulting outer join should preserve these semantics ### 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: [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]
