ClickHouse 26.9.25.15 → 26.10.2.103
1 release · 1 breaking change · 0 security fixes · 0 advisories fixed
0security1breaking0deprecated39feature0fix
Breaking changes
- breaking Backported in: CREATE TABLE x AS src inherits the credentials embedded in the engine of src, which are masked in SHOW CREATE TABLE. It now requires the SELECT privilege on src when the inherited definition can carry credentials, instead of only SHOW COLUMNS. (Yarik Briukhovetskyi). in 26.10.2.103
Security changes
None in the release notes.
Every release in between
breakingBackported in: CREATE TABLE x AS src inherits the credentials embedded in the engine of src, which are masked in SHOW CREATE TABLE. It now requires the SELECT privilege on src when the inherited definition can carry credentials, instead of only SHOW COLUMNS. (Yarik Briukhovetskyi).
featureBackported in: Added the experimental Elasticsearch table engine and elasticsearch table function for reading documents from an Elasticsearch index as a JSON column, with the document id and index name available as virtual columns. Enable them with the enable_elasticsearch setting. (Kirill Kopnev).
featureThe setting use_query_condition_cache_for_time_conditions (using the query condition cache for conditions involving the current time) is now experimental and disabled by default. (Alexey Milovidov).
featureBackported in: Column statistics of MergeTree data parts are cached per data part and column in a new statistics cache (server settings statistics_cache_size, statistics_cache_policy, statistics_cache_size_ratio; SYSTEM DROP STATISTICS CACHE), loaded on demand and merged on the fly for every…
featureBackported in: Lazy materialization now works for LIMIT N queries over JOINs. Controlled by the new setting query_plan_lazy_materialization_for_join, enabled by default. . (Nikolai Kochetov).
featureBackported in: Sets of IN with a subquery spill to disk by default: max_bytes_ratio_before_external_set now defaults to 0.5, so a set spills once query memory exceeds half of the memory that the server or user memory limits leave. Set it to 0 to keep such sets in memory. Sets on disk are built and…
featureBackported in: Estimating subcolumn sizes for PREWHERE (for example m['key'] of a Map(LowCardinality(String), String) column) no longer reads the LowCardinality dictionary or the Variant discriminators header of every data part, which made planning slow on object storage, especially for each new…
featureBackported in: Improved automatic_parallel_replicas observability by adding outcome-specific ProfileEvents, split optimization/plan-build timing counters, and runtime statistics-collection timing in query_log. (Nikita Taranov).
featureBackported in: Queries with FINAL now use the virtual row optimization of reading in order. Supported for ReplacingMergeTree, CollapsingMergeTree, VersionedCollapsingMergeTree, SummingMergeTree, AggregatingMergeTree and CoalescingMergeTree. (Vladimir Cherkasov).
featureBackported in: Reduced the memory usage of incremental BACKUP: the base backup keeps only the sizes and checksums of its files instead of the full information about each file. For a base backup of millions of files this saves gigabytes. (Julia Kartseva).
featureBackported in: Compare TOTP codes and plaintext_password passwords in constant time, so that the response time does not depend on how many leading characters are correct or on which time window matched. (Vladimir Cherkasov).
featureBackported in: A replica that takes part in a parallel replicas read now follows the initiator even when its own automatic_parallel_replicas_mode is not 0, for example when allow_feature_tier drops the value the initiator sends, or when INSERT ... SETTINGS automatic_parallel_replicas_mode = 2…
featureBackported in: The "Format" button in the Web UI now supports inputs with multiple queries: each query is formatted separately and replaced in place, keeping the comments and delimiters between them. (Alexey Milovidov).
featureBackported in: Automatic parallel replicas settings (automatic_parallel_replicas_mode, automatic_parallel_replicas_min_bytes_per_replica) are now production tier instead of experimental. (Nikita Taranov).
featureBackported in: The nodes in the output of EXPLAIN AST graph = 1 are numbered sequentially instead of being identified by memory addresses, so the output is the same on every run. (Raúl Marín).
featureBackported in: Fatal error reports no longer contain runtime memory addresses: stack frames and the fault address are printed as offsets inside the executable or a library, which can be passed to addr2line, and other addresses are hidden. system.crash_log.fault_address now contains the offset…
featureBackported in: A JOIN whose ON condition has a constant-false conjunct now works with the experimental parallel_replicas_plan_based setting when the join uses grace_hash, spills to disk, or runs with join_use_nulls = 1, instead of terminating the server or failing with NOT_FOUND_COLUMN_IN_BLOCK.…
featureBackported in: Fix a possible crash or out-of-bounds memory access when reading from HDFS if a DataNode or NameNode sends malformed responses. (Alexey Milovidov).
featureBackported in: Adds a minimum threshold for spilling in-memory data when external aggregation is enabled. (Mikhail Artemenko).
featureBackported in: System tables no longer contain runtime memory addresses: stack frames outside the main binary are stored as 0, system.trace_log.ptr is an identifier instead of an address, and the ids in system.processors_profile_log are indices within the query. (Raúl Marín).
featureBackported in: Improve glue catalog cache. Let's cache only mapping column name -> timestamp, not the whole metadata. (Konstantin Vedernikov).
featureBackported in: The obfuscate table function and the clickhouse obfuscator tool now support LowCardinality, Enum, Date32, DateTime64, Decimal, wide integers, IPv4, IPv6, BFloat16, Tuple and Map columns. The exception for an unsupported type now names the type and the column. (Alexey Milovidov).
featureBackported in: Hardening: certificate chains containing the compromised eMudhra intermediate CAs or the roots that issued them (emSign Root TLS CA - G3, emSign ECC Root CA - G3) are rejected even if the trust store of the operating system still trusts them. The CA certificates embedded into the…
featureBackported in: This patch supports writeFileUsingBlobWritingFunction for disks with multiple configured locations. (Mikhail Artemenko).
featureNO CL ENTRY: 'Revert "Backport to 26.10: Lower Bound External Group By Spill"'. (Mikhail Artemenko).
featureBackported in: Make 03673_columns_description_cache and 04257_102926_columns_descriptions_cache_nested_eviction robust to asynchronous part removal, applying the fix already made to their sibling 04510_shared_part_schema_metadata_eviction. (Groene AI).
featureBackported in: Query cache: do not store a partial subquery result. (Konstantin Bogdanov).
featureBackported in: Rewrite arrayJoin(emptyArrayToSingle(x)) -> LEFT ARRAY JOIN x. (Yarik Briukhovetskyi).
featureBackported in: Fix h3CellAreaM2/h3CellAreaRads2 precision loss for cells crossing the antimeridian. (Konstantin Bogdanov).
featureBackported in: Fix flaky integration test test_prometheus_protocols/test_evaluation.py::test_multiple_instant_vectors, which compared the series of an instant vector in a fixed order. (Groene AI).
featureBackported in: Use node ids instead of addresses in pipeline diagnostics. (Raúl Marín).
featureBackported in: Exit early in sliceContains for short and early-hit searches. (Raúl Marín).
featureBackported in: Fix Broken pipe in test 05345_robin_hood_large_hash_tables. (Alexey Milovidov).
featureBackported in: Lazily replicated ARRAY JOIN passenger columns hold only the rows of their output block again, so materialized views, max_result_bytes and squashing size ARRAY JOIN output correctly. (Groene AI).
featureBackported in: With distributed_plan_join_runtime_filters, a runtime filter that is no longer needed by its receiver no longer produces EXCHANGE_PEER_DISCONNECTED errors in system.errors and in the log. (Alexander Gololobov).
featureBackported in: Rename integer division setting to sql_compatible_division_for_integers. (Ilya Yatsishin).
featureBackported in: Revert "SLRU filesystem cache: promote partially downloaded file segments". (Sema Checherinda).
featureBackported in: Pin the old server image of test_custom_s3_disk_remote_url_allow_hosts to 26.8.26.12. (Groene AI).
featureBackported in: Decline automatic parallel replicas when the coordinated read gets another read's analysis. (Nikita Taranov).
featureBackported in: Keep the sliceContains block loop independent of the first-vector test on AArch64. (Groene AI).
+61 more items in the release notes