releases.shpreview
ClickHouse/ClickHouse Changelog/Bug Fixes and Improvements

Bug Fixes and Improvements

ClickHouse ChangelogView original ↗
  • Fixed sumCount aggregate function unable to read older serialized states after introduction of Nullable(Tuple)
  • Fixed exception in tuple comparison involving Nothing type with GROUPING SETS and ORDER BY
  • Fixed non-deterministic uncompressed_hash computation for Compact MergeTree parts with multiple compression codecs
  • Fixed logical error during INSERT SELECT with JSON and buckets in shared data
  • Fixed MEMORY_LIMIT_EXCEEDED being reported as CORRUPTED_DATA during SummingMergeTree and CoalescingMergeTree merges
  • Fixed "Context has expired" exception for correlated subqueries with table functions like url()
  • Fixed exceptions and incorrect behavior in optimize_syntax_fuse_functions with aggregate projections and Date types
  • Fixed replaceRegexpOne to extract query rewrite producing wrong results; fixed exception with GROUP BY ... WITH CUBE and group_by_use_nulls=1
  • Fixed DROP DATABASE hanging indefinitely with database_atomic_wait_for_drop_and_detach_synchronously
  • Fixed KILL QUERY unable to terminate queries stuck in WITH FILL, dictionary loading, or ALTER DELETE
  • Fixed security issue: loop table function bypassed row policies and column-level grants
  • Fixed incorrect partition pruning with pre-epoch DateTime64 and toDate() function
  • Fixed hasPartitionId returning incorrect results with multiple partitions
  • Fixed possible crashes reading empty granules in advanced shared data in JSON
  • Fixed Cannot schedule a file error on INSERT into Distributed due to race between DROP and INSERT
  • Fixed server crash in mapContainsKey/mapContainsKeyLike with tokenbf_v1 skip index
  • Fixed LOGICAL_ERROR with LowCardinality inside compound types in various functions
  • Fixed LOGICAL_ERROR in MergingAggregatedTransform with ARRAY JOIN and merge() over Distributed tables
  • Fixed server crash caused by uncaught exception in HTTP connection pool destructor
  • Fixed incorrect result with grace_hash algorithm and non-equi joins
  • Fixed performance inefficiency in DeltaLake metadata scanning
  • Fixed data race in ZooKeeper client between sendThread and receiveThread
  • Fixed bug preventing CTE with distributed insert selects
  • Fixed exception from CachedOnDiskReadBufferFromFile::readBigAt
  • Fixed LOGICAL_ERROR in Alias engine with materialized columns
  • Fixed Keeper data loss after restart with Azure Blob Storage
  • Fixed JIT miscompilation of sign function for integer types wider than Int8
  • Fixed DUPLICATE_COLUMN exception and silent NULLs reading Delta Lake tables with name mode column mapping
  • Fixed mutation after lightweight update and secondary indices
  • Fixed incorrect result of FINAL queries mixing primary and non-primary key skip indexes
  • Enforced READ ON FILE checks for scalar file() and DESCRIBE TABLE file()
  • Fixed crash with glob pattern in file() when directory contains dangling symlinks
  • Fixed segfault in query plan optimization converting outer join to inner join with arrayJoin
  • Fixed ProtobufList format not working with Kafka engine
  • Fixed logical error with analyzer_compatibility_join_using_top_level_identifier and ARRAY JOIN
  • Set Watch component for watch responses in aggregated_zookeeper_log
  • Fixed partition pruning with FINAL deduplication when partition key not covered by sorting key
  • Fixed logical error in kql_array_sort_asc/kql_array_sort_desc with constant array arguments
  • Fixed out-of-bounds access in ColumnConst::getExtremes with extremes = 1
  • Fixed potential deadlock with concurrent MOVE PARTITION operations
  • HTTP server now returns error message in response body for 400 Bad Request
  • Fixed wrong results with distributed index analysis and query condition cache
  • Fixed LOGICAL_ERROR in MergeTreeSetIndex with toDate conversion on key columns
  • Fixed LOGICAL_ERROR with RIGHT JOIN wrapped in CROSS JOIN in legacy join code path
  • Fixed segfaults and OOM from corrupted DDSketch deserialization in quantilesDD
  • Fixed LOGICAL_ERROR with correlated columns in lambda functions like arrayMap
  • Fixed logical error in caseWithExpression with materialize(NULL) or Nullable(Nothing) arguments
  • Fixed bad cast exception when filtering _table virtual column in merge table function
  • Fixed sporadic deduplication failure with inconsistent cleanup ordering in ZooKeeper
  • Fixed exception with ORDER BY ... WITH FILL used together with LIMIT BY
  • Fixed silent data corruption inserting Parquet/Arrow Date into Enum column
  • Fixed exception reading Arrow file with Array column into table with Nested column
  • Fixed MATERIALIZE INDEX and MATERIALIZE PROJECTION mutations getting stuck
  • Fixed exception reading from Nullable(Tuple(...)) with colliding element names
  • Fixed exception when joining Merge table wrapping Distributed table

Fetched April 11, 2026