ClickHouse/docs/changelogs/v20.12.5.18-stable.md

ClickHouse release v20.12.5.18-stable FIXME as compared to v20.12.5.14-stable

Improvement

• Backported in #19149: Explicitly set uid / gid of clickhouse user & group to the fixed values (101) in clickhouse-server images. #19096 (filimonov).

Bug Fix

• Backported in #18267: Fix indeterministic functions with predicate optimizer. This fixes #17244. #17273 (Winter Zhang).
• Backported in #19655: fix data type convert issue for mysql engine ... #18124 (bo zeng).
• Backported in #18311: Fix inserting a row with default value in case of parsing error in the last column. Fixes #17712. #18182 (Jianmei Zhang).
• Backported in #18229: Fix possible incomplete query result while reading from MergeTree* in case of read backoff (message <Debug> MergeTreeReadPool: Will lower number of threads in logs). Was introduced in #16423. Fixes #18137. #18216 (Nikolai Kochetov).
• Backported in #18630: SELECT JOIN now requires the SELECT privilege on each of the joined tables. This PR fixes #17654. #18232 (Vitaly Baranov).
• Backported in #19202: SELECT count() FROM table now can be executed if only one any column can be selected from the table. This PR fixes #10639. #18233 (Vitaly Baranov).
• Backported in #19162: Fix index analysis of binary functions with constant argument which leads to wrong query results. This fixes #18364. #18373 (Amos Bird).
• Backported in #19716: Disable constant folding for subqueries on the analysis stage, when the result cannot be calculated. #18446 (Azat Khuzhin).
• Backported in #18601: Fix bug which may lead to ALTER queries hung after corresponding mutation kill. Found by thread fuzzer. #18518 (alesapin).
• Backported in #18577: Fix possible Pipeline stuck error while using ORDER BY after subquery with RIGHT or FULL join. #18550 (Nikolai Kochetov).
• Backported in #18606: Add FixedString Data type support. I'll get this exception "Code: 50, e.displayText() = DB::Exception: Unsupported type FixedString(1)" when replicating data from MySQL to ClickHouse. This patch fixes bug #18450 Also fixes #6556. #18553 (awesomeleo).
• Backported in #18643: Fix removing of empty parts in ReplicatedMergeTree tables, created with old syntax. Fixes #18582. #18614 (Anton Popov).
• Backported in #18738: Fix Logger with unmatched arg size. #18717 (sundyli).
• Backported in #18949: Fixed Attempt to read after eof error when trying to CAST NULL from Nullable(String) to Nullable(Decimal(P, S)). Now function CAST returns NULL when it cannot parse decimal from nullable string. Fixes #7690. #18718 (Winter Zhang).
• Backported in #18802: Asynchronous distributed INSERTs can be rejected by the server if the setting network_compression_method is globally set to non-default value. This fixes #18741. #18776 (Alexey Milovidov).
• Backported in #18835: Fix *If combinator with unary function and Nullable types. #18806 (Azat Khuzhin).
• Backported in #18909: Fix possible hang at shutdown in clickhouse-local. This fixes #18891. #18893 (Alexey Milovidov).
• Backported in #19114: Attach partition should reset the mutation. #18804. #18935 (fastio).
• Backported in #18967: Fix bug when mutation with some escaped text (like ALTER ... UPDATE e = CAST('foo', 'Enum8(\'foo\' = 1') serialized incorrectly. Fixes #18878. #18944 (alesapin).
• Backported in #19008: Fix incorrect behavior when ALTER TABLE ... DROP PART 'part_name' query removes all deduplication blocks for the whole partition. Fixes #18874. #18969 (alesapin).
• Backported in #19192: Fixed very rare deadlock at shutdown. #18977 (Alexander Tokmakov).
• Backported in #19094: Disable optimize_move_functions_out_of_any because optimization is not always correct. This closes #18051. This closes #18973. #18981 (Alexey Milovidov).
• Backported in #19068: Join tries to materialize const columns, but our code waits for them in other places. #18982 (Nikita Mikhaylov).
• Backported in #19051: Fix inserting of LowCardinality column to table with TinyLog engine. Fixes #18629. #19010 (Nikolai Kochetov).
• Backported in #19083: Fix possible error Expected single dictionary argument for function if use function ignore with LowCardinality argument. Fixes #14275. #19016 (Nikolai Kochetov).
• Backported in #19047: Make sure groupUniqArray returns correct type for argument of Enum type. This closes #17875. #19019 (Alexey Milovidov).
• Backported in #19128: Restrict MODIFY TTL queries for MergeTree tables created in old syntax. Previously the query succeeded, but actually it had no effect. #19064 (Anton Popov).
• Backported in #19565: Fixed There is no checkpoint error when inserting data through http interface using Template or CustomSeparated format. Fixes #19021. #19072 (Alexander Tokmakov).
• Backported in #19232: Fix startup bug when clickhouse was not able to read compression codec from LowCardinality(Nullable(...)) and throws exception Attempt to read after EOF. Fixes #18340. #19101 (alesapin).
• Backported in #19180: Fix infinite reading from file in ORC format (was introduced in #10580). Fixes #19095. #19134 (Nikolai Kochetov).
• Backported in #19269: Fix bug when concurrent ALTER and DROP queries may hang while processing ReplicatedMergeTree table. #19237 (alesapin).
• Backported in #19424: Fix error Cannot convert column now64() because it is constant but values of constants are different in source and result. Continuation of #7156. #19316 (Nikolai Kochetov).
• Backported in #19553: Fix system.parts _state column (LOGICAL_ERROR when querying this column, due to incorrect order). #19346 (Azat Khuzhin).
• Backported in #19469: - Fix default value in join types with non-zero default (e.g. some Enums). Closes #18197. #19360 (Vladimir C).
• Backported in #19437: Fix possible buffer overflow in Uber H3 library. See https://github.com/uber/h3/issues/392. This closes #19219. #19383 (Alexey Milovidov).
• Backported in #19612: Fixed very rare bug that might cause mutation to hang after DROP/DETACH/REPLACE/MOVE PARTITION. It was partially fixed by #15537 for the most cases. #19443 (Alexander Tokmakov).
• Backported in #19664: Mark distributed batch as broken in case of empty data block in one of files. #19449 (Azat Khuzhin).
• Backported in #19508: Buffer overflow (on memory read) was possible if addMonth function was called with specifically crafted arguments. This fixes #19441. This fixes #19413. #19472 (Alexey Milovidov).
• Backported in #19541: Fix SIGSEGV with merge_tree_min_rows_for_concurrent_read/merge_tree_min_bytes_for_concurrent_read=0/UINT64_MAX. #19528 (Azat Khuzhin).
• Backported in #19642: Query CREATE DICTIONARY id expression fix. #19571 (Maksim Kita).
• Backported in #19638: DROP/DETACH TABLE table ON CLUSTER cluster SYNC query might hang, it's fixed. Fixes #19568. #19572 (Alexander Tokmakov).
• Backported in #19651: Fix use-after-free of the CompressedWriteBuffer in Connection after disconnect. #19599 (Azat Khuzhin).
• Backported in #19741: Fix wrong result of function neighbor for LowCardinality argument. Fixes #10333. #19617 (Nikolai Kochetov).
• Backported in #19699: Some functions with big integers may cause segfault. Big integers is experimental feature. This closes #19667. #19672 (Alexey Milovidov).
• Backported in #19818: Fix a segmentation fault in bitmapAndnot function. Fixes #19668. #19713 (Maksim Kita).
• Backported in #19781: Fix crash when nested column name was used in WHERE or PREWHERE. Fixes #19755. #19763 (Nikolai Kochetov).
• Backported in #19871: Fixed stack overflow when using accurate comparison of arithmetic type with string type. #19773 (Alexander Tokmakov).
• Backported in #19811: In previous versions, unusual arguments for function arrayEnumerateUniq may cause crash or infinite loop. This closes #19787. #19788 (Alexey Milovidov).
• Backported in #19941: Deadlock was possible if system.text_log is enabled. This fixes #19874. #19875 (Alexey Milovidov).
• Backported in #19937: BloomFilter index crash fix. Fixes #19757. #19884 (Maksim Kita).