ClickHouse/docs/changelogs/v23.8.9.54-lts.md
2024-05-30 18:10:12 +02:00

8.2 KiB

sidebar_position sidebar_label
1 2024

2024 Changelog

ClickHouse release v23.8.9.54-lts (192a1d231f) FIXME as compared to v23.8.8.20-lts (5e012a03bf)

Improvement

  • Backported in #57668: Output valid JSON/XML on excetpion during HTTP query execution. Add setting http_write_exception_in_output_format to enable/disable this behaviour (enabled by default). #52853 (Kruglov Pavel).
  • Backported in #58491: Fix transfer query to MySQL compatible query. Fixes #57253. Fixes #52654. Fixes #56729. #56456 (flynn).
  • Backported in #57238: Fetching a part waits when that part is fully committed on remote replica. It is better not send part in PreActive state. In case of zero copy this is mandatory restriction. #56808 (Sema Checherinda).
  • Backported in #57655: Handle sigabrt case when getting PostgreSQl table structure with empty array. #57618 (Mikhail Kot).

Build/Testing/Packaging Improvement

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

  • Backported in #58324: Flatten only true Nested type if flatten_nested=1, not all Array(Tuple). #56132 (Kruglov Pavel).
  • Backported in #57395: Fix ALTER COLUMN with ALIAS that previously threw the NO_SUCH_COLUMN_IN_TABLE exception. Closes #50927. #56493 (Nikolay Degterinsky).
  • Backported in #57449: Now ALTER columns which are incompatible with columns used in some projections will be forbidden. Previously it could result in incorrect data. This fixes #56932. This PR also allows RENAME of index columns, and improves the exception message by providing clear information on the affected indices or projections causing the prevention. #56948 (Amos Bird).
  • Backported in #57281: Fix segfault after ALTER UPDATE with Nullable MATERIALIZED column. Closes #42918. #57147 (Nikolay Degterinsky).
  • Backported in #57247: Fix incorrect JOIN plan optimization with partially materialized normal projection. This fixes #57194. #57196 (Amos Bird).
  • Backported in #57346: Fix ReadonlyReplica metric for some cases (e.g. when a table cannot be initialized because of difference in local and Keeper data). #57267 (Antonio Andelic).
  • Backported in #58434: Fix working with read buffers in StreamingFormatExecutor, previously it could lead to segfaults in Kafka and other streaming engines. #57438 (Kruglov Pavel).
  • Backported in #57539: Fix parsing of SYSTEM STOP LISTEN TCP SECURE. #57483 (joelynch).
  • Backported in #57779: Conf <user_directories> <replicated> <zookeeper_path>/clickhouse/access/</zookeeper_path> </replicated> </user_directories> sql ``` show settings like 'ignore_on_cluster_for_replicated_access_entities_queries' ┌─name─────────────────────────────────────────────────────┬─type─┬─value─┐ │ ignore_on_cluster_for_replicated_access_entities_queries │ bool │ 1 │ └──────────────────────────────────────────────────────────┴──────┴───────┘. #57538 (MikhailBurdukov).
  • Backported in #58256: Disable system.kafka_consumers by default (due to possible live memory leak). #57822 (Azat Khuzhin).
  • Backported in #57923: Fix invalid memory access in BLAKE3. #57876 (Raúl Marín).
  • Backported in #58084: Normilize function names in CREATE INDEX query. Avoid Existing table metadata in ZooKeeper differs in skip indexes errors if an alias was used insead of canonical function name when creating an index. #57906 (Alexander Tokmakov).
  • Backported in #58110: Keeper fix: Leader should correctly fail on preprocessing a request if it is not initialized. #58069 (Antonio Andelic).
  • Backported in #58155: Fix Integer overflow in Poco::UTF32Encoding. #58073 (Andrey Fedotov).
  • Backported in #58188: Parallel parsing for JSONCompactEachRow could work incorrectly in previous versions. This closes #58180. #58181 (Alexey Milovidov).
  • Backported in #58301: Fix parallel parsing for JSONCompactEachRow. #58250 (Kruglov Pavel).

NO CL ENTRY

NOT FOR CHANGELOG / INSIGNIFICANT