Release Notes for MariaDB Enterprise ColumnStore 5.5.2

Overview

MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server. This is the fourth release in the Enterprise ColumnStore 5 series.

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

This release is of General Availability (GA) maturity.

MariaDB Enterprise ColumnStore 5.5.2 was released on 2021-03-15.

Notable Changes

  • Added the ec2_iam_mode=enabled option to storagemanager.cnf, which enables an EC2 instance to authenticate with S3 using its IAM role. (MCOL-4386)

  • Added support for CREATE TABLE AS SELECT .. COUNT() .. FROM .. GROUP BY .. (MCOL-3785)

  • Removed legacy OAM scripts. (MCOL-4193)

  • Consolidated ColumnStore log files in the /var/log/mariadb/columnstore/ directory. (MCOL-4483)

  • Moved CMAPI log files to the /var/log/mariadb/columnstore/cmapi/ directory. (MCOL-4494)

  • Added more logs to /etc/logrotate.d/columnstore configuration. (MCOL-4319)

  • Refactor ColumnStore systemd services to ensure startup waits for network connectivity. (MCOL-4170)

  • Results from SELECT .. ORDER BY BINARY(col) now match InnoDB. (MCOL-4454)

  • Results from FLOOR() function now match InnoDB for DATETIME, TIMESTAMP, and TIME columns. (MCOL-4263)

Issues Fixed

Can result in data loss

  • Extent map can become corrupted during startup under 5.5.1 with a large extent map and shared storage. (MCOL-4546)

Can result in a hang or crash

  • A join with different collations crashes the ExeMgr process. (MCOL-4470)

  • A time zone conversion results in a hang due to a deadlock in the thread pool. (MCOL-4486)

  • When replication is used, INSERT INTO .. SELECT .. FROM ... results in a hang in the SQL thread. (MCOL-4515)

Can result in unexpected behavior

  • Error message from LOAD DATA INFILE statement mentions wrong path for .err and .bad files. (MCOL-571)

  • Table remains locked when ColumnStore is forced to restart. (MCOL-3324)

  • CREATE TABLE AS SELECT .. LIMIT 0 writes a row to the table. (MCOL-4453)

  • SELECT DISTINCT col FROM TABLE LIMIT offset, limit statement ignores offset. (MCOL-4455)

  • Results from a query with both a left join and an inner join are incorrect. (MCOL-4493)

  • Performance regression for queries that filter on small CHAR columns that use latin1 character set. (MCOL-4527)

  • Queries on big tables that filter on small CHAR columns ignore the collation. (MCOL-4539)

  • Results from a UDAF are incorrect when executed in a non-distributed manner. (MCOL-4585)

Platforms

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

  • CentOS 7

  • CentOS 8

  • Debian 9

  • Debian 10

  • Red Hat Enterprise Linux 7

  • Red Hat Enterprise Linux 8

  • SUSE Linux Enterprise Server 12

  • SUSE Linux Enterprise Server 15

  • Ubuntu 16.04

  • Ubuntu 18.04

  • Ubuntu 20.04