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

sidebar_position	sidebar_label
1	2024

2024 Changelog

ClickHouse release v24.10.2.80-stable (96b8005715) FIXME as compared to v24.10.1.2812-stable (9cd0a3738d)

Backward Incompatible Change

• Backported in #71363: Fix possible error No such file or directory due to unescaped special symbols in files for JSON subcolumns. #71182 (Pavel Kruglov).

Performance Improvement

• Backported in #71852: Improve the performance and accuracy of system.query_metric_log collection interval by reducing the critical region. #71473 (Pablo Marcos).

Improvement

• Backported in #71495: Enable parallel_replicas_local_plan by default. Building a full-fledged local plan on the query initiator improves parallel replicas performance with less resource consumption, provides opportunities to apply more query optimizations. #70171 (Igor Nikonov).
• Backported in #71985: Fixes RIGHT / FULL joins in queries with parallel replicas. Now, RIGHT joins can be executed with parallel replicas (right table reading is distributed). FULL joins can't be parallelized among nodes, - executed locally. #71162 (Igor Nikonov).
• Backported in #71670: When user/group is given as ID, the clickhouse su fails. This patch fixes it to accept UID:GID as well. ### Documentation entry for user-facing changes. #71626 (Mikhail f. Shiryaev).
• Backported in #71940: Update HostResolver 3 times in a history period. #71863 (Sema Checherinda).
• Backported in #71922: Allow_reorder_prewhere_conditions is on by default with old compatibility settings. #71867 (Raúl Marín).

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

• Backported in #71588: Fix mismatched aggreage function name of quantileExactWeightedInterpolated. The bug was introduced in https://github.com/ClickHouse/ClickHouse/pull/69619. cc @Algunenano. #71168 (李扬).
• Backported in #71357: Fix bad_weak_ptr exception with Dynamic in functions comparison. #71183 (Pavel Kruglov).
• Backported in #71467: Fix bug of memory usage increase if enable_filesystem_cache=1, but disk in storage configuration did not have any cache configuration. #71261 (Kseniia Sumarokova).
• Backported in #71355: Fix possible error "Cannot read all data" erros during deserialization of LowCardinality dictionary from Dynamic column. #71299 (Pavel Kruglov).
• Backported in #71324: Fix incomplete cleanup of parallel output format in the client. #71304 (Raúl Marín).
• Backported in #71466: Added missing unescaping in named collections. Without fix clickhouse-server can't start. #71308 (MikhailBurdukov).
• Backported in #71393: Fix inconsistent AST formatting when granting wrong wildcard grants #71309. #71332 (pufit).
• Backported in #71379: Add try/catch to data parts destructors to avoid terminate. #71364 (alesapin).
• Backported in #71751: Check suspicious and experimental types in JSON type hints. #71369 (Pavel Kruglov).
• Backported in #71451: Start memory worker thread on non-Linux OS too (fixes #71051). #71384 (Alexandre Snarskii).
• Backported in #71608: Fix error Invalid number of rows in Chunk with Variant column. #71388 (Pavel Kruglov).
• Backported in #71493: Fix crash in mongodb table function when passing wrong arguments (e.g. NULL). #71426 (Vladimir Cherkasov).
• Backported in #71815: Fix crash with optimize_rewrite_array_exists_to_has. #71432 (Raúl Marín).
• Backported in #71521: Fix possible error Argument for function must be constant (old analyzer) in case when arrayJoin can apparently appear in WHERE condition. Regression after https://github.com/ClickHouse/ClickHouse/pull/65414. #71476 (Nikolai Kochetov).
• Backported in #71555: Prevent crash in SortCursor with 0 columns (old analyzer). #71494 (Raúl Marín).
• Backported in #71618: Analyzer fix when query inside materialized view uses IN with CTE. Closes #65598. #71538 (Maksim Kita).
• Backported in #71570: Avoid crash when using a UDF in a constraint. #71541 (Raúl Marín).
• Backported in #71646: Return 0 or default char instead of throwing an error in bitShift functions in case of out of bounds. #71580 (Pablo Marcos).
• Backported in #71880: Fix LOGICAL_ERROR when doing ALTER with empty tuple. This fixes #71647. #71679 (Amos Bird).
• Backported in #71741: Don't transform constant set in predicates over partition columns in case of NOT IN operator. #71695 (Eduard Karacharov).
• Backported in #72012: Fix exception for toDayOfWeek on WHERE condition with primary key of DateTime64 type. #71849 (Yakov Olkhovskiy).
• Backported in #71897: Fixed filling of defaults after parsing into sparse columns. #71854 (Anton Popov).
• Backported in #71955: Fix data race between the progress indicator and the progress table in clickhouse-client. This issue is visible when FROM INFILE is used. Intercept keystrokes during INSERT queries to toggle progress table display. #71901 (Julia Kartseva).
• Backported in #72006: Fix a crash in clickhouse-client syntax highlighting. Closes #71864. #71949 (Nikolay Degterinsky).

Build/Testing/Packaging Improvement

• Backported in #71692: Improve clickhouse-server Dockerfile.ubuntu. Deprecate CLICKHOUSE_UID/CLICKHOUSE_GID envs. Remove CLICKHOUSE_DOCKER_RESTART_ON_EXIT processing to complien requirements. Consistent clickhouse/clickhouse-server/clickhouse-keeper execution to not have it plain in one place and /usr/bin/clickhouse* in another. #71573 (Mikhail f. Shiryaev).

NOT FOR CHANGELOG / INSIGNIFICANT

• Backported in #71387: Remove bad test test_system_replicated_fetches. #71071 (Alexey Milovidov).
• Backported in #71586: Fix WITH TOTALS in subquery with parallel replicas. #71224 (Nikita Taranov).
• Backported in #71437: Ignore No such key exceptions in some cases. #71236 (Antonio Andelic).
• Backported in #71629: Fix compatibility with refreshable materialized views created by old clickhouse servers. #71556 (Michael Kolupaev).
• Backported in #71805: Fix issues we face on orphane backport branches and closed release PRs, when fake-master events are sent to the check DB. #71782 (Mikhail f. Shiryaev).
• Backported in #71832: Closes #71780. #71818 (Kseniia Sumarokova).
• Backported in #71840: The change has already been applied to https://github.com/docker-library/official-images/pull/17876. Backport it to every branch to have a proper Dockerfile.ubuntu there. #71825 (Mikhail f. Shiryaev).