All pages
Powered by GitBook
1 of 7

MariaDB ColumnStore 1.2 Release Notes

Release notes for MariaDB ColumnStore 1.2

MariaDB ColumnStore 1.2.0 Alpha Release Notes

Release date: 17th October 2018

MariaDB ColumnStore 1.2.0 is an Alpha release of MariaDB ColumnStore. This is the first release of the MariaDB ColumnStore 1.2 series. The MariaDB ColumnStore 1.2 series provides several new features and improvements over the MariaDB ColumnStore 1.1 release.

MariaDB ColumnStore 1.2.0 is a Alpha release.

Do not use alpha releases on production systems!

For an overview of MariaDB ColumnStore see MariaDB ColumnStore Architectural Overview

Please provide feedback in JIRA for anything that is not working as expected so that we can fix it before we make the release available for the larger community. For general "how to questions" ask questions here or subscribe to mariadb-columnstore@googlegroups.com

Notable changes

  • MCOL-1385 - The base MariaDB server version is now 10.3.9 which include several maintenance and security fixes.

  • MCOL-392 - TIME data type is now supported

  • MCOL-320 - TIME and DATETIME data types now support microseconds

  • MCOL-497 - Cross Engine Joins now support SSL connections

  • Improved DDL syntax support

    • MCOL-497 - BOOL / BOOLEAN alias for TINYINT now supported - with thanks to community contributor "tntnatbry"

    • MCOL-573 - Backticks & reserved words now supported

    • MCOL-716 - Non-alphanumeric table/column names now supported

  • MCOL-1201 - User Defined Aggregate / Window Functions now support multiple parameters.

  • MCOL-521 - Regression aggregate and windows functions are now supported.

  • MCOL-1577 - CREATE TABLE...LIKE now supported

  • MCOL-1242 - A remote bulk data import tool is now available which allows loading data directly from any server. This tool is included in the MariaDB ColumnStore Tools package

  • MCOL-1281 - Microsoft Windows 10 support for bulk write SDK

  • Pentaho data adapter is now also available for Windows 10

Bugs and issues fixed

  • MCOL-1322 - data corruption when setting NUMERIC columns to NULL through the python and C++ API

  • MCOL-1523 - OAM Process failover logic for DDLproc is incorrect - causing DDL to stop working

  • MCOL-1606 - PDI 8 - variable substitution doesn't work

  • MCOL-1648 - pymcsapi3 on Windows depends on the Python 3 release DLL it was compiled with

  • MCOL-1658 - support space names in columnstore table column names

  • MCOL-1701 - Change Windows mcsapi build to use libraries from external directory

  • MCOL-1644 - PDI plugin CI tests - add check with PDI 8

  • MCOL-1704 - javamcsapi - compatibility test fails if executed multiple times

  • MCOL-1761 - Test script for Win is searching for wrong named zip file

  • MCOL-1766 - Increase Gradle dependency resolution timeout to 5min

  • MCOL-1695 - Add OS information to Kettle zip file

  • MCOL-1713 - Add Windows suffix to kettle data adapter

  • MCOL-345 - Saturated time() func handling is different to MariaDB

  • MCOL-346 - Saturated addtime() func handling is different to MariaDB

  • MCOL-573 - CS does not support reserved words as column names

  • MCOL-807 - HOUR() function returns NULL when it should not

  • MCOL-876 - Renaming a table in non-current database fails

  • MCOL-1002 - cpimport with down system say InfiniDB

  • MCOL-1219 - Column name can not start with numeric value

  • MCOL-1322 - data corruption when setting NUMERIC columns to NULL through the python and C++ API

  • MCOL-1327 - CS objects' identifiers doesn't support U+0000..U+007f even when quoted

  • MCOL-1377 - ColumnStore system logging not working after 1.1.4 ubuntu-16 install

  • MCOL-1379 - Scala connector won't compile in Ubuntu 18.04

  • MCOL-1386 - Create table statement doesn't allow usage of C style comments in it

  • MCOL-1520 - Forked server crashes in Item_ident::print() for a Temptable_field.

  • MCOL-1684 - Performance Schema crashes prepared statement

  • MCOL-1701 - Change Windows mcsapi build to use libraries from external directory

  • MCOL-1766 - Increase Gradle dependency resolution timeout to 5min

  • MCOL-266 - BOOLEAN data type not supported

  • MCOL-320 - support query of milli and micro second time parts

  • MCOL-392 - TIME datatype is not supported

  • MCOL-497 - support ssl connection in cross engine joins

  • MCOL-521 - add distributed regression aggregate and window functions

  • MCOL-548 - clean up engine repo cmake warnings

  • MCOL-569 - CS does not support reserved words as table names

  • MCOL-716 - support non alphanumeric characters for table and column names

  • MCOL-978 - Disable Query Cache for ColumnStore

  • MCOL-1052 - Implement GROUP BY pushdown support

  • MCOL-1073 - DecomSvr should be removed

  • MCOL-1201 - Allow UDAnF to have multiple parameters defined.

  • MCOL-1242 - Remote CpImport

  • MCOL-1244 - make postConfigure default install non-distributed

  • MCOL-1281 - mcsapi Windows support

  • MCOL-1378 - Hardening Flags pt 2

  • MCOL-1385 - Merge MariaDB 10.3

  • MCOL-1392 - Add time field support for PDI plugin

  • MCOL-1424 - Make the default installation option to separate instead of combined.

  • MCOL-1577 - ColumnStore to allow CREATE TABLE table_name LIKE ... Syntax

  • MCOL-1633 - mcsapi Windows - add needed Windows Redistributables to installer

  • MCOL-1688 - Informatica PowerCenter Bulk Write Connector

  • MCOL-1759 - Implement regr_sxx, regr_syy, regr_sxy and corr functions as UDAF

  • MCOL-1773 - Add mcsimport to PATH

  • MCOL-1547 - Investigate renewed in 10.3 CASE implementation.

  • MCOL-1634 - Include Windows library build into mcsapi

  • MCOL-1417 - TIME: cpimort saturates reserved NULL and empty indicator values incorrectly

  • MCOL-1418 - TIME: LDI saturates out-of-range values incorrectly

  • MCOL-1419 - TIME: Update saturates out-of-range values incorrectly

  • MCOL-1427 - Microsecond values are stored left-justified with trailing 0 padding

  • MCOL-1428 - SUBTIME() as a WHERE condition on TIME data type caused primProc to hang

  • MCOL-1429 - DAYNAME() and MONTHNAME() on TIME data type columns caused primProc to restart

  • MCOL-1433 - Some functions return non-matching results after data type TIME was added to the functions test suite

  • MCOL-1496 - Joiner array boundary bug

