ClickHouse/docs/changelogs/v24.3.3.102-lts.md
2024-05-30 16:58:36 +02:00

14 KiB

sidebar_position sidebar_label
1 2024

2024 Changelog

ClickHouse release v24.3.3.102-lts (7e7f3bdd9b) FIXME as compared to v24.3.2.23-lts (8b7d910960)

Improvement

  • Backported in #62188: StorageJoin with strictness ANY is consistent after reload. When several rows with the same key are inserted, the first one will have higher priority (before, it was chosen randomly upon table loading). close #51027. #61972 (vdimir).
  • Backported in #62443: Client has to send header 'Keep-Alive: timeout=X' to the server. If a client receives a response from the server with that header, client has to use the value from the server. Also for a client it is better not to use a connection which is nearly expired in order to avoid connection close race. #62249 (Sema Checherinda).
  • Backported in #62666: S3 storage and backups also need the same default keep alive settings as s3 disk. #62648 (Sema Checherinda).

Build/Testing/Packaging Improvement

  • Backported in #62013: Remove from the Keeper Docker image the volumes at /etc/clickhouse-keeper and /var/log/clickhouse-keeper. #61683 (Tristan).

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

  • Backported in #62533: Fix data race between MOVE PARTITION query and merges resulting in intersecting parts. #61610 (János Benjamin Antal).
  • Backported in #62244: Fix skipping escape sequcne parsing errors during JSON data parsing while using input_format_allow_errors_num/ratio settings. #61883 (Kruglov Pavel).
  • Backported in #62220: Fixes Crash in Engine Merge if Row Policy does not have expression. #61971 (Ilya Golshtein).
  • Backported in #62234: ReadWriteBufferFromHTTP set right header host when redirected. #62068 (Sema Checherinda).
  • Backported in #62278: Fix query parameter resolution with allow_experimental_analyzer enabled. Closes #62113. #62186 (Dmitry Novik).
  • Backported in #62354: Fix generateRandom with NULL in the seed argument. Fixes #62092. #62248 (Nikolai Kochetov).
  • Backported in #62412: When some index columns are not loaded into memory for some parts of a *MergeTree table, queries with FINAL might produce wrong results. Now we explicitly choose only the common prefix of index columns for all parts to avoid this issue. #62268 (Nikita Taranov).
  • Backported in #62733: Fix inability to address parametrized view in SELECT queries via aliases. #62274 (Dmitry Novik).
  • Backported in #62407: Fix name resolution in case when identifier is resolved to an executed scalar subquery. #62281 (Dmitry Novik).
  • Backported in #62331: Fix argMax with nullable non native numeric column. #62285 (Raúl Marín).
  • Backported in #62344: Fix data race on scalars in Context. #62305 (Kruglov Pavel).
  • Backported in #62484: Resolve positional arguments only on the initiator node. Closes #62289. #62362 (flynn).
  • Backported in #62442: Fix filter pushdown from additional_table_filters in Merge engine in analyzer. Closes #62229. #62398 (Kruglov Pavel).
  • Backported in #62475: Fix Unknown expression or table expression identifier error for GLOBAL IN table queries (with new analyzer). Fixes #62286. #62409 (Nikolai Kochetov).
  • Backported in #62612: Fix an error LIMIT expression must be constant in queries with constant expression in LIMIT/OFFSET which contains scalar subquery. Fixes #62294. #62567 (Nikolai Kochetov).
  • Backported in #62679: Fix segmentation fault when using Hive table engine. Reference #62154, #62560. #62578 (Nikolay Degterinsky).
  • Backported in #62641: Fix memory leak in groupArraySorted. Fix #62536. #62597 (Antonio Andelic).
  • Backported in #62770: Fix argMin/argMax combinator state. #62708 (Raúl Marín).
  • Backported in #62750: Fix temporary data in cache failing because of a small value of setting filesystem_cache_reserve_space_wait_lock_timeout_milliseconds. Introduced a separate setting temporary_data_in_cache_reserve_space_wait_lock_timeout_milliseconds. #62715 (Kseniia Sumarokova).
  • Backported in #62993: Fix an error when FINAL is not applied when specified in CTE (new analyzer). Fixes #62779. #62811 (Duc Canh Le).
  • Backported in #62859: Fixed crash in function formatRow with JSON format in queries executed via the HTTP interface. #62840 (Anton Popov).
  • Backported in #63056: Fixed bug in GCD codec implementation that may lead to server crashes. #62853 (Nikita Taranov).
  • Backported in #62960: Disable optimize_rewrite_aggregate_function_with_if for sum(nullable). #62912 (Raúl Marín).
  • Backported in #63032: Fix temporary data in cache incorrect behaviour in case creation of cache key base directory fails with no space left on device. #62925 (Kseniia Sumarokova).
  • Backported in #63148: Fix optimize_rewrite_aggregate_function_with_if implicit cast. #62999 (Raúl Marín).
  • Backported in #63146: Fix Not found column in block error for distributed queries with server-side constants in GROUP BY key. Fixes #62682. #63047 (Nikolai Kochetov).
  • Backported in #63144: Fix incorrect judgement of of monotonicity of function abs. #63097 (Duc Canh Le).
  • Backported in #63178: Setting server_name might help with recently reported SSL handshake error when connecting to MongoDB Atlas: Poco::Exception. Code: 1000, e.code() = 0, SSL Exception: error:10000438:SSL routines:OPENSSL_internal:TLSV1_ALERT_INTERNAL_ERROR. #63122 (Alexander Gololobov).
  • Backported in #63170: The wire protocol version check for MongoDB used to try accessing "config" database, but this can fail if the user doesn't have permissions for it. The fix is to use the database name provided by user. #63126 (Alexander Gololobov).
  • Backported in #63193: Fix a bug when SQL SECURITY statement appears in all CREATE queries if the server setting ignore_empty_sql_security_in_create_view_query=true https://github.com/ClickHouse/ClickHouse/pull/63134. #63136 (pufit).

CI Fix or Improvement (changelog entry is not required)

NO CL CATEGORY

NOT FOR CHANGELOG / INSIGNIFICANT