ClickHouse/docs/changelogs/v21.3.13.9-lts.md

sidebar_position	sidebar_label
1	2022

2022 Changelog

ClickHouse release v21.3.13.9-lts FIXME as compared to v21.3.12.2-lts

Improvement

• Backported in #24794: Avoid hiding errors like Limit for rows or bytes to read exceeded for scalar subqueries. #24545 (nvartolomei).

Bug Fix

• Backported in #25567: Kafka storage may support parquet format messages. #23412 (Chao Ma).
• Backported in #24554: Fixed server fault when inserting data through HTTP caused an exception. This fixes #23512. #23643 (Nikita Mikhaylov).
• Backported in #23833: Fix error Can't initialize pipeline with empty pipe for queries with GLOBAL IN/JOIN and use_hedged_requests. Fixes #23431. #23805 (Nikolai Kochetov).
• Backported in #24703: Allow empty HTTP headers. Fixes #23901. #24285 (Ivan).
• Backported in #24702: Fix drop partition with intersect fake parts. In rare cases there might be parts with mutation version greater than current block number. #24321 (Amos Bird).
• Backported in #24725: In "multipart/form-data" message consider the CRLF preceding a boundary as part of it. Fixes #23905. #24399 (Ivan).
• Backported in #24826: - Fixed the deadlock that can happen during LDAP role (re)mapping, when LDAP group is mapped to a nonexistent local role. #24431 (Denis Glazachev).
• Backported in #25566: Fix incorrect monotonicity of toWeek function. This fixes #24422 . This bug was introduced in https://github.com/ClickHouse/ClickHouse/pull/5212 , and was exposed later by smarter partition pruner. #24446 (Amos Bird).
• Backported in #24700: Fixed the behavior when query SYSTEM RESTART REPLICA or SYSTEM SYNC REPLICA is being processed infinitely. This was detected on server with extremely little amount of RAM. #24457 (Nikita Mikhaylov).
• Backported in #24698: Enable reading of subcolumns for distributed tables. #24472 (Anton Popov).
• Fixed remote JDBC bridge timeout connection issue. Closes #9609. #24588 (Maksim Kita).
• Backported in #24771: Fix bug which can lead to ZooKeeper client hung inside clickhouse-server. #24721 (alesapin).
• Backported in #24934: - If ZooKeeper connection was lost and replica was cloned after restoring the connection, its replication queue might contain outdated entries. It's fixed. - Fixed crash when replication queue contains intersecting virtual parts. It may rarely happen if some data part was lost. Print error in log instead of terminating. #24777 (Alexander Tokmakov).
• Backported in #24850: Fix bug when exception Mutation was killed can be thrown to the client on mutation wait when mutation not loaded into memory yet. #24809 (alesapin).
• Backported in #24917: Fix extremely rare bug on low-memory servers which can lead to the inability to perform merges without restart. Possibly fixes #24603. #24872 (alesapin).
• Backported in #25185: Fixed bug with declaring S3 disk at root of bucket. Earlier, it reported an error: ``` [heather] 2021.05.10 02:11:11.932234 [ 72790 ] {2ff80b7b-ec53-41cb-ac35-19bb390e1759} executeQuery: Code: 36, e.displayText() = DB::Exception: Key name is empty in path style S3 URI: (http://172.17.0.2/bucket/) (version 21.6.1.1) (from 127.0.0.1:47994) (in query: SELECT policy_name FROM system.storage_policies), Stack trace (when copying this message, always include the lines below):. #24898 (Vladimir Chebotarev).
• Backported in #24949: Fix possible heap-buffer-overflow in Arrow. #24922 (Kruglov Pavel).
• Backported in #25562: Fix extremely rare error Tagging already tagged part in replication queue during concurrent alter move/replace partition. Possibly fixes #22142. #24961 (alesapin).
• Backported in #25367: Fix serialization of splitted nested messages in Protobuf format. This PR fixes #24647. #25000 (Vitaly Baranov).
• Backported in #25561: Fix bug which allows creating tables with columns referencing themselves like a UInt32 ALIAS a + 1 or b UInt32 MATERIALIZED b. Fixes #24910, #24292. #25059 (alesapin).
• Backported in #25105: Fix bug with constant maps in mapContains that lead to error empty column was returned by function mapContains. Closes #25077. #25080 (Kruglov Pavel).
• Backported in #25142: Fix crash in query with cross join and joined_subquery_requires_alias = 0. Fixes #24011. #25082 (Nikolai Kochetov).
• Backported in #25351: Fix TOCTOU error in installation script. #25277 (Alexey Milovidov).
• Backported in #25473: Fix joinGetOrNull with not-nullable columns. This fixes #24261. #25288 (Amos Bird).
• Backported in #25361: Fix error Bad cast from type DB::ColumnLowCardinality to DB::ColumnVector<char8_t> for queries where LowCardinality argument was used for IN (this bug appeared in 21.6). Fixes #25187. #25290 (Nikolai Kochetov).
• Backported in #25355: Fix Logical Error Cannot sum Array/Tuple in min/maxMap. #25298 (Kruglov Pavel).
• Backported in #25437: Support SimpleAggregateFunction(LowCardinality) for SummingMergeTree. Fixes #25134. #25300 (Nikolai Kochetov).
• Backported in #25364: On ZooKeeper connection loss ReplicatedMergeTree table might wait for background operations to complete before trying to reconnect. It's fixed, now background operations are stopped forcefully. #25306 (Alexander Tokmakov).
• Backported in #25387: Fix the possibility of non-deterministic behaviour of the quantileDeterministic function and similar. This closes #20480. #25313 (Alexey Milovidov).
• Backported in #25455: Fix lost WHERE condition in expression-push-down optimization of query plan (setting query_plan_filter_push_down = 1 by default). Fixes #25368. #25370 (Nikolai Kochetov).
• Backported in #25406: Fix REPLACE column transformer when used in DDL by correctly quoting the formatted query. This fixes #23925. #25391 (Amos Bird).
• Backported in #25505: Fix segfault when sharding_key is absent in task config for copier. #25419 (Nikita Mikhaylov).

NO CL ENTRY

• NO CL ENTRY: 'Revert "Backport #24721 to 21.3: Remove endless wait from ZooKeeper client"'. #24799 (alesapin).

NOT FOR CHANGELOG / INSIGNIFICANT

• Try fix test_consistent_parts_after_clone_replica #24968 (Alexander Tokmakov).
• DictionaryLoader unnecessary dictionary configuration creation fix #25001 (Maksim Kita).