All pages
Powered by GitBook
1 of 6

MariaDB ColumnStore 23.10 Release Notes

Release notes for MariaDB ColumnStore 23.10

MariaDB ColumnStore 23.10.4 Release Notes

Overview

MariaDB Enterprise ColumnStore 23.10.4 is a maintenance release of MariaDB Enterprise ColumnStore. MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server.

MariaDB Enterprise ColumnStore 23.10.4 was released on 19 May 2025. This release is of General Availability (GA) maturity. MariaDB Enterprise ColumnStore 23.10.4 is a GA release in the 23.10 series.

This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.6.21-17.

Notable Changes

  • New memory consumption accounting mechanism to prevent OOM events-related crashes. (MCOL-5797)

  • FROM_UNIXTIME(negativeDecimal) not behaving as InnoDB (MCOL-4605)

  • SEC_TO_TIME(wideDecimal) returns 0 in DECIMAL context (MCOL-4607)

  • MOD loses precision on huge narrow decimal (MCOL-4611)

  • Different results compared to innodb with union all and subselect with null in select and impossible where condition (MCOL-4942)

  • cmapi support for log collection (MCOL-5300)

  • JSON_ARRAYAGG in MCS works differently than in InnoDB. (MCOL-5394)

  • CLI Startup - Single start command for Single Node (MCOL-5525)

  • Alias "mcs CLUSTER" commands to just mcs (MCOL-5526)

  • Cmapi (mcs cli) support for columnstore backups (MCOL-5618)

  • Improve Client Error Messaging and async broadcasting config. (MCOL-5638)

  • CTE/aggreation function give wrong results (MCOL-5842)

  • DROP TABLE IF EXISTS should not generate errors for non existing tables (MCOL-5890)

  • Disk based GROUP_CONCAT() (MCOL-5921)

  • NULLIF function returns -32768 instead of NULL when querying a Columnstore table (MCOL-5922)

  • when a value of a column is empty text ('') the result of group_concat(json_object(...)) is null instead of the correct result set (MCOL-5986)

Issues Fixed

Can result in hang or crash

  • Creating different keys with cskeys on all nodes can break cluster(key not distributed properly) (MCOL-5019)

  • Bitwise aggregation functions do not work with wide decimals (internal error) (MCOL-5386)

  • Loss of PrimProc can lead to infinite loop (MCOL-5396)

  • GROUP_CONCAT in query uses enormous amount of RAM causing OOM to kill PrimProc (MCOL-5852)

  • mariadbd crashing randomly when running "SELECT calShowPartitions(" (MCOL-5879)

  • SubAdapterStep::execute() MCS-2035 Fix Requested (MCOL-5889)

  • primproc oversubscribes memory (MCOL-5918)

  • primproc 11/SEGV - querying a view (MCOL-5932)

  • Fix rollbacks in mcs cli and passing errors during broadcasting config. (MCOL-5962)

Related to performance

  • Subselect sorting is single-threaded always (MCOL-5316)

Platforms

In alignment with the enterprise lifecycle, MariaDB Enterprise ColumnStore 23.10.3 is provided for:

  • Debian 11 (x86_64, ARM64)

  • Debian 12 (x86_64, ARM64)

  • Red Hat Enterprise Linux 8 (x86_64, ARM64)

  • Red Hat Enterprise Linux 9 (x86_64, ARM64)

  • Rocky Linux 8 (x86_64, ARM64)

  • Rocky Linux 9 (x86_64, ARM64)

  • Ubuntu 20.04 (x86_64, ARM64)

  • Ubuntu 22.04 (x86_64, ARM64)

  • Ubuntu 24.04 (x86_64, ARM64)

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

MariaDB ColumnStore 23.10.3 Release Notes

Overview

MariaDB Enterprise ColumnStore 23.10.3 is a maintenance release of MariaDB Enterprise ColumnStore. MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server.

MariaDB Enterprise ColumnStore 23.10.3 was released on 2025-01-27. This release is of General Availability (GA) maturity. MariaDB Enterprise ColumnStore 23.10.3 is a GA release in the 23.10 series.

This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.6.20-16.

