Functionality added or changed:
Error string was returned after a 28000 second
wait_timeout. This has been changed to generate aConnectionState.Closedevent. (Bug#38119)Changed how the procedure schema collection is retrieved. If
use procedure bodies=truethen themysql.proctable is selected directly as this is up to 50 times faster than the currentinformation_schemaimplementation. Ifuse procedure bodies=false, then theinformation_schemacollection is queried. (Bug#36694)String escaping functionality has been moved from the
MySqlStringclass to theMySqlHelperclass, where it can be accessed by theEscapeStringmethod. (Bug#36205)
Bugs fixed:
The
GetOrdinal()method failed to return the ordinal if the column name string contained an accent. (Bug#38721)MySQL Connector/NET uninstaller did not clean up all installed files. (Bug#38534)
There was a short circuit evaluation error in the
MySqlCommand.CheckState()method. When the statementconnection == nullwas true aNullReferenceExceptionwas thrown and not the expectedInvalidOperationException. (Bug#38276)The provider did not silently create the user if the user did not exist. (Bug#38243)
Executing a command that resulted in a fatal exception did not close the connection. (Bug#37991)
When a prepared insert query is run that contains an
UNSIGNED TINYINTin the parameter list, the complete query and data that should be inserted is corrupted and no error is thrown. (Bug#37968)In a .NET application MySQL Connector/NET modifies the connection string so that it contains several occurrences of the same option with different values. This is illustrated by the example that follows.
The original connection string:
host=localhost;database=test;uid=*****;pwd=*****; connect timeout=25; auto enlist=false;pooling=false;The connection string after closing
MySqlDataReader:host=localhost;database=test;uid=*****;pwd=*****; connect timeout=25;auto enlist=false;pooling=false; Allow User Variables=True;Allow User Variables=False; Allow User Variables=True;Allow User Variables=False;Unnecessary network traffic was generated for the normal case where the web provider schema was up to date. (Bug#37469)
MySqlReader.GetOrdinal()performance enhancements break existing functionality. (Bug#37239)The
autogenerateschemaoption produced tables with incorrect collations. (Bug#36444)GetSchemadid not work correctly when querying for a collection, if using a non-English locale. (Bug#35459)When reading back a stored double or single value using the .NET provider, the value had less precision than the one stored. (Bug#33322)
Using the MySQL Visual Studio plugin and a MySQL 4.1 server, certain field types (
ENUM) would not be identified correctly. Also, when looking for tables, the plugin would list all tables matching a wildcard pattern of the database name supplied in the connection string, instead of only tables within the specified database. (Bug#30603)