Release Notes for MariaDB Enterprise ColumnStore 23.02.1

Overview

MariaDB Enterprise ColumnStore 23.02.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.02.1 was released on 2023-03-13. This release is of General Availability (GA) maturity. MariaDB Enterprise ColumnStore 23.02.1 is the first GA release in the 23.02 series.

MariaDB Enterprise ColumnStore 23.02 replaces MariaDB Enterprise ColumnStore 22.08 in MariaDB Enterprise Server 10.6.

This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.6.12-7.

Users of earlier MariaDB Enterprise ColumnStore releases are encouraged to upgrade.

Notable Changes

  • Support added for loading data from AWS S3 via a UDF columnstore_info.load_from_s3 which allows data loading with cpimport for those with no access to the command line. (MCOL-5013)

  • Allow pushdown of queries involving UNION in outer SELECT to ColumnStore engine. (MCOL-4901)

  • MariaDB Enterprise ColumnStore 23.02.1 is confirmed to be compatible with TPC-H benchmark tests.

  • Starting with this release, GROUP BY handler is disabled by default. GROUP BY pushdown may produce unexpected results. In prior releases, GROUP BY handler was rarely used because it was last in precedence. (MCOL-5400)

  • UNION ALL with wrapped selects supports GROUP BY clause. (MCOL-4937)

  • UNION with signed and unsigned integer types is supported. (MCOL-5205)

  • UNION operations that can overflow the maximum supported DECIMAL precision of 38 digits generate the following error: (MCOL-5215)

    ERROR 1178 (42000): The storage engine for the table doesn't support MCS-2060: Union operation exceeds maximum DECIMAL precision of 38
    

Platforms

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

  • CentOS 7 (x86_64)

  • Debian 11 (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)