2025 Changelog

- Fix block structure mismatch with queries using FINAL and PREWHERE. [#91847](https://github.com/ClickHouse/ClickHouse/pull/91847) ([Antonio Andelic](https://github.com/antonio2368)).
- Fix logical error with `join_use_nulls` and multiple joins along with cross join. [#91853](https://github.com/ClickHouse/ClickHouse/pull/91853) ([Vladimir Cherkasov](https://github.com/vdimir)).
- Add repair mechanism for JSON with duplicated path in shared data and dynamic paths that could happen because of the bug that was fixed in <https://github.com/ClickHouse/ClickHouse/pull/90816>. [#91886](https://github.com/ClickHouse/ClickHouse/pull/91886) ([Pavel Kruglov](https://github.com/Avogar)).
- Fix the ORC reader bug when reading string columns that are encoded with DICTIONARY\_V2 and contain only NULL values. [#91889](https://github.com/ClickHouse/ClickHouse/pull/91889) ([Peng Jian](https://github.com/fastio)).
- Fix a serialization inconsistency between sparse and nullable substreams in Tuple columns that could lead to corrupted parts or crashes during reading. This addresses <https://github.com/ClickHouse/ClickHouse/pull/91851> . @Algunenano Could you please help check if this can fix the stress test in private repo? @CurtizJ Could you also help take a look please? Thanks!. [#91932](https://github.com/ClickHouse/ClickHouse/pull/91932) ([Amos Bird](https://github.com/amosbird)).
- Fix `Directory '{}' does not exist (LOGICAL_ERROR)` when creating backups on plain-rewritable disks. [#91935](https://github.com/ClickHouse/ClickHouse/pull/91935) ([Julia Kartseva](https://github.com/jkartseva)).
- Prevent crash when connecting to mongodb with named collections. [#91959](https://github.com/ClickHouse/ClickHouse/pull/91959) ([Antonio Andelic](https://github.com/antonio2368)).
- Fix "TOO\_MANY\_MARKS" error which could have happened after some `ALTER` queries for compact parts. [#91980](https://github.com/ClickHouse/ClickHouse/pull/91980) ([alesapin](https://github.com/alesapin)).
- Close <https://github.com/clickhouse/clickhouse/issues/87417> the writing schema of v1 format has a mistake : the type of "added\_snapshot\_id" should be "long" rather than "null, long" because it is required. it is a bug because it's not compatible with other system like spark. when we mixed there manifest files, the bug happens. [#92078](https://github.com/ClickHouse/ClickHouse/pull/92078) ([Han Fei](https://github.com/hanfei1991)).
- Fix the wrong names of `readWKT`, `readWKB`, which were in the wrong style in the previous versions. [#92094](https://github.com/ClickHouse/ClickHouse/pull/92094) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fix numerous logical errors, overflow and functional bugs in `midpoint` function. Closes [#91816](https://github.com/ClickHouse/ClickHouse/issues/91816). [#92102](https://github.com/ClickHouse/ClickHouse/pull/92102) ([Nihal Z. Miaji](https://github.com/nihalzp)).
- Fixes incorrect results that could appear when reading certain subcolumns (e.g., string size) with sparse encoding. [#92156](https://github.com/ClickHouse/ClickHouse/pull/92156) ([Pavel Kruglov](https://github.com/Avogar)).
- Fix `system.view_refreshes` failing with error `No macro 'replica' in config`. [#92203](https://github.com/ClickHouse/ClickHouse/pull/92203) ([Michael Kolupaev](https://github.com/al13n321)).
- Fix UDF replace in format. [#92210](https://github.com/ClickHouse/ClickHouse/pull/92210) ([Raúl Marín](https://github.com/Algunenano)).
- In `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](https://github.com/ClickHouse/ClickHouse/pull/92223) ([Tuan Pham Anh](https://github.com/tuanpach)).
- Surround operators `IN`, `NOT IN` with parentheses. Fixes [#85075](https://github.com/ClickHouse/ClickHouse/issues/85075). [#92225](https://github.com/ClickHouse/ClickHouse/pull/92225) ([Mikhail f. Shiryaev](https://github.com/Felixoid)).
- Fix backup of KeeperMap and Memory tables. Creating backup of tables using one of those two engines with `max_compress_block_size` set to `0` could lead to a crash. [#92237](https://github.com/ClickHouse/ClickHouse/pull/92237) ([Antonio Andelic](https://github.com/antonio2368)).
- Fix crash when reading both String data and .size subcolumn from Log engine. This fixes [#89909](https://github.com/ClickHouse/ClickHouse/issues/89909). This contains some commits in [#92290](https://github.com/ClickHouse/ClickHouse/issues/92290). [#92341](https://github.com/ClickHouse/ClickHouse/pull/92341) ([Amos Bird](https://github.com/amosbird)).
- Fix logical error caused by using `Nothing` type in `caseWithExpression` function arguments . Closes [#85354](https://github.com/ClickHouse/ClickHouse/issues/85354). [#92351](https://github.com/ClickHouse/ClickHouse/pull/92351) ([Nihal Z. Miaji](https://github.com/nihalzp)).
- Fix possible crash in aggregate functions after MEMORY\_LIMIT\_EXCEEDED. [#92390](https://github.com/ClickHouse/ClickHouse/pull/92390) ([Azat Khuzhin](https://github.com/azat)).