In addition, all bugs fixed in MariaDB ColumnStore 1.1.6 and earlier are implicitly included in this release.

Upgrade

The following procedure outlines upgrading a 1.1.6 ColumnStore install to 1.2.0:

  • 1.1.6 GA to 1.2.0 Alpha upgrade procedure

Multi version upgrades generally will work using the same procedure however we can't test every possible permutation so you should test your specific scenario outside of production first if you wish to try this (and this is good practice regardless).

Known issues and limitations

There are a number bugs and known limitations within this version of MariaDB ColumnStore, the most serious of these are listed below.

  • MCOL-1763 - mcsapi MCOL-1408 regression

  • MCOL-1776 - regression of MCOL-1403, trailing space string matching in VARCHAR

  • MCOL-1782 - UPDATE and DELETE reported incorrect affected row count

  • MCOL-1792 - mcsapi can incorrectly insert milliseconds

  • MCOL-1799 - length() on BLOB data generates an error

  • MCOL-1786 - cpimport cannot handle "true" keyword for boolean/numeric data types in cpimport

  • MCOL-1805 - mcimport can show a warning about column sizes during import

Documentation

MariaDB ColumnStore Documentation

Packaging

RPM, Debian, and binary packages are provided for the Linux distributions supported by MariaDB ColumnStore 1.2.0 Alpha version.

  • The supported OS for the Alpha version are CentOS 6, CentOS 7, Debian 8, Debian 9, RedHat 6, RedHat 7, SUSE 12, Ubuntu 16.04 and Ubuntu 18.04.

  • Packages can be downloaded here or can be installed from the repositories.

  • An Amazon AWS AMI Image is available for this release, please search for AMI name "MariaDB-ColumnStore-1.2.0". AMI specific installation instructions can be found here.

  • Certified to run in Google Cloud Environment in the GA OSs.

Source code

The source code of MariaDB ColumnStore is tagged at GitHub with a tag, which is identical with the version of MariaDB ColumnStore. For instance, the tag of version X.Y.Z of MariaDB ColumnStore is columnstore-X.Y.Z. Further, master always refers to the latest released non-beta version.

The source code is available at these locations

  • Storage Engine - Source code for engine specific processes on UM and PM node

  • MariaDB Server - Source code based on MariaDB Server 10.3.9 modified to support the ColumnStore storage engine

  • Tools - Source code for MariaDB ColumnStore Tools

  • Write Data API - Source code for Write Data API /SDK

  • MaxScale CDC and Kafka Data Adapters - Source Code for data adapters

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

MariaDB ColumnStore 1.2.1 Beta Release Notes

Release date: 14th November 2018

MariaDB ColumnStore 1.2.1 is an Beta release of MariaDB ColumnStore. This is the first release of the MariaDB ColumnStore 1.2 series. The MariaDB ColumnStore 1.2 series provides several new features and improvements over the MariaDB ColumnStore 1.1 release.

