Release notes for MariaDB ColumnStore 23.10
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.
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)
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)
Subselect sorting is single-threaded always (MCOL-5316)
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 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.
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)
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)
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)
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)
Upgrade Multi-Node MariaDB Enterprise ColumnStore from 6 to 23.10
This page is: Copyright © 2025 MariaDB. All rights reserved.
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.
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)
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)
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)
Disk join step race with parallel join (more than one thread) (MCOL-5626)
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)
Upgrade Multi-Node MariaDB Enterprise ColumnStore from 6 to 23.10
This page is: Copyright © 2025 MariaDB. All rights reserved.
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.
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)
Shmem segment remap causes SEGV in ExtentMapIndexImpl::find (MCOL-5559)
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)
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)
CPU wastes time in wait and sys because of urandom access in RowStorage (MCOL-5472)
Wrong metadata in CMAPI packages (MCOL-5595)
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)
Upgrade Multi-Node MariaDB Enterprise ColumnStore from 6 to 23.10
This page is: Copyright © 2025 MariaDB. All rights reserved.
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.
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)
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)
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
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.
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)
Upgrade Multi-Node MariaDB Enterprise ColumnStore from 6 to 23.10
This page is: Copyright © 2025 MariaDB. All rights reserved.