Altinity Stable Build for ClickHouse 22.3.15 Release Notes
Details of the Altinity Stable Build 22.3.15
Based on upstream/v220.127.116.11-lts
Changes Compared to Community Build v18.104.22.168-lts
- Fix for exponential time decaying window functions. Now respecting boundaries of the window. #36944 by @excitoon
- Fixes for objects removal in S3ObjectStorage #37882 by @excitoon
- Fixed Unknown identifier (aggregate-function) exception #39762 by @quickhouse
- Fixed point of origin for exponential decay window functions #39593 by @quickhouse
- Fix unused unknown columns introduced by WITH statement #39131 by @amosbird
- Fix memory leak while pushing to MVs w/o query context (from Kafka/…) by @azat
- Fix ArrowColumn dictionary conversion to LowCardinality strings. #40037 by #arthurpassos
- Optimized processing of ORDER BY in window functions #34632 by @excitoon
- Support batch_delete capability for GCS #37659 by @frew
- Add support for extended (chunked) arrays for Parquet format. #40485 by @arthurpassos
Changes in upstream from
- Update tzdata to 2022f. Mexico will no longer observe DST except near the US border: https://www.timeanddate.com/news/time/mexico-abolishes-dst-2022.html. Chihuahua moves to year-round UTC-6 on 2022-10-30. Fiji no longer observes DST. See https://github.com/google/cctz/pull/235 and https://bugs.launchpad.net/ubuntu/+source/tzdata/+bug/1995209. #42796 (Alexey Milovidov).
- Fix issue with passing MySQL timeouts for MySQL database engine and MySQL table function. Closes #34168. #40751 (Kseniia Sumarokova).
ALTER MODIFY COLUMNDataType to
Nullable(DataType)doesn’t require mutation. #27787 (victorgao).
- Fixed primary key analysis with conditions involving
toString(enum). #43596 (Nikita Taranov).
- Fixed queries with
SAMPLE BYwith prewhere optimization on tables using
Mergeengine. #43315 (Antonio Andelic).
- This closes #42453. #42573 (Alexey Milovidov).
- Choose correct aggregation method for LowCardinality with BigInt. #42342 (Duc Canh Le).
- Fix a bug with projections and the
aggregate_functions_null_for_emptysetting. This bug is very rare and appears only if you enable the
aggregate_functions_null_for_emptysetting in the server’s config. This closes #41647. #42198 (Alexey Milovidov).
- Fix possible crash in
Mergetable with enabled
optimize_monotonous_functions_in_order_bysetting. Fixes #41269. #41740 (Nikolai Kochetov).
- Fix possible
pipeline stuckexception for queries with
OFFSET. The error was found with
enable_optimize_predicate_expression = 0and always false condition in
WHERE. Fixes #41383. #41588 (Nikolai Kochetov).
- Writing data in Apache
ORCformat might lead to a buffer overrun. #41458 (Alexey Milovidov).
- The aggregate function
categorialInformationValuewas having incorrectly defined properties, which might cause a null pointer dereferencing at runtime. This closes #41443. #41449 (Alexey Milovidov).
- Malicious data in Native format might cause a crash. #41441 (Alexey Milovidov).
- Add column type check before UUID insertion in MsgPack format. #41309 (Kruglov Pavel).
- Queries with
OFFSETclause in subquery and
WHEREclause in outer query might return incorrect result, it’s fixed. Fixes #40416. #41280 (Alexander Tokmakov).
- Fix possible segfaults, use-heap-after-free and memory leak in aggregate function combinators. Closes #40848. #41083 (Kruglov Pavel).
- Fix memory leak while pushing to MVs w/o query context (from Kafka/…). #40732 (Azat Khuzhin).
- Fix potential dataloss due to a bug in AWS SDK (https://github.com/aws/aws-sdk-cpp/issues/658). Bug can be triggered only when clickhouse is used over S3. #40506 (alesapin).
- Proxy resolver stop on first successful request to endpoint. #40353 (Maksim Kita).
- Fix rare bug with column TTL for MergeTree engines family: In case of repeated vertical merge the error
Cannot unlink file ColumnName.bin ... No such file or directory.could happen. #40346 (alesapin).
- Fix potential deadlock in WriteBufferFromS3 during task scheduling failure. #40070 (Maksim Kita).
simdjson. This fixes #38621. #38838 (Alexey Milovidov).
- Fix cast lowcard of nullable in JoinSwitcher, close #37385. #37453 (Vladimir C).
- Tested binaries: https://builds.altinity.cloud/
- Docker: https://hub.docker.com/r/altinity/clickhouse-server
- Brew: https://github.com/Altinity/homebrew-clickhouse