ClickHouse/docs/changelogs/v21.8.2.19-prestable.md

sidebar_position	sidebar_label
1	2022

2022 Changelog

ClickHouse release v21.8.2.19-prestable FIXME as compared to v21.8.1.7409-prestable

Performance Improvement

• Backported in #26524: Improve latency of short queries, that require reading from tables with large number of columns. #26371 (Anton Popov).

Bug Fix

• Backported in #26283: Fix optimize_skip_unused_shards_rewrite_in for non-UInt64 types (may select incorrect shards eventually or throw Cannot infer type of an empty tuple or Function tuple requires at least one argument). #25798 (Azat Khuzhin).
• Backported in #26587: Fixed Not found column ... and Missing column ... errors when selecting from MaterializeMySQL. Fixes #23708, #24830, #25794. #25822 (Alexander Tokmakov).
• Backported in #26190: Fix sharding_key from column w/o function for remote() (before select * from remote('127.1', system.one, dummy) leads to Unknown column: dummy, there are only columns . error). #25824 (Azat Khuzhin).
• Backported in #26284: Fix possible mismatched header when using normal projection with prewhere. This fixes #26020. #26038 (Amos Bird).
• Backported in #26298: Fixed incorrect sequence_id in MySQL protocol packets that ClickHouse sends on exception during query execution. It might cause MySQL client to reset connection to ClickHouse server. Fixes #21184. #26051 (Alexander Tokmakov).
• Backported in #26204: Fix potential crash if more than one untuple expression is used. #26179 (Alexey Milovidov).
• Backported in #26228: Remove excessive newline in thread_name column in system.stack_trace table. This fixes #24124. #26210 (Alexey Milovidov).
• Backported in #26358: Fix logical error on join with totals, close #26017. #26250 (Vladimir C).
• Backported in #26788: Fix zstd decompression in case there are escape sequences at the end of internal buffer. Closes #26013. #26314 (Kseniia Sumarokova).
• Backported in #26360: Fixed rare bug in lost replica recovery that may cause replicas to diverge. #26321 (Alexander Tokmakov).
• Backported in #26452: Fix optimize_distributed_group_by_sharding_key for multiple columns (leads to incorrect result w/ optimize_skip_unused_shards=1/allow_nondeterministic_optimize_skip_unused_shards=1 and multiple columns in sharding key expression). #26353 (Azat Khuzhin).
• Backported in #26422: Fix possible crash when login as dropped user. This PR fixes #26073. #26363 (Vitaly Baranov).
• Backported in #26417: Fix infinite non joined block stream in partial_merge_join close #26325. #26374 (Vladimir C).
• Backported in #26448: Fix some fuzzed msan crash. Fixes #22517. #26428 (Nikolai Kochetov).
• Backported in #26488: Fix broken name resolution after rewriting column aliases. This fixes #26432. #26475 (Amos Bird).
• Backported in #26613: Fix issues with CREATE DICTIONARY query if dictionary name or database name was quoted. Closes #26491. #26508 (Maksim Kita).
• Backported in #26605: Fix crash in rabbitmq shutdown in case rabbitmq setup was not started. Closes #26504. #26529 (Kseniia Sumarokova).
• Backported in #26608: Update chown cmd check in clickhouse-server docker entrypoint. It fixes the bug that cluster pod restart failed (or timeout) on kubernetes. #26545 (Ky Li).
• Backported in #26648: Fix incorrect function names of groupBitmapAnd/Or/Xor. This fixes. #26557 (Amos Bird).
• Backported in #26644: Fix history file conversion if file is empty. #26589 (Azat Khuzhin).
• Backported in #26705: Fix potential nullptr dereference in window functions. This fixes #25276. #26668 (Alexander Kuzmenkov).
• Backported in #26771: Sometimes SET ROLE could work incorrectly, this PR fixes that. #26707 (Vitaly Baranov).

NOT FOR CHANGELOG / INSIGNIFICANT

• Remove misleading stderr output #26155 (Kseniia Sumarokova).
• Less logging in AsynchronousMetrics #26391 (Alexey Milovidov).
• Remove MySQLWireContext #26429 (Vitaly Baranov).
• Update link to dpkg-deb in dockerfiles #26497 (Vladimir C).