Release Notes for MariaDB Enterprise Server 10.4.18-11

In a very unlikely event, corruption of system tablespace or last recovered page can occur on recovery or a MariaDB Backup prepare. (MENT-1124, MDEV-24449)

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)

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)

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