What ClickHouse/ClickHouse shipped
Generated by FoxPlug from public activity — not affiliated with Clickhouse.
Week of September 14, 2026
What shipped
- Removed the query analysis that preceded the analyzer, completing the transition to the new analyzer as the sole query analysis path. Pull request #120311
- Fixed a critical security issue where HDFS database table cache did not check read source grants and host filters. Pull request #119523
- Fixed query-local text index caches to use plain LRU instead of a different cache policy. Pull request #120844
- Merged join-order conflict-detector settings into a single enum setting to reduce configuration complexity. Pull request #120630
- Added validation that Azure endpoint range responses match the requested offset to prevent data corruption from proxies that ignore range requests. Pull request #120955
- Fixed incorrect aggregate results when limit pushdown optimization was used with ORDER BY as a strict prefix of GROUP BY. Pull request #117573
- Changed server behavior to not terminate on retryable errors while loading outdated parts. Pull request #117981
- Fixed correlated subqueries in SELECT list to work correctly when the outer query has a WHERE clause. Pull request #118402
- Fixed parameterized views to work correctly when referenced by their own name in the analyzer. Pull request #120698
- Fixed WHERE f IN (nan) to not silently lose NaN rows from floating-point columns during statistics-based pruning. Pull request #117453
Why it matters
This week includes important stability fixes for query analysis, security hardening for cloud storage, and correctness fixes for aggregations and floating-point handling. The removal of legacy query analysis code simplifies the codebase after the analyzer became the default. Several edge-case bugs affecting correlated subqueries, parameterized views, and NaN handling have been resolved.
Changelog entry
- Removed legacy query analysis code that preceded the analyzer. Pull request #120311
- Fixed HDFS database to check read source grant and host filter when serving cached tables. Pull request #119523
- Fixed query-local text index caches to use plain LRU. Pull request #120844
- Added validation that Azure endpoint range responses match requested offset. Pull request #120955
- Fixed incorrect aggregates from limit pushdown when ORDER BY is a strict prefix of GROUP BY. Pull request #117573
- Server no longer terminates on retryable errors while loading outdated parts. Pull request #117981
- Fixed correlated subqueries in SELECT list to work with WHERE clauses. Pull request #118402
- Fixed parameterized views to work when referenced by their own name. Pull request #120698
- Fixed WHERE f IN (nan) to preserve NaN rows in floating-point columns. Pull request #117453
- Fixed formatDateTime functions to work with LowCardinality time zone arguments. Pull request #117006
New in ClickHouse: removed legacy query analysis code, fixed Azure range validation, secured HDFS table cache access checks, and resolved query correctness issues with correlated subqueries and NaN handling.
This week's ClickHouse updates focus on stability and correctness: we completed the transition to the new analyzer by removing legacy query analysis code; fixed a critical security issue in HDFS database table caching that wasn't enforcing read source grants; improved Azure Blob Storage reliability with range offset validation; resolved query correctness bugs affecting correlated subqueries, parameterized views, and floating-point NaN handling; and merged query optimization settings for cleaner configuration.