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
Support added for S3 storage engine. Replication is supported also when the same S3 storage is used for Primary and Replica.
Support added for MariaDB ColumnStore 1.5. Note, that plugins have independent maturity levels and MariaDB ColumnStore 1.5.2 in MariaDB Community Server 10.5.4 has beta maturity.
DROP TABLE statements now reliably delete table remnants inside storage engines, even if
frm
file is missing.Accelerated CRC32() function. (MDEV-22669)
Improves to DROP TABLE for InnoDB. (MDEV-8069) (MDEV-11412) (MDEV-22456)
InnoDB performance improvements. (MDEV-15053) (MDEV-22593) (MDEV-22697) (MDEV-22871) (MDEV-22841)
Changed Features
Updates limit innodb_encryption_threads to 255. (MDEV-22258)
Minimum value of max_sort_length raised to 8 (previously 4), so fixed size data types like
DOUBLE
andBIGINT
are not truncated for lower values of max_sort_length. (MDEV-22715)
Deprecated Features
Deprecates and ignores innodb_log_optimize_ddl. (MDEV-19747)
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 withER_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 anORDER 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
uponSET PASSWORD via SP
. (MDEV-20366)Fixes data loss on
DOUBLE
andDECIMAL
conversions toINT
. (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