ClickHouse / ClickHouse/ClickHouse
Projection is not used when using IS NULL and analyzer is enabled
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 21h 32m
- Merged PRs (30d)
- 515
Description
When using projections with the experimental analyzer enabled, a query containing IS NULL in the projection fails
to execute. The same query works when experimental analyzer is disabled.
For some odd reason (possibly other bug or bug of fiddle) I could only reproduce the issue if I run the same query with
force_optimize_projection = false, allow_experimental_analyzer = true BEFORE the problem query. When testing on my local
server it's not required.
https://fiddle.clickhouse.com/ed816b90-4ce2-40f0-bad7-646cf7287570
Clickhouse version: latest (24.8.2.3)
**Expected behavior**
Query should execute successfully using defined projection.
Contributor guide
Assessment
This issue has not been assessed yet.