Release Notes for MariaDB ColumnStore 1.5.2
MariaDB ColumnStore is a columnar storage engine for MariaDB 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. It is a beta release.
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.
See Installation for more details.
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.See OAM Replacement for more details.
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.
Bug Fixes
Fixes
IN
not evaluating properly inWHERE
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()
ofregr_sxx
,regr-sxy
, andregr_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
inORDER BY
withlong 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
instoragemanager.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 ColumnStore 1.5.2 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 ColumnStore 1.5 has been superseded by MariaDB ColumnStore 5.5 in MariaDB Enterprise Server 10.5. For installation and upgrade instructions, see Deploy MariaDB ColumnStore 5.4 with MariaDB Community Server 10.5.