MariaDB ColumnStore 1.2.1 is a Beta release.

Do not use beta releases on production systems!

For an overview of MariaDB ColumnStore see MariaDB ColumnStore Architectural Overview

Please provide feedback in JIRA for anything that is not working as expected so that we can fix it before we make the release available for the larger community. For general "how to questions" ask questions here or subscribe to mariadb-columnstore@googlegroups.com

Notable changes

  • MCOL-1804 - The base MariaDB server version is now 10.3.10 which include several maintenance and security fixes.

  • MCOL-520 - Non-root install now does not require sudo for the installation tools

  • MCOL-1846 - Amazon AMI support for Instances with ENA drivers

Bugs and issues fixed

  • MCOL-1307 - Adapter can't recognize database schema written with backtick

  • MCOL-1554 - PDI CS not work in the Pentaho Sever repository

  • MCOL-1776 - Test MCOL-1403 failing in develop

  • MCOL-1782 - UPDATE and DELETE reported incorrect affected row count

  • MCOL-1786 - Handle "true" keyword for numeric data types in cpimport - with thanks to community contributor "tntnatbry"

  • MCOL-1792 - Timestamp --> Datetime insert: milliseconds are wrongly inserted in CS

  • MCOL-1799 - test013 regression

  • MCOL-1811 - Rename mcsimport package name during Windows build

  • MCOL-1812 - Bulk Write SDK Windows installer uninstallation / alter - wrong execute credentials

  • MCOL-1813 - Bulk Write SDK's Windows installer doesn't detect Python installations for the current user only

  • MCOL-1821 - mcsimport not included in tools binary package

  • MCOL-1823 - Amazon AMI quick installer script - add in default to do distributed install

  • MCOL-1826 - PrimProc crash in float/double to string conversion

  • MCOL-1845 - RPM package summary need to be consistent

  • MCOL-1852 - Spark Exporter uses collect() instead of toLocalIterator() on DataFrames to export and therefore uses too much memory on the Driver

  • MCOL-1858 - An invalid records indication when loading the table unsing mcsimport

  • MCOL-520 - true non root install phase 1

  • MCOL-1158 - Support additional Python3 features using Swig's -py3 flag

  • MCOL-1642 - Add SQL command that shows Primary Front-End MariaDB ColumnStore Module

  • MCOL-1671 - Windows mcsapi - add option to install libraries directly into Java

  • MCOL-1774 - mcsimport - enclose by character support and escape character for enclose by char

  • MCOL-1816 - mcsapi - support bool data type

  • MCOL-1817 - Pentaho support bool data type

  • MCOL-1373 - Add TIME & DATETIME+msec support to mcsapi

  • MCOL-1593 - Add Windows builder to buildbot for API

  • MCOL-1744 - Remove unnecessary CentOS 7 mcsapi package dependencies

  • MCOL-1754 - Change libmysql dependency for Windows api tests to libmariadb

  • MCOL-1804 - Rebase 1.2 on MariaDB 10.3.10

  • MCOL-1846 - AMI support for Instances with ENA drivers

  • MCOL-1860 - cannot insert symbols in column using the mcsimport with escape_character option

  • MCOL-1654 - Querystats table is broken

In addition, all bugs fixed in MariaDB ColumnStore 1.2.0 and earlier are implicitly included in this release.

Upgrade

The following procedure outlines upgrading a 1.2.0 ColumnStore install to 1.2.1:

  • 1.2.0 Alpha to 1.2.1 Beta upgrade procedure

Multi version upgrades generally will work using the same procedure however we can't test every possible permutation so you should test your specific scenario outside of production first if you wish to try this (and this is good practice regardless).

Known issues and limitations

There are a number bugs and known limitations within this version of MariaDB ColumnStore, the most serious of these are listed below.

  • MCOL-1805 - mcimport can show a warning about column sizes during import

  • MCOL-1793 - regr_slope() and regr_r2() produce incorrect result when used as window functions

Documentation

MariaDB ColumnStore Documentation

Packaging

RPM, Debian, and binary packages are provided for the Linux distributions supported by MariaDB ColumnStore 1.2.0 Alpha version.

  • The supported OS for the Alpha version are CentOS 6, CentOS 7, Debian 8, Debian 9, RedHat 6, RedHat 7, SUSE 12, Ubuntu 16.04 and Ubuntu 18.04.

  • Packages can be downloaded here or can be installed from the repositories.

  • An Amazon AWS AMI Image is available for this release, please search for AMI name "MariaDB-ColumnStore-1.2.0". AMI specific installation instructions can be found here.

  • Certified to run in Google Cloud Environment in the GA OSs.

Source code

