7 MYSQL

============================================================================= Simba MySQL ODBC Driver Release Notes =============================================================================

The release notes provide details of enhancements, features, and known issues in Simba MySQL ODBC Driver 1.0.9, as well as the version history.

1.0.9 =======================================================================

Released 2018-11-15

Enhancements & New Features

• [MYSQLO-421][MYSQLO-423] Upgraded third-party libraries

  The driver now uses zlib version 1.2.11, and OpenSSL 1.1.0i.

• [MYSQLO-414] Standardized log file names

  When logging is enabled, the driver now produces the following log files:

  • A simbamysqlodbcdriver.log file that logs driver activity that is not specific to a connection.

  • A simbamysqlodbcdriver_connection_[Number].log for each connection made to the database, where [Number] is a number that identifies each log file. This file logs driver activity that is specific to the connection.

Known Issues The following are known issues that you may encounter due to limitations in the data source, the driver, or an application.

• Cursors are non-scrollable.

  The driver only supports forward-only cursors; it does not allow cursors to move backward through query results. This driver behaviour is consistent with the behaviour that is officially defined for MySQL cursors, which are non-scrollable.

• Local Socket/Pipe connections are not supported.

  The driver does not support named pipe or socket file connections. You must connect to the server using a TCP/IP connection.

• Query bookmarks are not supported.

  The driver cannot create query bookmarks or retrieve information from existing bookmarks.

• Positioned statements are not supported.

  The driver cannot execute statements on the rows from a result set.

• External authentication plugins are not supported.

  The driver does not support the following authentication plugins:
  • PAM
  • Cleartext client-side
  • Socket peer-credential

  Instead, use the native, SHA-265, or Windows native authentication plugins.

• Driver only supports the utf8mb4 character set.

  Currently, the driver cannot use different character sets when working with data.

Workflow Changes ============================================================

The following changes may disrupt workflows from earlier versions.

1.0.7 ————————————————————————

• Minimum TLS Version

  Beginning with this release, the driver requires a minimum version of TLS for encrypting the data store connection. By default, the driver requires TLS version 1.2. This requirement may cause existing DSNs and connection strings to stop working, if they are used to connect to data stores that use a TLS version earlier than 1.2.

  To resolve this, in your DSN or connection string, set the Minimum TLS option (the Min_TLS property) to the appropriate version of TLS for your server. For more information, see the Installation and Configuration Guide.

Version History =============================================================

1.0.8 ———————————————————————–

Released 2018-09-07

Enhancements & New Features

• [MYSQLO-421] Upgraded zlib library

  The driver now uses zlib version 1.2.11.

Resolved Issues The following issues have been resolved in Simba MySQL ODBC Driver 1.0.8.

• [MYSQLO-418][MYSQLO-419] In some cases, when logging is enabled, the log files include sensitive information such as credentials in plain text.

1.0.7 ———————————————————————–

Released 2018-07-31

Enhancements & New Features

• [MYSQL-412] Minimum TLS support

  You can now specify the minimum version of TLS the driver accepts when authenticating the connection to the data source.

• [MYSQL-409] More informative SSL error messages

  The driver now provides more detailed error messages for TLS/SSL errors.

• [MYSQLO-408] Support for the JSON data type

  The driver now supports the JSON data types for implementations for MySQL 5.7 and later.

Resolved Issues The following issues have been resolved in Simba MySQL ODBC Driver 1.0.7.

• The driver does not correctly handle user names and passwords that contain non-Latin characters.

• In some cases the driver will display a “System Access Violation” system message.

1.0.6 ———————————————————————–

Released 2018-04-27

Enhancements & New Features

• Updated SSL support

  The driver now supports OpenSSL 1.1.0.

1.0.5 ———————————————————————–

Released 2018-02-20

Resolved Issues The following issues were resolved in Simba MySQL Driver 1.0.5.

• During installation the system message “Error creating temporary swap file name” may be displayed.

1.0.4 ———————————————————————–

Released 2018-01-12

Resolved Issues The following issues have been resolved in Simba MySQL Driver 1.0.4.

• Connections may fail to authenticate, displaying the following system message: “(1020) Server Capability not supported: CLIENT_LONG_PASSWORD”.

• When using ProceduresParameters to generate schemas, the generated table does not contain all the expected information about the parameters of the stored procedures.

1.0.3 ———————————————————————–

Released 2017-12-05

Enhancements & New Features

• Support for system tables

  The driver now supports the SYSTEM TABLE type.

• Prefixes for log file names

  You can now configure the driver to add a prefix to log file names. The prefix includes the user name associated with the connection and the process ID of the application through which the connection is made. To enable this feature, set the UseLogPrefix connection property to 1. For more information, see the Installation and Configuration Guide.

Resolved Issues The following issue was resolved in Simba MySQL Driver 1.0.3.

• When attempting to update OpenSSL libraries, the driver may terminate unexpectedly, displaying the system message “side-by-side configuration is incorrect.”

1.0.2 ———————————————————————–

Released 2017-11-03

Resolved Issues The following issues were resolved in Simba MySQL Driver 1.0.2.

• Queries that do not affect rows, such as CREATE TABLE or DROP TABLE queries, return SQL_NO_DATA_FOUND even if the driver executed the query successfully.

• Data type information is returned inconsistently.

  This issue has been resolved. Before, depending on the specific catalog function that was called, the driver returned different information about the supported data types and how data is mapped between MySQL types and SQL types. The driver now returns the information correctly.

  For more information, see the “Data Types” section in the Installation and Configuration Guide.

1.0.1 ———————————————————————–

Released 2017-09-07

Enhancements & New Features

• SSL System Trust Store

  The driver now supports verification using certificates from the Windows system trust store.

• Limit Column Size to Signed 32-bit value

  The driver can be configured to limit column sizes to signed 32-bit values, preventing problems with larger column sizes in applications that do not support them.

Resolved Issues The following issues have been resolved in Simba MySQL Driver 1.0.1.

• Native authentication without a password is not supported.

• Driver would quit unexpectedly, reporting a commlink error.

• If TLS options were not specified, the driver would not behave as expected.

• If an alternate locale is specified in the connection settings, the driver still uses the host machine’s locale setting.

• DBMS version number of the product accessed by the driver is not correctly formatted.

• Driver does not correctly strip curly braces ( {} ) from procedure escapes.

• In some cases, the value for info.m_certPath would not be read.

• Hardcoded value used to identify localhost or IP address during connection has been updated with a more effective solution.

• System messages in the Main Dialog have been made clearer.

1.0.0 ———————————————————————–

Released 2017-03-30

• Version 1.0.0 was the initial release of the Simba MySQL ODBC Driver.

==============================================================================