MariaDB ColumnStore is a columnar storage engine included with MariaDB Enterprise Server. This is the third release in the ColumnStore 5 series.
This release of MariaDB ColumnStore is included with MariaDB Enterprise Server 10.5.8-5.
This release is of General Availability (GA) maturity.
MariaDB ColumnStore 5.5.1 was released on 2020-12-14.
Documentation
Notable Changes
ColumnStore VARCHAR was sized in bytes, which required customers with multi-byte data to account for the byte variance within their capacity calculations and column definitions. VARCHAR is now sized by characters (which may be multi-byte) in alignment to the behavior of InnoDB and as required by SQL standard (ISO/IEC 9075:2016 feature E021 - Character string types). ()
Non-equality comparison operators previously produced storage engine-specific results with NOPAD collations. This behavior now aligns to the behavior of InnoDB. ()
Added ENCODE() and DECODE() function support. ()
ColumnStore now respects case-insensitive comparison during JOIN when called for by the specified collation. (, )
Enhanced performance of multi-node ColumnStore startup. ()
Possible crash in mariadbd when calling stored procedures in the columnstore_info database. ()
INSERT .. SELECT hangs on cpimport when MariaDB ColumnStore is installed in a non-default path. ()
Incorrect error message shown when using unsupported JSON functions. ()
Equality does not respect the NOPAD collation attribute. ()
ROUND() function returns incorrect answer for DATE data type. (, )
mcs-loadbrm and mcs-savebrm have hard coded paths to load_brm and save_brm ()
In-place upgrade from 1.5 to 5.5 failed due to DEB package conflicts. ()
A configuration file x-columnstore.cnf previously existed during Beta and Gamma releases of ColumnStore. This file has been removed as it is no longer required. ()
In alignment with the , MariaDB ColumnStore 5.5.1 is provided for:
MariaDB ColumnStore is a columnar storage engine that is included with the MariaDB Enterprise Server. This is the fourth release in the ColumnStore 5 series.
This release of MariaDB ColumnStore is included with MariaDB Enterprise Server 10.5.9-6.
This release is of General Availability (GA) maturity.
MariaDB 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 .. ()
Removed legacy OAM scripts. ()
Consolidated ColumnStore log files in the /var/log/mariadb/columnstore/ directory. ()
Moved CMAPI log files to the /var/log/mariadb/columnstore/cmapi/ directory. ()
Added more logs to /etc/logrotate.d/columnstore configuration. ()
Refactor ColumnStore systemd services to ensure startup waits for network connectivity. ()
Results from SELECT .. ORDER BY BINARY(col) now match InnoDB. ()
Results from FLOOR() function now match InnoDB for DATETIME, TIMESTAMP, and TIME columns. ()
Extent map can become corrupted during startup under 5.5.1 with a large extent map and shared storage. ()
A join with different collations crashes the ExeMgr process. ()
A time zone conversion results in a hang due to a deadlock in the thread pool. ()
When replication is used, INSERT INTO .. SELECT .. FROM ... results in a hang in the SQL thread. ()
Error message from LOAD DATA INFILE statement mentions wrong path for .err and .bad files. ()
Table remains locked when ColumnStore is forced to restart. ()
CREATE TABLE AS SELECT .. LIMIT 0 writes a row to the table. ()
Configuration files not moved back into place after in-place upgrade. ()
In alignment with the , MariaDB ColumnStore 5.5.2 is provided for: