# MariaDB ColumnStore 1.0.2 Alpha Release Notes **Release date:** 23 August 2016 [MariaDB ColumnStore 1.0.2](https://github.com/mariadb-corporation/docs-release-notes/blob/test/kb/en/mariadb-columnstore/README.md) is an alpha release of MariaDB ColumnStore. This is the second alpha release of MariaDB ColumnStore with improvements over previous alpha release of 1.0.1. MariaDB ColumnStore 1.0.2 is an [***Alpha***](/docs/release-notes/community-server/about/release-criteria.md) release. **Do not use *****alpha***** releases on production systems!** For an overview of [MariaDB ColumnStore](https://github.com/mariadb-corporation/docs-release-notes/blob/test/kb/en/mariadb-columnstore/README.md) see [MariaDB ColumnStore Architectural Overview](/docs/analytics/mariadb-columnstore/architecture/columnstore-architectural-overview.md) MariaDB ColumnStore 1.0.2 is an Alpha release. This is the second alpha release of MariaDB ColumnStore with improvements over previous alpha release of 1.0.1. Please provide feedback in [JIRA](https://jira.mariadb.org/browse/MCOL) 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](https://github.com/mariadb-corporation/docs-release-notes/blob/test/kb/en/mariadb-columnstore/README.md) or subscribe to ## Notable Changes * [MCOL-70](https://jira.mariadb.org/browse/MCOL-70): systemd service support * [MCOL-4](https://jira.mariadb.org/browse/MCOL-4) Build for CentOS 7 * [MCOL-5](https://jira.mariadb.org/browse/MCOL-5) Build for Ubuntu 16.04 * [MCOL-58](https://jira.mariadb.org/browse/MCOL-58) Non-root installs now works for columnstore mysql code ## Bugs and Issues Fixed Below is list of some of the bugs and issues fixed. For the complete list please see [here](https://jira.mariadb.org/issues/?jql=project%20%3D%20%22MCOL%22%20AND%20status%20%3D%20CLOSED%20and%20fixVersion%20in%20\(1.0.2\)%20ORDER%20BY%20priority%20DESC%2C%20updated%20DESC) * [MCOL-35](https://jira.mariadb.org/browse/MCOL-35), [MCOL-66](https://jira.mariadb.org/browse/MCOL-66), [MCOL-14](https://jira.mariadb.org/browse/MCOL-14): Concurrent DML and DDL failed * [MCOL-140](https://jira.mariadb.org/browse/MCOL-140): Concurrent Insert threads generate errors * [MCOL-254](https://jira.mariadb.org/browse/MCOL-254): ColumnStore is limited to two columns in a GROUP BY statement * [MCOL-67](https://jira.mariadb.org/browse/MCOL-67): config.log and possibly other autoconf artifacts are in source control * [MCOL-69](https://jira.mariadb.org/browse/MCOL-69): autotools based build process does not work * [MCOL-151](https://jira.mariadb.org/browse/MCOL-151): ColumnStore engine not available after reboot * [MCOL-39](https://jira.mariadb.org/browse/MCOL-39): console command "getSystemConfig" return API for some parameter names * [MCOL-59](https://jira.mariadb.org/browse/MCOL-59): name change of Calpont.xml files * [MCOL-71](https://jira.mariadb.org/browse/MCOL-71): Problem changing the MariaDB release version in ColumnStore build * [MCOL-113](https://jira.mariadb.org/browse/MCOL-113): install\_calpont\_mysql.sh returns function not found errors on a new installation * [MCOL-138](https://jira.mariadb.org/browse/MCOL-138): postConfigure mentions MySQL * [MCOL-139](https://jira.mariadb.org/browse/MCOL-139): MariaDB ColumnStore version confusion * [MCOL-146](https://jira.mariadb.org/browse/MCOL-146): build enterprise rpms from new build processes * [MCOL-68](https://jira.mariadb.org/browse/MCOL-68): Makefile.in missing in oamapps/mcsadmin/ * [MCOL-64](https://jira.mariadb.org/browse/MCOL-64): Internal error: CAL0009: Error in dropping table from systables ## Upgrade workaround With the fixing of [MCOL-59](https://jira.mariadb.org/browse/MCOL-59), the MariaDB ColumnStore Platform Configuration file name has changed between 1.0.1 and 1.0.2. So if you have a 1.0.0 or 1.0.1 system and you want to upgrade to 1.0.2, you will need to do the following as part of the upgrade process. If you decide to reinstall 1.0.2 from scratch, this is isn’t required. For details on how to execute the workaround please see [upgrading-mariadb-columnstore-from-102-to-103](https://github.com/mariadb-corporation/docs-server/blob/test/release-notes/columnstore/columnstore-1-0/broken-reference/README.md) ## Known Issues and Limitations 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](/docs/analytics/mariadb-columnstore/security/columnstore-security-vulnerabilities.md) * [MCOL-82](https://jira.mariadb.org/browse/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](https://jira.mariadb.org/browse/MCOL-37): Following three window functions do not return correct value * FIRST\_VALUE * LEAD * LAG * [MCOL-75](https://jira.mariadb.org/browse/MCOL-75) and [MCOL-74](https://jira.mariadb.org/browse/MCOL-74): NTH\_VALUE and LAST\_VALUE functions return syntax errors. * [MCOL-73](https://jira.mariadb.org/browse/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-45](https://jira.mariadb.org/browse/MCOL-45) : CREATE PROCEDURE fails. * Do not use stored procedure with this Alpha version [MCOL-16](https://jira.mariadb.org/browse/MCOL-16): LOAD DATA INFILE into datetime columns, data got saturated. * Do not use LOAD DATA INFILE when importing data into datetime columns * Use cpimport to bulk load data into MariaDB ColumnStore instead. cpimports works correctly for datetime columns as well. * INSERT INTO works for datetime columns * [MCOL-49](https://jira.mariadb.org/browse/MCOL-49): Drop table does not work if the PM node runs out of space. * [MCOL-259](https://jira.mariadb.org/browse/MCOL-259): After starting MariaDB ColumnStore Service, if queries start within few nano-seconds, queries fail with “At least one DBRoot required for that query is offline“ message * Wait for 1 minute after the service is started, before starting to send queries * [MCOL-271](https://jira.mariadb.org/browse/MCOL-271) and [MCOL-171](https://jira.mariadb.org/browse/MCOL-171): empty string and date/datetime values are treated as NULL. This means you cannot insert empty values into a NOT NULL column. * [MCOL-256](https://jira.mariadb.org/browse/MCOL-256): Queries that have inline comments will produce erroneous results * 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](https://github.com/mariadb-corporation/docs-release-notes/blob/test/kb/en/mariadb-columnstore/README.md) ## Packaging RPM and binary packages are provided for the Linux distributions supported by MariaDB ColumnStore 1.0.2 Alpha version. * The supported OS for this Alpha version are CentOS 6, CentOS 7 and Ubuntu 16.0.4. * Packages can be downloaded [here](https://mariadb.com/my_portal/download/mariadb-columnstore) ## 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](https://github.com/mariadb-corporation/mariadb-columnstore-engine) * MariaDB Server - [Source code based on MariaDB Server 10.1 modified to support the ColumnStore storage engine](https://github.com/mariadb-corporation/mariadb-columnstore-server) *This page is: Copyright © 2025 MariaDB. All rights reserved.* {% @marketo/form formid="4316" formId="4316" %} --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://mariadb.com/docs/release-notes/columnstore/old-releases/columnstore-1-0/mariadb-columnstore-102-alpha-release-notes.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.