Release Notes for MariaDB Community Server 10.5.4

MariaDB Community Server 10.5.4 is the fifth release of the community release of MariaDB Server 10.5.

MariaDB Community Server 10.5.4 was released on 2020-06-24. It is a General Availability (GA) release.

New Features

Changed Features

Deprecated Features

Bug Fixes

  • InnoDB Buffer Pool no longer performs unnecessary page hash S-latch acquisition. (MDEV-22877)

  • Fixes possible wrong result in SELECT statements with GROUP BY clauses. (MDEV-22819)

  • Fixes query cache still activated in Ubuntu packages. (MDEV-22795)

  • Fixes crash with a stored aggregate function returning INET6. (MDEV-22764)

  • Fixes Galera node crash occurring when logging to a Slow Query Log table in Streaming Replication mode. (MDEV-22617)

  • Fixes Server crashing on INSERT statements on partitioned system versioned tables created WITHOUT OVERLAPS. (MDEV-22753)

  • Fixes WITHOUT OVERLAPS issue when performing updates via Foreign Key cascade. (MDEV-22602)

  • Fixes WITHOUT OVERLAPS issue involving prefix indexes. (MDEV-22599)

  • Fixes issue in RocksDB with system versioned tables using WITHOUT OVERLAPS where UPDATE statements fail with ER_CONSTRAINT_FAILED. (MDEV-22434)

  • Fixes issue with the COUNT(*) function on Spider tables using MariaDB ColumnStore as one of its back-ends. (MDEV-22372)

  • Fixes issue in InnoDB where ib_logfile0 is found to be too small for innodb_thread_concurrency when set 0. (MDEV-22325)

  • Fixes incorrect ordering with REGEXP_REPLACE() and OFFSET/LIMIT. (MDEV-22303)

  • Fixes view returns a wrong result set if its definition contains JSON_ARRAYAGG(). (MDEV-22685)

  • Fixes squared brackets missing from the JSON_ARRAYAGG() function when used in a view. (MDEV-22084)

  • Fixes DISTINCT with JSON_ARRAYAGG() gives wrong results. (MDEV-22011)

  • Fixes issue in JSON_ARRAYAGG() function not rejecting invalid ORDER BY clause. (MDEV-21914)

  • Fixes incorrect escaping when nesting the JSON_ARRAYAGG() function in the JSON_OBJECT() function. (MDEV-21902)

  • Fixes the JSON_ARRAYAGG() function to no longer return wrong results when called on a NULL value in an ORDER BY clause. (MDEV-22840)

  • Fixes incorrect error message returned by the JSON_OBJECTAGG() function. (MDEV-22823)

  • Fixes incorrect character set and collation in user variables. (MDEV-21815)

  • Fixes issue in Connect tables with INET6 columns raising warnings to SELECT statements. (MDEV-21764)

  • Fixes Server crashing in get_current_user upon SET PASSWORD via SP. (MDEV-20366)

  • Fixes data loss on DOUBLE and DECIMAL conversions to INT. (MDEV-20305)

  • Fixes issue of the PERCENTILE_DISC() function rejecting temporal and string input. (MDEV-20280)

  • Fixes Server failing to load configuration and some plugins that are inactivated due to a pre-installed mysql-common package. (MDEV-19933)

  • Fixes issue of BACKUP STAGE BLOCK_DDL hanging on flush sequence table. (MDEV-19745)

  • Fixes issue of query caching being disabled by default in APT packages. (MDEV-16251)

  • Fixes issue of CREATE PROCEDURE statement returning no error when using an unknown variable. (MDEV-14347)

  • Fixes lock up in InnoDB occurring on DROP TABLE statements or when rebuilding large tables. (MDEV-8069)

Platforms

In alignment to the MariaDB Corporation Engineering Policy, MariaDB Community Server 10.5.4 is provided for:

  • Red Hat Enterprise Linux 8

  • Red Hat Enterprise Linux 7

  • Red Hat Enterprise Linux 6

  • CentOS 8

  • CentOS 7

  • CentOS 6

  • Ubuntu 20.04

  • Ubuntu 18.04

  • Ubuntu 16.04

  • Debian 10

  • Debian 9

  • Debian 8

  • SUSE Linux Enterprise Server 15

  • SUSE Linux Enterprise Server 12

  • Microsoft Windows