ClickHouse/docs/changelogs/v23.3.14.78-lts.md

sidebar_position	sidebar_label
1	2023

2023 Changelog

ClickHouse release v23.3.14.78-lts (c8f4ba52c6) FIXME as compared to v23.3.13.6-lts (25635e2755)

Build/Testing/Packaging Improvement

• Backported in #54312: Fix strange additional QEMU logging after #47151, see https://s3.amazonaws.com/clickhouse-test-reports/50078/a4743996ee4f3583884d07bcd6501df0cfdaa346/stateless_tests__release__databasereplicated__[3_4].html. #50442 (Mikhail f. Shiryaev).
• Backported in #55391: Resource with source code including submodules is built in Darwin special build task. It may be used to build ClickHouse without checkouting submodules. #51435 (Ilya Yatsishin).
• Backported in #54703: Enrich changed_images.json with the latest tag from master for images that are not changed in the pull request. #54369 (János Benjamin Antal).
• Backported in #54679: We build and upload them for every push, which isn't worth it. #54675 (Mikhail f. Shiryaev).

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

• Fix parameterized view with cte and multiple usage #52328 (SmitaRKulkarni).
• Check recursion depth in OptimizedRegularExpression #52451 (Alexey Milovidov).
• Fix lightweight delete after drop of projection #52517 (Anton Popov).
• Fix sorting of sparse columns with large limit #52827 (Anton Popov).
• Fix adding sub-second intervals to DateTime #53309 (Michael Kolupaev).
• Fix: allow IPv6 for bloom filter #54200 (Yakov Olkhovskiy).
• Check for overflow before addition in analysisOfVariance function #54385 (Antonio Andelic).
• reproduce and fix the bug in removeSharedRecursive #54430 (Sema Checherinda).
• Fix aggregate projections with normalized states #54480 (Amos Bird).
• Fix possible parsing error in WithNames formats with disabled input_format_with_names_use_header #54513 (Kruglov Pavel).
• Fix "Invalid number of rows in Chunk" in MaterializedPostgreSQL #54844 (Kseniia Sumarokova).
• Prevent attaching parts from tables with different projections or indices #55062 (János Benjamin Antal).
• Fix trash optimization (up to a certain extent) #55353 (Alexey Milovidov).
• Fix parsing of arrays in cast operator #55417 (Anton Popov).

NO CL ENTRY

• NO CL ENTRY: 'Revert "Backport #54430 to 23.3: reproduce and fix the bug in removeSharedRecursive"'. #54731 (Mikhail f. Shiryaev).

NOT FOR CHANGELOG / INSIGNIFICANT

• Test libunwind changes. #51436 (Nikolai Kochetov).
• Refactor CI_CONFIG #52948 (Mikhail f. Shiryaev).
• Use pathlib.Path in S3Helper, rewrite build reports, improve small things #54010 (Mikhail f. Shiryaev).
• Fixed parameterized_view test after backporting a fix 23.3 #54401 (SmitaRKulkarni).
• Update automated commit status comment #54441 (vdimir).
• S3 artifacts #54504 (Mikhail f. Shiryaev).
• Fix CI skip build and skip tests checks #54532 (SmitaRKulkarni).
• Update WebObjectStorage.cpp #54695 (Kseniia Sumarokova).
• Do not set PR status label #54799 (vdimir).
• Get rid of the most of os.path stuff #55028 (Mikhail f. Shiryaev).
• check if block is empty after async insert retries #55143 (Han Fei).
• MaterializedPostgreSQL: remove back check #55297 (Kseniia Sumarokova).
• Remove existing moving/ dir if allow_remove_stale_moving_parts is off #55480 (Mike Kot).