Notable Changes

  • NOT LIKE is not compatible with MariaDB on explicit NULL (MCOL-4499)

  • LEFT(str, negativeInt) returns a wrong result (MCOL-4671)

  • Having not() provokes an ERROR 2013 (MCOL-4756)

  • MariaDB Columnstore produces wrong averages on extracted null-datetime fields (like year) (MCOL-5241)

  • select-union-select gives corrupted values (MCOL-5307)

  • Wrong result ('pNuLl_' instead of NULL) in the TEXT column when LEFT OUTER JOIN is used with WHERE condition (MCOL-5581)

  • Incorrect columnstore result | implicit self joins (MCOL-5651)

  • UNION query returns incorrect results when one table is ENGINE COLUMNSTORE (MCOL-5669)

  • DAY function returns wrong result in query on Columnstore table (MCOL-5670)

  • Different Resultset with AllowDiskBasedAggregation = Y (MCOL-5691)

  • UNION/INTERSECT/EXCEPT VALUES crashes the server if a ColumnStore table is involved (MCOL-5703)

  • Columnstore: SELECT SUM(0) may cause data type unknown error (MCOL-5708)

  • ALTER Column VARCHAR | Not Supported (MCOL-5779)

  • MariaDB Columnstore 23.10.2: wrong COUNT DISTINCTs in GROUP BY (MCOL-5875)

  • SELECT GROUP BY is not picking not-NULL values (MCOL-5755)

  • SELECT CONCAT() throws error: MCS-2021 (MCOL-5776)

Issues Fixed

Can result in hang or crash

  • Reading a Columnstore table via a view using "count" crashes when the view has "order by" in definition (MCOL-5249)

  • CMAPI self-signed cert are expired after one year.. which leads to "Connection refused" messages (MCOL-5454)

  • Columnstore crashes/unstable on too large selects (MCOL-5587)

  • OOM occurs during disk based aggregation with um_mem_limit > 0 (MCOL-5715)

  • SM doesn't quit endless loop when S3 service returns non-retryable error (MCOL-5785)

  • MCS crashes when PMSmallSide is raised > 1GB(the current default) (MCOL-5787)

  • Memory leaks in plugin code (MCOL-5791)

  • RGData ui32 counters limits us with addressing big data (MCOL-5794)

  • Separated UM/PM topologies are broken b/c DEC sends request to impossible PM id (MCOL-5805)

  • UM/PM roles are broken in DEC::writeToClients (MCOL-5808)

  • Columnstore Server crashes when REGEX is matched to function return value (MCOL-5812)

  • Pass UBSAN sanity checks (MCOL-5844)

Related to performance

  • ByteStreamProcessor is slow with UM JOIN (MCOL-5788)

  • Remove boost::iequals from the code because it takes a global lock getting a locale (MCOL-4696)

Platforms

In alignment with the enterprise lifecycle, MariaDB Enterprise ColumnStore 23.10.3 is provided for:

  • Debian 11 (x86_64, ARM64)

  • Debian 12 (x86_64, ARM64)

  • Red Hat Enterprise Linux 8 (x86_64, ARM64)

  • Red Hat Enterprise Linux 9 (x86_64, ARM64)

  • Rocky Linux 8 (x86_64, ARM64)

  • Rocky Linux 9 (x86_64, ARM64)

  • Ubuntu 20.04 (x86_64, ARM64)

  • Ubuntu 22.04 (x86_64, ARM64)

  • Ubuntu 24.04 (x86_64, ARM64)

Installation Instructions

  • ColumnStore Object Storage Topology with MariaDB Enterprise Server 10.6 and MariaDB Enterprise ColumnStore 23.10

  • ColumnStore Shared Local Storage Topology with MariaDB Enterprise Server 10.6 and MariaDB Enterprise ColumnStore 23.10

  • HTAP Topology with MariaDB Enterprise Server 10.6 and MariaDB Enterprise ColumnStore 23.10

  • Single-Node Enterprise ColumnStore 23.10 with MariaDB Enterprise Server 10.6 and Object Storage

  • Single-Node Enterprise ColumnStore 23.10 with MariaDB Enterprise Server 10.6

Upgrade Instructions

  • Upgrade Multi-Node MariaDB Enterprise ColumnStore from 6 to 23.10

  • Major Release Upgrades for MariaDB Enterprise ColumnStore

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

MariaDB ColumnStore 23.10.2 Release Notes

Overview

MariaDB Enterprise ColumnStore 23.10.2 is a feature release of MariaDB Enterprise ColumnStore. MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server.

MariaDB Enterprise ColumnStore 23.10.2 was released on 2024-08-19. This release is of General Availability (GA) maturity. MariaDB Enterprise ColumnStore 23.10.2 is a GA release in the 23.10 series.

This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.6.18-14.

Notable Changes

  • Save EM image locally if S3 fails PUT request or avoid saving if shared memory image is damaged or empty (MCOL-5709)

  • No data gets loaded into BLOB column and the value is left NULL (MCOL-5746)

  • Using regexp_substr on table with engine=columnstore results in error:"Function 'regexp_substr' isn't supported." (MCOL-5328)

  • Interactive "mcs cluster stop" command for CMAPI (MCOL-5594)

