Changes in MySQL 5.7.44 (2023-10-25, General Availability)

Important

MySQL 5.7.44 is the final release of the MySQL 5.7 series.

MySQL 5.7 users are encouraged to upgrade to the latest MySQL 8.0, 8.4, or MySQL Innovation release.

• SQL Function and Operator Notes

• Packaging Notes

• Functionality Added or Changed

• Bugs Fixed

SQL Function and Operator Notes

• The STR_TO_DATE() function did not perform complete range checking on the string to be converted, so that it was possible to pass to it a string which would yield an invalid date, such as '2021-11-31'. (Bug #108782, Bug #34704094)

Packaging Notes

• On Windows, the MSI package definition files were updated to work with the Windows Installer XML (WiX) toolset version 4. Note that they can no longer be used with previous versions of the toolset. (Bug #35613791)

• The bundled libedit library was upgraded to version 20221030-3.1. (Bug #35489173)

Functionality Added or Changed

• Important Change: The linked OpenSSL library for MySQL Server has been updated to version 3.0.10. Issues fixed in OpenSSL version 3.0.10 are described at https://openssl-library.org/news/openssl-3.0-notes/. (Bug #35702863, Bug #35732474)

Bugs Fixed

• InnoDB: Fixed processing of single character tokens by a FTS parser plugin.

  Our thanks to Shaohua Wang for the contribution. (Bug #35432973)

• InnoDB: The last detected deadlock section of the engine status log was only showing 1024 characters for the combined thread and query information. Fixing by removing the printed query string limit. (Bug #80927, Bug #23036096)

• Some complex queries using multiple common table expressions were not always handled correctly. (Bug #34900334)

  References: This issue is a regression of: Bug #34377854.