MariaDB 10.2.24 Release Notes
The most recent release of MariaDB 10.2 is:
MariaDB 10.2.44 Stable (GA) Download Now
Download Release Notes Changelog Overview of 10.2
Release date: 9 May 2019
MariaDB 10.2 is the previous stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB 10.2.24 is a Stable (GA) release.
For an overview of MariaDB 10.2 see the What is MariaDB 10.2? page.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug MDEV-12837 which caused serious stability issues with earlier versions. See the bug issue page for more information.
Thanks, and enjoy MariaDB!
Notable Changes
General server
- MDEV-18968 - Both
(WHERE 0.1)
and(WHERE NOT 0.1)
return empty set - MDEV-18466 - Unsafe to log updates on tables referenced by foreign keys with triggers in statement format
- MDEV-18899 - Server crashes in
Field::set_warning_truncated_wrong_value
- MDEV-18298 - Crashes server with segfault during role grants
- MDEV-17610 - Unexpected connection abort after certain operations from within stored procedure
- MDEV-19112 - WITH clause does not work with information_schema as default database
- MDEV-17830 - Server crashes in
Item_null_result::field_type
uponSELECT with CHARSET(date)
andROLLUP
- MDEV-14041 - Server crashes in
String::length
on queries with functions andROLLUP
- MDEV-18920 - Prepared statements with
st_convexhull
hang and eat 100% cpu. - MDEV-15837 - Assertion
item1->type() == Item::FIELD_ITEM && item2->type() == Item::FIELD_ITEM
- MDEV-9531 - GROUP_CONCAT with ORDER BY inside takes a lot of memory while it's executed
- MDEV-17036 - BULK with replace doesn't take the first parameter in account
- Bug#28986737 - RENAMING AND REPLACING MYSQL.USER TABLE CAN LEAD TO A SERVER CRASH
- MDEV-19350 - Server crashes in
delete_tree_element / ... / Item_func_group_concat::repack_tree
- MDEV-19188 - Server Crash When Using a Trigger With A Number of Virtual Columns on INSERT/UPDATE
- MDEV-19352 - Server crash in
alloc_histograms_for_table_share
upon query from information schema
InnoDB
- Merge InnoDB changes from MySQL 5.6.44 and 5.7.26
- InnoDB persistent corruption fixes: MDEV-19426, MDEV-19022, MDEV-19241, MDEV-13942
- InnoDB recovery fixes and speedup: MDEV-18733, MDEV-12699, MDEV-19356, MDEV-19426
Encryption
- MDEV-14398 -
innodb_encrypt_tables
will work even withinnodb_encryption_rotate_key_age=0
Protocol
- MDEV-17036 - BULK with replace doesn't take the first parameter in account
Replication
- MDEV-14784 - Slave crashes in show_status_array upon running a trigger with select from I_S
Mariabackup
- MDEV-19060 - mariabackup continues, despite failing to open a tablespace
Packaging & Misc
- MDEV-19054 -
mysql_upgrade_service
now allows MySQL 5.7 to MariaDB 10.2 upgrade - Starting with this release, we are now providing src.rpm packages for some platforms (MDEV-7066)
- As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Fedora 28
Security
- MDEV-18686 - Add option to PAM authentication plugin to allow case insensitive username matching
- bugfix - multi-update checked privileges on views incorrectly (commit 5057d4637525eadad438d25ee6a4870a4e6b384c)
- MDEV-19276 - during connect, write error log warning for
ER_DBACCESS_DENIED_ERROR
, iflog_warnings > 1
- MDEV-17456 - Malicious SUPER user can possibly change audit log configuration without leaving traces.
- Fixes for the following security vulnerabilities:
When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher,
running mysql_upgrade
is required due to changes introduced in
MDEV-14637.
Changelog
For a complete list of changes made in MariaDB 10.2.24 with links to detailed information on each push, see the changelog.
Contributors
For a full list of contributors to MariaDB 10.2.24, see the MariaDB Foundation release announcement.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More
information can be found on the
Distributions which Include MariaDB
page.