MySQL Connector/ODBC 5.1.2-beta, a new version of the ODBC driver for the MySQL database management system, has been released. This release is the second beta (feature-complete) release of the new 5.1 series and is suitable for use with any MySQL server version since MySQL 4.1, including MySQL 5.0, 5.1, and 6.0. (It will not work with 4.0 or earlier releases.)
Keep in mind that this is a beta release, and as with any other pre-production release, caution should be taken when installing on production level systems or systems with critical data.
Platform specific notes:
The HP-UX 11.23 IA64 binary package does not include the GUI bits because of problems building Qt on that platform.
There is no binary package for Mac OS X on 64-bit PowerPC because Apple does not currently provide a 64-bit PowerPC version of iODBC.
The installer for 64-bit Windows installs both the 32-bit and 64-bit driver. Please note that Microsoft does not yet supply a 64-bit bridge from ADO to ODBC.
Due to differences with the installation process used on Windows and potential registry corruption, it is recommended that uninstall any existing versions of MySQL Connector/ODBC 5.1.x before upgrading.
See also Bug#34571.
Functionality added or changed:
Explicit descriptors are implemented. (Bug#32064)
A full implementation of SQLForeignKeys based on the information available from INFORMATION_SCHEMA in 5.0 and later versions of the server has been implemented.
Changed
SQL_ATTR_PARAMSET_SIZEto return an error until support for it is implemented.Disabled
MYSQL_OPT_SSL_VERIFY_SERVER_CERTwhen using an SSL connection.SQLForeignKeysusesINFORMATION_SCHEMAwhen it is available on the server, which enables more complete information to be returned.
Bugs fixed:
The
SSLCIPHERoption would be incorrectly recorded within the SSL configuration on Windows. (Bug#33897)Within the GUI interface, when connecting to a MySQL server on a nonstandard port, the connection test within the GUI would fail. The issue was related to incorrect parsing of numeric values within the DSN when the option was not configured as the last parameter within the DSN. (Bug#33822)
Specifying a nonexistent database name within the GUI dialog would result in an empty list, not an error. (Bug#33615)
When deleting rows from a static cursor, the cursor position would be incorrectly reported. (Bug#33388)
SQLGetInfo()reported characters forSQL_SPECIAL_CHARACTERSthat were not encoded correctly. (Bug#33130)Retrieving data from a
BLOBcolumn would fail withinSQLGetDatawhen the target data type wasSQL_C_WCHARdue to incorrect handling of the character buffer. (Bug#32684)Renaming an existing DSN entry would create a new entry with the new name without deleting the old entry. (Bug#31165)
Reading a
TEXTcolumn that had been used to store UTF8 data would result in the wrong information being returned during a query. (Bug#28617)SQLForeignKeyswould return an empty string for the schema columns instead ofNULL. (Bug#19923)When accessing column data,
FLAG_COLUMN_SIZE_S32did not limit the octet length or display size reported for fields, causing problems with Microsoft Visual FoxPro.The list of ODBC functions that could have caused failures in Microsoft software when retrieving the length of
LONGBLOBorLONGTEXTcolumns includes:SQLColumnsSQLColAttributeSQLColAttributesSQLDescribeColSQLSpecialColumns(theoretically can have the same problem)
Dynamic cursors on statements with parameters were not supported. (Bug#11846)
Evaluating a simple numeric expression when using the OLEDB for ODBC provider and ADO would return an error, instead of the result. (Bug#10128)
Adding or updating a row using
SQLSetPos()on a result set with aliased columns would fail. (Bug#6157)