ClickHouse/docs/changelogs/v24.3.6.48-lts.md

sidebar_position	sidebar_label
1	2024

2024 Changelog

ClickHouse release v24.3.6.48-lts (b2d33c3c45) FIXME as compared to v24.3.5.46-lts (fe54cead6b)

Critical Bug Fix (crash, LOGICAL_ERROR, data loss, RBAC)

• Backported in #66889: Fix unexpeced size of low cardinality column in function calls. #65298 (Raúl Marín).
• Backported in #66687: Fix the VALID UNTIL clause in the user definition resetting after a restart. Closes #66405. #66409 (Nikolay Degterinsky).
• Backported in #67497: Fix crash in DistributedAsyncInsert when connection is empty. #67219 (Pablo Marcos).

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

• Backported in #66324: Add missing settings input_format_csv_skip_first_lines/input_format_tsv_skip_first_lines/input_format_csv_try_infer_numbers_from_strings/input_format_csv_try_infer_strings_from_quoted_tuples in schema inference cache because they can change the resulting schema. It prevents from incorrect result of schema inference with these settings changed. #65980 (Kruglov Pavel).
• Backported in #66151: Fixed buffer overflow bug in unbin/unhex implementation. #66106 (Nikita Taranov).
• Backported in #66451: Fixed a bug in ZooKeeper client: a session could get stuck in unusable state after receiving a hardware error from ZooKeeper. For example, this might happen due to "soft memory limit" in ClickHouse Keeper. #66140 (Alexander Tokmakov).
• Backported in #66222: Fix issue in SumIfToCountIfVisitor and signed integers. #66146 (Raúl Marín).
• Backported in #66676: Fix handling limit for system.numbers_mt when no index can be used. #66231 (János Benjamin Antal).
• Backported in #66602: Fixed how the ClickHouse server detects the maximum number of usable CPU cores as specified by cgroups v2 if the server runs in a container such as Docker. In more detail, containers often run their process in the root cgroup which has an empty name. In that case, ClickHouse ignored the CPU limits set by cgroups v2. #66237 (filimonov).
• Backported in #66356: Fix the Not-ready set error when a subquery with IN is used in the constraint. #66261 (Nikolai Kochetov).
• Backported in #66970: Fix Column identifier is already registered error with group_by_use_nulls=true and new analyzer. #66400 (Nikolai Kochetov).
• Backported in #66967: Fix Cannot find column error for queries with constant expression in GROUP BY key and new analyzer enabled. #66433 (Nikolai Kochetov).
• Backported in #66718: Correctly track memory for Allocator::realloc. #66548 (Antonio Andelic).
• Backported in #66949: Fix an invalid result for queries with WINDOW. This could happen when PARTITION columns have sparse serialization and window functions are executed in parallel. #66579 (Nikolai Kochetov).
• Backported in #66946: Fix Method getResultType is not supported for QUERY query node error when scalar subquery was used as the first argument of IN (with new analyzer). #66655 (Nikolai Kochetov).
• Backported in #67629: Fix for occasional deadlock in Context::getDDLWorker. #66843 (Alexander Gololobov).
• Backported in #67193: TRUNCATE DATABASE used to stop replication as if it was a DROP DATABASE query, it's fixed. #67129 (Alexander Tokmakov).
• Backported in #67375: Fix error Cannot convert column because it is non constant in source stream but must be constant in result. for a query that reads from the Merge table over the Distriburted table with one shard. #67146 (Nikolai Kochetov).
• Backported in #67572: Fix execution of nested short-circuit functions. #67520 (Kruglov Pavel).

NOT FOR CHANGELOG / INSIGNIFICANT

• Backported in #66422: Ignore subquery for IN in DDLLoadingDependencyVisitor. #66395 (Nikolai Kochetov).
• Backported in #66855: Fix data race in S3::ClientCache. #66644 (Konstantin Morozov).
• Backported in #67055: Increase asio pool size in case the server is tiny. #66761 (alesapin).
• Backported in #66943: Small fix in realloc memory tracking. #66820 (Antonio Andelic).