suneet-s opened a new issue #9758:
URL: https://github.com/apache/druid/issues/9758
### Affected Version
Tested on 0.16, 0.17, 0.18
### Description
The following SQL fails to plan with an ISE
```
SELECT "channel", "cityName", "comment", "count", "countryIsoCode"
FROM "wikipedia"
WHERE
countryIsoCode in ('TN', NULL)
```
The error is in the broker where it is trying to plan the query (stacktrace
too long to include here)
Druid In filters support null values, so this should work.
NOTE: when postgres issues a similar query it does not match rows where the
column value is null - Druid would probably need to do something similar as
well.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
