docs/changelogs/v25.8.1.5101-lts.md
Array(Dynamic) instead of unnamed Tuple for arrays of values with different types in JSON. To use previous behaviour, disable setting input_format_json_infer_array_of_dynamic_from_array_of_different_types. #80859 (Pavel Kruglov).indexHint() in conditions). #83791 (Igor Nikonov).Enum type as BYTE_ARRAY with ENUM logical type in Parquet output format by default. #84169 (Pavel Kruglov).write_marks_for_substreams_in_compact_parts by default. It significantly improves performance of subcolumns reading from newly created Compact parts. Servers with version less then 25.5 won't be able to read new Compact parts. #84171 (Pavel Kruglov).concurrent_threads_scheduler default value was round_robin, which proved unfair in the presence of a high number of single-threaded queries (e.g., INSERTs). This change makes a safer alternative fair_round_robin scheduler, the default. #84747 (Sergei Trifonov).$tag$ string contents... $tag$, also known as dollar-quoted string literals. In previous versions, there were fewer restrictions on tags: they could contain arbitrary characters, including punctuation and whitespace. This introduces parsing ambiguity with identifiers that can also start with a dollar character. At the same time, PostgreSQL only allows word characters for tags. To resolve the problem, we now restrict heredoc tags only to contain word characters. Closes #84731. #84846 (Alexey Milovidov).azureBlobStorage, deltaLakeAzure, and icebergAzure have been updated to properly validate AZURE permissions. All cluster-variant functions (-Cluster functions) now verify permissions against their corresponding non-clustered counterparts. Additionally, the icebergLocal and deltaLakeLocal functions now enforce FILE permission checks. #84938 (Nikita Mikhaylov).arrowflight(): SELECT * FROM arrowflight('host:port', 'dataset_name'). #74184 (zakr600).COPY command support. #74344 (Konstantin Vedernikov).dialect='promql' in clickhouse-client, point it to the TimeSeries table using the setting promql_table_name='X' and execute queries like rate(ClickHouseProfileEvents_ReadCompressedBytes[1m])[5m:1m]. In addition you can wrap the PromQL query with SQL: SELECT * FROM prometheusQuery('up', ...);. So far only functions rate, delta and increase are supported. No unary/binary operators. No HTTP API. #75036 (Vitaly Baranov).zookeeper_connection_log system table to store historical information about ZooKeeper connections. #79494 (János Benjamin Antal).cpu_slot_preemption enables preemptive CPU scheduling for workloads and ensures max-min fair allocation of CPU time among workloads. New workload settings for CPU throttling are added: max_cpus, max_cpu_share and max_burst_cpu_seconds. More details: https://clickhouse.com/docs/operations/workload-scheduling#cpu_scheduling. #80879 (Sergei Trifonov).parallel_replicas_support_projection has been added to control whether projection support is enabled. To simplify the implementation, support for projection is only enabled when parallel_replicas_local_plan is active. #82807 (zoomxi).JSONExtractCaseInsensitive (and other variants of JSONExtract). #83770 (Alistair Evans).system.completions table. Closes #81889. #83833 (|2ustam).nowInBlock64. Example usage: SELECT nowInBlock64(6) returns 2025-07-29 17:09:37.775725. #84178 (Halersson Paris).dateTimeToUUIDv7 to convert a DateTime value to a UUIDv7. Example usage: SELECT dateTimeToUUIDv7(toDateTime('2025-08-15 18:57:56')) returns 0198af18-8320-7a7d-abd3-358db23b9d5c. #84319 (samradovich).timeSeriesDerivToGrid and timeSeriesPredictLinearToGrid aggregate functions to re-sample data to a time grid defined by the specified start timestamp, end timestamp, and step; calculates PromQL-like deriv and predict_linear, respectively. #84328 (Stephen Chi).GRANT READ ON S3('s3://foo/.*') TO user. #84503 (pufit).Hash as a new output format. It calculates a single hash value for all columns and rows of the result. This is useful for calculating a "fingerprint" of the result, for example, in use cases where data transfer is a bottleneck. Example: SELECT arrayJoin(['abc', 'def']), 42 FORMAT Hash returns e5f9e676db098fdb9530d2059d8c23ef. #84607 (Robert Schulze).OPTIMIZE TABLE table_name. #85250 (Konstantin Vedernikov).drop table for iceberg (Removing from REST/Glue catalogs + removing metadata about table). #85395 (Konstantin Vedernikov).azureBlobStorage table engine: cache and reuse managed identity authentication tokens when possible to avoid throttling. #79860 (Nick Blakely).enable_producing_buckets_out_of_order_in_aggregation, enabled by default) that allows sending some buckets out of order during memory-efficient aggregation. When some aggregation buckets take significantly longer to merge than others, it improves performance by allowing the initiator to merge buckets with higher bucket id-s in the meantime. The downside is potentially higher memory usage (shouldn't be significant). #80179 (Nikita Taranov).input_format_parquet_use_native_reader_v3 to enable. #82789 (Michael Kolupaev).max_joined_block_rows outside of hash JOIN main loop. Slightly better performance for ALL JOIN. #83216 (Nikolai Kochetov).Curl client can be returned back by setting azure_sdk_use_native_client=false. #83294 (alesapin).JSON subcolumns reading from shared data in MergeTree by implementing new serializations for JSON shared data in MergeTree. #83777 (Pavel Kruglov).has([c1, c2, ...], column), where column is not of an Array type. This improves performance for such queries, making them as efficient as the IN operator. #83945 (Doron David).All LEFT/INNER JOINs will be automatically converted to RightAny if the right side is functionally determined by the join key columns (all rows have unique join key values). #84010 (Nikita Taranov).largestTriangleThreeBuckets by removing temporary data. #84479 (Alexey Milovidov).Join mode. #85040 (Anton Popov).structureToProtobufSchema, structureToCapnProtoSchema didn't correctly put a zero-terminating byte and were using a newline instead of it. That was leading to a missing newline in the output, and could lead to buffer overflows while using other functions that depend on the zero byte (such as logTrace, demangle, extractURLParameter, toStringCutToZero, and encrypt/decrypt). The regexp_tree dictionary layout didn't support processing strings with zero bytes. The formatRowNoNewline function, called with Values format or with any other format without a newline at the end of rows, erroneously cuts the last character of the output. Function stem contained an exception-safety error that could lead to a memory leak in a very rare scenario. The initcap function worked in the wrong way for FixedString arguments: it didn't recognize the start of the word at the start of the string if the previous string in a block ended with a word character. Fixed a security vulnerability of the Apache ORC format, which could lead to the exposure of uninitialized memory. Changed behavior of the function replaceRegexpAll and the corresponding alias, REGEXP_REPLACE: now it can do an empty match at the end of the string even if the previous match processed the whole string, such as in the case of ^a*|a*$ or ^|.* - this corresponds to the semantic of JavaScript, Perl, Python, PHP, Ruby, but differs to the semantic of PostgreSQL. Implementation of many functions has been simplified and optimized. Documentation for several functions was wrong and has now been fixed. Keep in mind that the output of byteSize for String columns and complex types, which consisted of String columns, has changed (from 9 bytes per empty string to 8 bytes per empty string), and this is normal. #85063 (Alexey Milovidov).EXPLAIN indexes = 1. #79938 (Christoph Wurm).columns_substreams.txt file to Wide part to track all substreams stored in the part. It helps to track dynamic streams in JSON and Dynamic types and so avoid reading sample of these columns to get the list of dynamic streams (for example for columns sizes calculation). Also now all dynamic streams are reflected in system.parts_columns. #81091 (Pavel Kruglov).max_remote_read_network_bandwidth_for_server and max_remote_write_network_bandwidth_for_server throttling. #81837 (Sergei Trifonov).optimize_rewrite_regexp_functions setting (enabled by default), which allows the optimizer to rewrite certain replaceRegexpAll, replaceRegexpOne, and extract calls into simpler and more efficient forms when specific regular expression patterns are detected. (issue #81981). #81992 (Amos Bird).remote-() table functions with parallel replicas if cluster is provided in address_expression argument. Also, fixes #73295. #82904 (Igor Nikonov).SET query_plan_use_new_logical_join_step=0 and report an issue. #83801 (Vladimir Cherkasov).max_joined_block_size_bytes in addition to max_joined_block_size_rows to limit the memory usage of JOINs with heavy columns. #83869 (Nikolai Kochetov).S3Queue table level. Added new S3Queue level settings: min_insert_block_size_rows_for_materialized_views and min_insert_block_size_bytes_for_materialized_views. By default profile level settings will be used and S3Queue level settings will override those. #83971 (Kseniia Sumarokova).MutationAffectedRowsUpperBound that shows the number of affected rows in a mutation (e.g., the total number of rows that satisfy the condition in ALTER UPDATE or ALTER DELETE query. #83978 (Anton Popov).memory_worker_use_cgroup and cgroups are available) to adjust memory tracker (memory_worker_correct_memory_tracker). #83981 (Azat Khuzhin).delta-kernel-rs filtering (statistics and partition pruning) in storage DeltaLake. #84006 (Kseniia Sumarokova).Pretty formats for Nullable numbers. #84070 (Alexey Milovidov).MEMORY_LIMIT_EXCEEDED. #84082 (Nikita Mikhaylov).apply_to_children config. #84137 (Antonio Andelic).logs_to_keep to database replicated settings, that allows changing the default logs_to_keep parameter for replicated databases. Lower values reduce the number of ZNodes (especially if there are many databases), while higher values allow a missing replica to catch up after a longer period of time. #84183 (Alexey Khatskevich).json_type_escape_dots_in_keys to escape dots in JSON keys during JSON type parsing. The setting is disabled by default. #84207 (Pavel Kruglov).delta_lake_enable_expression_visitor_logging to turn off expression visitor logs as they can be too verbose even for test log level when debugging something. #84315 (Kseniia Sumarokova).CGroup<Metric> and OS-level metrics (collected from procfs) have names OS<Metric>. #84317 (Nikita Taranov).max_retries_before_automatic_recovery to 10, so it will recover faster in some cases. #84369 (Alexander Tokmakov).CREATE USER {username:Identifier} IDENTIFIED WITH no_password). #84376 (Azat Khuzhin).backup_restore_s3_retry_initial_backoff_ms, backup_restore_s3_retry_max_backoff_ms, backup_restore_s3_retry_jitter_factor to configure the S3 retry backoff strategy used during backup and restore operations. #84421 (Julia Kartseva).IN / GLOBAL IN filters over KeyValue storage primary keys (e.g., EmbeddedRocksDB, KeeperMap). #84515 (Eduard Karacharov).UDF_EXECUTION_FAILED, whereas previously different error codes could be returned. #84547 (Xu Jia).get_acl command to KeeperClient. #84641 (Antonio Andelic).ConcurrentBoundedQueue, labelled by the queue type (i.e. what the queue is there for) and queue id (i.e. randomly generated id for the current instance of the queue). #84675 (Miсhael Stetsyuk).system.columns table now provides column as an alias for the existing name column. #84695 (Yunchi Pang).search_orphaned_parts_drives to limit scope to look for parts e.g. by disks with local metadata. #84710 (Ilya Golshtein).lgrq, for toggling request logging of received requests. #84719 (Antonio Andelic).encrypt_decrypt tool now supports encrypted ZooKeeper connections. #84764 (Roman Vasin).system.errors. This column is needed to group by the same error type in alerting rules. #84776 (Miсhael Stetsyuk).clickhouse-format to accept --highlight as an alias for --hilite. - Updated clickhouse-client to accept --hilite as an alias for --highlight. - Updated clickhouse-format documentation to reflect the change. #84806 (Rishabh Bhardwaj).read_in_order_use_virtual_row for WHERE. It allows to skip reading more parts for queries with filters that were not fully pushed to PREWHERE. #84835 (Nikolai Kochetov).backup_slow_all_threads_after_retryable_s3_error setting to reduce pressure on S3 during retry storms caused by errors such as SlowDown, by slowing down all threads once a single retryable error is observed. #84854 (Julia Kartseva).keeper_server.coordination_settings.latest_logs_cache_entry_count_threshold and keeper_server.coordination_settings.commit_logs_cache_entry_count_threshold. #84877 (Antonio Andelic).simdjson on unsupported architectures (previously leads to CANNOT_ALLOCATE_MEMORY errors). #84966 (Azat Khuzhin).vector_search_postfilter_multiplier was made obsolete and replaced by a more general setting : vector_search_index_fetch_multiplier. #85024 (Shankar Iyer).database_replicated settings defining the default values of DatabaseReplicatedSettings. If the setting is not present in the Replicated DB create query, the value from this setting is used. #85127 (Tuan Pham Anh).s3 or s3Cluster table engine/function, e.g. for example s3('url', CSV, structure = 'a Int32', compression_method = 'gzip'). #85134 (Kseniia Sumarokova)..metadata.json file via iceberg_metadata_compression_method setting. It supports all clickhouse compression methods. This closes #84895. #85196 (Konstantin Vedernikov).delta_lake_snapshot_version to allow reading specific snapshot version in table engine DeltaLake. #85295 (Kseniia Sumarokova).path for editor, update to 25.8.1. #85341 (Azat Khuzhin).partition_columns_in_data_file to azure configuration. #85373 (Arthur Passos).timeSeries*ToGrid() This is part #3 of https://github.com/ClickHouse/ClickHouse/pull/75036. #85390 (Vitaly Baranov).timeSeriesRange(start_timestamp, end_timestamp, step), - timeSeriesFromGrid(start_timestamp, end_timestamp, step, values),. #85435 (Vitaly Baranov).remote_fs_zero_copy_zookeeper_path. #85437 (Mikhail Koviazin).EXISTS as a scalar subquery. This allows using a scalar subquery cache and constant-folding the result, which is helpful for indexes. For compatibility, the new setting execute_exists_as_scalar_subquery=1 is added. #85481 (Nikolai Kochetov).ARRAY JOIN with the old analyzer. Introduce a new setting analyzer_compatibility_allow_compound_identifiers_in_unflatten_nested to keep the old behaviour. #85492 (Nikolai Kochetov).--max-concurrency for the clickhouse-benchmark tool that enables a mode with a gradual increase in the number of parallel queries. #85623 (Sergei Trifonov).max_uncompressed_bytes_in_patches) for total uncompressed bytes in patch parts. It prevents significant slowdowns of SELECT queries after lightweight updates and prevents possible misuse of lightweight updates. #85641 (Anton Popov).parameter column to system.grants to determine source type for GRANT READ/WRITE and the table engine for GRANT TABLE ENGINE. #85643 (MikhailBurdukov).nested. #85719 (Nikolai Kochetov).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).use_persistent_processing_nodes (changeable by ALTER TABLE MODIFY SETTING). #85995 (Kseniia Sumarokova).DISTINCT window aggregates run in linear time and fix a bug in sumDistinct. Closes #79792. Closes #52253. #79859 (Nihal Z. Miaji).trim called with all-constant inputs now produces a constant output string. (Bug #78796). #82900 (Robert Schulze).optimize_syntax_fuse_functions is enabled, close #75511. #83300 (Vladimir Cherkasov).WHERE ... IN (<subquery>) clause and enabled query condition cache (setting use_query_condition_cache). #83445 (LB7666).gcs function did not require any access to use. Now it will check GRANT READ ON S3 permission for usage. Closes #70567. #83503 (pufit).plain_rewritable/plain metadata types, previously they were simply ignored. #83695 (Tuan Pham Anh).add_minmax_index_for_numeric_columns=1 or add_minmax_index_for_string_columns=1, the index is later materialized during an ALTER operation, and it prevents the Replicated database from initializing correctly on a new replica. #83751 (Nikolay Degterinsky).LowCardinality(Float32|Float64|BFloat16) type. #83786 (Pervakov Grigorii).view(...) argument of remote table function with enabled analyzer. Fixes #78717. Fixes #79377. #83844 (Dmitry Novik).filesystem_prefetches_limit (not only from MergeTreePrefetchedReadPool). #83999 (Azat Khuzhin).MATERIALIZE COLUMN query could lead to unexpected files in checksums.txt and eventually detached data parts. #84007 (alesapin).Expected single dictionary argument for function while doing JOIN on an inequality condition when one of the columns is LowCardinality and the other is a constant. Closes #81779. #84019 (Alexey Milovidov).lightweight_mutation_projection_mode = 'rebuild' and user execute lighweight delete which deletes ALL rows from any block in table. #84158 (alesapin).WINDOW definitions. Fixes #83131. #84242 (Dmitry Novik).array() function. This fixes #84202. #84297 (Amos Bird).LOGICAL_ERROR for queries with parallel replicas and multiple INNER joins followed by RIGHT join. Do not use parallel replicas for such queries. #84299 (Vladimir Cherkasov).set indexes didn't consider Nullable columns while checking if granules passed the filter (issue #75485). #84305 (Elmi Ahmadov).IAccessStorage. #84365 (Konstantin Bogdanov).DoubleDelta codec can now only be applied to columns of numeric type. In particular FixedString columns can no longer be compressed using DoubleDelta. (fixes #80220). #84383 (Jimmy Aguilar Mena).MinMax index evaluation. #84386 (Elmi Ahmadov).zoutofmemory hardware error, otherwise it will throw logical error. see https://github.com/clickhouse/clickhouse-core-incidents/issues/877. #84420 (Han Fei).no_password attempts to login after the server setting allow_no_password was changed to 0. #84426 (Shankar Iyer).allow_experimental_delta_kernel_rs to false for compatibility. #84587 (Kseniia Sumarokova).rotate_log_storage_interval = 0 would cause ClickHouse to crash. (issue #83975). #84637 (George Larionov).CORRUPTED_DATA error when lazy columns are used with external sort. #84738 (János Benjamin Antal).DeltaLake. Closes #84543. #84745 (Kseniia Sumarokova).ngram and no_op tokenizers no longer crash the (experimental) text index for empty input tokens. #84849 (Robert Schulze).ReplacingMergeTree and CollapsingMergeTree engines. #84851 (Anton Popov).ReplicatedMergeTree engine created on servers with a version lower than 25.7. #84933 (Anton Popov).MergeTree engine after running a ALTER TABLE ... REPLACE PARTITION query. #84941 (Anton Popov).AzureIteratorAsync. #85064 (Nikita Taranov).ReplicatedMergeTree. Previously, the result of a lightweight update may temporarily not be visible on the replica until the merged or mutated part that materializes the patch parts is downloaded from another replica. #85121 (Anton Popov).Not-ready Set for IN (subquery) inside additional_table_filters expression setting. #85210 (Nikolai Kochetov).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).DeltaLake engine delta-kernel implementation. #85221 (Kseniia Sumarokova).DeltaLake engine. It was broken in 25.7 (https://github.com/ClickHouse/ClickHouse/pull/81136). #85223 (Kseniia Sumarokova)._part_offset column in projection in releases until it is stabilized. #85372 (Sema Checherinda).log_comment or insert_deduplication_token. #85540 (Anton Popov).JSONExtract when converting JSON numbers to Decimal types. Now numeric JSON values preserve their exact decimal representation, avoiding floating-point rounding errors. #85665 (ssive7b).LOGICAL_ERROR when using COMMENT COLUMN IF EXISTS in the same ALTER statement after DROP COLUMN. The IF EXISTS clause now correctly skips the comment operation when the column has been dropped within the same statement. #85688 (xiaohuanlin).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).WITH statement for the parallel distributed INSERT SELECT with the Distributed destination table. Before, the query could throw an Unknown expression identifier error. #85811 (Nikolai Kochetov).deltaLakeAzure, deltaLakeCluster, icebergS3Cluster and icebergAzureCluster. #85889 (Julian Maicher).CREATE ... AS (SELECT * FROM s3Cluster(...)) with DatabaseReplicated. #85904 (Konstantin Bogdanov).url() table function to properly include port numbers in the Host header when accessing non-standard ports. This resolves authentication failures when using presigned URLs with S3-compatible services like MinIO running on custom ports, which is common in development environments. (Fixes #85898). #85921 (Tom Quist).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).BACKUP_ENTRY_NOT_FOUND error when restoring an empty Memory table. #86012 (Julia Kartseva).NonZeroUInt64 for logs_to_keep in DatabaseReplicatedSettings. #86142 (Tuan Pham Anh).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).clickhouse binary in integrations tests to get unstripped debug symbols. #83779 (Mikhail f. Shiryaev).system.symbols and addressToSymbol""'. #82809 (Alexey Milovidov).getMergeTreeReaderSettings to a static member function"'. #84749 (Robert Schulze).use_async_executor_for_materialized_views introduced in https://github.com/ClickHouse/ClickHouse/pull/72497. #73377 (Alexander Gololobov).getMergeTreeReaderSettings to a static member function. #83531 (Jimmy Aguilar Mena).sccache supports explicit server start. We should start it before the ninja build stage. #83600 (Mikhail f. Shiryaev).ON CLUSTER backups. We need to clean coordination nodes in ZooKeeper correctly after a backup or restore failed or got cancelled. #83835 (Vitaly Baranov).DDLWorker before shutting down BackupsWorker. #83840 (Vitaly Baranov).FilterTransform could stop reading if the expression for any chunk returned a constant false. This can lead to a bug, because constant columns are allowed to appear during the execution, and most function default implementations will preserve constants as well. #83855 (Nikolai Kochetov).CONTAINS_ALL flag from postings list. #83901 (Elmi Ahmadov).runner_options when running flaky checks. #83909 (Nikita Taranov).max_cpu_shares does not take effect independently in CPU scheduling. #83960 (Fan Ziqi).system.query_metric_log that cannot work in theory. #84014 (Alexey Milovidov).03532_json_dynamic_updates. #84022 (Alexey Milovidov).03221_insert_timeout_overflow_mode. #84023 (Alexey Milovidov).01825_new_type_json_ghdata_insert_select. #84066 (Alexey Milovidov).00988_expansion_aliases_limit. #84067 (Alexey Milovidov).02932_set_ttl_where. #84088 (Alexey Milovidov).03325_alter_modify_projection_primary_key_column. #84089 (Alexey Milovidov).parallel_hash join and thin key columns (like Int16). #84213 (Vladimir Cherkasov).test_parallel_replicas_protocol. #84251 (Nikita Taranov).runner --debug option to enable ClickHouse root folder mount for debugging. #84252 (Sergei Trifonov).00160_merge_and_index_in_in lighter. #84255 (Alexey Milovidov).MergeTreeBackgroundExecutor. When we need to restart all tables due to connection loss and we wait for background tasks to finish - tables may even stuck in readonly mode for an hour. But looks like we don't need this lock for calling cancel. #84311 (Alexander Tokmakov).repo field in logs cluster, use single ClickHouseProc class. #84314 (Mikhail f. Shiryaev).repo field in exported CI logs. #84321 (Mikhail f. Shiryaev).estimateNumRowsForMaxSizeColumn. #84323 (Nikita Taranov).StorageGenerateRandom. #84325 (Nikita Taranov).00984_parser_stack_overflow under heavy sanitizers. #84399 (Nikita Taranov).02023_storage_filelog. #84418 (Nikita Taranov).00111_shard_external_sort_distributed test with slow sanitizers. #84429 (Pedro Ferreira).00002_log_and_exception_messages_formatting (1). #84511 (Alexey Milovidov).00002_log_and_exception_messages_formatting (2). #84537 (Alexey Milovidov).00002_log_and_exception_messages_formatting (3). #84538 (Alexey Milovidov).mergeTreeIndex. #84673 (Anton Popov).sccache sometimes could start during cmake configuration, and fail to start. This change starts the server before cmake. #84674 (Mikhail f. Shiryaev).SharedLockGuard explicitly. #84687 (Mikhail Artemenko).02962_system_sync_replica_lightweight_from_modifier. #84743 (Sergei Trifonov).searchAny/searchAll: do not tokenize input needles. #84804 (Elmi Ahmadov).apply_patch_parts. #84848 (Anton Popov).test_restore_replica. #84855 (Nikita Mikhaylov).03203_hive_style_partitioning.sh. #84875 (Kseniia Sumarokova).test_keeper_invalid_digest. #84897 (Antonio Andelic).searchAny/searchAll(..., tokens(...)). #84900 (Elmi Ahmadov).feature_docs.py to account for autogenerated docs. #84944 (Shaun Struwig).for i in *.oldanalyzer.reference; do diff -q -s $i ${i/oldanalyzer./} >/dev/null && echo $i; done | xargs git rm. #84978 (Alexey Milovidov).03208_multiple_joins_with_storage_join in parallel replicas job. #84986 (Nikita Fomichev).execute_spark_query failed. #85080 (Kseniia Sumarokova).--order parameter in clickhouse-test. #85123 (Alexey Milovidov).multiSearchAny from text index. #85180 (Robert Schulze).TemporaryReplaceTableName from private. #85186 (Miсhael Stetsyuk).01201_read_single_thread_in_order under MSan. #85187 (Nikita Taranov).prefetch_threadpool_pool_size=0. #85322 (Nikita Taranov).#1: Add contrib and build scripts. This is part #1 of https://github.com/ClickHouse/ClickHouse/pull/75036. #85366 (Vitaly Baranov).#2 of https://github.com/ClickHouse/ClickHouse/pull/75036. #85375 (Vitaly Baranov).#4 of https://github.com/ClickHouse/ClickHouse/pull/75036. #85394 (Vitaly Baranov).nowInBlock64: Fix bug #85534. #85542 (Robert Schulze)._distance virtual column. #85557 (Shankar Iyer).--exclude-dependencies from https://github.com/tox-dev/pipdeptree/pull/488 to build dependencies excluding pipdeptree. Run reqgenerator.py first time for style-test container. Add opanai package for completion tasks. #85655 (Mikhail f. Shiryaev).merge_failures because generally the metric indicates a sustained issue and keeps growing, so increase and rate functions will eventually return non-zero values. (And if the issue is not sustained, then the metric is not of interest to us anyway.). #85659 (Miсhael Stetsyuk).xirr.cpp as a file name. #85670 (Robert Schulze).03164_materialize_skip_index_on_merge. #85810 (Robert Schulze).AVRO_VERSION. #85886 (Zypperia).GinFilter::QueryString. #86004 (Robert Schulze).LogsSeriesLimiter appeared to be not thread-safe, thus it's removed from the S3Client. This closes: #86088. #86090 (Nikita Mikhaylov).max_digestion_size_per_segment back, mark as obsolete. #86170 (Robert Schulze).