ClickHouse/docs/changelogs/v20.6.3.28-stable.md

4.7 KiB

ClickHouse release v20.6.3.28-stable FIXME as compared to v20.6.2.15-prestable

Bug Fix

  • Backported in #13301: The function groupArrayMoving* was not working for distributed queries. It's result was calculated within incorrect data type (without promotion to the largest type). The function groupArrayMovingAvg was returning integer number that was inconsistent with the avg function. This fixes #12568. #12622 (Alexey Milovidov).
  • Backported in #13029: CREATE USER IF NOT EXISTS now doesn't throw exception if the user exists. This fixes #12507. #12646 (Vitaly Baranov).
  • Backported in #12983: Fix columns duplication for range hashed dictionary created from DDL query. This fixes #10605. #12857 (alesapin).
  • Backported in #13222: Fix DateTime64 conversion functions with constant argument. #13205 (Azat Khuzhin).
  • Backported in #13245: Fix assert in arrayElement function in case of array elements are Nullable and array subscript is also Nullable. This fixes #12172. #13224 (Alexey Milovidov).
  • Backported in #13267: Fix function if with nullable constexpr as cond that is not literal NULL. Fixes #12463. #13226 (Alexey Milovidov).
  • Backported in #13298: Fix potentially low performance and slightly incorrect result for uniqExact, topK, sumDistinct and similar aggregate functions called on Float types with NaN values. It also triggered assert in debug build. This fixes #12491. #13254 (Alexey Milovidov).
  • Backported in #13316: The server may crash if user passed specifically crafted arguments to the function h3ToChildren. This fixes #13275. #13277 (Alexey Milovidov).
  • Backported in #13329: Fix possible error Totals having transform was already added to pipeline in case of a query from delayed replica. #13290 (Nikolai Kochetov).
  • Backported in #13317: Fix crash in LEFT ASOF JOIN with join_use_nulls=1. #13291 (Artem Zuikov).
  • Backported in #13375: Fix segfault when function groupArrayMovingSum deserializes empty state. Fixes #13339. #13341 (alesapin).
  • Backported in #13432: Fix PrettyCompactMonoBlock for clickhouse-local. Fix extremes/totals with PrettyCompactMonoBlock. Fixes #7746. #13394 (Azat Khuzhin).
  • Backported in #13443: Fix aggregate function any(x) is found inside another aggregate function in query error with SET optimize_move_functions_out_of_any = 1 and aliases inside any(). #13419 (Artem Zuikov).