« Changelog History


ClickHouse v20.3.5.21 Release Notes

Release Date: 2020-03-27 // about 4 years ago

  • 🐛 Bug Fix

    • Fix 'Different expressions with the same alias' error when query has PREWHERE and WHERE on distributed table and SET distributed_product_mode = 'local'. #9871 (Artem Zuikov).
    • 🛠 Fix mutations excessive memory consumption for tables with a composite primary key. This fixes #9850. #9860 (alesapin).
    • 👻 For INSERT queries shard now clamps the settings got from the initiator to the shard's constaints instead of throwing an exception. This fix allows to send INSERT queries to a shard with another constraints. This change improves fix #9447. #9852 (Vitaly Baranov).
    • 🛠 Fix 'COMMA to CROSS JOIN rewriter is not enabled or cannot rewrite query' error in case of subqueries with COMMA JOIN out of tables lists (i.e. in WHERE). Fixes #9782. #9830 (Artem Zuikov).
    • 🛠 Fix possible exception Got 0 in totals chunk, expected 1 on client. It happened for queries with JOIN in case if right joined table had zero rows. Example: select * from system.one t1 join system.one t2 on t1.dummy = t2.dummy limit 0 FORMAT TabSeparated;. Fixes #9777. #9823 (Nikolai Kochetov).
    • Fix SIGSEGV with optimize_skip_unused_shards when type cannot be converted. #9804 (Azat Khuzhin).
    • 🛠 Fix broken ALTER TABLE DELETE COLUMN query for compact parts. #9779 (alesapin).
    • Fix max_distributed_connections (w/ and w/o Processors). #9673 (Azat Khuzhin).
    • 🛠 Fixed a few cases when timezone of the function argument wasn't used properly. #9574 (Vasily Nemkov).

    👌 Improvement

    • ✂ Remove order by stage from mutations because we read from a single ordered part in a single thread. Also add check that the order of rows in mutation is ordered in sorting key order and this order is not violated. #9886 (alesapin).