2024 Changelog

ClickHouse release v24.8.7.41-lts (e28553d4f2b) FIXME as compared to v24.8.6.70-lts (ddb8c219771)

Improvement

• Backported in #71713: CLICKHOUSE_PASSWORD is escaped for XML in clickhouse image's entrypoint. #69301 (aohoyd).
• Backported in #71666: When user/group is given as ID, the clickhouse su fails. This patch fixes it to accept UID:GID as well. ### Documentation entry for user-facing changes. #71626 (Mikhail f. Shiryaev).
• Backported in #71936: Update HostResolver 3 times in a history period. #71863 (Sema Checherinda).

Bug Fix (user-visible misbehavior in an official stable release)

• Backported in #71486: Fix Content-Encoding not sent in some compressed responses. #64802. #68975 (Konstantin Bogdanov).
• Backported in #71462: Added missing unescaping in named collections. Without fix clickhouse-server can't start. #71308 (MikhailBurdukov).
• Backported in #71747: Check suspicious and experimental types in JSON type hints. #71369 (Pavel Kruglov).
• Backported in #71604: Fix error Invalid number of rows in Chunk with Variant column. #71388 (Pavel Kruglov).
• Backported in #71826: Fix crash with optimize_rewrite_array_exists_to_has. #71432 (Raúl Marín).
• Backported in #71517: Fix possible error Argument for function must be constant (old analyzer) in case when arrayJoin can apparently appear in WHERE condition. Regression after https://github.com/ClickHouse/ClickHouse/pull/65414. #71476 (Nikolai Kochetov).
• Backported in #71551: Prevent crash in SortCursor with 0 columns (old analyzer). #71494 (Raúl Marín).
• Backported in #71614: Analyzer fix when query inside materialized view uses IN with CTE. Closes #65598. #71538 (Maksim Kita).
• Backported in #71566: Avoid crash when using a UDF in a constraint. #71541 (Raúl Marín).
• Backported in #71727: Return 0 or default char instead of throwing an error in bitShift functions in case of out of bounds. #71580 (Pablo Marcos).
• Backported in #71876: Fix LOGICAL_ERROR when doing ALTER with empty tuple. This fixes #71647. #71679 (Amos Bird).
• Backported in #71737: Don't transform constant set in predicates over partition columns in case of NOT IN operator. #71695 (Eduard Karacharov).
• Backported in #72002: Fix a crash in clickhouse-client syntax highlighting. Closes #71864. #71949 (Nikolay Degterinsky).

Build/Testing/Packaging Improvement

• Backported in #71690: Improve clickhouse-server Dockerfile.ubuntu. Deprecate CLICKHOUSE_UID/CLICKHOUSE_GID envs. Remove CLICKHOUSE_DOCKER_RESTART_ON_EXIT processing to complien requirements. Consistent clickhouse/clickhouse-server/clickhouse-keeper execution to not have it plain in one place and /usr/bin/clickhouse* in another. #71573 (Mikhail f. Shiryaev).

NOT FOR CHANGELOG / INSIGNIFICANT

• Backported in #71801: Fix issues we face on orphane backport branches and closed release PRs, when fake-master events are sent to the check DB. #71782 (Mikhail f. Shiryaev).
• Backported in #71836: The change has already been applied to https://github.com/docker-library/official-images/pull/17876. Backport it to every branch to have a proper Dockerfile.ubuntu there. #71825 (Mikhail f. Shiryaev).