« Changelog History


ClickHouse v20.3.6.40 Release Notes

Release Date: 2020-04-16 // about 4 years ago

  • 🆕 New Feature

    • ➕ Added function isConstant. This function checks whether its argument is constant expression and returns 1 or 0. It is intended for development, debugging and demonstration purposes. #10198 (alexey-milovidov).

    🐛 Bug Fix

    • Fix error Pipeline stuck with max_rows_to_group_by and group_by_overflow_mode = 'break'. #10279 (Nikolai Kochetov).
    • 🛠 Fix rare possible exception Cannot drain connections: cancel first. #10239 (Nikolai Kochetov).
    • 🛠 Fixed bug where ClickHouse would throw "Unknown function lambda." error message when user tries to run ALTER UPDATE/DELETE on tables with ENGINE = Replicated*. Check for nondeterministic functions now handles lambda expressions correctly. #10237 (Alexander Kazakov).
    • 🛠 Fixed "generateRandom" function for Date type. This fixes #9973. Fix an edge case when dates with year 2106 are inserted to MergeTree tables with old-style partitioning but partitions are named with year 1970. #10218 (alexey-milovidov).
    • 🛠 Convert types if the table definition of a View does not correspond to the SELECT query. This fixes #10180 and #10022. #10217 (alexey-milovidov).
    • 🛠 Fix parseDateTimeBestEffort for strings in RFC-2822 when day of week is Tuesday or Thursday. This fixes #10082. #10214 (alexey-milovidov).
    • 🛠 Fix column names of constants inside JOIN that may clash with names of constants outside of JOIN. #10207 (alexey-milovidov).
    • 🛠 Fix possible inifinite query execution when the query actually should stop on LIMIT, while reading from infinite source like system.numbers or system.zeros. #10206 (Nikolai Kochetov).
    • 🛠 Fix using the current database for access checking when the database isn't specified. #10192 (Vitaly Baranov).
    • Convert blocks if structure does not match on INSERT into Distributed(). #10135 (Azat Khuzhin).
    • 🛠 Fix possible incorrect result for extremes in processors pipeline. #10131 (Nikolai Kochetov).
    • 🛠 Fix some kinds of alters with compact parts. #10130 (Anton Popov).
    • Fix incorrect index_granularity_bytes check while creating new replica. Fixes #10098. #10121 (alesapin).
    • 🛠 Fix SIGSEGV on INSERT into Distributed table when its structure differs from the underlying tables. #10105 (Azat Khuzhin).
    • 🛠 Fix possible rows loss for queries with JOIN and UNION ALL. Fixes #9826, #10113. #10099 (Nikolai Kochetov).
    • 🛠 Fixed replicated tables startup when updating from an old ClickHouse version where /table/replicas/replica_name/metadata node doesn't exist. Fixes #10037. #10095 (alesapin).
    • ➕ Add some arguments check and support identifier arguments for MySQL Database Engine. #10077 (Winter Zhang).
    • 🛠 Fix bug in clickhouse dictionary source from localhost clickhouse server. The bug may lead to memory corruption if types in dictionary and source are not compatible. #10071 (alesapin).
    • 🛠 Fix bug in CHECK TABLE query when table contain skip indices. #10068 (alesapin).
    • Fix error Cannot clone block with columns because block has 0 columns ... While executing GroupingAggregatedTransform. It happened when setting distributed_aggregation_memory_efficient was enabled, and distributed query read aggregating data with different level from different shards (mixed single and two level aggregation). #10063 (Nikolai Kochetov).
    • 🛠 Fix a segmentation fault that could occur in GROUP BY over string keys containing trailing zero bytes (#8636, #8925). #10025 (Alexander Kuzmenkov).
    • 🛠 Fix parallel distributed INSERT SELECT for remote table. This PR fixes the solution provided in #9759. #9999 (Vitaly Baranov).
    • 🛠 Fix the number of threads used for remote query execution (performance regression, since 20.3). This happened when query from Distributed table was executed simultaneously on local and remote shards. Fixes #9965. #9971 (Nikolai Kochetov).
    • 🛠 Fix bug in which the necessary tables weren't retrieved at one of the processing stages of queries to some databases. Fixes #9699. #9949 (achulkov2).
    • 🛠 Fix 'Not found column in block' error when JOIN appears with TOTALS. Fixes #9839. #9939 (Artem Zuikov).
    • 🛠 Fix a bug with ON CLUSTER DDL queries freezing on server startup. #9927 (Gagan Arneja).
    • Fix parsing multiple hosts set in the CREATE USER command, e.g. CREATE USER user6 HOST NAME REGEXP 'lo.?*host', NAME REGEXP 'lo*host'. #9924 (Vitaly Baranov).
    • 🛠 Fix TRUNCATE for Join table engine (#9917). #9920 (Amos Bird).
    • 🛠 Fix "scalar doesn't exist" error in ALTERs (#9878). #9904 (Amos Bird).
    • 🛠 Fix race condition between drop and optimize in ReplicatedMergeTree. #9901 (alesapin).
    • Fix error with qualified names in distributed_product_mode='local'. Fixes #4756. #9891 (Artem Zuikov).
    • Fix calculating grants for introspection functions from the setting 'allow_introspection_functions'. #9840 (Vitaly Baranov).

    🏗 Build/Testing/Packaging Improvement