Changes in MySQL Connector/Python 9.0.0 (2024-07-01, General Availability)

• Functionality Added or Changed

• Bugs Fixed

Functionality Added or Changed

• The required Python Protobuf version installed with the X DevAPI connector was updated to version 4.25.3, as older versions could cause the connector to unexpectedly halt. Previously it allowed versions within the range 4.21.1 through 4.21.12. (WL #16284)

• Added a [telemetry] installation option that pulls in the OpenTelemetry API, SDK, and OTLP Exporter packages when installing Connector/Python. Optionally use pip install mysql-connector-python[telemetry] to install Connector/Python along with the OpenTelemetry v1.18.0 packages.

  Removed the bundled OpenTelemetry installation option that was initiated by passing in [opentelemetry] to pip, such as pip install mysql-connector-python[opentelemetry]. (WL #16283)

• Deprecated the following cursors: CMySQLCursorBufferedNamedTuple, CMySQLCursorNamedTuple, CMySQLCursorPreparedNamedTuple, CMySQLCursorPreparedRaw, MySQLCursorBufferedNamedTuple, MySQLCursorNamedTuple, MySQLCursorPreparedNamedTuple, and MySQLCursorPreparedRaw. (WL #16318)

• Debian, Solaris, and most RPM (except Enterprise Linux) packages are no longer available. Instead, using pip to manage Connector/Python is recommended.

Bugs Fixed

• With mysql.connector.aio, executing cmd_change_user() would emit a "Got packets out of order" error. (Bug #36664998)

• With use_pure=True, if the sql_mode mixed in NO_BACKSLASH_ESCAPES with another SQL mode, such as STRICT_TRANS_TABLES, then the client escaped strings as if NO_BACKSLASH_ESCAPES was not active. (Bug #36476195)

• The aio.cursor.MySQLCursorBufferedRaw method did not skip the conversion layer. For example, it would return a datetime.date entry as datetime.date instead of bytes. (Bug #36289767)

• For the DNS SRV functionality, changed the minimum dnspython dependency version to 2.6.1.

  Thanks to Michael Perrone for the contribution. (Bug #114985, Bug #36611371, WL #16350)

• With the C extension, the collation connection option was ignored. (Bug #114832, Bug #36570707)