ClickHouse v20.5.1.3833 Release Notes

Release Date: 2020-06-22 // about 1 month ago

Previous changes from v20.4.3.16

  • 🐛 Bug Fix

    • ✂ Removed logging from mutation finalization task if nothing was finalized. #11109 (alesapin).
    • 🛠 Fixed memory leak in registerDiskS3. #11074 (Pavel Kovalenko).
    • 🛠 Fixed the potential missed data during termination of Kafka engine table. #11048 (filimonov).
    • 🛠 Fixed parseDateTime64BestEffort argument resolution bugs. #11038 (Vasily Nemkov).
    • 🛠 Fixed very rare potential use-after-free error in MergeTree if table was not created successfully. #10986, #10970 (alexey-milovidov).
    • 🛠 Fixed metadata (relative path for rename) and data (relative path for symlink) handling for Atomic database. #10980 (Azat Khuzhin).
    • 🛠 Fixed server crash on concurrent ALTER and DROP DATABASE queries with Atomic database engine. #10968 (tavplubix).
    • 🛠 Fixed incorrect raw data size in getRawData() method. #10964 (Igr).
    • 🛠 Fixed incompatibility of two-level aggregation between versions 20.1 and earlier. This incompatibility happens when different versions of ClickHouse are used on initiator node and remote nodes and the size of GROUP BY result is large and aggregation is performed by a single String field. It leads to several unmerged rows for a single key in result. #10952 (alexey-milovidov).
    • 🛠 Fixed sending partially written files by the DistributedBlockOutputStream. #10940 (Azat Khuzhin).
    • 🛠 Fixed crash in SELECT count(notNullIn(NULL, [])). #10920 (Nikolai Kochetov).
    • 🛠 Fixed the hang which was happening sometimes during DROP of Kafka table engine. (or during server restarts). #10910 (filimonov).
    • 🛠 Fixed the impossibility of executing multiple ALTER RENAME like a TO b, c TO a. #10895 (alesapin).
    • 🛠 Fixed possible race which could happen when you get result from aggregate function state from multiple thread for the same column. The only way it can happen is when you use finalizeAggregation function while reading from table with Memory engine which stores AggregateFunction state for quantile* function. #10890 (Nikolai Kochetov).
    • 🛠 Fixed backward compatibility with tuples in Distributed tables. #10889 (Anton Popov).
    • 🛠 Fixed SIGSEGV in StringHashTable if such a key does not exist. #10870 (Azat Khuzhin).
    • 🛠 Fixed WATCH hangs after LiveView table was dropped from database with Atomic engine. #10859 (tavplubix).
    • 🛠 Fixed bug in ReplicatedMergeTree which might cause some ALTER on OPTIMIZE query to hang waiting for some replica after it become inactive. #10849 (tavplubix).
    • ⚡️ Now constraints are updated if the column participating in CONSTRAINT expression was renamed. Fixes #10844. #10847 (alesapin).
    • 🛠 Fixed potential read of uninitialized memory in cache-dictionary. #10834 (alexey-milovidov).
    • 🛠 Fixed columns order after Block::sortColumns(). #10826 (Azat Khuzhin).
    • 🛠 Fixed the issue with ODBC bridge when no quoting of identifiers is requested. Fixes #7984. #10821 (alexey-milovidov).
    • 🛠 Fixed UBSan and MSan report in DateLUT. #10798 (alexey-milovidov).
    • 🛠 Fixed incorrect type conversion in key conditions. Fixes #6287. #10791 (Andrew Onyshchuk).
    • Fixed parallel_view_processing behavior. Now all insertions into MATERIALIZED VIEW without exception should be finished if exception happened. Fixes #10241. #10757 (Nikolai Kochetov).
    • 🛠 Fixed combinator -OrNull and -OrDefault when combined with -State. #10741 (hcz).
    • 🛠 Fixed possible buffer overflow in function h3EdgeAngle. #10711 (alexey-milovidov).
    • 🛠 Fixed bug which locks concurrent alters when table has a lot of parts. #10659 (alesapin).
    • 🛠 Fixed nullptr dereference in StorageBuffer if server was shutdown before table startup. #10641 (alexey-milovidov).
    • Fixed optimize_skip_unused_shards with LowCardinality. #10611 (Azat Khuzhin).
    • 🛠 Fixed handling condition variable for synchronous mutations. In some cases signals to that condition variable could be lost. #10588 (Vladimir Chebotarev).
    • 🛠 Fixed possible crash when createDictionary() is called before loadStoredObject() has finished. #10587 (Vitaly Baranov).
    • 🛠 Fixed SELECT of column ALIAS which default expression type different from column type. #10563 (Azat Khuzhin).
    • Implemented comparison between DateTime64 and String values. #10560 (Vasily Nemkov).
    • ⚡️ Disable GROUP BY sharding_key optimization by default (optimize_distributed_group_by_sharding_key had been introduced and turned of by default, due to trickery of sharding_key analyzing, simple example is if in sharding key) and fix it for WITH ROLLUP/CUBE/TOTALS. #10516 (Azat Khuzhin).
    • 🛠 Fixed #10263. #10486 (Azat Khuzhin).
    • Added tests about max_rows_to_sort setting. #10268 (alexey-milovidov).
    • ➕ Added backward compatibility for create bloom filter index. #10551. #10569 (Winter Zhang).