AdamGS opened a new issue, #25024:
URL: https://github.com/apache/datafusion/issues/25024
### Describe the bug
As seen in the query below, we currently only take column nullability into
consideration when planning joins instead of full expression nullability, in
cases where we join on an expression that might introduce nulls.
### To Reproduce
```sql
CREATE TABLE outer_t(id VARCHAR NOT NULL) AS VALUES ('z');
CREATE TABLE inner_t(id VARCHAR NOT NULL) AS VALUES ('a');
SELECT id
FROM outer_t
WHERE (NULLIF(id, 'z') NOT IN (SELECT id FROM inner_t)) IS NULL;
```
### Expected behavior
The query above currently returns no results, but should return a single row
with the value `z` (verified with DuckDB).
### 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]
