Functionality Added or Changed
Performing GetValue() on a field
TINYINT(1) returned a
BOOLEAN. While not a bug, this
caused problems in software that expected an
INT to be returned. A new
connection string option Treat Tiny As
Boolean has been added with a default value of
true. If set to false the
provider will treat TINYINT(1) as
INT.
(Bug #34052)
Added ClearPool and ClearAllPools features.
DDEX provider now works under Visual Studio 2008 beta 2.
Added support for DbDataAdapter
UpdateBatchSize. Batching is fully supported
including collapsing inserts down into the multi-value form if
possible.
Bugs Fixed
In an open connection where the server had disconnected unexpectedly, the status information of the connection would not be updated properly. (Bug #33909)
The status of connections reported through the state change handler was not being updated correctly. (Bug #34082)
When accessing tables from different databases within the same
TransactionScope, the same user/password
combination would be used for each database connection. MySQL Connector/Net
does not handle multiple connections within the same transaction
scope. An error is now returned if you attempt this process,
instead of using the incorrect authorization information.
(Bug #34204)
Some speed improvements have been implemented in the
TokenizeSql process used to identify elements
of SQL statements.
(Bug #34220)
Incorporated some connection string cache optimizations sent to us by Maxim Mass. (Bug #34000)
Using compression in the MySQL connection with MySQL Connector/Net would be slower than using native (uncompressed) communication. (Bug #27865)
Commands executed from within the state change handler would
fail with a NULL exception.
(Bug #30964)
Memory usage could increase and decrease significantly when updating or inserting a large number of rows. (Bug #31090)
Column name metadata was not using the character set as defined within the connection string being used. (Bug #31185)
Data cached from the connection string could return invalid information because the internal routines were not using case-sensitive semantics. This lead to updated connection string options not being recognized if they were of a different case than the existing cached values. (Bug #31433)
When running a stored procedure multiple times on the same connection, the memory usage could increase indefinitely. (Bug #30116)
The MySqlDbType.Datetime has been replaced
with MySqlDbType.DateTime. The old format has
been obsoleted.
(Bug #26344)