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 [email protected]
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
Additional typo fix contribution by Kabike
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:
The following procedure outlines upgrading a 1.2.x ColumnStore install to 1.2.5:
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