Release Notes for MariaDB Enterprise Server 10.3.36-17
MariaDB Enterprise Server 10.3.36-17 is a maintenance release of MariaDB Enterprise Server 10.3. This release includes a variety of fixes.
MariaDB Enterprise Server 10.3.36-17 was released on 2022-09-12.
Fixed Security Vulnerabilities
CVE (with cve.mitre.org link)
CVSS base score
Can result in data loss
mariadb-backupis executed with the
--rsynccommand-line option, the backup tries to copy the InnoDB buffer pool dump file, which is located at the path defined by the
innodb_buffer_pool_filenamesystem variable. (MDEV-28781)
Starting with this release,
mariadb-backuponly copies the InnoDB buffer pool dump file during State Snapshot Transfers (SSTs) for MariaDB Enterprise Cluster, powered by Galera.
Can result in a hang or crash
INSERT .. SELECT .. GROUP BYis executed and the
GROUP BYclause contains a derived table, the server can crash. (MDEV-28617)
When a query contains an
ANY(SELECT .. GROUP BY(SELECT ..))predicand with a redundant subquery in the
GROUP BYclause, the server can crash. (MDEV-29139)
ALTER TABLE .. ADDis used to add a column with the
INSTANTalgorithm, the server can crash if the
.frmfile does not match the actual row format used by the data file. (MDEV-26577)
For tables created prior to MariaDB Server 10.2, the
.frmfile could be inconsistent with the actual row format used by the data file. If the server were upgraded to MariaDB Enterprise Server 10.6, the inconsistency could remain.
INSERT .. SELECTis executed and the
SELECTquery calls an aggregate or window function, the server can crash with a segmentation fault. (MDEV-26427)
When a query uses the
DISTINCTkeyword and calls an aggregate function as an argument for an always-constant function, the server can crash. (MDEV-23809)
An always-constant function is a function that always returns a constant value, even if the function's arguments are not constant.
For example, the
COLLATION()function is an always-constant function.
Can result in unexpected behavior
INcondition contains a mixture of numeric and string values, results can be inconsistent. (MDEV-21445)
When a transaction can't be fully written to the binary log, but the transaction can be safely rolled back, a
LOST_EVENTSincident event is written to the binary log. (MDEV-21443)
In previous releases, this problem could cause replica servers to encounter the following error:
Last_SQL_Errno 1590 Last_SQL_Error The incident LOST_EVENTS occurred on the master. Message: error writing to the binary log
Starting with this release, a
LOST_EVENTSincident is only written to the binary log when safe rollback is not possible.
When a replica server replicates an incident event, the details about the failure are not in the primary server's error log, the replica server's error log, or the output of
SHOW REPLICA STATUS. (MDEV-21087)
When a table is created from a
SELECTstatement that uses a recursive CTE, the table can use unexpected data types and contain truncated data if the calculated values from the recursive part of the CTE do not fit in the column types that are taken from the non-recursive part of the CTE. (MDEV-12325)
Starting with this release, the CTE calculation is aborted when the calculated values do not fit in the column types. When this occurs, a warning or error (depending on
sql_modeis raised with the
ER_WARN_DATA_OUT_OF_RANGEerror code and the following error message:
Out of range value for column 'COLUMN_NAME' at row ROW_NUM
When the optimizer chooses a semi-join optimization for a subquery, the LooseScan and FirstMatch strategies are not considered for certain queries where they would be appropriate, and they are considered for certain queries where they would be inappropriate. (MDEV-28749)
FULLTEXTsearch is performed on an InnoDB table, the results are incorrect when the search term contains an apostrophe (
Starting with this release, when a search term contains an apostrophe (
'), InnoDB tokenizes the word at the apostrophe, ignores the first token, and matches against the second token.
In alignment to the enterprise lifecycle, MariaDB Enterprise Server 10.3.36-17 is provided for:
CentOS 7 (x86_
Debian 10 (x86_
Microsoft Windows (x86_
Red Hat Enterprise Linux 7 (x86_
Red Hat Enterprise Linux 8 (x86_
Rocky Linux 8 (x86_
SUSE Linux Enterprise Server 12 (x86_
SUSE Linux Enterprise Server 15 (x86_
Ubuntu 18.04 (x86_
Ubuntu 20.04 (x86_
Some components of MariaDB Enterprise Server might not support all platforms. For additional information, see "MariaDB Corporation Engineering Policies".