v.1.1.54276
Backward Incompatible Changes
1Bug Fix
21- Distributed Tables with Merge Table Support for SELECT Queries on _table Field
- Fixed Race Condition in ReplicatedMergeTree Data Parts Check
- Fixed Freezing Issue in Leader Election During Server Start
- Max Replica Delay Setting Fix for Local Data Source Queries
- Fixed ALTER TABLE CLEAR COLUMN Behavior for Non-Existing Columns
- Fixed Exception in multiIf Function for Empty Arrays or Strings
- Fixed Memory Allocation Issues in Native Format Deserialization
- Fixed Auto-Update Issue in Trie Dictionaries
- Fixed Exception with GROUP BY Clause in Merge Table Queries Using SAMPLE
- Fixed GROUP BY Crash in Distributed Aggregation Memory Efficient Mode
- Database Table Specification in IN and JOIN Clauses
- Fix for Excessive Threads in Parallel Aggregation
- Fixed "if" Function Behavior with FixedString Arguments
- Fix for SELECT Issue on Distributed Table with Zero-Weight Shards
- Running CREATE VIEW IF EXISTS No Longer Causes Crashes
- Fix handling of negative numbers with input_format_skip_unknown_fields=1 set
- Fixed Infinite Loop in dictGetHierarchy Function
- Fixed Syntax Error in Distributed Queries with Subqueries and Merge Tables
- Fixed SELECT Query Interpretation in Dictionary Tables
- Fixed "Cannot mremap" Error for Large Arrays in IN and JOIN Clauses
- Fixed MySQL Dictionary Failover
complete-list-of-changes
15- Added output_format_json_quote_denormals setting for JSON nan and inf values
- Optimized Stream Allocation for Distributed Table Reads
- Settings Configurable in Readonly Mode
- Enhancement to MergeTree Engine for Non-Integer Granules to Improve RAM Usage and Cache Locality
- Efficient Use of Indexes with Expressions in Conditions
- Replicated Deduplication Window Configuration
- Cleanup Delay Period Functionality
- Replica Leader Prevention Mechanism
- Accelerated Cleanup of Outdated ZooKeeper Data
- Multiple Enhancements for Clustered DDL Queries and New Timeout Setting
- Improved Stack Trace Display in Server Logs
- Added "none" Value for Compression Method
- Multiple dictionaries_config sections in config.xml
- Connect to MySQL via File System Socket
- New Column for Mark Size in System.Parts Table
Improvement
3main-changes
5New Feature
8- Added Optional WITH Clause for SELECT Query
- Synchronous INSERT in Distributed Tables Enabled by insert_distributed_sync=1
- Added UUID Data Type for 16-Byte Identifiers
- Aliases Added for CHAR, FLOAT, and Other Types for Tableau Compatibility
- Added Time Conversion Functions toYYYYMM, toYYYYMMDD, and toYYYYMMDDhhmmss
- Using IP Addresses to Identify Servers for Clustered DDL Queries
- Support for Non-Constant Arguments and Negative Offsets in substring Function
- Max Size Parameter and Performance Optimization for groupArray Function