Release Notes for MariaDB Enterprise Server 10.5.9-6

MariaDB Enterprise Backup adds completed with Error! to the end of the log file if the backup is started with parameter --log-innodb-page-corruption and completed with corrupted tables. The new log entry canceled with Error! will be used when the backup could not be completed. (MENT-1059)

and system variables are read-only. (MDEV-25179)

Galera wsrep library updated to 26.4.7 in MariaDB Enterprise Cluster.

and allow either order for ACCOUNT LOCK and PASSWORD EXPIRE (MDEV-24098)

Server crash on WITH RECURSIVE UNION ALL (CTE) query. (MDEV-23619)

Server hang due to Galera lock conflict resolution. (MDEV-23328)

Possible crash in replication when applying a transaction that contains cascading foreign key delete for a table and that has an indexed virtual column. (MDEV-23033)

Possible lock conflicts between two wsrep high priority threads in MariaDB Enterprise Cluster on tables having unique secondary keys. (MDEV-23851)

Server crash when VALUE() uses a subselect. (MDEV-24675)

Possible crash of the server when audit logging is active. (MENT-1098)

MariaDB Enterprise Cluster crash after execution of XA START (MDEV-24469)

Hang with and (MDEV-24313)

Encryption is modifying a freed page for InnoDB, which results in a crash. (MDEV-24695)

A query on a table with composite key and range condition on multiple attributes can result in a crash. (MENT-1126)

Permission denied error message is returned on users with permissions for nested CTEs. (MDEV-20751)

Regression: SELECT .. UNION .. with inconsistent column names fails. (MDEV-19179)

Race condition between and transaction commit with MariaDB Enterprise Cluster. (MDEV-23536)

Plugin system variables and activation options can break for MariaDB Enterprise Cluster. (MDEV-20717)

SELECT INTO OUTFILE used permission 666 where 644 should be used to limit the privileges to change the file. (MDEV-23875)

Syntax error on correct syntax for that includes X is null = 0 (MDEV-24194)

Altered connection limits for user have no effect. (MDEV-17852)

Syntax error when using COLLATE for creating virtual columns. (MDEV-12161)

Auto purge of relaylogs stops when relay-log-file is slave-relay-log.999999 and is enabled. (MDEV-8134)

ORDER BY in view definition leads to wrong result with GROUP BY on query using view. (MDEV-23826)

column from a derived table returns invalid values. (MDEV-23291)

doesn't respect filters for PROXY_CONNECT events. (MDEV-24318)

plugin doesn't consider proxy users in and (MDEV-19442)

With ALTER USER .. IDENTIFIED BY command, password isn't replaced by asterisks in audit log. (MENT-1128)

does not insert history row for system versioned or application period based tables if the row has not changed. (MDEV-23446)

Wrong duplicate primary key error between the history row generated on referential action and the history row on evaluating foreign referential action for self-reference in a system versioned table. (MDEV-21138, MDEV-23644)

Wrong number of decimal digits in certain UNION or subquery constellations, like union of unsigned and NULL type. (MDEV-24387)

[CREATE TABLE](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-statements-and-structure/sql-statements/data-definition/create/create-table) .. SELECT FROM does not create table if VALUE() is not using a scalar value. (MDEV-24618)

InnoDB may report incorrect binlog position information after (MDEV-22351)

Sequences which are used as default by a table are not dumped in right order by (MDEV-21785)

generates invalid SQL for user where password expiry and account lock set. (MDEV-24098)

Garbd of MariaDB Enterprise Cluster can't initiate SST (MDEV-23647)

Misleading error message from might be interpreted as a point in time recovery is not possible. (MDEV-23846)

High memory usage in the optimizer when a query is using SELECT .. FROM tbl .. WHERE unique_key not in (long-list) AND .. unique_key not in (long-list) AND .. (MDEV-24711)

for tables with CHECK CONSTRAINTS returns with Out of Memory error. (MDEV-24274)

Alter rename table does not remove table from when using algorithm=copy (MDEV-24364)

Persistent statistics are lost for table after (MDEV-24564)

The default setting of has effects on with results in a performance regression. (MDEV-24537)

Accessing may break innodb_open_files logic. (MDEV-24190)

reports garbage. (MDEV-24600)

S3, same-backend replication: Dropping a table on primary causes error on replica. (MDEV-24351)

privilege is missing from (MDEV-24344)

Flushing starts only when 90% (srv_max_buf_pool_modified_pct) pages are modified. (MDEV-24917)

Quick memory exhaustion with extended_keys=on on queries having multiple or using InnoDB. (MDEV-9750)

system variable minimum value changed from 1 to 2

mariadb-backup --log-innodb-page-corruption command-line option added

mariadb-dump --system command-line option added

mariadb_es_repo_setup --include-unsupported command-line option added

mariadb_es_repo_setup --skip-check-installed command-line option added

mariadb_es_repo_setup --version command-line option added

mariadb_repo_setup --version command-line option added

mariadbd --innodb-idle-flush-pct command-line option removed

mariadbd --optimizer-max-sel-arg-weight command-line option added

system variable minimum value changed from 8 to 64

system variable added

performance schema table schema changed

information schema table schema changed

Red Hat Enterprise Linux 8 (x86_64, ARM64)

Red Hat Enterprise Linux 9 (x86_64, ARM64)

Rocky Linux 8 (x86_64, ARM64)

Rocky Linux 9 (x86_64, ARM64)

SUSE Linux Enterprise Server 12 (x86_64)

SUSE Linux Enterprise Server 15 (x86_64, ARM64)

Ubuntu 20.04 (x86_64, ARM64)

Enterprise Spider Sharded Topology with MariaDB Enterprise Server 10.5

Enterprise Spider Federated Topology with MariaDB Enterprise Server 10.5