MySQL 9.7.2

Release Date: July 28, 2026

MySQL 9.7.2 has been released — a maintenance release that includes a broad set of bug fixes across InnoDB, JSON handling, the Optimizer, Performance Schema, Replication, and more. This release was published on July 28, 2026.

Security and Infrastructure Updates

The version of libfido2 bundled with MySQL has been upgraded to 1.17.0, bringing improved FIDO2/WebAuthn authentication support. Additionally, a fix addresses a crash that could occur when calling audit_log_encryption_password_get() with a keyring ID.

InnoDB Changes

Fixed a debug assertion in row_upd_rec_in_place() for non-versioned ROW_FORMAT=REDUNDANT rows. (Bug #39165747)
During buffer-pool resize operations, the Adaptive Hash Index could be incorrectly disabled in mysqld-auto.cnf even when innodb_adaptive_hash_index=ON. This has been corrected. (Bug #39157211)
Resolved an issue where adding an AUTO_INCREMENT column to an existing table could skip certain records, leading to inaccurate auto-increment values. (Bug #37105898)
General table maintenance and cleanup improvements. (Bug #39091376)
Fixed an issue relating to unique indexes. (Bug #38501299)

JSON and Duality Views

Several JSON-related fixes land in 9.7.2:

Updating a JSON Relational Duality View that deletes rows from a nested child base table could violate foreign-key constraints. Delete operations are now performed first, in reverse binding order, before inserts and updates. (Bug #39566804)
Fixes for JSON Schema validation, JSON date value processing, nested array handling, and metadata validation. (Bugs #39489024, #39361343, #39255759, #39255734)
JSON_VALUE() with RETURNING DATETIME and a DEFAULT value could return an invalid constant date when used in a DATE context, silently affecting predicates and joins. The datetime value is now extracted before narrowing to a date. (Bug #39649893)

Optimizer and Query Fixes

Fixed issues with subquery_to_derived optimization. (Bug #39525738)
Corrected handling of ROLLUP queries. (Bug #39501528)
Resolved error handling in aggregation of decimal data. (Bug #39474810)
General error-handling improvements. (Bug #39272322)
Fixed user-variable handling issues. (Bug #39243027)
Common Table Expressions (CTEs) now work correctly with subquery_to_derived enabled. (Bug #39179197)
Fixed an issue in ExtractValue(). (Bug #39138426)
Filters using IFNULL could return incorrect results under certain circumstances. (Bug #36448705)
Temporal results from GREATEST(), LEAST(), or COALESCE() could report incorrect collation through the client protocol. This has been corrected. (Bug #36448705)

Other Notable Fixes

Performance Schema — Various improvements to performance monitoring accuracy.
Replication — Bug fixes for replication consistency and reliability.
Compilation — Fixed a potential memory leak in the comp_err utility. (Bug #36532183)
MySQL Programs — mysql_tzinfo_to_sql no longer generates unnecessary warnings about missing timezone files. (Bug #39649893)

Deprecation and Removal Notes

As part of MySQL's ongoing lifecycle management, several deprecated features have been flagged for removal in future versions. Review the official MySQL 9.7 Release Notes for the full deprecation list.