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: 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 (Pavel Kruglov).
• Backported in #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 (Igor Nikonov).
• Backported in #80339: Fix reading subcolumns from Merge engine. #80158 (Pavel Kruglov).
• Backported in #80506: Fix improper serialization of nested numeric fields as strings in MongoDB documents. Remove maximum depth limit for documents from MongoDB. #80289 (Kirill Nikiforov).
• Backported in #80402: Fix text representation of DateTime and DateTime64 for PostgreSQL storage. #80301 (Yakov Olkhovskiy).
• Backported in #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 Fixes #77848. #80360 (Nikolai Kochetov).

NOT FOR CHANGELOG / INSIGNIFICANT

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