Release Notes for MariaDB Xpand 5.3.22

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.22 was released on 2022-07-14.

Notable Changes

  • statd.py can now accept the database user password from an environment variable.

    • Providing the password via an environment variable can be more secure than providing it using the --password command-line option, because the command-line option appears in the output of ps.

    • When the -E command-line option is specified, the database user password is read from the XPAND_SQL_PASSWD environment variable:

      $ export XPAND_SQL_PASSWD='USER_PASSWORD'
      $ /opt/clustrix/bin/statd.py --host 'HOSTNAME' --user 'USER_NAME' -E
      

Issues Fixed

Can result in data loss

  • When an UPDATE is executed on a table that has a TIMESTAMP or DATETIME column defined with ON UPDATE NOW(), the column's value is not updated to the current timestamp if the table also has a trigger defined with BEFORE UPDATE .. FOR EACH ROW.

    • Starting with this release, Xpand updates columns defined with ON UPDATE NOW() when the table also has a trigger defined with BEFORE UPDATE .. FOR EACH ROW.

Upgrade Instructions