« Changelog History


ClickHouse v20.4.6.53 Release Notes

Release Date: 2020-06-25 // almost 4 years ago

  • 🐛 Bug Fix

    • 🛠 Fix rare crash caused by using Nullable column in prewhere condition. Continuation of #11608. #11869 (Nikolai Kochetov).
    • 🔀 Don't allow arrayJoin inside higher order functions. It was leading to broken protocol synchronization. This closes #3933. #11846 (alexey-milovidov).
    • 🛠 Fix wrong result of comparison of FixedString with constant String. This fixes #11393. This bug appeared in version 20.4. #11828 (alexey-milovidov).
    • 🛠 Fix wrong result for if() with NULLs in condition. #11807 (Artem Zuikov).
    • 🛠 Fix using too many threads for queries. #11788 (Nikolai Kochetov).
    • Fix unexpected behaviour of queries like SELECT *, xyz.* which were success while an error expected. #11753 (hexiaoting).
    • 📇 Now replicated fetches will be cancelled during metadata alter. #11744 (alesapin).
    • 🛠 Fixed LOGICAL_ERROR caused by wrong type deduction of complex literals in Values input format. #11732 (tavplubix).
    • 🛠 Fix ORDER BY ... WITH FILL over const columns. #11697 (Anton Popov).
    • Pass proper timeouts when communicating with XDBC bridge. Recently timeouts were not respected when checking bridge liveness and receiving meta info. #11690 (alexey-milovidov).
    • 🛠 Fix LIMIT n WITH TIES usage together with ORDER BY statement, which contains aliases. #11689 (Anton Popov).
    • 🛠 Fix error which leads to an incorrect state of system.mutations. It may show that whole mutation is already done but the server still has MUTATE_PART tasks in the replication queue and tries to execute them. This fixes #11611. #11681 (alesapin).
    • ➕ Add support for regular expressions with case-insensitive flags. This fixes #11101 and fixes #11506. #11649 (alexey-milovidov).
    • ✂ Remove trivial count query optimization if row-level security is set. In previous versions the user get total count of records in a table instead filtered. This fixes #11352. #11644 (alexey-milovidov).
    • 🛠 Fix bloom filters for String (data skipping indices). #11638 (Azat Khuzhin).
    • 🛠 Fix rare crash caused by using Nullable column in prewhere condition. (Probably it is connected with #11572 somehow). #11608 (Nikolai Kochetov).
    • 🛠 Fix error Block structure mismatch for queries with sampling reading from Buffer table. #11602 (Nikolai Kochetov).
    • 🛠 Fix wrong exit code of the clickhouse-client, when exception.code() % 256 = 0. #11601 (filimonov).
    • 🛠 Fix trivial error in log message about "Mark cache size was lowered" at server startup. This closes #11399. #11589 (alexey-milovidov).
    • 🛠 Fix error Size of offsets doesn't match size of column for queries with PREWHERE column in (subquery) and ARRAY JOIN. #11580 (Nikolai Kochetov).
    • 🛠 Fixed rare segfault in SHOW CREATE TABLE Fixes #11490. #11579 (tavplubix).
    • 🛠 All queries in HTTP session have had the same query_id. It is fixed. #11578 (tavplubix).
    • 🐳 Now clickhouse-server docker container will prefer IPv6 checking server aliveness. #11550 (Ivan Starkov).
    • Fix shard_num/replica_num for <node> (breaks use_compact_format_in_distributed_parts_names). #11528 (Azat Khuzhin).
    • 🛠 Fix race condition which may lead to an exception during table drop. It's a bit tricky and not dangerous at all. If you want an explanation, just notice me in telegram. #11523 (alesapin).
    • 🛠 Fix memory leak when exception is thrown in the middle of aggregation with -State functions. This fixes #8995. #11496 (alexey-milovidov).
    • 🔀 If data skipping index is dependent on columns that are going to be modified during background merge (for SummingMergeTree, AggregatingMergeTree as well as for TTL GROUP BY), it was calculated incorrectly. This issue is fixed by moving index calculation after merge so the index is calculated on merged data. #11162 (Azat Khuzhin).
    • 🐎 Get rid of old libunwind patches. https://github.com/ClickHouse-Extras/libunwind/commit/500aa227911bd185a94bfc071d68f4d3b03cb3b1#r39048012 This allows to disable -fno-omit-frame-pointer in clang builds that improves performance at least by 1% in average. #10761 (Amos Bird).
    • 🛠 Fix usage of primary key wrapped into a function with 'FINAL' modifier and 'ORDER BY' optimization. #10715 (Anton Popov).

    🏗 Build/Testing/Packaging Improvement