citusdata / citusdata/citus

= ANY (NULL) doesn’t prune.

Open
#1,599 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.