Issues Fixed

  • ORDER BY clause if not included in the GROUP BY clause fails (MCOL-4234)

  • Group By ... Order By NULL fails (MCOL-4235)

  • Alter table add column leaves table unusable (MCOL-4480)

  • select * into file from (select ... group by) produces spurious error (MCOL-4637)

  • MariaDB Columnstore all versions: update and inserts behave differently on 0000-00-00 00:00:00 datetime (MCOL-5035)

  • Cross-Engine join at text type not supported (MCOL-5056)

  • ColumnStore table does not exist after a rename (MCOL-5197)

  • Using views leads to an error when an Analyzer report with a measure and a year is built. (MCOL-5236)

  • Views with null-replaced timestamps yield incorrect query results (MCOL-5237)

  • RAND() uses static seed of 0 (MCOL-5492)

  • Resultset will be cut with setting columnstore_um_mem_limit >0 (MCOL-5689)

  • CS return error for intersect (MCOL-5699)

  • Random columnstore error MCS-2035 with special SELECT structures (MCOL-5704)

Can result in a hang or crash

  • CMAPI: ConnectionRefusedError unhandled exception (MCOL-5749)

  • Truncate table failed after PrimProc restarted (MCOL-5352)

  • mcs-savebrm stores an empty EM on cluster shutdown rendering the cluster unusable (MCOL-5405)

  • NULL & non-zero length string, assertion 'mStr || mLength == 0' failed (MCOL-5597)

Can result in unexpected behavior

  • Disk join step race with parallel join (more than one thread) (MCOL-5626)

Platforms

In alignment with the enterprise lifecycle, MariaDB Enterprise ColumnStore 23.10.2 is provided for:

  • Debian 11 (x86_64, ARM64)

  • Debian 12 (x86_64, ARM64)

  • Red Hat Enterprise Linux 8 (x86_64, ARM64)

  • Red Hat Enterprise Linux 9 (x86_64, ARM64)

  • Rocky Linux 8 (x86_64, ARM64)

  • Rocky Linux 9 (x86_64, ARM64)

  • Ubuntu 20.04 (x86_64, ARM64)

  • Ubuntu 22.04 (x86_64, ARM64)

  • Ubuntu 24.04 (x86_64, ARM64)

Installation Instructions

  • ColumnStore Object Storage Topology with MariaDB Enterprise Server 10.6 and MariaDB Enterprise ColumnStore 23.10

  • ColumnStore Shared Local Storage Topology with MariaDB Enterprise Server 10.6 and MariaDB Enterprise ColumnStore 23.10

  • HTAP Topology with MariaDB Enterprise Server 10.6 and MariaDB Enterprise ColumnStore 23.10

  • Single-Node Enterprise ColumnStore 23.10 with MariaDB Enterprise Server 10.6 and Object Storage

  • Single-Node Enterprise ColumnStore 23.10 with MariaDB Enterprise Server 10.6

Upgrade Instructions

  • Upgrade Multi-Node MariaDB Enterprise ColumnStore from 6 to 23.10

  • Major Release Upgrades for MariaDB Enterprise ColumnStore

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

MariaDB ColumnStore 23.10.1 Release Notes

Overview

MariaDB Enterprise ColumnStore 23.10.1 is a feature release of MariaDB Enterprise ColumnStore. MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server.

MariaDB Enterprise ColumnStore 23.10.1 was released on 2024-03-11. This release is of General Availability (GA) maturity. MariaDB Enterprise ColumnStore 23.10.1 is a GA release in the 23.10 series.

This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.6.17-12.

The changes listed here are relative to MariaDB Enterprise ColumnStore 23.02.4.

Notable Changes

  • Cross db table rename fails (MCOL-4202)

  • Columnstore throws error when using GROUP BY on DB-Views where field name is identical in two different tables (MCOL-5463)

  • GROUP BY on duplicate expressions using functions throws error "IDB-2001: ... is not in GROUP BY clause." on Columnstore (MCOL-5476)

  • Support WITH ROLLUP (MCOL-678)

Issues Fixed

Can result in data loss

  • Shmem segment remap causes SEGV in ExtentMapIndexImpl::find (MCOL-5559)

