thevar1able/ClickHouse
1
0
Fork 0
mirror of https://github.com/ClickHouse/ClickHouse.git synced 2024-11-21 15:12:02 +00:00
Code Issues Packages Projects Releases Wiki Activity
test-filter-by-join-table
ClickHouse/docs/changelogs/v24.8.3.59-lts.md

8.8 KiB
Raw Permalink Blame History

sidebar_position sidebar_label
1 2024

2024 Changelog

ClickHouse release v24.8.3.59-lts (e729b9fa40) FIXME as compared to v24.8.2.3-lts (b54f79ed32)

New Feature

  • Backported in #68710: Query cache entries can now be dropped by tag. For example, the query cache entry created by SELECT 1 SETTINGS use_query_cache = true, query_cache_tag = 'abc' can now be dropped by SYSTEM DROP QUERY CACHE TAG 'abc' (or of course just: SYSTEM DROP QUERY CACHE which will clear the entire query cache). #68477 (Michał Tabaszewski).

Improvement

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

  • Backported in #68973: 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 #68818: 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 #68893: 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 #68721: 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 #69029: Added back virtual columns _table and _database to distributed tables. They were available until version 24.3. #68672 (Anton Popov).
  • Backported in #68864: Fix possible error Size of permutation (0) is less than required (...) during Variant column permutation. #68681 (Kruglov Pavel).
  • Backported in #68854: Fix possible error DB::Exception: Block structure mismatch in joined block stream: different columns: with new JSON column. #68686 (Kruglov Pavel).
  • Backported in #68790: Fix issue with materialized constant keys when hashing maps with arrays as keys in functions sipHash(64/128)Keyed. #68731 (Salvatore Mesoraca).
  • Backported in #69108: TODO. #68744 (Nikolai Kochetov).
  • Backported in #68850: Fix resolving dynamic subcolumns from subqueries in analyzer. #68824 (Kruglov Pavel).
  • Backported in #68911: Fix complex types metadata parsing in DeltaLake. Closes #68739. #68836 (Kseniia Sumarokova).
  • Backported in #69160: Fix possible wrong result during anyHeavy state merge. #68950 (Raúl Marín).
  • Backported in #69072: Fixed writing to Materialized Views with enabled setting optimize_functions_to_subcolumns. #68951 (Anton Popov).
  • Backported in #69016: Don't use serializations cache in const Dynamic column methods. It could let to use-of-unitialized value or even race condition during aggregations. #68953 (Kruglov Pavel).
  • Backported in #69120: Fix logical error when we have empty async insert. #69080 (Han Fei).

NO CL CATEGORY

NOT FOR CHANGELOG / INSIGNIFICANT