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
andpostConfigure
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 usessystemd
for administrationThe new
systemd
service calledmariadb-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 andORDER 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 DNS error
MessageQueueClient :: setup (): unknown name or service - ExeMgr = unassigned
(MCOL-2181)Fixes truncation during updates causing the Server to assert. (MCOL-3749)
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()
ofregr_sxx
,regr-sxy
, andregr_syy
(MCOL-3837)Fixes Server aborting when
Columnstore.xml
is missing. (MCOL-3853)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
inORDER BY
withlong double
(MCOL-3904)Fixes error message pointing to wrong function. (MCOL-3924)
Fixes memory leak in XML parser. (MCOL-3934)
Fixes microsecond support for FROM_UNIXTIME() function. (MCOL-3959)
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.
Last updated
Was this helpful?