Release Notes for MariaDB Enterprise Server 10.5.9-6

Crash on recovery after server kill during instant ADD COLUMN (MDEV-24323)

Possible segfault on CREATE TABLE with explicit FTS_DOC_ID_INDEX using multiple fields. (MDEV-24403)

Server crashes upon attempt to update view through second execution of a stored procedure. (MDEV-16940)

CREATE VIEW containing WITH clause can crash. (MDEV-22781)

Possible crash for a query using recursive CTE without having a default schema defined. (MDEV-24019)

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 innodb_use_native_aio=0 and innodb_write_io_threads=1 (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)

SHOW GRANTS is missing the WITH GRANT privilege for roles. (MDEV-24289)

mysqld_safe log messages are missing in the error log file. (MDEV-21367)

CHECK_CLAUSE field in INFORMATION_SCHEMA.CHECK_CONSTRAINTS truncates check constraints expressions. (MDEV-24139)

Unexpected error message when selecting from view that uses mergeable derived table. (MDEV-24314)

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

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

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

Plugin system variables and activation options can break mariadbd --wsrep_recover 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 CREATE VIEW 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 slave_parallel_threads is enabled. (MDEV-8134)

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

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

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

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

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

UPDATE 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 .. SELECT FROM does not create table if VALUE() is not using a scalar value. (MDEV-24618)

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

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

SHOW CREATE USER 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 mariadb-binlog 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)

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

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

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

The default setting of innodb_max_dirty_pages_pct_lwm=0 has effects on innodb_adaptive_flushing=ON with results in a performance regression. (MDEV-24537)

Accessing INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION may break innodb_open_files logic. (MDEV-24190)

performance_schema.events_transactions_history_long.trx_id reports garbage. (MDEV-24600)

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

BINLOG REPLAY privilege is missing from SHOW PRIVILEGES (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 IN or NOT IN using InnoDB. (MDEV-9750)

mariadb-upgrade fails with error messages ALGORITHM=INSTANT is not supported for this operation (MDEV-16735)

mariadb-upgrade hangs when executing ALTER TABLE on the mysql.event system table, if the table is not empty (MDEV-24452)

Enterprise upgrade from 10.4 to 10.5 fails with option disable-s3 in the 10.4 configuration file. (MENT-1068)