v.1.1.54388
Backward Incompatible Changes
2Bug Fix
19- Duplicates Removed with DISTINCT and ORDER BY Query
- Fix for Incorrect Results in ARRAY JOIN and arrayFilter Queries
- Fixed Error Reading Array Column from Nested Structure
- Fixed HAVING Clause Query Analysis Error
- Fixed Recursive Alias Query Analysis Error
- Fixed PREWHERE Filter Error in ReplacingMergeTree
- User Profile Settings Not Applied in HTTP Sessions
- Fixed Command Line Settings Application in ClickHouse Local
- ZooKeeper Client Library Uses Server-Received Session Timeout
- Fixed ZooKeeper Client Library Timeout Bug
- Fixed Partition Key Column Pruning in Queries
- Merges Allowed After CLEAR COLUMN IN PARTITION
- Type Mapping Fix in ODBC Table Function
- Type Comparisons Fixed for DateTime with and without Time Zone
- Fixed CAST Operator Syntax and Formatting
- Fixed Insertion into Materialized View for Distributed Table Engine
- Fixed Race Condition in Kafka Engine Data Writing to Materialized Views
- Fixed SSRF Vulnerability in remote() Table Function
- Fixed clickhouse-client exit behavior in multiline mode
Build/Testing/Packaging Improvement
8- gcc8 Compiler for Builds
- Added LLVM Build from Submodule
- Librdkafka Library Updated to v0.11.4
- Added libcpuid library support and updated to version 0.4.0
- Fixed Build with Vectorclass Library
- Cmake Defaults to Ninja File Generation
- Added Support for libtinfo Library in Place of libtermcap
- Fixed Header File Conflict in Fedora Rawhide #2520
Experimental Feature
2Improvement
10- Background Tasks in Replicated Tables Now Use Thread Pool
- Improved LZ4 Compression Performance
- Faster Analysis for Complex Queries with JOINs and Sub-Queries
- DNS Cache Automatically Updates on Excessive Network Errors
- Table Inserts Conditional on Materialized View Limits
- Corrected Event Counter Discrepancies in Queries
- Allow Matching Tuple Types in SQL Expressions
- Server with Replicated Tables Can Start Without ZooKeeper Configuration
- Cgroup Limits Considered in CPU Core Calculation
- Added chown for config directories in systemd config file
New Feature
15- Support for ALTER TABLE DELETE Queries on Replicated Tables
- Support for ALTER TABLE PARTITION Query in MergeTree Tables
- Support for TRUNCATE TABLE Query
- New SYSTEM Queries for Replicated Tables
- Added MySQL Engine Table Write Capability
- Added url() function and URL table engine in ClickHouse
- Added windowFunnel aggregate function
- New startsWith and endsWith Functions for Strings
- numbers() Table Function Now Supports Offset Specification
- Password Entry for clickhouse-client
- Server Logs Now Support Syslog Integration
- Support for Logging in Dictionaries with Shared Library Source
- Support for Custom CSV Delimiters
- Added date_time_input_format Setting for Flexible DateTime Parsing
- Added clickhouse-obfuscator Utility for Data Obfuscation