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.8, as well as the version history.
1.1.8 ========================================================================
Released 2023-07-27
Enhancements & New Features
[MYSQLO-760][MYSQLO-761] Updated FIPS support
The connector now supports the FIPS (Federal Information Processing Standards) module to ensure the security, quality, and processing compatibility of various services. For more information, see the Installation and Configuration Guide.
[MYSQLO-736] Updated macOS support
On macOS, the connector is now a Universal driver that natively supports Apple Silicon. For security best practices, it is suggested to keep both the connector and OS updated.
Resolved Issues The following issue has been resolved in Simba MySQL ODBC Connector 1.1.8.
- [MYSQLO-743] When executing the load data local infile command, the connector loads the data incorrectly.
Known Issues The following are known issues that you may encounter due to limitations in the data store, the connector, or an application.
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 connector does 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.
- PAM
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.1.7 ————————————————————————
[MYSQLO-744] Removing support for earlier versions of operating systems
Beginning with this release, the connector no longer supports the following operating systems:
- macOS 10.13
- Windows 8.1
For information about supported operating systems, see the Installation and Configuration Guide.
[MYSQLO-744] MySQL 5.6 no longer supported
Beginning with this release, the connector does not support MySQL versions 5.6. For information about supported versions, see the Installation and Configuration Guide.
[MYSQLO-744] Native authentication no longer supported
Beginning with this release, the connector does not support Native authentication. For information about supported authentication methods, see the Installation and Configuration Guide.
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.7 ————————————————————————
Released 2023-03-20
Enhancements & New Features
[MYSQLO-744] Upgraded third-party libraries
The connector has been updated to use the following libraries:
- OpenSSL version 3.0.8 (previously 1.1.1n)
- ICU version 71.1 (previously 58.3)
- Expat version 2.5.0 (previously 2.4.6)
1.1.6 ————————————————————————
Released 2022-09-30
Enhancements & New Features
[MYSQLO-723] Parameterized Query support
When you execute the parameter query, the connector now returns SQL_VARCHAR as metadata. To do this, select the Return Default metadata for SQLDescribeParam check box (set the RETURN_DEFAULT_METADATA_FOR_SQLDESCRIBECOLUMNS connection property to 1). For more information, see the Installation and Configuration Guide.
Resolved Issues The following issues have been resolved in Simba MySQL ODBC Connector 1.1.6.
[MYSQLO-710] When executing sequenced queries, the connector executes the query twice.
This issue has been resolved now. The connector now executes the sequenced queries only once.
[MYSQLO-711] When executing a table with longtext column datatype, the connector returns an error.
This issue has been resolved now. The connector now is able to execute a getschema call for a table with the longtext column datatype.
[MYSQLO-716] When connecting using passwordless authentication, the connector returns an error.
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.
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)
==============================================================================