The source code of MariaDB ColumnStore is tagged at GitHub with a tag, which is identical with the version of MariaDB ColumnStore. For instance, the tag of version X.Y.Z of MariaDB ColumnStore is columnstore-X.Y.Z. Further, master always refers to the latest released non-beta version.

The source code is available at these locations

  • Storage Engine - Source code for engine specific processes on UM and PM node

  • MariaDB Server - Source code based on MariaDB Server 10.3.10 modified to support the ColumnStore storage engine

  • Tools - Source code for MariaDB ColumnStore Tools

  • Write Data API - Source code for Write Data API /SDK

  • MaxScale CDC and Kafka Data Adapters - Source Code for data adapters

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

MariaDB ColumnStore 1.2.2 GA Release Notes

Release date: 3rd December 2018

MariaDB ColumnStore 1.2.2 is a GA release of MariaDB ColumnStore. The MariaDB ColumnStore 1.2 series provides several new features and improvements over the MariaDB ColumnStore 1.1 release.

For an overview of MariaDB ColumnStore see MariaDB ColumnStore Architectural Overview

Please provide feedback in JIRA for anything that is not working as expected so that we can fix it before we make the release available for the larger community. For general "how to questions" ask questions here or subscribe to mariadb-columnstore@googlegroups.com

Notable changes

  • MCOL-1952 - The base MariaDB server version is now 10.3.11 which include several maintenance and security fixes.

  • MCOL-1847 - NumBlocksPct and TotalUmMemory can take fixed memory sizes instead of percentages

  • MCOL-1739 - mcsapi has been split into separate packages for every programming language

  • MCOL-1890 - The kafka package has been renamed

Bugs and issues fixed

  • MCOL-1519 - Query doesn't process certain JOIN types with GROUP BY handler.

  • MCOL-1558 - BRM_saves_current should use a relative path

  • MCOL-1638 - Suse12 regression failure test023 median::nextValue crashing PrimProc

  • MCOL-1716 - GROUP BY handler incorrectly process filters with subquery as IN predicate

  • MCOL-1718 - Clarify configuration requirements for usage of the -z option

  • MCOL-1742 - CentOS 7 - data-adapter repository installation broken

  • MCOL-1777 - regr tests depend on table that doesn't exist yet

  • MCOL-1778 - WF regression tests need fixing

  • MCOL-1779 - tablemode test failing in develop

  • MCOL-1793 - regr_slope() and regr_r2() produce incorrect result when used as window functions

  • MCOL-1800 - test022 regression

  • MCOL-1847 - need to be able to specify NumBlocksPct and TotalUmMemory explicitly

  • MCOL-1855 - ColumnStore table whose name contains $ cannot be renamed

  • MCOL-1868 - func_concat_ws type

  • MCOL-1875 - getsystemcpu & related commands always return 0 cpu usage

  • MCOL-1877 - getactivesqlstatements returns 'file open error'

  • MCOL-1879 - csv text "true" is mapped to 0 during import but should be parsed to 1

  • MCOL-1885 - Cross engine / Query stats doesn't show specific query errors

  • MCOL-1900 - PDI Plugin unresponsive if CS is not available

  • MCOL-1945 - mxs_adapter throws malloc error

  • MCOL-1947 - Our aliases break BASH

  • MCOL-1949 - vTpch10.sql and vTpch21.sql regression

  • MCOL-1953 - columnstoreClusterTester.sh script fails

  • MCOL-1959 - mxs_adapter assertion crash on multi table stream

  • MCOL-1094 - mcsapi should have view/clear table lock features

  • MCOL-1362 - Add a export function that utilizes (sequential) write from Spark workers

  • MCOL-1739 - Split mcsapi installation into different packages for C++, Java and Python

  • MCOL-1740 - mcsimport - depend on mcsapi only

  • MCOL-1844 - Allow prior/custom changes made to myCnf-include-args.text be added to new myCnf-include-args.text after upgrading

  • MCOL-1790 - Implement new CASE item type detection

  • MCOL-1866 - Change logo in mcsapi, PDI and mcsimport

  • MCOL-1944 - /var/log/mariadb/columnstore ownership set to 777 recursive

  • MCOL-1952 - Rebase develop 10.3.11

In addition, all bugs fixed in MariaDB ColumnStore 1.2.1 and earlier are implicitly included in this release.

Upgrade

The following procedure outlines upgrading a 1.1.6 ColumnStore install to 1.2.2:

  • 1.1.6 GA to 1.2.2 GA upgrade procedure

Multi version upgrades generally will work using the same procedure however we can't test every possible permutation so you should test your specific scenario outside of production first if you wish to try this (and this is good practice regardless).

Known issues and limitations

