Changes in MySQL Connector/Python 9.2.0 (2025-01-21, General Availability)

• Functionality Added or Changed

• Bugs Fixed

Functionality Added or Changed

• Added two new connection options: read_timeout (time limit to receive a response from the server) and write_timeout (time limit to send data to the server). Both options default to None, which sets the timeout to indefinitely. (Bug #115788, Bug #36922645, WL #16381)

• Added the read_timeout and write_timeout options for both connections and cursors. These set the transaction timeout (sending and receiving data to and from the server), and default to None that sets the wait time to indefinitely. (WL #16381)

• The single and multiple statement execution mechanic was unified, when before a multi cursor.execute() option was required to execute multiple statements.

  Changes include removing the multi option and adding the optional map_results option, and adding the fetchsets() and nextset() methods. (WL #16285)

Bugs Fixed

• The configuration option parser was modified to use ast.literal_eval() instead of eval(). For additional information, see Connector/Python Option-File Support. (Bug #37145655)

• When passing in multiple statements, the connector did not properly traverse (and execute) each query when the last query was preceded by a comment. (Bug #36126909)

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

• The mechanism to execute and retrieve multiple statements was improved. Changes include: the removal of execute()'s multi parameter, the addition of the nextset() and fetchsets() methods, and a new map_results option for the execute() method. For additional information, see Executing Multiple Statements. (Bug #35810050, WL #16285)

• Fixed two memory leaks coming from the get_rows() connection API command of the C-extension implementation. (Bug #115082, Bug #36702939)