Changes in MySQL Connector/ODBC 9.1.0 (2024-10-15, General Availability)

• Functionality Added or Changed

• Bugs Fixed

Functionality Added or Changed

• Added OpenID Connect support leveraging the new authentication_openid_connect_client client-side authentication plugin. OpenID Connect functionality is supported by MySQL Enterprise Edition Server 9.1.0 and later.

  The new openid-token-file connection option defines a path to a file containing the JWT formatted identity token. (WL #16436)

• The RPM and DEB packages now install a copy of the MySQL client library plugins for the connector. The version of these plugins match the version of the statically linked MySQL client library.

  They are installed to {libdir}/mysql/libmyodbc{ABI}/plugin/ where {libdir} is the system location where packages install libraries. {ABI} is the connector's ABI version, which is currently 9.

  The connector installed from RPM and DEB packages use the bundled plugins as needed without requiring the PLUGIN_DIR connection option, although the PLUGIN_DIR connection option is still available to change the plugin location. Runtime dependencies required by the plugins, such as Kerberos and LDAP libraries, are expected on the system and installed from their own packages. (WL #16457)

Bugs Fixed

• The Generic Linux TGZ package did not bundle all client-side authentication plugins. (Bug #36972449)

• Fixed a potential Out of Bounds (OOB) issue related to escaping large queries. (Bug #36955942)

• Added a plugin caching mechanism. (Bug #36929669)

• Fixed a memory leak that occurred when emitting SQL_DATE errors. (Bug #18531881)

• The internal mysql_init() function used for making connections is now thread safe. (Bug #115710, Bug #36894687)

• Having a number of bound parameters greater than the number of placeholders in the corresponding SQL query could emit an error, as the statement had to be prepared and executed more than once. (Bug #115584, Bug #36841317)

• When connected to a MySQL 5.7 server, queries using bound parameters would not succeed and emitted a "No data supplied for parameters in prepared statement" error. (Bug #115531, Bug #36828312)

• With the prefetch connection option set to a non-zero value, large queries could cause the connector to unexpectedly halt. (Bug #113554, Bug #36945554)

• Fixed the SQLBulkOperations() function's generated WHERE clause, which could potentially cause an application to unexpectedly halt. (Bug #69194, Bug #18641963, Bug #26474373)