Back to Clickhouse

2025 Changelog

docs/changelogs/v25.6.9.98-stable.md

26.4.1.1-new13.5 KB
Original Source

2025 Changelog

ClickHouse release v25.6.9.98-stable (b242c4182b8) FIXME as compared to v25.6.8.10-stable (c54ce812cd4)

Performance Improvement

Improvement

  • Backported in #86063: Views, created by ephemeral users, will now store a copy of an actual user and will no longer be invalidated after the ephemeral user is deleted. #84763 (pufit).
  • Backported in #85728: Added show_data_lake_catalogs_in_system_tables flag to manage adding data lake tables in system.tables resolves #85384. #85411 (Smita Kulkarni).
  • Backported in #86251: Slow down S3 client threads on retryable errors in S3 Object Storage. This extends the previous setting backup_slow_all_threads_after_retryable_s3_error to S3 disks and renames it to the more general s3_slow_all_threads_after_retryable_error. #85918 (Julia Kartseva).
  • Backported in #86503: Add ability to enable JSON logging only for specific channel, for this set logger.formatting.channel to one of syslog/console/errorlog/log. #86331 (Azat Khuzhin).

Bug Fix (user-visible misbehavior in an official stable release)

  • Backported in #85757: Fixed parquet writer outputting incorrect statistics (min/max) for Decimal types. #83754 (Michael Kolupaev).
  • Backported in #84942: This closes #81303. #83892 (Konstantin Vedernikov).
  • Backported in #85794: Fix writing JSON paths with NULL values in RowBinary format. #83923 (Pavel Kruglov).
  • Backported in #85881: Fix reading Variant column with lazy materialization. #84400 (Pavel Kruglov).
  • Backported in #86056: Fixed server crash when a user created with no_password attempts to login after the server setting allow_no_password was changed to 0. #84426 (Shankar Iyer).
  • Backported in #85310: Now if all TTL are removed from table MergeTree will do nothing related to TTL. #84441 (alesapin).
  • Backported in #85304: Fix ALTER MODIFY ORDER BY not validating TTL columns in sorting keys. TTL columns are now properly rejected when used in ORDER BY clauses during ALTER operations, preventing potential table corruption. #84536 (xiaohuanlin).
  • Backported in #85115: Add a check if a correlated subquery is used in a distributed context to avoid a crash. Fixes #82205. #85030 (Dmitry Novik).
  • Backported in #85269: Fixing illegal_type_of_argument in mv when types are different. #85135 (Sema Checherinda).
  • Backported in #85234: Fix Not-ready Set for IN (subquery) inside additional_table_filters expression setting. #85210 (Nikolai Kochetov).
  • Backported in #85262: Get rid of unnecessary getStatus() calls during SYSTEM DROP REPLICA queries. Fixes the case when a table is dropped in the background, and the Shutdown for storage is called exception is thrown. #85220 (Nikolay Degterinsky).
  • Backported in #85360: Fix race in DeltaLake engine delta-kernel implementation. #85221 (Kseniia Sumarokova).
  • Backported in #85502: Added missing table name length checks in CREATE OR REPLACE and RENAME queries. #85326 (Michael Kolupaev).
  • Backported in #85399: Fix the creation of RMV on a new replica of the Replicated database if DEFINER is dropped. #85327 (Nikolay Degterinsky).
  • Backported in #85524: Fix backup of parts with broken projections. #85362 (Antonio Andelic).
  • Backported in #85424: Fix crash and data corruption during ALTER UPDATE for JSON. #85383 (Pavel Kruglov).
  • Backported in #85617: Queries with parallel replicas which uses reading reverse in order optimization can produce incorrect result. #85406 (Igor Nikonov).
  • Backported in #85696: Fix possible UB (crashes) in case of MEMORY_LIMIT_EXCEEDED during String deserialization. #85440 (Azat Khuzhin).
  • Backported in #85824: Fix incorrect metrics KafkaAssignedPartitions and KafkaConsumersWithAssignment. #85494 (Ilya Golshtein).
  • Backported in #85687: Fix early return condition for S3 request rate slowdown: require either s3_slow_all_threads_after_network_error or backup_slow_all_threads_after_retryable_s3_error to be true to enable slowdown behavior when all threads are paused due to a retryable error, instead of requiring both. #85505 (Julia Kartseva).
  • Backported in #85560: Fixed rare crash in asynchronous inserts that change settings log_comment or insert_deduplication_token. #85540 (Anton Popov).
  • Backported in #85914: Fix secrets masking in icebergS3Cluster and icebergAzureCluster table functions. #85658 (MikhailBurdukov).
  • Backported in #85869: Fix coalescing merge tree segfault for large strings. This closes #84582. #85709 (Konstantin Vedernikov).
  • Backported in #86111: Using distributed_depth as an indicator of *Cluster function was incorrect and may lead to data duplication; use client_info.collaborate_with_initiator instead. #85734 (Konstantin Bogdanov).
  • Backported in #85858: Fix possible inconsistency for dictionaries with update_field on MEMORY_LIMIT_EXCEEDED errors. #85807 (Azat Khuzhin).
  • Backported in #86265: Fix logical error on attempt to CREATE ... AS (SELECT * FROM s3Cluster(...)) with DatabaseReplicated. #85904 (Konstantin Bogdanov).
  • Backported in #86161: Now unity catalog will ignore schemas with weird data types in case of non-delta tables. Fixes #85699. #85950 (alesapin).
  • Backported in #86039: Fixed a bug in Replicated database recovery: if a table name contains the % symbol, it could re-create the table with a different name during recovery. #85987 (Alexander Tokmakov).
  • Backported in #86250: Fix backup restores failing due to BACKUP_ENTRY_NOT_FOUND error when restoring an empty Memory table. #86012 (Julia Kartseva).
  • Backported in #86197: Fix using wrong default values for path with Enum hint inside JSON. #86065 (Pavel Kruglov).
  • Backported in #86289: Exception was thrown by a FINAL query with skip index if the table (e.g ReplacingMergeTree) was created with settingindex_granularity_bytes = 0. That exception has been fixed now. #86147 (Shankar Iyer).
  • Backported in #86306: Fix crash in case of const and non-const blocks in one INSERT. #86230 (Azat Khuzhin).
  • Backported in #86346: Fix crash during ALTER UPDATE Nullable(JSON). #86281 (Pavel Kruglov).
  • Backported in #86464: Fix leaking of MergesMutationsMemoryTracking due to Buffer tables and fix query_views_log for streaming from Kafka (and others). #86422 (Azat Khuzhin).

Build/Testing/Packaging Improvement

NOT FOR CHANGELOG / INSIGNIFICANT