Release Notes for MariaDB ColumnStore 1.4.3

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. (MCOL-3686)

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

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

  • Support added to cpimport for S3 storage with multi-PM (multi-performance module). (MCOL-3520)

Issues Fixed

Can result in data loss

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

Can result in a hang or crash

  • Server aborts if Columnstore.xml is missing. (MCOL-3680, MCOL-3853)

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

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

  • Truncation during UPDATE can cause crash. (MCOL-3749)

  • Failure to sync timezone variable between queries can trigger a hang. (MCOL-3776)

  • Failure in disk space pre-allocation for non-compressed data can trigger a crash in cpimport . (MCOL-3791)

Can result in unexpected behavior

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

  • Incorrect query validation for complex ORDER BY (MCOL-975)

  • NOT IN subquery does not return rows with NULL qualifying column values. (MCOL-1734)

  • GROUP BY doesn't process IN and correlate subquery. (MCOL-1963)

  • GROUP BY doesn't process NOT IN and correlate subquery with aggregates. (MCOL-1964)

  • Matched and changed row counts may be zero even if rows are changed (Rows matched: 0  Changed: 0). (MCOL-2239)

  • Queries containing SPACE() may return error 1178. (MCOL-3473)

    ERROR 1178 (42000) at line 1: The storage engine for the table
    doesn't support IDB-1001: Function 'space' can only be used in
    the outermost select or order by clause and cannot be used in
    conjunction with an aggregate function.
    
  • StorageManager may log inconsistently. (MCOL-3638)

  • COUNT with DISTINCT and two columns may fail. (MCOL-3662)

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

  • Impossible WHERE and HAVING conditions skipping may generate spurious warnings. (MCOL-3769)

  • Failure to start when Server is rebooted without mcsadmin shutdownSystem first. (MCOL-3829)

  • ORDER BY over negative SEC_TO_TIME() results produce an incorrect order. (MCOL-3598)

  • Stopping Server with systemd triggers restart by ColumnStore. (MCOL-3718)

  • Note: 1618 COLLATE is ignored in ColumnStore was not correctly surfaced. (MCOL-3721)

  • Subqueries with ORDER BY ... LIMIT may produce incorrect result. (MCOL-3747)

Known Issues

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

  • LIKE and NOT LIKE 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.3 is provided for:

  • Red Hat Enterprise Linux 8

  • Red Hat Enterprise Linux 7

  • CentOS 8

  • CentOS 7

  • Ubuntu 18.04

  • Ubuntu 16.04

  • Debian 10

  • Debian 9

  • SUSE Linux Enterprise Server 15

  • SUSE Linux Enterprise Server 12

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