Altinity Stable for ClickHouse 22.8.20 Release Notes

Changes Compared to Upstream v22.8.20.11-lts

Bug fix

• Don’t execute and/or/if/multiIf on LowCardinality dictionary (#44469 via #283)
• Fix Block structure mismatch in Pipe::unitePipes for FINAL (#51492 via #278
• Arrow wouldn’t abort process in case of error in input file (#45478 by @Avogar via #242)
• Fix nullptr dereference in DB::VolumeJBOD::reserve (#41483 - via #241)
• Fix base58Encode / base58Decode handling leading 0 / ‘1’ (#40620 by @zvonand via #224)
• Flatten list type arrow chunks on parsing (#43297 via #209)

Improvement

• Added support of chunked arrow/parquet arrays (#40485 by @arthurpassos via #223)
• Increase request_timeout_ms for s3 disks (#42321 by @filimonov via #222)
• Improved stale replica recovery process for ReplicatedMergeTree (#42134 by @tavplubix, #41945 by @alesapin via #221)

Security

• Fixed CVEs in the clickhouse-diagnostics utility

Changes in upstream from v22.8.15.23-lts to v22.8.20.11-lts

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

• Fix broken index analysis when binary operator contains a null constant argument #50177 (Amos Bird).
• Fix incorrect constant folding #50536 (Alexey Milovidov).
• Fix fuzzer failure in ActionsDAG #51301 (Alexey Milovidov).
• Fix segfault in MathUnary #51499 (Ilya Yatsishin).
• Fix subtly broken copy-on-write of ColumnLowCardinality dictionary #51064 (Michael Kolupaev).
• Generate safe IVs #51086 (Salvatore Mesoraca).
• Fix bad cast from LowCardinality column when using short circuit function execution #43311 (Kruglov Pavel).
• Fix msan issue in randomStringUTF8() #49750 (Robert Schulze).
• JIT compilation not equals NaN fix #50056 (Maksim Kita).
• Fix crash with multiIf and constant condition and nullable arguments #50123 (Anton Popov).
• Fixed type conversion from Date/Date32 to DateTime64 when querying with DateTime64 index #50280 (Lucas Chang).
• Fix Keeper deadlock on exception when preprocessing requests. #50387 (frinkr).
• Fix Log family table return wrong rows count after truncate #50585 (flynn).
• Do not read all the columns from right GLOBAL JOIN table. #50721 (Nikolai Kochetov).
• Fix explain graph with projection #47473 (flynn).
• Disable compile_aggregate_expressions by default #48195 (Alexey Milovidov).
• Fix possible segfault in cache #48469 (Kseniia Sumarokova).
• Fix bug in Keeper when a node is not created with scheme auth in ACL sometimes. #48595 (Aleksei Filatov).
• Fix bug in zero-copy replication disk choice during fetch #47010 (alesapin).
• Fix query parameters #47488 (Alexey Milovidov).
• Fix wait for zero copy lock during move #47631 (alesapin).
• Fix crash in polygonsSymDifferenceCartesian #47702 (pufit).
• Backport to 22.8: Fix moving broken parts to the detached for the object storage disk on startup #48273 (Aleksei Filatov).

Performance Improvement

• Backported in #49214: Fixed excessive reading in queries with FINAL. #47801 (Nikita Taranov).

Improvement

• Backported in #48157: Fixed UNKNOWN_TABLE exception when attaching to a materialized view that has dependent tables that are not available. This might be useful when trying to restore state from a backup. #47975 (MikhailBurdukov).
  

---