The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2025-01-30. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB ColumnStore 23.10.2 Release Notes

Contents

  1. Overview
  2. Notable Changes
  3. Issues Fixed
    1. Can result in a hang or crash
    2. Can result in unexpected behavior
  4. Platforms
  5. Installation Instructions
  6. Upgrade Instructions

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 to the enterprise lifecycle, MariaDB Enterprise ColumnStore 23.10.2 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

Upgrade Instructions

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.