v.18.14
Bug Fix
60- compile_expressions Setting Disabled by Default in ClickHouse
- Default Setting: `enable_optimize_predicate_expression` Disabled
- Fixed LIMIT query error: Block structure mismatch in UNION stream
- Fixed Data Merge Errors in Nested Structures with Arrays
- Fixed Query Results with Disabled Merge Tree Uniform Read Distribution Setting
- Fixed Insert Error in Distributed Table (Native Format)
- Fixed crash on joining unnamed subqueries
- Fixed Incorrect Queries with Empty WHERE Clause in External Database Queries
- Fixed Incorrect Timeout Value in ODBC Dictionaries
- Fixed Block Structure Mismatch in MergingSorted Stream Error
- Fixed ON CLUSTER Queries with Secure Connections in Cluster Config
- Fixed Query Errors with SAMPLE, PREWHERE, and Alias Columns
- Fixed rare unknown compression method error with direct IO setting enabled
- Fixed ON CLUSTER Queries for Secure Cluster Configuration
- Memory Limit Exceeded Errors When Deserializing Array(String) in Version 18.12.13
- Fixed ODBC Bridge Process Termination Issues
- Fixed Synchronous Insertion in Distributed Table with Column List Differences
- Fixed rare race condition causing crashes when dropping MergeTree table
- Fixed query deadlock on thread creation failure due to resource unavailability
- Fixed ENGINE clause parsing for CREATE AS table syntax
- Fixed dictGet Error for Mixed Constant and Non-Constant Arguments in Range Dictionaries
- Fixed netlink error message printing in Linux kernel log
- Fixed Segfault in Empty Function for FixedString Type
- Fixed Memory Allocation Issue with Large max_query_size Setting
- Fixed ODBC Dictionary Update Issues
- Databases Specified Correctly in DDL ON CLUSTER Queries
- Fixed Segfault for Exceeding max_temporary_non_const_columns Limit
- Fixed Dictionary Tables Issue in range_hashed Dictionaries (v18.12.17)
- Fixed Nullable Type Error in range_hashed Dictionaries
- Fixed pointInPolygon function errors for dense vertex polygons
- Merging Data Parts: Checksum Mismatch Causes Download Loop in ClickHouse
- Fixed Memory Consumption Calculation Error in Version 18.12.13
- Fixed CREATE TABLE ON CLUSTER AS SELECT Functionality in Version 18.12.13
- Fixed unnecessary data preparation for remote JOINs
- Fixed Kafka Engine Bugs Related to Deadlocks and Locks
- Missing Schema Parameter for Kafka Tables in Cap'n'Proto Format
- ClickHouse Enhances Server Connection Handling with ZooKeeper
- Ignoring ZooKeeper Servers with DNS Query Errors
- Fixed Date and DateTime Type Conversion in VALUES Insertion
- Corrected Decimal to Integer Type Conversion
- Fixed Errors in enable_optimize_predicate_expression Setting
- Fixed CSV Parsing Error for Floating-Point Numbers with Custom Separator
- Fixed arrayCumSumNonNegative function to exclude negative values when accumulator is below zero
- Fixed Merge Tables Behavior with Distributed Tables and PREWHERE
- Bug Fixes in ALTER UPDATE Query
- Fixed Bugs in odbc Table Function in Version 18.12
- Fixed Aggregate Functions with StateArray Combinators
- Fixed Crash When Dividing Decimal by Zero
- Fixed Output Types for Decimal and Integer Operations
- Fixed Segfault in GROUP BY on Decimal128
- log_query_threads now requires log_queries to be enabled
- Fixed Distributed Operation Error in Quantiles Aggregate Function
- Fixed Aggregation Issues in Mixed-Version Cluster Queries
- Fixed Substitution Handling in ClickHouse Performance Test
- Fixed FINAL and PREWHERE Error
- Fixed PREWHERE Error for Newly Added Columns in ALTER
- Added Check for arrayJoin in DEFAULT and MATERIALIZED Expressions
- Added check for arrayJoin absence in PREWHERE clause to prevent error messages
- Fixed Rare Segfault in Optimization of AND Chains to IN Expressions
- Minor Corrections to Clickhouse-Benchmark Functionality
Build/Testing/Packaging Improvement
4Performance Improvement
2Backward Incompatible Changes
1Experimental Feature
2Improvement
28- Significant Memory Optimization for ORDER BY and LIMIT Queries
- Default Join Behavior in SQL Queries
- Qualified Asterisks Functionality in JOIN Queries
- ODBC Table Engine Enhances Identifier Quoting in Remote SQL Dialects
- Default Enabling of compile_expressions for JIT Compilation
- Fixed Concurrent DROP and CREATE Database/Table Behaviors
- LIKE and IN expressions with constant right half sent to remote server in MySQL and ODBC queries
- Improvements in WHERE Clause Handling for MySQL and ODBC Queries
- Correct Row Width Calculation for Pretty Formats in Terminal
- ON CLUSTER in ALTER UPDATE Queries
- Improved JSONEachRow Data Reading Performance
- Added Synonyms for LENGTH and CHARACTER_LENGTH; CONCAT Function Case-Sensitivity Adjusted
- Added TIMESTAMP Synonym for DateTime Type
- Server Logs Always Include Reserved Query ID Space for Easier Parsing
- Memory Consumption Logging for Queries Exceeding Integer Gigabyte Levels
- Added Compatibility Mode to Prevent Server Crash from Insufficient Columns in INSERT Query
- New Feature: 'partition_key' Alias in clickhouse-copier WHERE Expressions
- Kafka Engine Workflow Moved to Background Thread Pool for Load Management
- Support for Tuple and Nested Structures in Cap'n'Proto Format
- Top-Level Domains Update for firstSignificantSubdomain Function
- External Dictionaries Configuration: Interpreting null_value as Default Data Type
- Support for intDiv and intDivOrZero Functions for Decimal
- Support for Date, DateTime, UUID, and Decimal Types in sumMap Aggregate Function
- Support for Decimal Data Type in External Dictionaries
- Support Decimal Data Type in SummingMergeTree Tables
- Added UUID Specializations in if Statement
- Reduced System Calls in MergeTree Table Reads
- Truncate Table Query Execution on Replicas
New Feature
10- WITH CUBE Modifier for GROUP BY in ClickHouse
- Added formatDateTime Function by Alexandr Krasheninnikov
- Added JDBC Table Engine and Function in ClickHouse
- Added ISO week number functions: toISOWeek, toISOYear, toStartOfISOYear, and toDayOfYear
- Nullable Columns Support for MySQL and ODBC Tables
- Nested Data Structures Supported in JSONEachRow Format with New Setting
- Parallel Processing for MATERIALIZED VIEWS in ClickHouse
- Added SYSTEM FLUSH LOGS Query for Forced Log Flushes
- New Macros for Declaring Replicated Tables in ClickHouse
- Added Support for Reading Decimal Values in Engineering Notation