Maintenance Release Changelog v8.9

Enhancement: Improve behavior of garbage collection for plancache.

Bugfix: Fixed a bug caused by using a (cross-segment) vector index (Vector Indexing) with null vectors. Users on prior 8.9 versions will need to recreate (drop and add) vector indexes for this fix to be effective as the cross-segment indexes are built in the background.

Bugfix: Fixes a data-dependent crash condition occurring in certain TABLE(JSON_TO_ARRAY(... joins introduced in version 8.9.

Enhancement: Added new nori (Korean) analyzer customizations for Full-Text Search V2.

Enhancement: Added support for updated Standard and Enterprise licenses.

Enhancement: Added logging for LRU compiled unit eviction.

Enhancement: Fixed out of memory (OOM) errors and extra memory usage in Iceberg ingest. Introduced global engine variable pipelines_iceberg_data_workers_heap_size to control memory consumption on leaves.

Enhancement: Introduced new JSON_BUILD_ARRAY function.

Enhancement: Introduced support for placeholders for partition ID and timestamp in the SELECT INTO ... file name command.

Bugfix: Fixed a bug causing accumulation of .rem files on disk.

Bugfix: Fixed a small memory bug in columnstore scans that use the JSON_TO_ARRAY join optimization.

Bugfix: Fixed a crash in JSON_EXTRACT_STRING.

Bugfix: Fixed a bug with updates and asserts using JSON_ARRAY_CONTAINS_<type> predicates.

Bugfix: Fixed bottomless upload throttling criteria.

Bugfix: Blocked creation of temporary table as a shallow copy.

Bugfix: Resolved an issue where an in-development subsystem can leak files on disk

Enhancement: Added Korean language analyzer for full-text search V2.

Enhancement: Added support to infer CSV files with a single column when the file contains no field terminators in any record.

Enhancement: Relaxed dependency on partition count of leaf nodes for leaf plans.

Bugfix: Fixed handling of heartbeat messages in the MongoDB extractor in debug mode.

Bugfix: Fixed display of default BSON and string values with null-terminators in the information schema.

Bugfix: Removed trailing dot for decimal column types that have scale equal to 0.

Bugfix: Fixed IN-list index matching for columnstore tables when a query has multiple IN-list predicates.

Bugfix: Fixed a bug that caused an invalid optree error after the JsonArrayContainsToTableBuiltin rewrite.

Bugfix: Fixed a crash that occurred during spilling when executing a query with a large number of GROUP BY columns.

Bugfix: Fixed performance regression in Vector Search when using DOT_PRODUCT metric.

Bugfix: Added an optional 'swap_time' argument to UUID_TO_BIN and BIN_TO_UUID functions.

Bugfix: Allowed cached table memory to be freed for empty tables in replica databases.

Bugfix: Fixed a lateral join parsing bug.