All pages
Powered by GitBook
1 of 3

MariaDB ColumnStore 1.5 Release Notes

Release notes for MariaDB ColumnStore 1.5

MariaDB ColumnStore 1.5.2 Release Notes

Overview

MariaDB ColumnStore is a columnar storage engine included with MariaDB Enterprise Server. This release of MariaDB ColumnStore is included with MariaDB Community Server 10.5.4.

MariaDB ColumnStore 1.5.2 was released on 2020-06-24. It is the first release in the MariaDB ColumnStore 1.5 series. This release is of Beta maturity, and should not be used with production workloads.

Notable Changes

  • Comprehensive rewrite of installation and administration logic. (MCOL-3836)

  • Simplified installation:

    • Users no longer need to execute columnstore-post-install and postConfigure

    • It is a plugin for MariaDB Community Server.

    • It is packaged similar to other MariaDB Community Server plugins.

  • Simplified administration:

    • mcsadmin has been removed. Instead, ColumnStore 1.5 uses systemd for administration

    • The new systemd service called mariadb-columnstore is used to manage ColumnStore's processes.

  • Support for standard MariaDB Community Server collation and character sets. (MCOL-337)

  • Improved performance for REGR_* functions. (MCOL-3837)

  • Fixes for defects in tiered storage and S3-compatible object storage.

New Features

  • Support to set up tempfiles.d to prevent the OS from flushing /tmp on reboot. (MCOL-2101)

  • Support for faster replication-slave processing. (MCOL-3835)

  • Implements ISTRUE() function. (MCOL-3756)

  • Creates a systemd unit file for the MariaDB ColumnStore service. (MCOL-3914)

  • Implements MCSNodeControl package. (MCOL-3920)

  • Implements REST API server. (MCOL-3921)

  • Merges 3 MariaDB ColumnStore packages into a single package. (MCOL-3991)

  • Changing systemlang to an unrecognized string now causes MariaDB ColumnStore to not start up. (MCOL-3420)

  • Support for ALTER TABLE conversion to MariaDB ColumnStore. (MCOL-3852)

  • Support for COLLATE in DDL and ORDER BY clauses. (MCOL-3862)

  • Improvements in failover design. (MCOL-3886)

Changed Features

  • loadbrm process rewritten in Python (mcs-loadbrm.py). Now requires Python 3 as a dependency.

Issues Fixed

  • Fixes IN not evaluating properly in WHERE clauses. (MCOL-2096)

  • Fixes DNS error MessageQueueClient :: setup (): unknown name or service - ExeMgr = unassigned (MCOL-2181)

  • Fixes FILE001.cdf:No such file or directory error when query, TRUNCATE and cpimport collided. (MCOL-3251)

  • Fixes internal error IDB-2035 to BIT_OR() function in projection and subquery. (MCOL-3356)

  • Fixes wrong minimum and maximum values after cpimport causing wrong SELECT statement results. (MCOL-3716)

  • Fixes truncation during updates causing the Server to assert. (MCOL-3749)

  • Fixes RAND() function returning different results in 1.4 compared to 1.2. (MCOL-3760)

  • Fixes issue where the same erroneous statement returns a different error other run. (MCOL-3777)

  • Fixes GROUP BY ordering error: IDB-2021: 'ref_genome' is not in GROUP BY clause (MCOL-3782)

  • Fixes MariaDB asserts when connection is closed. (MCOL-3812)

  • Fixes incorrect counts in views. (MCOL-3813)

  • Fixes issue in UNION operations about table not being in query. (MCOL-3828)

  • Fixes issue where systemctl cat mariadb.service is not working on all systems. (MCOL-3830)

  • Optimizes execute() of regr_sxx, regr-sxy, and regr_syy (MCOL-3837)

  • Fixes COUNT() as window function not working with NULL values. (MCOL-3839)

  • Fixes Server aborting when Columnstore.xml is missing. (MCOL-3853)

  • Fixes COUNT() with distinct and 2 columns failing on every other execution. (MCOL-3857)

  • Fixes vTpch22.sql hanging. (MCOL-3858)

  • Fixes issue where renaming table causes schema to go out of sync. (MCOL-3859)

  • Fixes errors raised by every other run of the EXPLAIN statement. (MCOL-3860)

  • Fixes fatalHandler usage. (MCOL-3864)

  • Fixes intermittent cpimport crashes. (MCOL-3865)

  • Fixes bug3333.sql mismatch. (MCOL-3894)

  • Fixes fails in Group_concat in ORDER BY with long double (MCOL-3904)

  • Fixes error message pointing to wrong function. (MCOL-3924)

  • Fixes memory leak in XML parser. (MCOL-3934)

  • Fixes IF() function returning incorrect results when using hex constant. (MCOL-3949)

  • Fixes microsecond support for FROM_UNIXTIME() function. (MCOL-3959)

  • Fixes issue with single INSERT after a LDI in a transaction. (MCOL-4002)

  • Fixes issue using $HOME in storagemanager.cnf variable. (MCOL-4014)

  • Fixes mishandling of multi-byte characters in DML export to cpimport-1.5. (MCOL-4017)

  • Fixes window function issues due to 1.4 returning results where 1.2 returns errors. (MCOL-3856)

  • Fixes cpimport S3 multi-PM usage. (MCOL-3861)

Platforms

