v.19.13
Backward Incompatible Change
1Bug Fix
30- Kafka Integration Has Been Fixed in This Version.
- Fixed Doubledelta Encoding of Int64 for Large Doubledelta Values, Improved Doubledelta Encoding for Random Data for Int32
- Fixed Overestimation of Max_rows_to_read If the Setting Merge_tree_uniform_read_distribution Is Set to 0
- Fix ALTER TABLE ..
- Fix NPE When Using IN Clause with a Subquery with a Tuple
- Fixed an Issue That If a Stale Replica Becomes Alive, It May Still Have Data Parts That Were Removed by DROP PARTITION
- Fixed Issue with Parsing CSV #6426 #6559 (tavplubix)
- Fixed Data Race in System.parts Table and ALTER Query
- Fixed Wrong Code in Mutations That May Lead to Memory Corruption
- Fixed Possible Data Loss After ALTER DELETE Query on Table with Skipping Index
- This Release Also Contains All Bug Security Fixes from 19.11.9.52 and 19.11.10.54.
- Fixed Data Race in System.parts Table and ALTER Query
- Fixed Mismatched Header in Streams Happened in Case of Reading from Empty Distributed Table with Sample and Prewhere
- Fixed Crash When Using IN Clause with a Subquery with a Tuple
- Fix Case with Same Column Names in GLOBAL JOIN ON Section
- Fix Crash When Casting Types to Decimal That Do Not Support It
- Fixed Crash in Extractall() Function
- Query Transformation for Mysql, Odbc, JDBC Table Functions Now Works Properly for SELECT WHERE Queries with Multiple AND Expressions
- Added Previous Declaration Checks for Mysql 8 Integration
- This Release Also Contains All Bug Fixes from 19.14.6.12.
- Fixed Possible Inconsistent State of Table While Executing DROP Query for Replicated Table While Zookeeper Is Not Accessible
- Fix for Data Race in Storagemerge #6717 (alexey-milovidov)
- Fix Bug Introduced in Query Profiler Which Leads to Endless Recv from Socket
- Fix Excessive CPU Usage While Executing Jsonextractraw Function over a Boolean Value
- Fixes the Regression While Pushing to Materialized View
- Table Function Url Had the Vulnerability Allowed the Attacker to Inject Arbitrary HTTP Headers in the Request
- Fix Useless AST Check in Set Index
- Fixed Parsing of Aggregatefunction Values Embedded in Query
- Fixed Wrong Behaviour of Trim Functions Family
- This Release Also Contains All Bug Fixes from 19.11.12.69.
Build/Testing/Packaging Improvement
3Experimental Features
1New Feature
7- Sampling Profiler on Query Level
- Allow to Specify a List of Columns with Columns('regexp') Expression That Works Like a More Sophisticated Variant of * Asterisk
- CREATE TABLE AS Table_function() Is Now Possible #6057 (dimarub2000)
- Adam Optimizer for Stochastic Gradient Descent Is Used by Default in Stochasticlinearregression() and Stochasticlogisticregression() Aggregate Functions, Because It Shows Good Quality Without Almost Any Tuning
- Added Functions for Working with the Π‘ustom Week Number #5212 (andy Yang)
- RENAME Queries Now Work with All Storages
- Now Client Receive Logs from Server with Any Desired Level by Setting Send_logs_level Regardless to the Log Level Specified in Server Settings
Performance Improvement
1Security Fix
2- If the Attacker Has Write Access to Zookeeper and Is Able to Run Custom Server Available from the Network Where Clickhouse Run, It Can Create Custom-built Malicious Server That Will Act as Clickhouse Replica and Register It in Zookeeper
- Fix Two Vulnerabilities in Codecs in Decompression Phase (malicious User Can Fabricate Compressed Data That Will Lead to Buffer Overflow in Decompression)