Changes in MySQL Connector/ODBC 8.0.23 (2021-01-18, General Availability)

• Functionality Added or Changed

• Bugs Fixed

Functionality Added or Changed

• Previously, Connector/ODBC added client support for the MySQL Enterprise Edition SASL LDAP authentication plugin with SCRAM-SHA-1 as an authentication method. Connector/ODBC now also supports SCRAM-SHA-256 as an alternative authentication method for classic MySQL protocol connections. SCRAM-SHA-256 is similar to SCRAM-SHA-1 but is more secure. SASL-based LDAP authentication does not apply to clients running macOS.

  The SASL module required for LDAP/SCRAM-SHA256 is provided by the cyrus-sasl-scram RPM package and libsasl2-modules-gssapi-mit DEB package (the same package that provides modules for LDAP/GSSAPI/Kerberos). (WL #14250)

Bugs Fixed

• Using the commercial glib package (authentication_ldap_sasl) with auth using GSSAPI (authentication_ldap_sasl_auth_method_name='GSSAPI') did not function. Added the missing sasl2 modules package. (Bug #32175842)

• On Debian based systems, the post-installation script uses dpkg-architecture ODBC drivers path, so the associated dpkg-dev package was added as a runtime dependency. (Bug #32157740)

• Double and Float values could differ depending if the query was standard or utilized server side prepared statements. Standard used MSYSQL_ROW for non-binary data to represent them as character strings, whereas server side prepared statements used the MYSQL_BIND structure and the specific MySQL type which could lead towards inconsistent results. Now this is performed in a uniform way to yield the same results. (Bug #32135124, Bug #98946)

• Microsoft Access halted when opening a linked table with only a JSON column. The JSON column type is now supported, and JSON data is only editable if another column is used as a primary key. Because JSON is a long data type with the maximum length of 4GB, it can't be used as a primary key by Microsoft Access and therefore tables having only JSON columns are only available in read-only mode. (Bug #32114901)

• Removed the mysql-client-plugins dependency. It remains required for connections using commercial MySQL server accounts with LDAP authentication, so must be manually installed for that situation. The mysql-client-plugins package has conflicts with MySQL server versions before 8.0.21, so earlier versions (such as MySQL 5.7) require an 8.0 server upgrade to use it. (Bug #31875490)

• On macOS, Connector/ODBC would not report an error if SQL_ATTR_PARAMSET_SIZE was set but not supported; instead the setting was ignored. (Bug #29862441, Bug #95608)