= ANY (NULL) doesn’t prune.
Open
bug
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
While testing #1475 I noticed that the following query creates 32 tasks, one for each shard. So I think it doesn’t prune:
```sql
select count(*) from companies where id = any (null);
```
Equivalent IN query seem to prune correctly. It creates only one task:
```sql
select count(*) from companies where id in (null);
```
Contributor guide
Assessment
This issue has not been assessed yet.