7 MYSQL

============================================================================== Magnitude Simba MySQL ODBC Data Connector Release Notes ==============================================================================

The release notes provide details of enhancements, features, known issues, and workflow changes in Simba MySQL ODBC Connector 1.1.2, as well as the version history.

1.1.2 ========================================================================

Released 2021-06-30

Resolved Issues The following issue has been resolved in Simba MySQL ODBC Connector 1.1.2.

  • [MYSQLO-665] In some cases, a rounding issue causes the connector to produce unexpected results for numeric fields.

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

  • [MYSQLO-540] If the input value of the ColumnSize parameter in a SQLBindParameter() function call is greater than 4294967295, the value is reduced to 4294967295.

  • Cursors are non-scrollable.

    The connector only supports forward-only cursors; it does not allow cursors to move backward through query results. This connector 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 connector 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 connector cannot create query bookmarks or retrieve information from existing bookmarks.

  • Positioned statements are not supported.

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

  • External authentication plugins are not supported.

    The connectordoes not support the following authentication plugins:

    • PAM
    • Cleartext client-side
    • Socket peer-credential

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

  • Connector only supports the utf8mb4 character set.

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

  • [MYSQLO-611] When using RHEL 8 with dynamic linking, and the cryptographic policy is set to default or higher, the connector returns an error for certificates with a key length of less than 2048.

    As a workaround, increase the key length or set the cryptographic policy to legacy.

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

The following changes may disrupt established workflows for the connector.

1.0.18 ———————————————————————–

  • [MYSQLO-515][MYSQLO-517] Removing support for earlier versions of operating systems

    Beginning with this release, the driver no longer supports the following operating systems:

    • Windows 7
    • Windows Server 2008
    • Windows Server 2008 R2
    • macOS 10.12 “Sierra”
    • CentOS 6
    • Red Hat Enterprise Linux (RHEL) 6
    • Debian 8

    For information about supported operating systems, see the Installation and Configuration Guide.

1.0.13 ———————————————————————–

  • [MYSQLO-469] Ubuntu 14.04 and SLES 11 no longer supported

    Beginning with this release, the driver does not support Ubuntu 14.04 and SUSE Linux Enterprise Server (SLES) 11.

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.1.1 ————————————————————————

Released 2021-05-21

Enhancements & New Features

  • [MYSQLO-305] Support for LOAD DATA Local INFILE

    The connector now supports LOAD DATA Local INFILE. For more information, see “Non-LOCAL Versus LOCAL Operation” in the MySQL documentation: https://dev.mysql.com/doc/refman/8.0/en/load-data.html#load-data-local

  • [MYSQLO-661] Updated OpenSSL support

    The connector now uses OpenSSL 1.1.1k for encryption of data. Previously, the connector used OpenSSL 1.1.1i.

Resolved Issues The following issues have been resolved in Simba MySQL ODBC Connector 1.1.1.

  • [MYSQLO-658] The connector defaults to text protocol and only switches to binary protocol when prepared statements are used.

  • [MYSQLO-655] When using SQLPutData(), the connector inserts partial data.

  • [MYSQLO-660] When retrieving column metadata with the UNSIGNED DECIMAL datatype, the connector returns incorrect precision.

1.1.0 ————————————————————————

Released 2021-03-31

Enhancements & New Features

  • Upgraded third-party libraries

    The connector has been updated to use the following libraries:

    • OpenSSL version 1.1.1i (previously 1.1.1g)
    • ICU version 58.3.x (previously 58.2.x)

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

Installation and Configuration Guide