---
sidebar_position: 1
sidebar_label: 2025
---

# 2025 Changelog

### ClickHouse release v25.1.6.34-stable (004003dccf8) FIXME as compared to v25.1.5.31-stable (48f17e8a805)

#### Performance Improvement
* Backported in [#76700](https://github.com/ClickHouse/ClickHouse/issues/76700): Fixed double preallocation in `ConcurrentHashJoin` in case join sides are swapped by the optimizer. [#75149](https://github.com/ClickHouse/ClickHouse/pull/75149) ([Nikita Taranov](https://github.com/nickitat)).
* Backported in [#76696](https://github.com/ClickHouse/ClickHouse/issues/76696): Fixed unnecessary contention in `parallel_hash` when `max_rows_in_join = max_bytes_in_join = 0`. [#75155](https://github.com/ClickHouse/ClickHouse/pull/75155) ([Nikita Taranov](https://github.com/nickitat)).

#### Improvement
* Backported in [#76437](https://github.com/ClickHouse/ClickHouse/issues/76437): Allow to parse endpoints like `localhost:1234/handle` in `postgresql` or `mysql` table functions. This fixes a regression introduced in https://github.com/ClickHouse/ClickHouse/pull/52503. [#75944](https://github.com/ClickHouse/ClickHouse/pull/75944) ([Nikita Mikhaylov](https://github.com/nikitamikhaylov)).
* Backported in [#76609](https://github.com/ClickHouse/ClickHouse/issues/76609): Use correct fallback when multipart copy to S3 fails during backup with Access Denied. Multi part copy can generate Access Denied error when backup is done between buckets that have different credentials. [#76515](https://github.com/ClickHouse/ClickHouse/pull/76515) ([Antonio Andelic](https://github.com/antonio2368)).

#### Bug Fix (user-visible misbehavior in an official stable release)
* Backported in [#76142](https://github.com/ClickHouse/ClickHouse/issues/76142): Fix for some of IPv6 addresses (such as ::ffff:1.1.1.1) in forwarded_for field is wrongly interpreted resulting in client disconnect with exception. [#75133](https://github.com/ClickHouse/ClickHouse/pull/75133) ([Yakov Olkhovskiy](https://github.com/yakov-olkhovskiy)).
* Backported in [#76395](https://github.com/ClickHouse/ClickHouse/issues/76395): Checks that we don't specify key_condition when counting total_number_of_rows for NumRowsCache. [#75164](https://github.com/ClickHouse/ClickHouse/pull/75164) ([Daniil Ivanik](https://github.com/divanik)).
* Backported in [#76529](https://github.com/ClickHouse/ClickHouse/issues/76529): Respect `materialized_views_ignore_errors` when a materialized view writes to a URL engine and there is a connectivity issue. [#75679](https://github.com/ClickHouse/ClickHouse/pull/75679) ([Christoph Wurm](https://github.com/cwurm)).
* Backported in [#76540](https://github.com/ClickHouse/ClickHouse/issues/76540): Fix `Block structure mismatch in QueryPipeline stream` error for some queries with `UNION ALL`. [#75715](https://github.com/ClickHouse/ClickHouse/pull/75715) ([Nikolai Kochetov](https://github.com/KochetovNicolai)).
* Backported in [#76475](https://github.com/ClickHouse/ClickHouse/issues/76475): Fix incorrect permission check where `ALTER RENAME` required `CREATE USER` grant. Closes [#74372](https://github.com/ClickHouse/ClickHouse/issues/74372). [#76241](https://github.com/ClickHouse/ClickHouse/pull/76241) ([pufit](https://github.com/pufit)).
* Backported in [#76403](https://github.com/ClickHouse/ClickHouse/issues/76403): Fix logical error in index analysis if condition in `WHERE` has `pointInPolygon` function. [#76360](https://github.com/ClickHouse/ClickHouse/pull/76360) ([Anton Popov](https://github.com/CurtizJ)).
* Backported in [#76484](https://github.com/ClickHouse/ClickHouse/issues/76484): Removed allocation from the signal handler. [#76446](https://github.com/ClickHouse/ClickHouse/pull/76446) ([Nikita Taranov](https://github.com/nickitat)).

#### NOT FOR CHANGELOG / INSIGNIFICANT

* Backported in [#76508](https://github.com/ClickHouse/ClickHouse/issues/76508): Add `prefetch` method to `ReadBufferFromEncryptedFile`. [#76322](https://github.com/ClickHouse/ClickHouse/pull/76322) ([Antonio Andelic](https://github.com/antonio2368)).
* Backported in [#76465](https://github.com/ClickHouse/ClickHouse/issues/76465): Fix `setReadUntilPosition` in `AsynchronousBoundedReadBuffer`. [#76429](https://github.com/ClickHouse/ClickHouse/pull/76429) ([Antonio Andelic](https://github.com/antonio2368)).
* Backported in [#76577](https://github.com/ClickHouse/ClickHouse/issues/76577): Skip 02435_rollback_cancelled_queries test when running with Azure blob storage. [#76561](https://github.com/ClickHouse/ClickHouse/pull/76561) ([Alexey Katsman](https://github.com/alexkats)).
* Backported in [#76602](https://github.com/ClickHouse/ClickHouse/issues/76602): Use `MultiRead` when querying `system.distributed_ddl_queue`. [#76575](https://github.com/ClickHouse/ClickHouse/pull/76575) ([Antonio Andelic](https://github.com/antonio2368)).

