MariaDB ColumnStore 1.4.4 Release Notes

Overview

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

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

MariaDB ColumnStore 1.4.4 was released on 2020-06-08.

Notable Changes

columnstore_use_import_for_batchinsert system variable option ALWAYS added to use cpimport for LOAD DATA LOCAL INFILE and INSERT .. SELECT regardless of whether the query runs in a transaction. This gives the user the ability to use a faster import method, with the caveat that if a user issues a rollback of the transaction, it will have no effect as the data would have already been committed to actual database files by cpimport. ()

Issues Fixed

Can result in data loss

• can modify incorrect data due to incorrect WHERE clause handling. ()

Can result in a hang or crash

• A hang may occur in load_brm on dbroot1 failover. ()

• may be blocked by improper failover. ()

• Crash may occur when using cpimport () to process data containing multi-byte characters. ()

Can result in unexpected behavior

• over negative SEC_TO_TIME() results produce an incorrect order. ()

• Subqueries with ORDER and LIMIT may produce the wrong answer. ()

• clause in WHERE could be evaluated improperly. ()

Related to performance

• Subquery wrapping impacts performance. ()

• Unoptimized lines (CPU impact and unnecessary rounding error) in regr_sxx, regr-sxy, and regr_syy ()

Related to install and upgrade

• postConfigure uses invalid device nodes for dbroots. ()

• startsystem allows startup without correct DBROOT 1 assignment. ()

• Incorrect handling of unassigned IP addresses in configuration file. ()

Known Issues

• Built-in SQL functions do not work in ColumnStore when sql_mode=ORACLE ()

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".