All Versions
Latest Version
Avg Release Cycle
30 days
Latest Release
1 day ago

Changelog History
Page 4

  • v20.5.1.3716

    June 12, 2020
  • v20.5.1.3657

    June 07, 2020
  • v20.5.1.3654

    June 06, 2020
  • v20.5.1.3629

    June 04, 2020
  • v20.5.1.3496

    May 24, 2020
  • v20.5.1.3364

    May 14, 2020
  • v20.5.1.3327

    May 12, 2020
  • v20.4.8.99 Changes

    August 10, 2020

    ๐Ÿ› Bug Fix

    • ๐Ÿ›  Fixed error in parseDateTimeBestEffort function when unix timestamp was passed as an argument. This fixes #13362. #13441 (alexey-milovidov).
    • ๐Ÿ›  Fixed potentially low performance and slightly incorrect result for uniqExact, topK, sumDistinct and similar aggregate functions called on Float types with NaN values. It also triggered assert in debug build. This fixes #12491. #13254 (alexey-milovidov).
    • ๐Ÿ›  Fixed function if with nullable constexpr as cond that is not literal NULL. Fixes #12463. #13226 (alexey-milovidov).
    • ๐Ÿ›  Fixed assert in arrayElement function in case of array elements are Nullable and array subscript is also Nullable. This fixes #12172. #13224 (alexey-milovidov).
    • ๐Ÿ›  Fixed wrong index analysis with functions. It could lead to pruning wrong parts, while reading from MergeTree tables. Fixes #13060. Fixes #12406. #13081 (Anton Popov).
    • ๐Ÿ›  Fixed unnecessary limiting for the number of threads for selects from local replica. #12840 (Nikolai Kochetov).
    • ๐Ÿ›  Fixed possible extra overflow row in data which could appear for queries WITH TOTALS. #12747 (Nikolai Kochetov).
    • ๐Ÿ›  Fixed performance with large tuples, which are interpreted as functions in IN section. The case when user write WHERE x IN tuple(1, 2, ...) instead of WHERE x IN (1, 2, ...) for some obscure reason. #12700 (Anton Popov).
    • Fixed memory tracking for input_format_parallel_parsing (by attaching thread to group). #12672 (Azat Khuzhin).
    • ๐Ÿ›  Fixed #12293 allow push predicate when subquery contains with clause. #12663 (Winter Zhang).
    • ๐Ÿ›  Fixed #10572 fix bloom filter index with const expression. #12659 (Winter Zhang).
    • ๐Ÿ›  Fixed SIGSEGV in StorageKafka when broker is unavailable (and not only). #12658 (Azat Khuzhin).
    • โž• Added support for function if with Array(UUID) arguments. This fixes #11066. #12648 (alexey-milovidov).
    • ๐Ÿ›  Fixed race condition in external dictionaries with cache layout which can lead server crash. #12566 (alesapin).
    • โœ‚ Removed data for Distributed tables (blocks from async INSERTs) on DROP TABLE. #12556 (Azat Khuzhin).
    • Fixed bug which lead to broken old parts after ALTER DELETE query when enable_mixed_granularity_parts=1. Fixes #12536. #12543 (alesapin).
    • ๐Ÿ‘ Better exception for function in with invalid number of arguments. #12529 (Anton Popov).
    • ๐Ÿ›  Fixed performance issue, while reading from compact parts. #12492 (Anton Popov).
    • ๐Ÿ›  Fixed crash in JOIN with dictionary when we are joining over expression of dictionary key: t JOIN dict ON expr( = Disable dictionary join optimisation for this case. #12458 (Artem Zuikov).
    • ๐Ÿ›  Fixed possible segfault if StorageMerge. Closes #12054. #12401 (tavplubix).
    • ๐Ÿ›  Fixed order of columns in WITH FILL modifier. Previously order of columns of ORDER BY statement wasn't respected. #12306 (Anton Popov).
    • ๐Ÿ”€ Avoid "bad cast" exception when there is an expression that filters data by virtual columns (like _table in Merge tables) or by "index" columns in system tables such as filtering by database name when querying from system.tables, and this expression returns Nullable type. This fixes #12166. #12305 (alexey-milovidov).
    • ๐Ÿ‘‰ Show error after TrieDictionary failed to load. #12290 (Vitaly Baranov).
    • ๐Ÿ›  The function arrayFill worked incorrectly for empty arrays that may lead to crash. This fixes #12263. #12279 (alexey-milovidov).
    • ๐Ÿ›  Implemented conversions to the common type for LowCardinality types. This allows to execute UNION ALL of tables with columns of LowCardinality and other columns. This fixes #8212. This fixes #4342. #12275 (alexey-milovidov).
    • ๐Ÿ›  Fixed the behaviour when during multiple sequential inserts in StorageFile header for some special types was written more than once. This fixed #6155. #12197 (Nikita Mikhaylov).
    • ๐Ÿ›  Fixed logical functions for UInt8 values when they are not equal to 0 or 1. #12196 (Alexander Kazakov).
    • Cap max_memory_usage* limits to the process resident memory. #12182 (Azat Khuzhin).
    • ๐Ÿ›  Fixed dictGet arguments check during GROUP BY injective functions elimination. #12179 (Azat Khuzhin).
    • ๐Ÿ‘ Don't split the dictionary source's table name into schema and table name itself if ODBC connection doesn't support schema. #12165 (Vitaly Baranov).
    • ๐Ÿ›  Fixed wrong logic in ALTER DELETE that leads to deleting of records when condition evaluates to NULL. This fixes #9088. This closes #12106. #12153 (alexey-milovidov).
    • ๐Ÿ›  Fixed transform of query to send to external DBMS (e.g. MySQL, ODBC) in presense of aliases. This fixes #12032. #12151 (alexey-milovidov).
    • ๐Ÿ›  Fixed potential overflow in integer division. This fixes #12119. #12140 (alexey-milovidov).
    • ๐Ÿ›  Fixed potential infinite loop in greatCircleDistance, geoDistance. This fixes #12117. #12137 (alexey-milovidov).
    • ๐Ÿšš Normalize "pid" file handling. In previous versions the server may refuse to start if it was killed without proper shutdown and if there is another process that has the same pid as previously runned server. Also pid file may be removed in unsuccessful server startup even if there is another server running. This fixes #3501. #12133 (alexey-milovidov).
    • ๐Ÿ›  Fixed handling dependency of table with ENGINE=Dictionary on dictionary. This fixes #10994. This fixes #10397. #12116 (Vitaly Baranov).
    • ๐Ÿ›  Fixed performance for selects with UNION caused by wrong limit for the total number of threads. Fixes #12030. #12103 (Nikolai Kochetov).
    • ๐Ÿ›  Fixed segfault with -StateResample combinators. #12092 (Anton Popov).
    • Fixed empty result_rows and result_bytes metrics in system.quey_log for selects. Fixes #11595. #12089 (Nikolai Kochetov).
    • ๐Ÿ›  Fixed unnecessary limiting the number of threads for selects from VIEW. Fixes #11937. #12085 (Nikolai Kochetov).
    • ๐Ÿ›  Fixed possible crash while using wrong type for PREWHERE. Fixes #12053, #12060. #12060 (Nikolai Kochetov).
    • ๐Ÿ›  Fixed error Expected single dictionary argument for function for function defaultValueOfArgumentType with LowCardinality type. Fixes #11808. #12056 (Nikolai Kochetov).
    • ๐Ÿ›  Fixed error Cannot capture column for higher-order functions with Tuple(LowCardinality) argument. Fixes #9766. #12055 (Nikolai Kochetov).
    • ๐Ÿ“‡ Parse tables metadata in parallel when loading database. This fixes slow server startup when there are large number of tables. #12045 (tavplubix).
    • ๐Ÿ›  Make topK aggregate function return Enum for Enum types. This fixes #3740. #12043 (alexey-milovidov).
    • ๐Ÿ›  Fixed constraints check if constraint is a constant expression. This fixes #11360. #12042 (alexey-milovidov).
    • ๐Ÿ›  Fixed incorrect comparison of tuples with Nullable columns. Fixes #11985. #12039 (Nikolai Kochetov).
    • Fixed calculation of access rights when allow_introspection_functions=0. #12031 (Vitaly Baranov).
    • ๐Ÿ›  Fixed wrong result and potential crash when invoking function if with arguments of type FixedString with different sizes. This fixes #11362. #12021 (alexey-milovidov).
    • ๐Ÿ›  A query with function neighbor as the only returned expression may return empty result if the function is called with offset -9223372036854775808. This fixes #11367. #12019 (alexey-milovidov).
    • ๐Ÿ›  Fixed calculation of access rights when allow_ddl=0. #12015 (Vitaly Baranov).
    • ๐Ÿ›  Fixed potential array size overflow in generateRandom that may lead to crash. This fixes #11371. #12013 (alexey-milovidov).
    • ๐Ÿ›  Fixed potential floating point exception. This closes #11378. #12005 (alexey-milovidov).
    • ๐Ÿ›  Fixed wrong setting name in log message at server startup. #11997 (alexey-milovidov).
    • ๐Ÿ›  Fixed Query parameter was not set in Values format. Fixes #11918. #11936 (tavplubix).
    • ๐Ÿ›  Keep aliases for substitutions in query (parametrized queries). This fixes #11914. #11916 (alexey-milovidov).
    • ๐Ÿ›  Fixed bug with no moves when changing storage policy from default one. #11893 (Vladimir Chebotarev).
    • ๐Ÿ›  Fixed potential floating point exception when parsing DateTime64. This fixes #11374. #11875 (alexey-milovidov).
    • Fixed memory accounting via HTTP interface (can be significant with wait_end_of_query=1). #11840 (Azat Khuzhin).
    • ๐Ÿ“‡ Parse metadata stored in zookeeper before checking for equality. #11739 (Azat Khuzhin).

    ๐ŸŽ Performance Improvement

    • ๐ŸŽ Index not used for IN operator with literals", performance regression introduced around v19.3. This fixes "#10574. #12062 (nvartolomei).

    ๐Ÿ— Build/Testing/Packaging Improvement

    • โšก๏ธ Install ca-certificates before the first apt-get update in Dockerfile. #12095 (Ivan Blinkov).
  • v20.4.6.53 Changes

    June 25, 2020

    ๐Ÿ› 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. 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

  • v20.4.5.36 Changes

    June 10, 2020

    ๐Ÿ› 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 #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 #11278 (Vitaly Baranov).
    • ๐Ÿ›  Fix crash while reading malformed data in Protobuf format. This fixes, fixes #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