Bug Fixes and Improvements — ClickHouse Changelog

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