Changes in MySQL Connector/Python 8.0.4 (2017-07-17, Development Milestone)

MySQL Connectors and other MySQL client tools and applications now synchronize the first digit of their version number with the (highest) MySQL server version they support. For example, MySQL Connector/Python 8.0.12 would be designed to support all features of MySQL server version 8 (or lower). This change makes it easy and intuitive to decide which client version to use for which server version.

Connector/Python 8.0.4 is the first release to use the new numbering. It is the successor to Connector/Python 2.2.3.

• Character Set Support

• Functionality Added or Changed

• Bugs Fixed

Character Set Support

• Connector/Python now supports MySQL servers configured to use utf8mb4 as the default character set. (WL #10659)

Functionality Added or Changed

• To avoid unintentional changes to all items in a collection, the Collection.modify() and Collection.remove() methods now require a nonempty selection expression as argument. To intentionally apply an operation to an entire collection, pass a condition that always evaluates to true, such as True. A similar change was made to Table.update() and Table.delete(). (Bug #25991574, WL #10754)

• For MSI and Solaris packages, the pure Python Protobuf support implementation was replaced by a C++ extension. This enables Connector/Python to support Python 2 and 3 as well Protobuf 2 and 3. (WL #10198)

• The NodeSession class has been renamed to Session, and the XSession class has been removed. (WL #10658)

• Connections created using Session objects now are encrypted by default. Also, the ssl-enabled connection option has been replaced by ssl-mode. Permitted ssl-mode values are disabled, required (the default), verify_ca and verify_identity. (WL #10770)

• The format of document ID values generated when adding documents to a collection has changed. It is still a string of 32 hexadecimal digits based on UUID, but the order of digits was changed to match the requirement of a stable ID prefix. (WL #10004)

Bugs Fixed

• The C Extension was not installed by some Connector/Python installers, such as Solaris .pkg and macOS .dmg installer packages. (Bug #24422244)

• Collection.drop_index("name") incorrectly returned an instance of DropCollectionIndexStatement. (WL #10772)