ClickHouse/docs/changelogs/v24.6.5.30-stable.md

sidebar_position	sidebar_label
1	2024

2024 Changelog

ClickHouse release v24.6.5.30-stable (e6e196c92d) FIXME as compared to v24.6.4.42-stable (c534bb4b4d)

Bug Fix (user-visible misbehavior in an official stable release)

• Backported in #68969: Fix the upper bound of the function fromModifiedJulianDay. It was supposed to be 9999-12-31 but was mistakenly set to 9999-01-01. #67583 (PHO).
• Backported in #68814: Fixed crash in Parquet filtering when data types in the file substantially differ from requested types (e.g. ... FROM file('a.parquet', Parquet, 'x String'), but the file has x Int64). Without this fix, use input_format_parquet_filter_push_down = 0 as a workaround. #68131 (Michael Kolupaev).
• Backported in #69005: After https://github.com/ClickHouse/ClickHouse/pull/61984 schema_inference_make_columns_nullable=0 still can make columns Nullable in Parquet/Arrow formats. The change was backward incompatible and users noticed the changes in the behaviour. This PR makes schema_inference_make_columns_nullable=0 to work as before (no Nullable columns will be inferred) and introduces new value auto for this setting that will make columns Nullable only if data has information about nullability. #68298 (Kruglov Pavel).
• Backported in #68883: Fixes #50868. Small DateTime64 constant values returned by a nested subquery inside a distributed query were wrongly transformed to Nulls, thus causing errors and possible incorrect query results. #68323 (Shankar).
• Backported in #69025: Added back virtual columns _table and _database to distributed tables. They were available until version 24.3. #68672 (Anton Popov).
• Backported in #68860: Fix possible error Size of permutation (0) is less than required (...) during Variant column permutation. #68681 (Kruglov Pavel).
• Backported in #68786: Fix issue with materialized constant keys when hashing maps with arrays as keys in functions sipHash(64/128)Keyed. #68731 (Salvatore Mesoraca).
• Backported in #69156: Fix possible wrong result during anyHeavy state merge. #68950 (Raúl Marín).
• Backported in #69116: Fix logical error when we have empty async insert. #69080 (Han Fei).

NO CL CATEGORY

• Backported in #68942:. #68897 (Alexander Gololobov).

NOT FOR CHANGELOG / INSIGNIFICANT

• Backported in #68830: Turn off fault injection for insert in 01396_inactive_replica_cleanup_nodes_zookeeper. #68715 (alesapin).
• Backported in #69048: Fix 01114_database_atomic flakiness. #68930 (Raúl Marín).