ClickHouse / ClickHouse/ClickHouse
`NOT IN (NULL)` unexpected result
Open
comp-regular-function
external
minor
sql-compatibility
unexpected behaviour
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 21h 32m
- Merged PRs (30d)
- 515
Description
```sql
select 1 NOT IN (NULL);
┌─notIn(1, NULL)─┐
│ 1 │
└────────────────┘
psql => \pset null 'Null'
Null display is "Null".
psql=> SELECT 1 NOT IN (NULL);
?column?
----------
Null
(1 row)
```
Contributor guide
Assessment
This issue has not been assessed yet.