ClickHouse / ClickHouse/ClickHouse

Projection is not used when using IS NULL and analyzer is enabled

Open
#68,949 0 comments 0 reactions 0 assignees View on GitHub
comp-projections external potential bug
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

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.