v26.2 Changelog for Cloud

### Data type and serialization fixes[​](#data-type-and-serialization-fixes "Direct link to Data type and serialization fixes")

- Fixed possible error during reading of size subcolumn from Dynamic/JSON types. [#95573](https://github.com/ClickHouse/ClickHouse/pull/95573) ([Pavel Kruglov](https://github.com/Avogar)).
- Fixed crash during `tupleElement` applied to arrays of JSON. [#95647](https://github.com/ClickHouse/ClickHouse/pull/95647) ([Pavel Kruglov](https://github.com/Avogar)).
- Fixed executing `tupleElement` on JSON with nested paths returning wrong results. [#95907](https://github.com/ClickHouse/ClickHouse/pull/95907) ([Pavel Kruglov](https://github.com/Avogar)).
- Fixed `tupleElement` throwing an exception with JSON for paths with type hints. [#97728](https://github.com/ClickHouse/ClickHouse/pull/97728) ([Pavel Kruglov](https://github.com/Avogar)).
- Fixed skipping paths in JSON data type — previously `JSON(SKIP path)` would skip all keys with prefix `path` (even keys like `pathpath`), which could lead to data loss. Now only the exact key is skipped. [#95948](https://github.com/ClickHouse/ClickHouse/pull/95948) ([Pavel Kruglov](https://github.com/Avogar)).
- Fixed applying `type_json_allow_duplicated_key_with_literal_and_nested_object` to typed paths in JSON. [#97422](https://github.com/ClickHouse/ClickHouse/pull/97422) ([Pavel Kruglov](https://github.com/Avogar)).
- Fixed incompatible typed paths check in JSON type. [#92539](https://github.com/ClickHouse/ClickHouse/pull/92539) ([Pavel Kruglov](https://github.com/Avogar)).
- Fixed creating type hint for path 'skip' in JSON. [#92842](https://github.com/ClickHouse/ClickHouse/pull/92842) ([Pavel Kruglov](https://github.com/Avogar)).
- Fixed dynamic subcolumns resolution in column aliases in analyzer. [#92583](https://github.com/ClickHouse/ClickHouse/pull/92583) ([Pavel Kruglov](https://github.com/Avogar)).
- Fixed `Nested columns sizes are inconsistent with local_discriminators` error due to wrong in-place filtering optimization for Variant columns. [#96410](https://github.com/ClickHouse/ClickHouse/pull/96410) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed crash in `ifNull` with `Variant` argument used in `GROUP BY`. [#96790](https://github.com/ClickHouse/ClickHouse/pull/96790) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed logical error in `FunctionVariantAdaptor` with functions requiring const arguments like `arrayROCAUC`. [#97116](https://github.com/ClickHouse/ClickHouse/pull/97116) ([Bharat Nallan](https://github.com/bharatnc)).
- Fixed `LOGICAL_ERROR` in `FunctionVariantAdaptor` when a function returned `Nothing` type. [#97213](https://github.com/ClickHouse/ClickHouse/pull/97213) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed logical exception when comparing NULL with a Variant column containing LowCardinality types. [#97379](https://github.com/ClickHouse/ClickHouse/pull/97379) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed `LOGICAL_ERROR` in `concat` when an argument contained a `Variant` type with `LowCardinality` inside. [#97654](https://github.com/ClickHouse/ClickHouse/pull/97654) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed incorrect results when `LowCardinality` columns were converted to `Nullable`. [#96483](https://github.com/ClickHouse/ClickHouse/pull/96483) ([Nihal Z. Miaji](https://github.com/nihalzp)).
- Correctly handled `LowCardinality Nullable` types in `CAST` when `cast_keep_nullable` was enabled. [#95747](https://github.com/ClickHouse/ClickHouse/pull/95747) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed `ColumnNullable is not compatible with original` exception when casting complex nested types. [#96924](https://github.com/ClickHouse/ClickHouse/pull/96924) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed `LOGICAL_ERROR` when using `isNull`/`isNotNull` on subcolumns of `Nullable(Tuple(... Nullable(T) ...))` types. [#97582](https://github.com/ClickHouse/ClickHouse/pull/97582) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed `LOGICAL_ERROR` in Array-to-`QBit` conversion. [#97413](https://github.com/ClickHouse/ClickHouse/pull/97413) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed `LOGICAL_ERROR` when reading sparse column and its subcolumn together. [#97515](https://github.com/ClickHouse/ClickHouse/pull/97515) ([Pavel Kruglov](https://github.com/Avogar)).
- Fixed `LOGICAL_ERROR` when reading `.size` subcolumn of a sparse `Nullable(String)` in a Tuple with PREWHERE. [#97264](https://github.com/ClickHouse/ClickHouse/pull/97264) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed assertion failure in `Set` and `MergeTreeIndexSet` when processing columns with inner sparse subcolumns. [#97493](https://github.com/ClickHouse/ClickHouse/pull/97493) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed possible error `SIZES_OF_COLUMNS_DOESNT_MATCH` during sorting of empty tuple column. [#92520](https://github.com/ClickHouse/ClickHouse/pull/92520) ([Pavel Kruglov](https://github.com/Avogar)).
- Fixed `DELTA_BYTE_ARRAY` decoding bugs in native Parquet reader affecting highly repetitive string data. [#91929](https://github.com/ClickHouse/ClickHouse/pull/91929) ([Daniel Muino](https://github.com/dmuino)).
- Fixed assertion when reading from Parquet file when part of a prewhere expression was used elsewhere in the query. [#90635](https://github.com/ClickHouse/ClickHouse/pull/90635) ([Max Kainov](https://github.com/maxknv)).
- Fixed `LOGICAL_ERROR` in Parquet V3 native reader when PREWHERE filter column contained non-boolean UInt8 values. [#96594](https://github.com/ClickHouse/ClickHouse/pull/96594) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed Parquet schema inference in the old reader when a JSON column came after a Tuple column. [#92867](https://github.com/ClickHouse/ClickHouse/pull/92867) ([Michael Kolupaev](https://github.com/al13n321)).
- Fixed schema being cached for all files instead of only the inferred file during glob schema inference. [#92006](https://github.com/ClickHouse/ClickHouse/pull/92006) ([Pavel Kruglov](https://github.com/Avogar)).
- Fixed `ProtobufList` format reading from empty files and producing ghost records for empty tables. [#96007](https://github.com/ClickHouse/ClickHouse/pull/96007) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed regression with the `Gorilla` codec when an explicitly specified size did not correspond to the data type size. [#96118](https://github.com/ClickHouse/ClickHouse/pull/96118) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- PostgreSQL engine can now correctly read `BOOLEAN[]`. [#96006](https://github.com/ClickHouse/ClickHouse/pull/96006) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed logical error when reading UUID column from SQLite TEXT column. [#96016](https://github.com/ClickHouse/ClickHouse/pull/96016) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed SQLite engine type conversion for `DateTime`, `Date`, `UUID`, and other types. [#96017](https://github.com/ClickHouse/ClickHouse/pull/96017) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Fixed `FixedString` values being escaped incorrectly in queries to SQLite and PostgreSQL. [#96019](https://github.com/ClickHouse/ClickHouse/pull/96019) ([Alexey Milovidov](https://github.com/alexey-milovidov)).
- Added `input_format_numbers_enum_on_conversion_error` setting for conversion from Numbers to Enums. [#56240](https://github.com/ClickHouse/ClickHouse/pull/56240) ([Nikolay Degterinsky](https://github.com/evillique)).

### Text index and skip index fixes[​](#text-index-and-skip-index-fixes "Direct link to Text index and skip index fixes")