Release date: 20 September 2016
MariaDB ColumnStore 1.0.3 is an alpha release of MariaDB ColumnStore. This is the third alpha release of MariaDB ColumnStore with improvements over previous alpha release of 1.0.2.
MariaDB ColumnStore 1.0.3 is an Alpha release.
Do not use alpha releases on production systems!
For an overview of MariaDB ColumnStore see
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
The base MariaDB server version is now 10.1.17, including the security fix for (MySQL Remote Root Code Execution / Privilege Escalation 0 day).
: A date of 0000-00-00 is now supported and will not be turned into NULL. Previous NULL conversions will remain as NULL
: The minimum possible data (apart from ‘0000-00-00’) has changed from ‘1400-01-01’ to ‘1000-01-01’ which is more in-line with MariaDB’s documented date range
Below is list of some of the bugs and issues fixed. For the complete list please see
: Comment parser in breaks some queries
: LDI using cpimport pads char column values with spaces
: DATETIME field doesn't match with MySQL standard
: DDL parser doesn't support space instead of equals in table options
Multi version upgrades are not supported, please upgrade versions prior to 1.0.2 before upgrading to 1.0.3. Details on upgrading from version to 1.0.2 to 1.0.3 can be found .
Upgrade from MariaDB ColumnStore Alpha versions 1.0.0 and 1.0.1 is not supported, please upgrade to version 1.0.2 prior to upgrading to 1.0.3.
There are a number bugs and known limitations within this early Alpha version of MariaDB ColumnStore, the most serious of these are listed below. These are expected to be fixed way before the Beta release. There are some known security issues. They are listed
: Subquery using IN with VIEW returns incorrect results. Queries selecting from view and using IN in where clause with a subquery on another view returns incorrect results.
: Following three window functions do not return correct value
FIRST_VALUE
LEAD
RPM and binary packages are provided for the Linux distributions supported by MariaDB ColumnStore 1.0.3 Alpha version.
The supported OS for this Alpha version are CentOS 6, CentOS 7 and Ubuntu 16.0.4.
Packages can be downloaded
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 -
MariaDB Server -
MCOL-259: intermediate regression test failures - At least one DBRoot required for that query is offline.
MCOL-256: Queries that have inline comments will produce erroneous results
MCOL-240: DBT3 query 11 returned an internal error, ExeMgr aborted
MCOL-173: "INSERT INTO tableName SELECT 42,100" not working correctly
MCOL-171: 0000-00-00 dates are not supported and are munged to NULL with no warnings
MCOL-80: EXTRACT() function returned assertion error
MCOL-45: CREATE PROCEDURE fails
LAG
MCOL-73): Wide table formatted display causes frontend to return error
MariaDB ColumnStore supports wide tables storage
Displaying the query results on a large number of columns without formatting the column works
Displaying the query results on a large number of columns with formatting causes error at MariaDB Server level
MCOL-290: DecomSvr status incorrectly reported as Initial rather than Active.
While Millisecond and Microsecond storage is supported for datetime, time and timestamp columns, at this time the query results cannot return millisecond and microseconds.
UTF-8 Limitation
UTF-8 must be declared at the table level if the instance has been set up with a UTF-8 profile. Tables created with a non-matching character set will yield indeterminate results.
Viewing SQL output should be done using client software that supports UTF-8 character sets.
UTF-8 characters are not supported in object names.
This page is: Copyright © 2025 MariaDB. All rights reserved.