Release Notes for MariaDB Shell 22.12.1

Notable Changes

• On Linux, the ros sub-commands can be used to interact with the Remote Observability Service (ROS). (TENT-208, TENT-233, TENT-240)

  • The ros install sub-command can be used to install the components of ROS. For information on how to perform the installation, see "Install MariaDB Agent Manager with MariaDB Shell".

  • For information on all ros sub-commands, see "Remote Observability Service Sub-commands for MariaDB Shell".

• As a security enhancement, when MariaDB Shell prompts for passwords and other sensitive information, the specified string is not printed to the screen. (TENT-199)

• The ls and dir sub-commands can be used to list databases and tables. (TENT-190)

• For compatibility with mariadb client, the -e and --execute command-line options can be used to execute queries. (TENT-105)

• MariaDB Shell enables autocommit by default. (TENT-102, TENT-235)

• SQL files can be executed using standard input redirection. (TENT-29)

• Error messages have been improved. (TENT-162, TENT-188)

• The --protocol command-line option can be used to select a protocol. (TENT-219)

  • The options are: mariadb, mysql, xpand, max, maxscale

  • By default, the protocol is mariadb

• The --help command-line option prints the MariaDB Shell version. (TENT-223)

• When MariaDB Shell connects using a user with an expired password, MariaDB Shell prompts the user to change their password. (TENT-234)

• On Linux distributions, the mariadb-shell package is no longer dependent on the package containing mariadb client, which has a different name on different distributions. (TENT-244)

  • On CentOS, RHEL, and Rocky Linux, the dependency on the MariaDB-client package was removed.

  • On Debian and Ubuntu, the dependency on the mariadb-client package was removed.

• MaxScale CLI integration is supported. (TENT-81)

• Hot-swappable output style for queries are supported. (TENT-13)

  • To hot-swap the output style for a single query, prefix the query with the output sub-command:

    MariaDB (No Database) » output classic SELECT 1;
    

    Output format changed to classic
    +---+
    | 1 |
    +---+
    | 1 |
    +---+
    

Issues Fixed

Known Issues

• This release of MariaDB Shell fails during execution if the installed MariaDB Connector/C package is the package bundled with MariaDB Enterprise Server. (CONPY-243)

  • The following error message can occur upon execution:

      File "/root/.pyenv/versions/3.10.7/lib/python3.10/site-packages/mariadb/__init__.py", line 136, in <module>
      File "/root/.pyenv/versions/3.10.7/lib/python3.10/site-packages/mariadb/__init__.py", line 136, in <genexpr>
    ValueError: invalid literal for int() with base 10: '17-12'
    

  • To use this release of MariaDB Shell, ensure that your MariaDB Connector/C package is the package bundled with MariaDB Community Server, which can be installed from the MariaDB Community Repository.

  • On CentOS, RHEL, and Rocky Linux, the MariaDB Connector/C package is called MariaDB-shared.

  • On Debian and Ubuntu, the MariaDB Connector/C package is called libmariadb3.

• This release of MariaDB Shell fails during execution if the MariaDB Connector/C package is not installed. (CONPY-243)

  • The following error message can occur upon execution:

      File "/root/.pyenv/versions/3.10.7/lib/python3.10/site-packages/mariadb/__init__.py", line 7, in <module>
    ImportError: libmariadb.so.3: cannot open shared object file: No such file or directory
    

  • To use this release of MariaDB Shell, ensure that the MariaDB Connector/C package is installed.

Platforms

MariaDB Shell 22.12.1 is provided for:

• Apple macOS (x86_64, M1)

• CentOS 7 (x86_64)

• Debian 10 (x86_64)

• Debian 11 (x86_64)

• Microsoft Windows (x86_64)

• Red Hat Enterprise Linux 7 (x86_64)

• Red Hat Enterprise Linux 8 (x86_64)

• Red Hat Enterprise Linux 9 (x86_64)

• Rocky Linux 8 (x86_64)

• Rocky Linux 9 (x86_64)

• Ubuntu 18.04 (x86_64)

• Ubuntu 20.04 (x86_64)

• Ubuntu 22.04 (x86_64)

Installation

• Install MariaDB Shell

Resources

• Usage Documentation

• Usage Documentation for SkySQL

• Reference Documentation

• Issue Reporting