MariaDB ColumnStore 1.4.3 Release Notes

Overview

MariaDB ColumnStore is a columnar storage engine. This is the first GA release in the ColumnStore 1.4 series. This release contains new features and fixes, compared to MariaDB ColumnStore 1.4.2.

This release of MariaDB ColumnStore is included with MariaDB Enterprise Server 10.4.12-6.

MariaDB ColumnStore 1.4.3 was released on 2020-03-02.

Notable Changes

• MariaDB ColumnStore 1.4.3 is the first Generally Available (GA) release of the ColumnStore 1.4 release series. ()

• Support added for ALTER TABLE ... ENGINE=ColumnStore ()

• Support added for CREATE TABLE ... ENGINE=ColumnStore AS SELECT ... ()

Issues Fixed

Can result in data loss

• Potential data loss with S3 StorageManager when mcsadmin suspendDataWrites returns before S3 sync is complete. ()

Can result in a hang or crash

• Server aborts if Columnstore.xml is missing. (, )

• A User Module (UM) join memory overflow can cause session hang and fail to free memory. ()

• Improper StorageManager shutdown can result if process is killed by fatal error. ()

• Truncation during

Can result in unexpected behavior

• Incorrect comparison of padded string vs. non-padded column. ()

• Incorrect query validation for complex ORDER BY ()

• subquery does not return rows with NULL qualifying column values. ()

• GROUP BY

• StorageManager may log inconsistently. ()

• with DISTINCT and two columns may fail. ()

• If min/max are set, incorrect results may be provided after a cpimport due to incorrect extent elimination. ()

• Impossible

Related to performance

• Performance regression in and ()

• Slow DDL statement execution after a restart. ()

Related to install and upgrade

• postConfigure aborted due to missing /tmp/columnstore_tmp_files directory. ()

• postConfigure output 'unassigned' alias script name. ()

• columnstore-post-install isn't triggered during package install. (

Known Issues

• Performance of some queries, such as those containing UNION, may be worse than on ColumnStore 1.2.x.

• and queries currently fall back to a slower execution method.

Interface Changes

• None.

Platforms

In alignment to the MariaDB Corporation Engineering Policy, MariaDB ColumnStore 1.4.4 is provided for:

• Red Hat Enterprise Linux 8

• Red Hat Enterprise Linux 7

• CentOS 8

• CentOS 7

Note: MariaDB Enterprise ColumnStore 1.4 is no longer supported. If you would like to deploy Enterprise ColumnStore, please use MariaDB Enterprise ColumnStore 5 or later. For installation and upgrade instructions, see "Deploy".