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

# 2025 Changelog

### ClickHouse release v25.4.5.24-stable (0f9619ed591) FIXME as compared to v25.4.4.25-stable (c97f6ffeac6)

#### Bug Fix (user-visible misbehavior in an official stable release)
* Backported in [#80466](https://github.com/ClickHouse/ClickHouse/issues/80466): Try to use IColumn instead of Field in SingleValueDataGeneric. It fixes the incorrect return values for some aggregate functions like `argMax` for types `Dynamic/Variant/JSON`. [#79166](https://github.com/ClickHouse/ClickHouse/pull/79166) ([Pavel Kruglov](https://github.com/Avogar)).
* Backported in [#80258](https://github.com/ClickHouse/ClickHouse/issues/80258): Fixes AMBIGUOUS_COLUMN_NAME error with lazy materialization when no columns are used for query execution until projection. Example, SELECT * FROM t ORDER BY rand() LIMIT 5. [#79926](https://github.com/ClickHouse/ClickHouse/pull/79926) ([Igor Nikonov](https://github.com/devcrafter)).
* Backported in [#80339](https://github.com/ClickHouse/ClickHouse/issues/80339): Fix reading subcolumns from Merge engine. [#80158](https://github.com/ClickHouse/ClickHouse/pull/80158) ([Pavel Kruglov](https://github.com/Avogar)).
* Backported in [#80506](https://github.com/ClickHouse/ClickHouse/issues/80506): Fix improper serialization of nested numeric fields as strings in MongoDB documents. Remove maximum depth limit for documents from MongoDB. [#80289](https://github.com/ClickHouse/ClickHouse/pull/80289) ([Kirill Nikiforov](https://github.com/allmazz)).
* Backported in [#80402](https://github.com/ClickHouse/ClickHouse/issues/80402): Fix text representation of DateTime and DateTime64 for PostgreSQL storage. [#80301](https://github.com/ClickHouse/ClickHouse/pull/80301) ([Yakov Olkhovskiy](https://github.com/yakov-olkhovskiy)).
* Backported in [#80395](https://github.com/ClickHouse/ClickHouse/issues/80395): Fix `NOT_FOUND_COLUMN_IN_BLOCK` error caused by filter-push-down optimization of the logical JOIN sep in case `ON` expression is not a trivial equality. Fixes [#79647](https://github.com/ClickHouse/ClickHouse/issues/79647) Fixes [#77848](https://github.com/ClickHouse/ClickHouse/issues/77848). [#80360](https://github.com/ClickHouse/ClickHouse/pull/80360) ([Nikolai Kochetov](https://github.com/KochetovNicolai)).

#### NOT FOR CHANGELOG / INSIGNIFICANT

* Backported in [#80260](https://github.com/ClickHouse/ClickHouse/issues/80260): More tests for PR INSERT SELECT. [#79380](https://github.com/ClickHouse/ClickHouse/pull/79380) ([Igor Nikonov](https://github.com/devcrafter)).
* Backported in [#79623](https://github.com/ClickHouse/ClickHouse/issues/79623): Avoid cache calculation for deduplication when deduplication is off. [#79596](https://github.com/ClickHouse/ClickHouse/pull/79596) ([Sema Checherinda](https://github.com/CheSema)).
* Backported in [#80273](https://github.com/ClickHouse/ClickHouse/issues/80273): Fix flaky test_refreshable_mv/test.py::test_adding_replica. [#79940](https://github.com/ClickHouse/ClickHouse/pull/79940) ([Michael Kolupaev](https://github.com/al13n321)).
* Backported in [#80256](https://github.com/ClickHouse/ClickHouse/issues/80256): Try to make test_check_replicated_does_not_block_shutdown less flaky. [#80028](https://github.com/ClickHouse/ClickHouse/pull/80028) ([Raúl Marín](https://github.com/Algunenano)).
* Backported in [#80522](https://github.com/ClickHouse/ClickHouse/issues/80522): Fixing creating live and window view creation with populating, it is broken after pr 79596. [#80471](https://github.com/ClickHouse/ClickHouse/pull/80471) ([Sema Checherinda](https://github.com/CheSema)).

