MySQL Connector/ODBC 3.51.14 is available!

[Jim Winstead]

Dear MySQL users,

MySQL Connector/ODBC 3.51.14, a new version of the ODBC driver for the
MySQL database system, has been released. This release is the latest
release of the 3.51 series and is suitable for use with any MySQL
version including MySQL 4.1, 5.0, or 5.1.

WARNING

While we consider this a production release, we recommend caution in
upgrading due to changes in our build procedures, and the large number
of bug fixes that have gone into this long-delayed release.

The release is now available in source and binary form for a number of
platforms from our download pages at

http://dev.mysql.com/downloads/connector/odbc/3.51.html

and mirror sites. Note that not all mirror sites may be up to date at this
point in time, so if you can't find this version on some mirror, please try
again later or choose another download site.

Jess Balint and others from MySQL will be speaking about ODBC at our
MySQL Conference & Expo in late April, in a talk titled "Primetime ODBC:
Constructing ODBC Applications and the ODBC 5.0 Roadmap." Early
registration for the conference closes on March 14, 2007, so register
now to save $200!

http://www.mysqlconf.com/

We welcome and appreciate your feedback, bug reports, bug fixes, patches, etc.:

http://forge.mysql.com/wiki/Contributing

Platform notes:
* There are no binary packages for Microsoft Windows x64 Edition --
these will be provided in a future release.
* The RPM binary packages do not include the GUI bits.
* The Mac OS X binary packages are only provided as tarballs, there is no
installer for this release.
* 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 HP-UX 11.23 IA64 binary package does not include the GUI bits because
of problems building Qt on that platform.
* The binary packages for Sun Solaris are only provided as tarballs, not
the PKG format, for this release.
* There are no binary packages for SCO OpenServer.

Changes since the last release:

Functionality added or changed:
* Added auto-reconnect option because automatic reconnect is now
disabled by default in libmysql
* Added auto is null option (Bug #10910)
* Added support for SQLMoreResults
* Checking SQL_ATTR_CONNECTION_DEAD now always calls mysql_ping() to
check for a dead connection.
* Remove ODBC escape syntax { and } that begin and terminate statements,
allowing {CALL (?)} for procedures that don't require OUT or INOUT
parameters
* Improved regression tests
* Added --with-separate-debug-driver ./configure option

Bugs fixed:
* SQL_ATTR_CONNECTION_TIMEOUT was inappropriately mapped to
MYSQL_OPT_CONNECT_TIMEOUT. (Bug #19823)
* Prepared statements using the embedded MySQL server would fail
due to an unitialized variable. (Bug #16535)
* Fix positioned update and delete on statements derived from one
table with no primary key but including all columns (Bug #22796)
* Only initialize the ODBC version when the old-style SQLAllocEnv()
is called. If SQLAllocHandle() is used, the ODBC version must be
explicitly specified using a call to SQLSetEnvAttr()
* On 64-bit systems, some types would be incorrectly returned. (Bug #26024)
* Using DataAdapter, Connector/ODBC may continually consume memory when
reading the same records within a loop (Windows Server 2003 SP1/SP2 only).
(Bug #20459)
* Fix truncation of queries with leading spaces when SQL_ATTR_MAX_ROWS
is set to a non-zero value (Bug #6609)
* Fixed problem with memory allocation in Windows for BLOB and long
queries that need re-allocation of net->buff
* Using Connector/ODBC, with SQLBindCol and binding the length to the return
value from SQL_LEN_DATA_AT_EXEC fails with a memory allocation error.
(Bug #20547)
* Fixed Windows-specific problems with the GUI for SQL_DRIVER_PROMPT
* Fixed issues with numeric and decimal rounding
* Fixed memory leak in SQLDriverConnect()
* Fixed serious memory leak in SQLSpecialColumns() (up to 8KB/call)
* Fixed handle leak in LibMain (Bug #21385, thanks to Leandro Becker)
* Fixed field lengths reported by SQLDescribeCol() when using functions
such as COMPRESS() in SELECT queries (Bug #20208)
* Fixed 64-bit issues related to SQLINTEGER columns defined as int,
but later cast to long.
* TIME fields were incorrectly converted into date/time values. (Bug #25846,
Bug #24867, and Bug #25432)
* Fixed #Deleted issue in Microsoft Access by changing the default behavior
of MyODBC driver regarding SQL_AUTO_IS_NULL variable. Added new option to
the GUI and driver
* Fixed memory leak in SQLSpecialColumns()
* Corrected return size of SQLGetStmtAttr() when getting desc handles
* Fixed SQLGetInfo() of SQL_TXN_CAPABLE to return SQL_TC_DDL_COMMIT
* For SQL_C_TIME, handle conversion from the different time-related MySQL
types, instead of always assuming it is just a TIME. (DATETIME, TIMESTAMP,
and DATE were all handled incorrectly.)
* Fix crash when default database is not set
* Fix handling of lost connections (Bug #14639)
* File DSNs could not be saved. (Bug #12019)
* Nullability of auto_increment fields is incorrect. (Bug #10130)
* Connector/ODBC may insert the wrong parameter values when using prepared
statements under 64-bit Linux. (Bug #22446)
* The SQLDriverConnect() ODBC method did not work with recent Connector/ODBC
releases. (Bug #12393)
* Some properties returned by SQLGetInfo() were set using the wrong data
type, resulting in possible memory overruns. (Bug #20995)
* Ending a transaction using SQLEndTran() on a environment handle was
not supported. (Bug #21588)

Enjoy!

Jim Winstead
MySQL/Sun