MariaDB ColumnStore 1.4.4 Release Notes

Overview

MariaDB ColumnStore is a columnar storage engine. This is the second GA release in the ColumnStore 1.4 series. This release contains new features and fixes, compared to MariaDB ColumnStore 1.4.3.

This release of MariaDB ColumnStore is included with MariaDB Enterprise Server 10.4.13-7.

MariaDB ColumnStore 1.4.4 was released on 2020-06-08.

Notable Changes

columnstore_use_import_for_batchinsert system variable option ALWAYS added to use cpimport for LOAD DATA LOCAL INFILE and INSERT .. SELECT regardless of whether the query runs in a transaction. This gives the user the ability to use a faster import method, with the caveat that if a user issues a rollback of the transaction, it will have no effect as the data would have already been committed to actual database files by cpimport. (MCOL-4000)

Issues Fixed

Can result in data loss

• UPDATE can modify incorrect data due to incorrect WHERE clause handling. (MCOL-4023)

Can result in a hang or crash

• A hang may occur in load_brm on dbroot1 failover. (MCOL-3945)

• CREATE TABLE may be blocked by improper failover. (MCOL-3999)

• Crash may occur when using cpimport (LOAD DATA LOCAL INFILE) to process data containing multi-byte characters. (MCOL-4005)

• Rollback may trigger crash of StorageManager. (MCOL-4021)

• PM failover and movePmDbrootConfig failure on CentOS 7 with glusterfs. (MCOL-3842)

Can result in unexpected behavior

• ORDER BY over negative SEC_TO_TIME() results produce an incorrect order. (MCOL-3598)

• Subqueries with ORDER and LIMIT may produce the wrong answer. (MCOL-3747)

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

• Sub-query with GROUP BY and ORDER BY allows non-aggregates in projection. (MCOL-2166)

• FILE001.cdf:No such file or directory can occur when query, TRUNCATE and cpimport collide. (MCOL-3251)

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

• Incorrect handling of ORDER BY can occur in some queries. (MCOL-3485)

• Unexpected syntax errors could be returned from window functions. (MCOL-3580)

• Format(c1,0) returns only sign, without a digit, on a decimal(1) field. (MCOL-3595)

• TIMEDIFF() returns NULL instead of expected value. (MCOL-3597)

• MODA() and REGR_ UDAFs are not properly created. (MCOL-3599)

• BIT_COUNT(), CHARSET(), UNHEX(), and MINUTE() functions did not exist. (MCOL-3600)

• regr_ tests returns doubles with higher precision than in ColumnStore 1.2. (MCOL-3631)

• Window function failures could return results rather than errors. (MCOL-3632)

• ISTRUE() function did not exist. (MCOL-3756)

• Alternate behavior for rand() vs ColumnStore 1.2. (MCOL-3760)

• Wrong error could be returned on every second run of an error-generating query. (MCOL-3777)

• Internal error: IDB-2021: 'tablename' is not in GROUP BY clause could occur. (MCOL-3782)

• UNION may complain about table not in query. (MCOL-3828)

• COUNT() as a window function does not work correctly with NULL values. (MCOL-3839)

• SQLYog may encounter an error during ColumnStore cross-engine JOINs. (MCOL-3845)

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

• Error messages may point to the wrong function. (MCOL-3924)

• Microsecond support for FROM_UNIXTIME() (MCOL-3959)

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

• Unsupported LIMIT in correlated subqueries may give erroneous result. (MCOL-3757)

Related to performance

• Subquery wrapping impacts performance. (MCOL-3664)

• Unoptimized lines (CPU impact and unnecessary rounding error) in regr_sxx, regr-sxy, and regr_syy (MCOL-3837)

Related to install and upgrade

• postConfigure uses invalid device nodes for dbroots. (MCOL-2022)

• startsystem allows startup without correct DBROOT 1 assignment. (MCOL-2153)

• Incorrect handling of unassigned IP addresses in configuration file. (MCOL-2181)

• After shutdownsystem, first startsystem always fails. (MCOL-3704)

• ColumnStore Tools for 1.4 were unavailable. (MCOL-3847)

• postConfigure reports false positive that server is running. (MCOL-3870)

• postConfigure looks in incorrect location for columnstore.cnf.rpmsave during an upgrade. (MCOL-3887)

• Multi-node non-systemd installation with replication enabled fails to start. (MCOL-3985)

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

• Changing systemlang in Columnstore.xml to an unrecognized string will prevent ColumnStore startup. (MCOL-3420)

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 ColumnStore 1.4.4 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.4 is no longer supported. If you would like to deploy Enterprise ColumnStore, please use MariaDB Enterprise ColumnStore 5 or later. For installation and upgrade instructions, see "Deploy".

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