Release Notes for MariaDB Enterprise ColumnStore 5.5.2

Topics on this page:

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.

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)

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

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)

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)

Configuration files not moved back into place after in-place upgrade. (MCOL-4597)

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