There are a number bugs and known limitations within this version of MariaDB ColumnStore, the most serious of these are listed below.

  • MCOL-1662 - INSERT...SELECT and LOAD DATA INFILE when used in a transaction as well as mcsapi can cause dictionary columns to be badly cached

  • MCOL-1797 - resumeDatabaseWrites can cause DML/DDL to go active all on UMs simultaneously

  • MCOL-1990 - localquery mode tries to turn on replication and fails.

  • MCOL-2061 - Running TRUNCATE on a table that has been upgraded from 1.1 -> 1.2 can cause MariaDB server to crash. As a workaround you can DROP and recreate the table.

Documentation

MariaDB ColumnStore Documentation

Packaging

RPM, Debian, and binary packages are provided for the Linux distributions supported by MariaDB ColumnStore 1.2.2 GA version.

  • The supported OS for the GA version are CentOS 6, CentOS 7, Debian 8, Debian 9, RedHat 6, RedHat 7, SUSE 12, Ubuntu 16.04 and Ubuntu 18.04.

  • Packages can be downloaded here or can be installed from the repositories.

  • An Amazon AWS AMI Image is available for this release, please search for AMI name "MariaDB-ColumnStore-1.2.2". AMI specific installation instructions can be found here.

  • Certified to run in Google Cloud Environment in the GA OSs.

Source code

The source code of MariaDB ColumnStore is tagged at GitHub with a tag, which is identical with the version of MariaDB ColumnStore. For instance, the tag of version X.Y.Z of MariaDB ColumnStore is columnstore-X.Y.Z. Further, master always refers to the latest released non-beta version.

The source code is available at these locations

  • Storage Engine - Source code for engine specific processes on UM and PM node

  • MariaDB Server - Source code based on MariaDB Server 10.3.11 modified to support the ColumnStore storage engine

  • Tools - Source code for MariaDB ColumnStore Tools

  • Write Data API - Source code for Write Data API /SDK

  • MaxScale CDC and Kafka Data Adapters - Source Code for data adapters

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

MariaDB ColumnStore 1.2.3 GA Release Notes

Release date: 21st March 2019

MariaDB ColumnStore 1.2.3 is a GA release of MariaDB ColumnStore. The MariaDB ColumnStore 1.2 series provides several new features and improvements over the MariaDB ColumnStore 1.1 release.

For an overview of MariaDB ColumnStore see MariaDB ColumnStore Architectural Overview

Please provide feedback in JIRA for anything that is not working as expected so that we can fix it before we make the release available for the larger community. For general "how to questions" ask questions here or subscribe to mariadb-columnstore@googlegroups.com

Notable changes

  • MCOL-2218 - The base MariaDB server version is now 10.3.13 which include several maintenance and security fixes.

  • MCOL-2176 - Jemalloc is a new dependency for MariaDB ColumnStore.

  • MCOL-1822 - The maximum possible value for AVG() and SUM() has significantly increased due to the usage of long double.

Bugs and issues fixed

  • MCOL-901 - group_concat() consumes a great amount of memory

  • MCOL-1456 - Query doesn't try REDO_PHASE1

  • MCOL-1559 - Regression on working_tpch1/misc/bug3669 string pad compare not correct

  • MCOL-1607 - postConfigure must support hostnames as cluster nodes network endpoints.

  • MCOL-1637 - MCOL-1052 causes regression

  • MCOL-1662 - WriteEngine bulk methods do not version dictionaries correctly

  • MCOL-1702 - Joblist thread pool leaks if mariadb client connection drops its connection early.

  • MCOL-1726 - mcsapi stale transactions

  • MCOL-1741 - Debian 9 - data-adapter package dependencies broken

  • MCOL-1755 - Informatica: delete statement doesn't escape reserved names for column names

  • MCOL-1795 - Remote Cpimport / API: Text overlaps MariaDB logo in installer windows

  • MCOL-1797 - resumedatabasewrites causes both DDL/DML to go active on um1/um2

  • MCOL-1829 - Output of 'select * (with order by limit) queries' returns unexpected result

  • MCOL-1883 - RENAME crashes when tablename contains / symbol

  • MCOL-1890 - Deb package name change broken

  • MCOL-1945 - mxs_adapter throws malloc error

  • MCOL-1980 - javamcsapi's shared library gets generated with the version number appended twice

  • MCOL-1981 - regr_avgx and regr_avgy should return NULL if count is zero

  • MCOL-1983 - regr_intercept, regr_r2, regr_slope and possibly other regr functions should return NULL with only one row.

  • MCOL-1995 - javamcsapi - MillionRow test fails on Ubuntu 16.04 and 18.04

  • MCOL-2009 - Fix jobstep abort

  • MCOL-2018 - Dictionary null comparison check can crash

  • MCOL-2050 - ORDER BY with OFFSET in subquery produces random and incorrect result

  • MCOL-2052 - IS.columnstore_files maximum contains incorrect number of records for any relation.

  • MCOL-2062 - cpimport scientific notation conversion problem

  • MCOL-2070 - pentaho kettle adapter lock session with bulk columnstore and dml transaction(delete/update operation).

  • MCOL-2071 - PDI CS Bulk Load plugin not able to read transformations with empty configuration

  • MCOL-2165 - Autoswitch broken in some cases in 1.2.2

  • MCOL-2180 - UDAF docs are currently broken

  • MCOL-2182 - PrimProc crash - signal 11, Segmentation fault - funcexp::Func_lpad::getStrVal

  • MCOL-1688 - Informatica PowerCenter Bulk Write Connector

  • MCOL-1814 - Add Windows builder to buildbot for Kettle

  • MCOL-1815 - Add Windows builder to buildbot for mcsimport

  • MCOL-1822 - Change the default to use double when overflow occurs in SUM() and AVG()

  • MCOL-1897 - Add API test suite to buildbot

  • MCOL-1898 - Add data-adapters test suite to buildbot

  • MCOL-1899 - Add tools test suite to buildbot

  • MCOL-1961 - javamcsapi, pymcsapi known isTableLock and TableLockInfo limitations

  • MCOL-2082 - Write Spark and PySpark documentation for mcsapi

  • MCOL-2110 - Cant build engine out-of-source

  • MCOL-2120 - Check NUMA devel package is installed on BuildBot instances

  • MCOL-2176 - Use jemalloc as the main memory allocator - testing for 1.2.3-1

  • MCOL-2218 - Rebase 1.2 on MariaDB 10.3.13