Can result in a hang or crash

  • Queries stuck in MariaDB waiting for an answer from PrimProc (MCOL-5565)

  • LIKE '%1%' in WHERE part never finishes (MCOL-5599)

  • PrimProc goes in a loop, 100% CPU usage on a single core (MCOL-5602)

  • PrimProc crashes in json_key_matches (MCOL-5607)

  • FairThreadScheduler::sendErrorMsg and BPPSeeder::sendErrorMsg crash PP trying to send to a nullptr sock (MCOL-5636)

Can result in unexpected behavior

  • UPDATE returns wrong "Rows matched" on multi-tables (MCOL-4740)

  • json data returns differently by same query (MCOL-5350)

  • Columnstore query returns incorrect value instead of expected out-of-range error (MCOL-5568)

  • JSON_QUERY is stateful (may segfault on big amount of data) (MCOL-5625)

  • Continuous workload triggers unknown primitive cmd message in PP log (MCOL-5637)

Related to performance

  • CPU wastes time in wait and sys because of urandom access in RowStorage (MCOL-5472)

Related to install and upgrade

  • Wrong metadata in CMAPI packages (MCOL-5595)

Platforms

In alignment with the enterprise lifecycle, MariaDB Enterprise ColumnStore 23.10.1 is provided for:

  • Debian 11 (x86_64, ARM64)

  • Debian 12 (x86_64, ARM64)

  • Red Hat Enterprise Linux 8 (x86_64, ARM64)

  • Red Hat Enterprise Linux 9 (x86_64, ARM64)

  • Rocky Linux 8 (x86_64, ARM64)

  • Rocky Linux 9 (x86_64, ARM64)

  • Ubuntu 20.04 (x86_64, ARM64)

  • Ubuntu 22.04 (x86_64, ARM64)

  • Ubuntu 24.04 (x86_64, ARM64)

Installation Instructions

  • ColumnStore Object Storage Topology with MariaDB Enterprise Server 10.6 and MariaDB Enterprise ColumnStore 23.10

  • ColumnStore Shared Local Storage Topology with MariaDB Enterprise Server 10.6 and MariaDB Enterprise ColumnStore 23.10

  • HTAP Topology with MariaDB Enterprise Server 10.6 and MariaDB Enterprise ColumnStore 23.10

  • Single-Node Enterprise ColumnStore 23.10 with MariaDB Enterprise Server 10.6 and Object Storage

  • Single-Node Enterprise ColumnStore 23.10 with MariaDB Enterprise Server 10.6

Upgrade Instructions

  • Upgrade Multi-Node MariaDB Enterprise ColumnStore from 6 to 23.10

  • Major Release Upgrades for MariaDB Enterprise ColumnStore

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

MariaDB ColumnStore 23.10.0 Release Notes

Overview

MariaDB Enterprise ColumnStore 23.10.0 is a feature release of MariaDB Enterprise ColumnStore. MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server.

MariaDB Enterprise ColumnStore 23.10.0 was released on 2023-10-11. This release is of General Availability (GA) maturity. MariaDB Enterprise ColumnStore 23.10.0 is the first GA release in the 23.10 series.

This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.6.15-10.

The changes listed here are relative to MariaDB Enterprise ColumnStore 23.02.4.

