Altinity Stable for ClickHouse 22.3.10

Release Notes

Changes from ClickHouse v22.3.10.22-LTS

Changes Compared to Community Build v22.3.10.22-lts:

Bug Fixes

• Fix for exponential time decaying window functions. Now respecting boundaries of the window #36944 by @excitoon (via #164)
• Fixes for objects removal in S3ObjectStorage #37882 by @excitoon (via #164)
• Fixed Unknown identifier (aggregate-function) exception #39762 by @quickhouse (via #189)
• Fixed point of origin for exponential decay window functions #39593 by @quickhouse (via #190)
• Reverted ‘Fix seeking while reading from encrypted disk’ https://github.com/ClickHouse/ClickHouse/pull/39687, known to cause issues in 22.3 (via #https://github.com/Altinity/ClickHouse/pull/193)
• Reverted: ‘Enable using constants from with and select in aggregate function parameters.’ https://github.com/ClickHouse/ClickHouse/pull/27531, causes problems on 22.3 (via #194)

Improvements

• Improvement: Optimized processing of ORDER BY in window functions #34632 by @excitoon (via #164)
• Improvement: Support batch_delete capability for GCS #37659 by @frew (via #164)

Build/Testing/Packaging Improvements

• Build/Testing/Packaging Improvement: Allow Github workflows to run on Altinity’s infrastructure

Changes from v22.3.8.39-lts to v22.3.10.22-lts

Bug Fixes

• ‘Fix CANNOT_READ_ALL_DATA with pread_threadpool.’. #39800 (Anton Popov).
• ‘Fix seeking while reading from encrypted disk’. #39687 (Vitaly Baranov).
• ‘Fix bug with maxsplit in the splitByChar’. #39552 (filimonov).
• ‘Fix data race and possible heap-buffer-overflow in Avro format’. #39498 (Kruglov Pavel).
• ‘Fix incorrect postgresql query which fetches tables list’. #39283 (Kseniia Sumarokova).
• ‘Fix segfault in materialised postgresql’. #39272 (Kseniia Sumarokova).
• ‘removed default queue arguments’. #39259 (rnbondarenko).
• ‘Fix reading of sparse columns from s3’ #37978 via #39206 (robot-ch-test-poll).
• ‘Fix reading from s3 in some corner cases’ #38239. via #39206 (robot-ch-test-poll).
• ‘prewhere action should preserve sorting columns’. #39157 (Yakov Olkhovskiy).
• ‘Fix insert into MV with enabled extremes.’. #39125 (Nikolai Kochetov).
• ‘Fix for fs cache’. #39070 (Kseniia Sumarokova).
• ‘Remove logging from OvercommitTracker to avoid deadlocks’. #39030 (Dmitry Novik).
• ‘Fix reading of sparse columns from s3’. #37978 (Anton Popov).
• ‘Fix some issues with low cardinality and async reads from remote fs’. #36763 (Kseniia Sumarokova).
• ‘Fix performance regression of scalar query’. #35986 (Amos Bird).

Other

• ‘Change mysql-odbc url’. #39702 (Mikhail f. Shiryaev).
• ‘Replace MemoryTrackerBlockerInThread to LockMemoryExceptionInThread’. #39619 (Nikolai Kochetov).
• ‘Add docker_server.py running to backport and release CIs’. #39011 (Mikhail f. Shiryaev).
• ‘Retry docker buildx commands with progressive sleep in between’. #38898 (Mikhail f. Shiryaev).

Full list of changes

Available at:

• Tested binaries: https://builds.altinity.cloud/
• Docker: https://hub.docker.com/r/altinity/clickhouse-server
• Brew: https://github.com/Altinity/homebrew-clickhouse