v26.2 Changelog for Cloud

## Bug Fixes[​](#bug-fixes "Direct link to Bug Fixes")

All bug fixes (click to expand)

### JOIN fixes[​](#join-fixes "Direct link to JOIN fixes")

- Fixed `INCOMPATIBLE_TYPE_OF_JOIN` error for Join storage when outer-to-inner join optimization was applied. [#84292](https://github.com/ClickHouse/ClickHouse/pull/84292) ([Vladimir Cherkasov](https://github.com/vdimir)).
- Fixed logical error for queries with multiple JOINs with `USING` clause and `join_use_nulls`. [#92251](https://github.com/ClickHouse/ClickHouse/pull/92251) ([Vladimir Cherkasov](https://github.com/vdimir)).
- Fixed logical error during join reordering with `join_use_nulls`. [#92289](https://github.com/ClickHouse/ClickHouse/pull/92289) ([Vladimir Cherkasov](https://github.com/vdimir)).
- Fixed a possible crash with `join_on_disk_max_files_to_merge` setting. [#92335](https://github.com/ClickHouse/ClickHouse/pull/92335) ([Bharat Nallan](https://github.com/bharatnc)).
- Fixed `LOGICAL_ERROR` caused by unwanted modification of query plan when converting outer join to inner join. Also relaxed optimization requirements to apply when injective functions are used on aggregating keys during joins. [#92503](https://github.com/ClickHouse/ClickHouse/pull/92503) ([János Benjamin Antal](https://github.com/antaljanosbenjamin)).
- Fixed logical error with multiple joins on constant condition and `join_use_nulls`. [#92892](https://github.com/ClickHouse/ClickHouse/pull/92892) ([Vladimir Cherkasov](https://github.com/vdimir)).
- Fixed `NULL != NULL` case for `full_sorting_join` on `LowCardinality(Nullable(T))` column. [#92924](https://github.com/ClickHouse/ClickHouse/pull/92924) ([Vladimir Cherkasov](https://github.com/vdimir)).
- Fixed join results when the right-side join key was a sparse column. [#93038](https://github.com/ClickHouse/ClickHouse/pull/93038) ([Amos Bird](https://github.com/amosbird)).
- Fixed runtime filters working incorrectly when `LEFT ANTI JOIN` had an extra post-condition. [#91824](https://github.com/ClickHouse/ClickHouse/pull/91824) ([Alexander Gololobov](https://github.com/davenger)).
- Fixed logical error when runtime filters were used in a query with totals for right-side table. [#93330](https://github.com/ClickHouse/ClickHouse/pull/93330) ([Alexander Gololobov](https://github.com/davenger)).
- Fixed logical error in some cases triggered when join runtime filters were added to query plan due to incorrectly returned duplicated const columns. [#93144](https://github.com/ClickHouse/ClickHouse/pull/93144) ([Alexander Gololobov](https://github.com/davenger)).
- Fixed `__applyFilter` function used by join runtime filters returning `ILLEGAL_TYPE_OF_ARGUMENT` in some valid cases. [#93187](https://github.com/ClickHouse/ClickHouse/pull/93187) ([Alexander Gololobov](https://github.com/davenger)).
- Fixed runtime filters not being added when joining with an already-filled right table. [#93211](https://github.com/ClickHouse/ClickHouse/pull/93211) ([Alexander Gololobov](https://github.com/davenger)).
- Fixed `NOT_FOUND_COLUMN_IN_BLOCK` error when runtime filter was enabled and joined tables returned the same column multiple times. [#93526](https://github.com/ClickHouse/ClickHouse/pull/93526) ([Alexander Gololobov](https://github.com/davenger)).
- Fixed `FilterStep` not properly added when join runtime filter was applied over `Merge` table. [#94021](https://github.com/ClickHouse/ClickHouse/pull/94021) ([Alexander Gololobov](https://github.com/davenger)).
- Fixed type conversion to super type during join operation of `Join` storage with `USING` clause. [#94000](https://github.com/ClickHouse/ClickHouse/pull/94000) ([Dmitry Novik](https://github.com/novikd)).
- Fixed queries with parallel replicas and JOIN with non-MergeTree table. [#93902](https://github.com/ClickHouse/ClickHouse/pull/93902) ([Igor Nikonov](https://github.com/devcrafter)).
- Fixed race condition for Nullable join column in runtime filters. [#95775](https://github.com/ClickHouse/ClickHouse/pull/95775) ([Hechem Selmi](https://github.com/m-selmi)).
- Fixed empty string becoming `NULL` in `Join` table with `Nullable(String)` key. [#96002](https://github.com/ClickHouse/ClickHouse/pull/96002) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed `NOT_SUPPORTED` error when using `direct` join algorithm with an empty MergeTree table. [#95935](https://github.com/ClickHouse/ClickHouse/pull/95935) ([Vladimir Cherkasov](https://github.com/vdimir)).
- Fixed incorrect results from queries involving outer joins combined with multiple INNER JOINs due to illegal join reordering when an outer join's `ON` condition referenced columns from multiple previously joined tables. [#96193](https://github.com/ClickHouse/ClickHouse/pull/96193) ([Vladimir Cherkasov](https://github.com/vdimir)).
- Fixed runtime filter exception for Tuple columns with Nullable subfields. [#96509](https://github.com/ClickHouse/ClickHouse/pull/96509) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed queries with CROSS JOINs and enabled parallel replicas returning incorrect results. [#96848](https://github.com/ClickHouse/ClickHouse/pull/96848) ([Igor Nikonov](https://github.com/devcrafter)).
- Fixed `arrayJoin` producing duplicate rows when used with INNER JOIN and WHERE clause, caused by partial predicate push-down incorrectly pushing filters containing `arrayJoin` below a JOIN. [#96989](https://github.com/ClickHouse/ClickHouse/pull/96989) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed `LOGICAL_ERROR` when `arrayJoin` in `WHERE` clause referenced columns from both sides of a JOIN. [#97239](https://github.com/ClickHouse/ClickHouse/pull/97239) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed logical error when using a matcher (`*`) inside a lambda function within a VALUES clause in a JOIN with USING. [#95661](https://github.com/ClickHouse/ClickHouse/pull/95661) ([Vladimir Cherkasov](https://github.com/vdimir)).
- Fixed possible logical error with matcher (`*`, `table.*`) and `analyzer_compatibility_join_using_top_level_identifier` when `USING` column had different types. [#95808](https://github.com/ClickHouse/ClickHouse/pull/95808) ([Vladimir Cherkasov](https://github.com/vdimir)).
- Fixed logical error with `analyzer_compatibility_join_using_top_level_identifier` and ALIAS columns. [#97297](https://github.com/ClickHouse/ClickHouse/pull/97297) ([Vladimir Cherkasov](https://github.com/vdimir)).
- Fixed crash in old analyzer when using JOIN with duplicated aliases. [#96405](https://github.com/ClickHouse/ClickHouse/pull/96405) ([Ilya Golshtein](https://github.com/ilejn)).

### Query and analyzer fixes[​](#query-and-analyzer-fixes "Direct link to Query and analyzer fixes")