Release Notes for MariaDB Enterprise ColumnStore 23.10.1

Overview

MariaDB Enterprise ColumnStore 23.10.1 is a feature release of MariaDB Enterprise ColumnStore. MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server.

MariaDB Enterprise ColumnStore 23.10.1 was released on 2024-03-11. This release is of General Availability (GA) maturity. MariaDB Enterprise ColumnStore 23.10.1 is a GA release in the 23.10 series.

This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.6.17-12.

The changes listed here are relative to MariaDB Enterprise ColumnStore 23.02.4.

Notable Changes

  • Cross db table rename fails (MCOL-4202)

  • Columnstore throws error when using GROUP BY on DB-Views where field name is identical in two different tables (MCOL-5463)

  • GROUP BY on duplicate expressions using functions throws error "IDB-2001: ... is not in GROUP BY clause." on Columnstore (MCOL-5476)

  • Support WITH ROLLUP (MCOL-678)

Issues Fixed

Can result in data loss

  • Shmem segment remap causes SEGV in ExtentMapIndexImpl::find (MCOL-5559)

Can result in a hang or crash

  • Queries stuck in MariaDB waiting for an answer from PrimProc (MCOL-5565)

  • LIKE '%1%' in WHERE part never finishes (MCOL-5599)

  • PrimProc goes in a loop, 100% CPU usage on a single core (MCOL-5602)

  • PrimProc crashes in json_key_matches (MCOL-5607)

  • FairThreadScheduler::sendErrorMsg and BPPSeeder::sendErrorMsg crash PP trying to send to a nullptr sock (MCOL-5636)

Can result in unexpected behavior

  • UPDATE returns wrong "Rows matched" on multi-tables (MCOL-4740)

  • json data returns differently by same query (MCOL-5350)

  • Columnstore query returns incorrect value instead of expected out-of-range error (MCOL-5568)

  • JSON_QUERY is stateful (may segfault on big amount of data) (MCOL-5625)

  • Continuous workload triggers unknown primitive cmd message in PP log (MCOL-5637)

Platforms

In alignment to the enterprise lifecycle, MariaDB Enterprise ColumnStore 23.10.1 is provided for:

  • CentOS 7 (x86_64)

  • Debian 11 (x86_64, ARM64)

  • Debian 12 (x86_64, ARM64)

  • Red Hat Enterprise Linux 7 (x86_64)

  • Red Hat Enterprise Linux 8 (x86_64, ARM64)

  • Red Hat Enterprise Linux 9 (x86_64, ARM64)

  • Rocky Linux 8 (x86_64, ARM64)

  • Rocky Linux 9 (x86_64, ARM64)

  • Ubuntu 20.04 (x86_64, ARM64)

  • Ubuntu 22.04 (x86_64, ARM64)