ClickHouse v20.9.4.76 Release Notes
Release Date: 2020-10-29 // over 3 years ago-
๐ Bug Fix
- ๐ Fix double free in case of exception in function
dictGet
. It could have happened if dictionary was loaded with error. #16429 (Nikolai Kochetov). - ๐ Fix group by with totals/rollup/cube modifers and min/max functions over group by keys. Fixes #16393. #16397 (Anton Popov).
- Fix async Distributed INSERT w/ prefer_localhost_replica=0 and internal_replication. #16358 (Azat Khuzhin).
- ๐ Fix a very wrong code in TwoLevelStringHashTable implementation, which might lead to memory leak. I'm suprised how this bug can lurk for so long.... #16264 (Amos Bird).
- ๐ Fix the case when memory can be overallocated regardless to the limit. This closes #14560. #16206 (alexey-milovidov).
- ๐ Fix
ALTER MODIFY ... ORDER BY
query hang forReplicatedVersionedCollapsingMergeTree
. This fixes #15980. #16011 (alesapin). - ๐ Fix collate name & charset name parser and support
length = 0
for string type. #16008 (Winter Zhang). - ๐ Allow to use direct layout for dictionaries with complex keys. #16007 (Anton Popov).
- Prevent replica hang for 5-10 mins when replication error happens after a period of inactivity. #15987 (filimonov).
- ๐ Fix rare segfaults when inserting into or selecting from MaterializedView and concurrently dropping target table (for Atomic database engine). #15984 (tavplubix).
- ๐ Fix ambiguity in parsing of settings profiles:
CREATE USER ... SETTINGS profile readonly
is now considered as using a profile namedreadonly
, not a setting namedprofile
with the readonly constraint. This fixes https://github.com/ClickHouse/ClickHouse/issues/15628. #15982 (Vitaly Baranov). - ๐ Fix a crash when database creation fails. #15954 (Winter Zhang).
- ๐ Fixed
DROP TABLE IF EXISTS
failure withTable ... doesn't exist
error when table is concurrently renamed (for Atomic database engine). Fixed rare deadlock when concurrently executing some DDL queries with multiple tables (likeDROP DATABASE
andRENAME TABLE
) FixedDROP/DETACH DATABASE
failure withTable ... doesn't exist
when concurrently executingDROP/DETACH TABLE
. #15934 (tavplubix). - ๐ Fix incorrect empty result for query from
Distributed
table if query hasWHERE
,PREWHERE
andGLOBAL IN
. Fixes #15792. #15933 (Nikolai Kochetov). - ๐ Fix possible deadlocks in RBAC. #15875 (Vitaly Baranov).
- ๐ Fix exception
Block structure mismatch
inSELECT ... ORDER BY DESC
queries which were executed afterALTER MODIFY COLUMN
query. Fixes #15800. #15852 (alesapin). - ๐ Fix
select count()
inaccuracy for MaterializeMySQL. #15767 (tavplubix). - ๐ Fix some cases of queries, in which only virtual columns are selected. Previously
Not found column _nothing in block
exception may be thrown. Fixes #12298. #15756 (Anton Popov). - Fixed too low default value of
max_replicated_logs_to_keep
setting, which might cause replicas to become lost too often. Improve lost replica recovery process by choosing the most up-to-date replica to clone. Also do not remove old parts from lost replica, detach them instead. #15701 (tavplubix). - ๐ Fix error
Cannot add simple transform to empty Pipe
which happened while reading fromBuffer
table which has different structure than destination table. It was possible if destination table returned empty result for query. Fixes #15529. #15662 (Nikolai Kochetov). - ๐ Fixed bug with globs in S3 table function, region from URL was not applied to S3 client configuration. #15646 (Vladimir Chebotarev).
- ๐ Decrement the
ReadonlyReplica
metric when detaching read-only tables. This fixes https://github.com/ClickHouse/ClickHouse/issues/15598. #15592 (sundyli). - Throw an error when a single parameter is passed to ReplicatedMergeTree instead of ignoring it. #15516 (nvartolomei).
๐ Improvement
- ๐ Fix double free in case of exception in function