« Changelog History


ClickHouse v20.4.5.36 Release Notes

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

  • 🐛 Bug Fix

    • Fix the error Data compressed with different methods that can happen if min_bytes_to_use_direct_io is enabled and PREWHERE is active and using SAMPLE or high number of threads. This fixes #11539. #11540 (alexey-milovidov).
    • 🛠 Fix return compressed size for codecs. #11448 (Nikolai Kochetov).
    • 🛠 Fix server crash when a column has compression codec with non-literal arguments. Fixes #11365. #11431 (alesapin).
    • 🛠 Fix pointInPolygon with nan as point. Fixes https://github.com/ClickHouse/ClickHouse/issues/11375. #11421 (Alexey Ilyukhov).
    • 🛠 Fix potential uninitialized memory read in MergeTree shutdown if table was not created successfully. #11420 (alexey-milovidov).
    • 🛠 Fixed geohashesInBox with arguments outside of latitude/longitude range. #11403 (Vasily Nemkov).
    • 🛠 Fix possible Pipeline stuck error for queries with external sort and limit. Fixes #11359. #11366 (Nikolai Kochetov).
    • ✂ Remove redundant lock during parts send in ReplicatedMergeTree. #11354 (alesapin).
    • 🛠 Fix support for \G (vertical output) in clickhouse-client in multiline mode. This closes #9933. #11350 (alexey-milovidov).
    • 🛠 Fix potential segfault when using Lazy database. #11348 (alexey-milovidov).
    • 🛠 Fix crash in quantilesExactWeightedArray. #11337 (Nikolai Kochetov).
    • 📇 Now merges stopped before change metadata in ALTER queries. #11335 (alesapin).
    • Make writing to MATERIALIZED VIEW with setting parallel_view_processing = 1 parallel again. Fixes #10241. #11330 (Nikolai Kochetov).
    • 🛠 Fix visitParamExtractRaw when extracted JSON has strings with unbalanced { or [. #11318 (Ewout).
    • 🛠 Fix very rare race condition in ThreadPool. #11314 (alexey-milovidov).
    • 🛠 Fix insignificant data race in clickhouse-copier. Found by integration tests. #11313 (alexey-milovidov).
    • 🛠 Fix potential uninitialized memory in conversion. Example: SELECT toIntervalSecond(now64()). #11311 (alexey-milovidov).
    • 🛠 Fix the issue when index analysis cannot work if a table has Array column in primary key and if a query is filtering by this column with empty or notEmpty functions. This fixes #11286. #11303 (alexey-milovidov).
    • Fix bug when query speed estimation can be incorrect and the limit of min_execution_speed may not work or work incorrectly if the query is throttled by max_network_bandwidth, max_execution_speed or priority settings. Change the default value of timeout_before_checking_execution_speed to non-zero, because otherwise the settings min_execution_speed and max_execution_speed have no effect. This fixes #11297. This fixes #5732. This fixes #6228. Usability improvement: avoid concatenation of exception message with progress bar in clickhouse-client. #11296 (alexey-milovidov).
    • 🛠 Fix crash when SET DEFAULT ROLE is called with wrong arguments. This fixes https://github.com/ClickHouse/ClickHouse/issues/10586. #11278 (Vitaly Baranov).
    • 🛠 Fix crash while reading malformed data in Protobuf format. This fixes https://github.com/ClickHouse/ClickHouse/issues/5957, fixes https://github.com/ClickHouse/ClickHouse/issues/11203. #11258 (Vitaly Baranov).
    • 🛠 Fixed a bug when cache-dictionary could return default value instead of normal (when there are only expired keys). This affects only string fields. #11233 (Nikita Mikhaylov).
    • 🛠 Fix error Block structure mismatch in QueryPipeline while reading from VIEW with constants in inner query. Fixes #11181. #11205 (Nikolai Kochetov).
    • 🛠 Fix possible exception Invalid status for associated output. #11200 (Nikolai Kochetov).
    • 🛠 Fix possible error Cannot capture column for higher-order functions with Array(Array(LowCardinality)) captured argument. #11185 (Nikolai Kochetov).
    • 🛠 Fixed S3 globbing which could fail in case of more than 1000 keys and some backends. #11179 (Vladimir Chebotarev).
    • 🔀 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).
    • 🛠 Fix Kafka performance issue related to reschedules based on limits, which were always applied. #11149 (filimonov).
    • 🛠 Fix for the hang which was happening sometimes during DROP of table engine=Kafka (or during server restarts). #11145 (filimonov).
    • 🛠 Fix excessive reserving of threads for simple queries (optimization for reducing the number of threads, which was partly broken after changes in pipeline). #11114 (Azat Khuzhin).
    • ⚡️ Fix predicates optimization for distributed queries (enable_optimize_predicate_expression=1) for queries with HAVING section (i.e. when filtering on the server initiator is required), by preserving the order of expressions (and this is enough to fix), and also force aggregator use column names over indexes. Fixes: #10613, #11413. #10621 (Azat Khuzhin).

    🏗 Build/Testing/Packaging Improvement