MariaDB ColumnStore 23.10.1 Release Notes

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 ()

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

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

• Support WITH ROLLUP ()

Issues Fixed

Can result in data loss

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

Can result in a hang or crash

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

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

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

• PrimProc crashes in json_key_matches ()

Can result in unexpected behavior

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

• json data returns differently by same query ()

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

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

Related to performance

• CPU wastes time in wait and sys because of urandom access in RowStorage ()

Related to install and upgrade

• Wrong metadata in CMAPI packages ()

Platforms

In alignment with the , MariaDB Enterprise ColumnStore 23.10.1 is provided for:

• Debian 11 (x86_64, ARM64)

• Debian 12 (x86_64, ARM64)

• Red Hat Enterprise Linux 8 (x86_64, ARM64)

• Red Hat Enterprise Linux 9 (x86_64, ARM64)

Installation Instructions

Upgrade Instructions

• Upgrade Multi-Node MariaDB Enterprise ColumnStore from 6 to 23.10