MySQL Connector/NET Release Notes  /  Changes in MySQL Connector/Net 6.2  /  Changes in MySQL Connector/NET 6.2.5 (2011-07-01)

Changes in MySQL Connector/NET 6.2.5 (2011-07-01)

This release fixes bugs since 6.2.4.

Bugs Fixed

  • MySQLConnectionStringBuilder.ContainsKey() incorrectly returned false when testing whether a keyword was part of the connection string. (Bug #11766671, Bug #59835)

  • SchemaDefinition-5.5.ssdl was modified to treat CHAR(36) columns as a GUID. (Bug #61657, Bug #12708208)

  • SqlFragment.QuoteIdentifier was modified to add MySQL quotes around identifiers. (Bug #61635, Bug #12707285)

  • Modified MySqlConnection.BeginTransaction to throw a NotSupportedException for Snapshot isolation level. (Bug #61589, Bug #12698020)

  • MysqlDataReader.GetSchemaTable returned incorrect values and types. (Bug #59989, Bug #11776346)

  • All queries other than INSERT were executed individually instead of as a batch even though batching was enabled for the connection. (Bug #59616, Bug #11850286)

  • MySQL Connector/NET generated an exception when executing a query consisting of ';', for example:

    mycmd(";",mycon)
    mycmd.executenonquery()

    The exception generated was:

    System.IndexOutOfRangeException: Index was outside the bounds of the array.
       at MySql.Data.MySqlClient.MySqlCommand.TrimSemicolons(String sql)
       at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
       at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
       at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()

    (Bug #59537, Bug #11766433)

  • Setting Membership.ApplicationName had no effect. (Bug #59438, Bug #11770465)

  • A NullReferenceException was thrown on disposal of a TransactionScope object. (Bug #59346, Bug #11766272)

  • MembershipProvider did not generate hashes correctly if the algorithm was keyed. The Key of the algorithm should have been set if the HashAlgorithm was KeyedHashAlgorithm. (Bug #58906)

  • Code introduced to fix bug #54863 proved problematic on .NET version 3.5 and above. (Bug #58853)

  • The MySqlTokenizer contained unnecessary Substring and Trim calls:

    string token = sql.Substring(startIndex, stopIndex - startIndex).Trim();

    The variable token was not used anywhere in the code. (Bug #58757)

  • MySqlCommand.ExecuteReader(CommandBehavior) threw a NullReferenceException when being called with CommandBehavior.CloseConnection, if the SQL statement contained a syntax error, or contained invalid data such as an invalid column name. (Bug #58652)

  • ReadFieldLength() returned incorrect value for BIGINT autoincrement columns. (Bug #58373)

  • MySQL Connector/NET did not support the utf8mb4 character set. When attempting to connect to utf8mb4 tables or columns, an exception KeyNotFoundException was generated. (Bug #58244)

  • A typed dataset did not get the table name. (Bug #57894, Bug #11764989)

  • Setting MySqlCommand.CommandTimeout to 0 had no effect. It should have resulted in an infinite timeout. (Bug #57265)

  • When performing a row-by-row update, only the first row was updated and all other rows were ignored. (Bug #57092)

  • Setting the Default Command Timeout connection string option had no effect. (Bug #56806)

  • When an output parameter was declared as type MySqlDbType.Bit, it failed to return with the correct value. (Bug #56756)

  • MySqlHelper.ExecuteReader did not include an overload accepting MySqlParameter objects when using a MySqlConnection. However, MySqlHelper did include an overload for MySqlParameter objects when using a string object containing the connection string to the database. (Bug #56755)

  • Default values returned for text columns were not quoted. This meant that the COLUMN_DEFAULT field of the GetSchema columns collection did not return a valid SQL expression. (Bug #56509)

  • MySQL Connector/NET for .NET/Mono attempted to dynamically load the assembly Mono.Posix.dll when a Unix socket was used to connect to the server. This failed and the connector was not able to use a Unix socket unless the Mono.Posix.dll assembly was previously loaded by the program. (Bug #56410)

  • Modified ProviderManifest.xml to map TIMESTAMP database columns to the DateTime .NET type. (Bug #55351, Bug #12652602)

  • The ADO.NET Entity Data Model could not add stored procedures from MySQL Server 5.0.45 but worked fine using MySQL Server 5.1. (Bug #55349)

  • Fixed Entity Framework provider GROUP BY clause generation by adding all group-by keys to the SELECT statement. (Bug #46742, Bug #12622129)