Altinity Stable for ClickHouse 22.8
(February 13, 2023)
Most recent releases organized by major release and release date:
Return to the top.
Return to the top.
Return to the top.
Based on upstream/v22.3.15.33-lts
v22.3.12.19-lts
to v22.3.15.33-lts
ALTER MODIFY COLUMN
DataType to Nullable(DataType)
doesn’t require mutation. #27787 (victorgao).toString(enum)
. #43596 (Nikita Taranov).SAMPLE BY
with prewhere optimization on tables using Merge
engine. #43315 (Antonio Andelic).aggregate_functions_null_for_empty
setting. This bug is very rare and appears only if you enable the aggregate_functions_null_for_empty
setting in the server’s config. This closes #41647. #42198 (Alexey Milovidov).SELECT
from Merge
table with enabled optimize_monotonous_functions_in_order_by
setting. Fixes #41269. #41740 (Nikolai Kochetov).pipeline stuck
exception for queries with OFFSET
. The error was found with enable_optimize_predicate_expression = 0
and always false condition in WHERE
. Fixes #41383. #41588 (Nikolai Kochetov).ORC
format might lead to a buffer overrun. #41458 (Alexey Milovidov).categorialInformationValue
was having incorrectly defined properties, which might cause a null pointer dereferencing at runtime. This closes #41443. #41449 (Alexey Milovidov).OFFSET
clause in subquery and WHERE
clause in outer query might return incorrect result, it’s fixed. Fixes #40416. #41280 (Alexander Tokmakov).Cannot unlink file ColumnName.bin ... No such file or directory.
could happen. #40346 (alesapin).simdjson
. This fixes #38621. #38838 (Alexey Milovidov).Return to the top.
background_fetches_pool_size
is set to 8. This is better for production usage with frequent small insertions or slow ZooKeeper clusters.Cannot find column in ActionsDAG result'
, which may happen if subquery uses untuple
. https://github.com/ClickHouse/ClickHouse/issues/22290quantile(s)TDigest
that could produce non-accurate results in some edge cases: https://github.com/ClickHouse/ClickHouse/issues/22408+
’ sign: https://github.com/clickHouse/clickHouse/pull/23822The complete diff between Altinity and community versions can also be viewed at github:
Fixed a bug with distributed queries that could sometimes fail with ‘Unknown packet n from server
’ error message: https://github.com/ClickHouse/ClickHouse/issues/21588
Fixed several issues with mutations handling (e.g. https://github.com/ClickHouse/ClickHouse/issues/22013)
Fix a rare bug when quorum insert with iinsert_quorum_parallel=1
is not really a “quorum” because of deduplication
Fixed a possible buffer overflow in token bloom filter index: https://github.com/ClickHouse/ClickHouse/issues/19233
Fixed a bug when nullable types sometimes could not be retrieved: https://github.com/ClickHouse/ClickHouse/issues/21116
Fixed a bug with replicated tables metadata not properly cleaned from the non-primary ZooKeeper instance: https://github.com/ClickHouse/ClickHouse/issues/21054
Added parseDateTimeBestEffortOrZero
to allow for empty values, while parseDateTimeBestEffort
will not work with empty values. For example:
SELECT parseDateTimeBestEffort('')
Query id: 1c60717e-116b-445f-b675-7b9cac35c262
0 rows in set. Elapsed: 0.003 sec.
Received exception from server (version 21.11.1):
Code: 41. DB::Exception: Received from localhost:9000. DB::Exception: Cannot read DateTime: neither Date nor Time was parsed successfully: While processing parseDateTimeBestEffort(''). (CANNOT_PARSE_DATETIME)
SELECT parseDateTimeBestEffortOrZero('')
Query id: 484baec9-6d00-4c66-a792-85a270d6f2f2
┌─parseDateTimeBestEffortOrZero('')─┐
│ 1970-01-01 03:00:00 │
└───────────────────────────────────┘
ClickHouse Altinity Stable packages for this release can be found at:
Return to the top.
Bug fixes.
Return to the top.
The release includes several dozen bug fixes from the previous release.
if
function with NULLs.WITH
clause.SIGSEGV
in Kafka engine when broker is unavailable.block structure mismatch
error for queries with UNION
and JOIN
.ALTER TABLE UPDATE
could produce incorrect results when updating Nullable columns.Updated RPM packages for Altinity Stable Release can be found in the Altinity Stable Repository. The ClickHouse repository can be used for DEB packages but check version numbers carefully.
Return to the top.
(February 13, 2023)
(July 14, 2022)
(October 11, 2021)
(June 24, 2021)
(March 24, 2021)
(December 2, 2020)
(June 24, 2020)
(January 20, 2020)
(November 28, 2019)
(September 3, 2019)
(December 31, 2018)
Was this page helpful?
Glad to hear it!
Sorry to hear that. We'll track this issue and see how we can improve.