In addition, all bugs fixed in MariaDB ColumnStore 1.2.2 and earlier are implicitly included in this release.

Upgrade

The following procedure outlines upgrading a 1.1.7 ColumnStore install to 1.2.3:

  • 1.1.7 GA to 1.2.3 GA upgrade procedure

Multi version upgrades generally will work using the same procedure however we can't test every possible permutation so you should test your specific scenario outside of production first if you wish to try this (and this is good practice regardless).

Known issues and limitations

There are a number bugs and known limitations within this version of MariaDB ColumnStore, the most serious of these are listed below.

  • MCOL-1990 - localquery mode tries to turn on replication and fails.

  • MCOL-2061 - Running TRUNCATE on a table that has been upgraded from 1.1 -> 1.2 can cause MariaDB server to crash. As a workaround you can DROP and recreate the table.

Documentation

MariaDB ColumnStore Documentation

Packaging

RPM, Debian, and binary packages are provided for the Linux distributions supported by MariaDB ColumnStore 1.2.3 GA version.

  • The supported OS for the GA version are CentOS 6, CentOS 7, Debian 8, Debian 9, RedHat 6, RedHat 7, SUSE 12, Ubuntu 16.04 and Ubuntu 18.04.

  • Packages can be downloaded here or can be installed from the repositories.

  • An Amazon AWS AMI Image is available for this release, please search for AMI name "MariaDB-ColumnStore-1.2.3". AMI specific installation instructions can be found here.

  • Certified to run in Google Cloud Environment in the GA OSs.

Source code

The source code of MariaDB ColumnStore is tagged at GitHub with a tag, which is identical with the version of MariaDB ColumnStore. For instance, the tag of version X.Y.Z of MariaDB ColumnStore is columnstore-X.Y.Z. Further, master always refers to the latest released non-beta version.

The source code is available at these locations

  • Storage Engine - Source code for engine specific processes on UM and PM node

  • MariaDB Server - Source code based on MariaDB Server 10.3.13 modified to support the ColumnStore storage engine

  • Tools - Source code for MariaDB ColumnStore Tools

  • Write Data API - Source code for Write Data API /SDK

  • MaxScale CDC and Kafka Data Adapters - Source Code for data adapters

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

MariaDB ColumnStore 1.2.4 GA Release Notes (Release removed)

Release date: 29th May 2019

This version has been removed from production due to MCOL-3395 having the potential to corrupt databases.

MariaDB ColumnStore 1.2.4 is a GA release of MariaDB ColumnStore. The MariaDB ColumnStore 1.2 series provides several new features and improvements over the MariaDB ColumnStore 1.1 release.

For an overview of MariaDB ColumnStore see MariaDB ColumnStore Architectural Overview

Please provide feedback in JIRA for anything that is not working as expected so that we can fix it before we make the release available for the larger community. For general "how to questions" ask questions here or subscribe to mariadb-columnstore@googlegroups.com

Notable changes

  • MCOL-3315 - The base MariaDB server version is now 10.3.15 which include several maintenance and security fixes.

  • MCOL-3270 - cpimport performance for dictionary data is up to 2x faster.

  • MCOL-2061 - If you are performing a major version upgrade or have in the past there is a new stored procedure called columnstore_info.columnstore_upgrade() should be executed.

