2024 Changelog

Backported in #72060: When retrieving data directly from a dictionary using Dictionary storage, dictionary table function, or direct SELECT from the dictionary itself, it is now enough to have SELECT permission or dictGet permission for the dictionary. This aligns with previous attempts to prevent ACL bypasses: https://github.com/ClickHouse/ClickHouse/pull/57362 and https://github.com/ClickHouse/ClickHouse/pull/65359. It also makes the latter one backward compatible. #72051 (Nikita Mikhaylov).

Backported in #71981: After this issue there are quite a few table replicas in production such that their metadata_version node value is both equal to 0 and is different from the respective table's metadata node version. This leads to alter queries failing on such replicas. #69274 (Miсhael Stetsyuk).
Backported in #72142: Acquiring zero-copy shared lock before moving a part to zero-copy disk to prevent possible data loss if Keeper is unavailable. #71845 (Aleksei Filatov).
Backported in #72038: Fix exception for toDayOfWeek on WHERE condition with primary key of DateTime64 type. #71849 (Yakov Olkhovskiy).
Backported in #72032: Fix Illegal type error for MergeTree tables with binary monotonic function in ORDER BY when the first argument is constant. Fixes #71941. #71966 (Nikolai Kochetov).
Backported in #72155: Allow only SELECT queries in EXPLAIN AST used inside subquery. Other types of queries lead to logical error: 'Bad cast from type DB::ASTCreateQuery to DB::ASTSelectWithUnionQuery' or Inconsistent AST formatting. #71982 (Pavel Kruglov).
Backported in #72114: Fix formatting of MOVE PARTITION ... TO TABLE ... alter commands when format_alter_commands_with_parentheses is enabled. #72080 (János Benjamin Antal).