docs/changelogs/v25.10.4.104-stable.md
enable_positional_arguments_for_projections setting to enable a safe ClickHouse cluster upgrade when positional arguments are present in the projections. #92007 (Dmitry Novik).merge_max_dynamic_subcolumns_in_wide_part to be able to limit the number of dynamic subcolumns in the Wide part after merge regardless of the parameters specified in the data type. #87646 (Pavel Kruglov).insert select from s3cluster() queries for parallel distributed execution. this change allows using where, which was possible before. #84611 (Igor Nikonov).merge_tree_use_prefixes_deserialization_thread_pool setting instead of unconditionally using the thread pool. #91208 (Raufs Dunamalijevs).Array to QBit. Integer and float arrays can now be inserted directly into QBit columns without explicit type casts. #91846 (Raufs Dunamalijevs).UNION. Fixes #88180. #88350 (Sema Checherinda).All hive partitioning columns must be present in the schema during upgrade). #90202 (Kseniia Sumarokova).CANNOT_READ_ALL_DATA error. Resolves #90264. #90302 (Pavel Kruglov).toDateTimeOrNull of a negative argument returns NULL. #90490 (Yarik Briukhovetskyi).LowCardinality(Bool/Date32) in Arrow format. Resolves #83883. #90505 (Pavel Kruglov).LowCardinality columns in partition keys. Closes #89412. #90666 (xiaohuanlin).ALTER UPDATE queries when a remote table function is used with localhost as a target host. #90761 (pufit).display_secrets_in_show_and_select and format_display_secrets_in_show_and_select. #90765 (Pablo Marcos).serialize_string_in_memory_with_zero_byte. #90880 (Antonio Andelic).SummingMergeTree aggregation for Nested LowCardinality columns. #90927 (Ivan Babrou).CREATE USER. #90928 (pufit).write_marks_for_substreams_in_compact_parts. #91014 (Pavel Kruglov).ARRAY JOIN when one of the table columns is empty tuple column. Closes #90801. #91123 (Nihal Z. Miaji).dictGetDescendants caused by NULL when dictionary type has Hierarchy support but no column is HIERARCHICAL. Closes #92026. Closes #92121. #91420 (Nihal Z. Miaji).QBit type failing with query parameters like SET param_q=[1,2,3,4]; SELECT {q:QBit(Float32,4)}. #91488 (Raufs Dunamalijevs).remote function. Closes #90568. #91524 (Nihal Z. Miaji).L2DistanceTransposed returning incorrect results when using non-constant reference vectors (e.g., from a table). #91517. #91593 (Raufs Dunamalijevs).delta_lake_snapshot_version which could give incorrect result when used with table engine (not table function) and value -1 (disabled) after snapshot version was used before that. Closes #87676. #91818 (Kseniia Sumarokova).ddlworker::markreplicasactive, if there is no active host found, and the remote_servers has some host_ids, we print a warning log instead of throwing an exception. #92223 (Tuan Pham Anh).Nothing type in caseWithExpression function arguments . Closes #85354. #92351 (Nihal Z. Miaji).count_distinct_optimization pass over window functions and over multiple arguments. #92376 (Raúl Marín).GRANT statements failing due to unrelated revokes. #92725 (pufit).not match(...) is used in WHERE causing incorrect results. Closes #92492. #92726 (Nihal Z. Miaji).Connection. #92807 (Raufs Dunamalijevs). Failed to set file processing within 100 retries in storgae S3Queue in Ordered mode. It is now replaced with a warning. This error could happen before 25.10 version if keeper session expired, however it will still be a warning in 25.10+ versions, as it is still theoretically possible to get this error in case of high processing concurrency in Ordered mode. #92814 (Kseniia Sumarokova).IN clause with subqueries in the predicate of the WHERE clause. #92838 (Anton Popov).FILE_DOESNT_EXIST after mutation of a sparse column with ratio_of_defaults_for_sparse_serialization=0.0. Closes #92633. #92860 (Pavel Kruglov).ratio_of_defaults_for_sparse_serialization was changed to 1.0 via alter. #93016 (Pavel Kruglov).not materialize(...) or not CAST(...) is used in WHERE causing incorrect results. Closes #88536. #93017 (Nihal Z. Miaji).chcache and sccache as rust wrapper. #92404 (Mikhail f. Shiryaev).~PooledConnection. #89090 (Miсhael Stetsyuk).ulimit -n setting was recently changed in the integration tests runner, and this fd leak started to become visible. #91750 (Mikhail Artemenko).optimize_skip_unused_shards optimization for Distributed engine that may lead to Serialization is not implemented for data type Set due to wrong types. #91923 (Azat Khuzhin).