Notable Changes

  • Improved compatibility with InnoDB behavior when performing a WHERE clause with NULL comparison. (MCOL-271)

  • The default character set and collation have changed.

    • In previous releases, latin1 is the default character set. latin1 uses 1 byte per character.

    • Starting with this release, utf8 (utf8mb3) is the default character set. utf8mb3 uses 3 bytes per character.

    • If an existing table schema contains column types whose byte width now exceed the maximum byte width for that column type, dropping and creating the table with the new version without specifying CHARSET=latin1, will fail. Users who need latin1 character set should specify CHARSET=latin1 when creating tables (CREATE TABLE). For example, create table t1 (a VARCHAR(8000))engine=columnstore; in the new version using utf8mb3 as the default CHARSET will fail, because the maximum allowable character length will be 2666=(8000/3). So if the user wants to use the existing table schema, latin1 should be specified as the CHARSET either at the column-level (for example, create table t1 (a VARCHAR(8000) charset 'latin1')engine=columnstore; or at the table-level in the DDL, for example, create table t1 (a VARCHAR(8000))engine=columnstore default charset=latin1;

  • mcs cluster commands support ColumnStore cluster management operations. (MCOL-4848)

    • mcs cluster status - get MCS cluster status

    • mcs cluster stop - stop MCS cluster

    • mcs cluster start - start MCS cluster

    • mcs cluster restart - restart MCS cluster

    • mcs cluster node add –-node <hostname\IP\FQDN> - add node to MCS cluster. The –-node argument can be used multiple times in one command.

    • mcs cluster node remove –-node <hostname\IP\FQDN> - remove node from MCS cluster. The –-node argument can be used multiple times in one command.

    • mcs cluster set mode –-mode - set MCS cluster mode. Accepted values are readonly and readwrite

    • mcs cluster set api-key –-key <api_key> - set MCS cluster API management key

    • mcs cluster –-help - outputs help on each command

Some commands have one or multiple optional arguments, to see optional argument values, use the --help argument after any command, for example:

mcs cluster node remove --help
  • Collation information is available to the cpimport utility through the system catalog. (MCOL-5005)

  • cpimport is character set aware. (MCOL-4931)

  • Improved Disk Join step to handle corner cases for large data. (MCOL-5477)

  • The columnstore.cnf has been cleaned up and updated. Unused code has been deleted. Certain server settings related to ColumnStore performance that may differ than the server's own defaults have been added, for example, character_set_server and collation_server. (MCOL-5519)

Issues Fixed

Can result in unexpected behavior

  • After a DML failure, the table lock remains. (MCOL-4988)

  • After using ALTER TABLE to add a new AUTOINCREMENT column or to change a column to AUTOINCREMENT, callastinsertid() shows incorrect autoincrement value. (MCOL-5572)

  • Trailing spaces behave differently in ColumnStore than in InnoDB causing unexpected results. (MCOL-4403)

  • With a query containing a 3 table JOIN, the wrong result can be returned. (MCOL-5539)

  • With queries containing a JOIN, a bad result set can be produced. (MCOL-5522)

  • After switching JOIN order, the aggregated count on left join result is incorrect. (MCOL-5543)

  • After installation or service restart, permissions for the /dev/shm directory are incorrect. (MCOL-5535)

Interface Changes

  • columnstore_diskjoin_force_run system variable added

  • columnstore_diskjoin_max_partition_tree_depth system variable added

  • columnstore_max_allowed_in_values system variable added

  • columnstore_max_pm_join_result_count system variable added

  • mariadbd --columnstore-diskjoin-force-run command-line option added

  • mariadbd --columnstore-diskjoin-max-partition-tree-depth command-line option added

  • mariadbd --columnstore-max-allowed-in-values command-line option added

  • mariadbd --columnstore-max-pm-join-result-count command-line option added

Default Values Changed

  • character_set_client changed from latin1 to utf8mb3

  • character_set_connection changed from latin1 to utf8mb3

  • character_set_database changed from latin1 to utf8mb3

  • character_set_results changed from latin1 to utf8mb3

  • character_set_server changed from latin1 to utf8mb3

  • collation_connection changed from latin1_swedish_ci to utf8mb3_general_ci

  • collation_database changed from latin1_swedish_ci to utf8mb3_general_ci

  • collation_server changed from latin1_swedish_ci to utf8mb3_general_ci

If an existing table schema contains column types whose byte width now exceed the maximum byte width for that column type, dropping and creating the table with the new version without specifying CHARSET=latin1, will fail. Users should specify CHARSET=latin1 in CREATE TABLE statements.

Platforms

In alignment with the enterprise lifecycle, MariaDB Enterprise ColumnStore 23.10.0 is provided for:

  • CentOS 7 (x86_64)

  • Debian 11 (x86_64, ARM64)

  • Debian 12 (x86_64, ARM64)

  • Red Hat Enterprise Linux 7 (x86_64)

  • Red Hat Enterprise Linux 8 (x86_64, ARM64)

  • Red Hat Enterprise Linux 9 (x86_64, ARM64)

  • Rocky Linux 8 (x86_64, ARM64)

  • Rocky Linux 9 (x86_64, ARM64)

  • Ubuntu 20.04 (x86_64, ARM64)

  • Ubuntu 22.04 (x86_64, ARM64)

Installation Instructions

  • ColumnStore Object Storage Topology with MariaDB Enterprise Server 10.6 and MariaDB Enterprise ColumnStore 23.02

  • ColumnStore Shared Local Storage Topology with MariaDB Enterprise Server 10.6 and MariaDB Enterprise ColumnStore 23.02

  • HTAP Topology with MariaDB Enterprise Server 10.6 and MariaDB Enterprise ColumnStore 23.02

  • Single-Node Enterprise ColumnStore 23.02 with MariaDB Enterprise Server 10.6 and Object Storage

  • Single-Node Enterprise ColumnStore 23.02 with MariaDB Enterprise Server 10.6

Upgrade Instructions

  • Upgrade Multi-Node MariaDB Enterprise ColumnStore from 6 to 23.10

  • Major Release Upgrades for MariaDB Enterprise ColumnStore

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