Release Notes for MariaDB Xpand 5.3.20

Overview

MariaDB Xpand is a distributed SQL database that is part of MariaDB Enterprise. This release of MariaDB Xpand is a maintenance release.

MariaDB Xpand 5.3.20 was released on 2022-02-08.

Notable Changes

  • Some of Xpand's replication-related tools have been updated to work with parallel replication, including:

    • reptool

    • repclient

Issues Fixed

Can Result in a Hang or Crash

  • When STOP SLAVE is executed, the replica (slave) node can crash.

Can Result in Unexpected Behavior

  • When parallel replication is configured using CREATE SLAVE .. SLICES=0 or by omitting the SLICES option, serial replication is used instead of parallel replication.

    • Starting with this release, when the SLICES option is set to 0 or omitted, parallel replication is used, and the number of slices defaults to the number of nodes in the cluster.

  • After upgrading to Xpand 5.3.19, columns with invalid DEFAULT values can trigger errors, even when sql_mode='' is set.

    • In Xpand 5.3.19, when a table definition contains columns with invalid DEFAULT values, creating the table, altering the table, or accessing the table fails with the following error:

      ERROR 1366 (HY000): [64519] Value invalid: Failed to evaluate default value for "COLUMN_NAME" ("'VALUE' is an invalid DATA_TYPE")
      
    • In Xpand 5.3.19, when a table definition contains columns with invalid DEFAULT values, restoring the table fails with the following error:

      ERROR 1366 (HY000): [64519] Value invalid: creating table "DATABASE_NAME"."TABLE_NAME" during restore (While restoring object DATABASE_NAME.TABLE_NAME: (Failed to evaluate default value for "COLUMN_NAME" ("'VALUE' is an invalid DATA_TYPE")))
      
    • Starting with this release, Xpand allows columns to have invalid DEFAULT values when sql_mode does not contain STRICT_TRANS_TABLES.

Installation Instructions

Upgrade Instructions