Bugs and issues fixed

  • MCOL-537 - Some compiler warnings need fixing

  • MCOL-1495 - Memory leak in WriteEngineServ

  • MCOL-1951 - Crash when MySQL aggregate UDF is called against Columnstore table

  • MCOL-1984 - SystemConfig / WaitPeriod change lost during upgrade

  • MCOL-2001 - mscadmin redistributeData parameters are not accepted as suggested by the help information.

  • MCOL-2035 - Some regr_* tests aren't deterministic so comparisons are iffy. RANK()

  • MCOL-2061 - MariaDB shows warnings and could crash on DDL after upgrade

  • MCOL-2089 - High CPU usage and slow performance appears when load data with remote mcsimport

  • MCOL-2091 - UDAF doesn't work if there are two count(distinct) in projection list

  • MCOL-2244 - There is no way to identify execution thread that causes bottleneck

  • MCOL-2267 - Query with SUM() erroring - /rowgroup.h@677: assertion '0' failed

  • MCOL-2273 - getSystemDisk showing incorrect root usage and reporting incorrect alarm

  • MCOL-3249 - Probably Kafka DA produces '\0' in the end of TEXT or VARCHAR with width > 7

  • MCOL-3268 - javamcsapi compatibility test fails

  • MCOL-3293 - UPDATE performance improvement contribution - Contributed by ABS Global

  • MCOL-3296 - ctrl+c sometimes leaves DMLProc in bad state

  • MCOL-3307 - Non-Columnstore Window function causes debug assert

  • MCOL-3311 - regression test212 logs integer expression expected error

  • MCOL-3318 - RPM warnings appear when installing ColumnStore's MariaDB Server

  • MCOL-593 - support columnstore tables as slaves to innodb master tables

  • MCOL-1254 - Add hidden switch for MariaDB async replication

  • MCOL-2013 - API .NET support - Alpha - Contributed by Bill Adams

  • MCOL-2076 - Allow simple replication to ColumnStore

  • MCOL-2129 - Add a new postConfigure flag to resolve submitted hostnames to correct reverse dns names

  • MCOL-3267 - Support ORDER BY within UNION subqueries

  • MCOL-3270 - Improve cpimport ingest speed into Dictionary columns - Contributed by ABS Global

  • MCOL-2068 - add support for using and defaulting memory based settings to docker image

  • MCOL-3315 - Rebase on MariaDB 10.3.15

Additional typo fix contribution by Kabike

In addition, all bugs fixed in MariaDB ColumnStore 1.2.3 and earlier are implicitly included in this release.

Upgrade

The following procedure outlines upgrading a 1.1.7 ColumnStore install to 1.2.4:

  • 1.1.7 GA to 1.2.4 GA upgrade procedure

The following procedure outlines upgrading a 1.2.x ColumnStore install to 1.2.4:

  • 1.2.x GA to 1.2.4 GA upgrade procedure

Multi version upgrades generally will work using the same procedure however we can't test every possible permutation so you should test your specific scenario outside of production first if you wish to try this (and this is good practice regardless).

Known issues and limitations

There are a number bugs and known limitations within this version of MariaDB ColumnStore, the most serious of these are listed below.

  • MCOL-1990 - localquery mode tries to turn on replication and fails.

Documentation

MariaDB ColumnStore Documentation

Packaging

RPM, Debian, and binary packages are provided for the Linux distributions supported by MariaDB ColumnStore 1.2.4 GA version.

  • The supported OS for the GA version are CentOS 6, CentOS 7, Debian 8, Debian 9, RedHat 6, RedHat 7, SUSE 12, Ubuntu 16.04 and Ubuntu 18.04.

  • Packages can be downloaded here or can be installed from the repositories.

  • An Amazon AWS AMI Image is available for this release, please search for AMI name "MariaDB-ColumnStore-1.2.4". AMI specific installation instructions can be found here.

  • Certified to run in Google Cloud Environment in the GA OSs.

Source code

The source code of MariaDB ColumnStore is tagged at GitHub with a tag, which is identical with the version of MariaDB ColumnStore. For instance, the tag of version X.Y.Z of MariaDB ColumnStore is columnstore-X.Y.Z. Further, master always refers to the latest released non-beta version.

The source code is available at these locations

  • Storage Engine - Source code for engine specific processes on UM and PM node

  • MariaDB Server - Source code based on MariaDB Server 10.3.15 modified to support the ColumnStore storage engine

  • Tools - Source code for MariaDB ColumnStore Tools

  • Write Data API - Source code for Write Data API /SDK

  • MaxScale CDC and Kafka Data Adapters - Source Code for data adapters

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