In alignment to the MariaDB Corporation Engineering Policy, MariaDB Enterprise ColumnStore 1.5.3 is provided for:

  • Red Hat Enterprise Linux 8

  • Red Hat Enterprise Linux 7

  • CentOS 8

  • CentOS 7

  • Ubuntu 20.04

  • 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.5 has been superseded by MariaDB Enterprise ColumnStore 5 in MariaDB Enterprise Server 10.5.

This page is: Copyright © 2025 MariaDB. All rights reserved.

MariaDB ColumnStore 1.5.3 Release Notes

Overview

MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server. This is the first release in the Enterprise ColumnStore 1.5 series, and marks the first major release since integration with MariaDB Enterprise Server.

This release is focused on architectural change, product quality, and improved alignment to MariaDB Enterprise Server.

This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.5.4-2.

This release is of Gamma maturity, and should not be used with production workloads.

MariaDB Enterprise ColumnStore 1.5.3 was released on 2020-07-16.

Notable Changes

  • Comprehensive rewrite of installation, administration, cluster management, and failover logic. (MCOL-3836)

  • Simplified installation

    • Users no longer need to execute columnstore-post-install and postConfigure

    • It is a plugin for MariaDB Enterprise Server.

    • It is packaged similar to other MariaDB Enterprise Server plugins.

    • See Installation for more details.

  • Simplified administration:

    • mcsadmin has been removed. Instead, Enterprise ColumnStore 1.5 uses systemd for administration of single-node and multi-node deployments, and it also adds a new REST API for administration of multi-node deployments.

    • The new systemd service called mariadb-columnstore is used to manage ColumnStore's processes.

    • The new REST API is used to manage multi-node ColumnStore deployments.

    • The new REST API provides an interface for MariaDB MaxScale 2.5 to orchestrate the multi-node Enterprise ColumnStore deployment.

    • See OAM Replacement for more details.

  • This release was the source for fixes previously backported to ColumnStore 1.4.4.

  • This release includes correction of regressions present in ColumnStore 1.4.4 vs pre-integration.

  • Fixes for defects in tiered storage and S3-compatible object storage.

  • Support for standard MariaDB Enterprise Server collation and character sets. (MCOL-337)

  • Improved performance for REGR_* functions. (MCOL-3837)

Issues Fixed

Can result in a hang or crash

  • mariadbd will abort if Columnstore.xml is missing. (MCOL-3853)

  • Intermittent crash of cpimport in some complicated workflows. (MCOL-3865)

  • Exceeding thread limits will cause queries against S3-compatible object storage to hang. (MCOL-3858)

  • Error was not properly returned when a COMMIT or ROLLBACK failed, triggering an assertion. (MCOL-4124)

Can result in unexpected behavior

  • mcs-storagemanager attempted startup when not needed. (MCOL-4151)

  • COUNT(DISTINCT) on more than one column produces an error. (MCOL-3857)

  • REVERSE() function does not work with non-Latin characters. (MCOL-2221)

  • Multi-table DROP IF EXISTS generates an error instead of a warning. (MCOL-4164)

  • UPDATE with SELECT returning nulls may produce wrong answer. (MCOL-4116)

  • rand() calls with the same seed value return different results. (MCOL-3760)

  • Attempt to INSERT a TINYINT with an out-of-range value can generate a spurious error message. (MCOL-3777)

  • A query containing a Common Table Expression (CTE) can return the wrong error message, that a field is not in the GROUP BY clause even if it is. (MCOL-3782)

  • Complex queries using UNION can return the wrong error message, table not found. (MCOL-3828)

  • COUNT(NULL) doesn't work as a window function. (MCOL-3839)

  • The wrong error message is given when a function not supported by ColumnStore is used inside a function that is supported by ColumnStore. (MCOL-3924)

  • microsecond support for from_unixtime

  • INSERT after a LOAD DATA LOCAL INFILE in a transaction may silently fail. (MCOL-4002)

  • IN clause in WHERE could be evaluated improperly. (MCOL-2096)

  • A spurious "file not found" error message can occur when query, truncate, and cpimport collided. (MCOL-3521)

  • Internal error: IDB-2035 can occur with BIT_OR function in projection and subquery in FROM (MCOL-3356)

  • Multi-byte characters mishandled in DML export to cpimport-1.5. (MCOL-4017)

  • GROUP_CONCAT() with ORDER BY and long doubles may fail. (MCOL-3904)

  • CONV() returned less characters in the resulting string. (MCOL-3596)

  • MODA() produces memory leak. (MCOL-4042)

  • Memory leaks. (MCOL-4043, MCOL-3934)

  • EXPLAIN generates error on every other (alternating) execution. (MCOL-3860)

  • Renaming a table causes schema to become out of sync between MariaDB Server catalog and ColumnStore. (MCOL-3859)

  • Incorrect COUNT(*) with a complex view. (MCOL-3813)

Related to install and upgrade

  • storagemanager.cnf variable $HOME drew path from user's environment. $HOME now points to the current location of ColumnStore data. (MCOL-4014)

Known Issues

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

Interface Changes

None.

Platforms

In alignment to the MariaDB Corporation Engineering Policy, MariaDB Enterprise ColumnStore 1.5.3 is provided for:

  • Red Hat Enterprise Linux 8

  • Red Hat Enterprise Linux 7

  • CentOS 8

  • CentOS 7

  • Ubuntu 20.04

  • Ubuntu 18.04

  • Ubuntu 16.04

  • Debian 10

  • Debian 9

  • SUSE Linux Enterprise Server 15

  • SUSE Linux Enterprise Server 12

Installation Instructions

Upgrade Instructions

This page is: Copyright © 2025 MariaDB. All rights reserved.