MariaDB ColumnStore 1.0.4 Beta Release Notes

You are viewing an old version of this article. View the current version here.

Release date: 27th October 2016

MariaDB ColumnStore 1.0.4 is a beta release of MariaDB ColumnStore. This is the first beta release of MariaDB ColumnStore with improvements over the previous 1.0.3 alpha release.

MariaDB ColumnStore 1.0.4 is an 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 [email protected]

Notable Changes

  • MCOL-305 The base MariaDB server version is now 10.1.18. <TODO>

Bugs and Issues Fixed

Below is list of some of the bugs and issues fixed. For the complete list please see here <TODO>

Upgrade

<TODO> Multi version upgrades are not supported, please upgrade versions prior to 1.0.3 before upgrading to 1.0.4. Details on upgrading from version to 1.0.2 to 1.0.3 can be found here.

Upgrade from MariaDB ColumnStore Alpha versions 1.0.0 and 1.0.1 is not supported, please upgrade to version 1.0.3 prior to upgrading to 1.0.4.

Known Issues and Limitations

<TODO> 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 here

  • MCOL-82: 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.
  • MCOL-37: Following three window functions do not return correct value
    • FIRST_VALUE
    • LEAD
    • LAG
  • MCOL-75 and MCOL-74: NTH_VALUE and LAST_VALUE functions return syntax errors.
  • 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-271 empty string values are treated as NULL. This means you cannot insert empty values into a NOT NULL string column.
  • 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.

Documentation

MariaDB ColumnStore Documentation

Packaging

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

  • The supported OS for this Alpha version are CentOS 6, CentOS 7 and Ubuntu 16.0.4.
  • Packages can be downloaded here

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

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.