MariaDB ColumnStore 1.2.5 GA Release Notes

Release date: 23rd July 2019

MariaDB ColumnStore 1.2.5 is a GA release of MariaDB ColumnStore. The MariaDB ColumnStore 1.2 series provides several new features and improvements over the MariaDB ColumnStore 1.1 release.

For an overview of MariaDB ColumnStore see MariaDB ColumnStore Architectural Overview

Please provide feedback in JIRA for anything that is not working as expected so that we can fix it before we make the release available for the larger community. For general "how to questions" ask questions here or subscribe to mariadb-columnstore@googlegroups.com

Notable changes

  • MCOL-3398 - The base MariaDB server version is now 10.3.16 which include several maintenance and security fixes.

  • MCOL-3395 - Critical regression in the dictionary storage of 1.2.4 fixed.

Bugs and issues fixed

  • MCOL-1375 - Assertion failure when using HAVING with constant values

  • MCOL-1985 - Fix up regr functions in regrmysql.cpp so regr_* funtions work correcly for InnoDB tables

  • MCOL-2225 - cross engine join with space in column names in on condition cause fatal error

  • MCOL-2230 - DATE/TIME type math is broken -- TIMEDIFF, TIMESTAMPDIFF and date math

  • MCOL-3239 - CS incorrectly pushes function filter predicate into a subquery.

  • MCOL-3304 - Window functions in queries with embedded selects produce bad numbers

  • MCOL-3314 - Exemgr crash on query happening when we increase 2 variables, MaxOutStandingRequests and RequestSize

  • MCOL-3353 - Possible memory corruption in execplan

  • MCOL-3367 - ColumnStore API rpm packages failed to install

  • MCOL-3373 - Bug in funcexp while throwing an exception

  • MCOL-3384 - Crash in mxs_adapter

  • MCOL-3385 - Strings returned by the Avro C API include the null terminator in thestring length

  • MCOL-3391 - columnstore_upgrade failed from 1.2.2 to 1.2.4 when database including multibyte table name

  • MCOL-3395 - regression: dictionary de-duplication cache bleeding between columns

  • MCOL-3399 - Regression in LDI string length handling

  • MCOL-3404 - tpcds query #98 failed with an internal error

  • MCOL-3321 - some regr_* function tests need order by to make them deterministic

  • MCOL-3343 - Window Functions don't work with arithmetic operators or other functions

  • MCOL-1968 - wrong string comparisation after dataimport and extents

  • MCOL-1989 - Querying view results in internal error: column is not found in info map

  • MCOL-3398 - Rebase 1.2 on MariaDB 10.3.16

In addition, all bugs fixed in MariaDB ColumnStore 1.2.4 and earlier are implicitly included in this release.

Upgrade

The following procedure outlines upgrading a 1.1.7 ColumnStore install to 1.2.5:

  • 1.1.7 GA to 1.2.5 GA upgrade procedure

The following procedure outlines upgrading a 1.2.x ColumnStore install to 1.2.5:

  • 1.2.x GA to 1.2.5 GA upgrade procedure

Multi version upgrades generally will work using the same procedure however we can't test every possible permutation so you should test your specific scenario outside of production first if you wish to try this (and this is good practice regardless).

Known issues and limitations

There are a number bugs and known limitations within this version of MariaDB ColumnStore, the most serious of these are listed below.

  • MCOL-1990 - localquery mode tries to turn on replication and fails.

Documentation

MariaDB ColumnStore Documentation

Packaging

RPM, Debian, and binary packages are provided for the Linux distributions supported by MariaDB ColumnStore 1.2.5 GA version.

  • The supported OS for the GA version are CentOS 6, CentOS 7, Debian 8, Debian 9, RedHat 6, RedHat 7, SUSE 12, Ubuntu 16.04 and Ubuntu 18.04.

  • Packages can be downloaded here or can be installed from the repositories.

  • An Amazon AWS AMI Image is available for this release, please search for AMI name "MariaDB-ColumnStore-1.2.5". AMI specific installation instructions can be found here.

  • Certified to run in Google Cloud Environment in the GA OSs.

Source code

The source code of MariaDB ColumnStore is tagged at GitHub with a tag, which is identical with the version of MariaDB ColumnStore. For instance, the tag of version X.Y.Z of MariaDB ColumnStore is columnstore-X.Y.Z. Further, master always refers to the latest released non-beta version.

The source code is available at these locations

  • Storage Engine - Source code for engine specific processes on UM and PM node

  • MariaDB Server - Source code based on MariaDB Server 10.3.16 modified to support the ColumnStore storage engine

  • Tools - Source code for MariaDB ColumnStore Tools

  • Write Data API - Source code for Write Data API /SDK

  • MaxScale CDC and Kafka Data Adapters - Source Code for data adapters

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