Functionality Added or Changed
The method for retrieving stored procedure metadata has been
changed so that users without
SELECT privileges on the
mysql.proc table can use a stored procedure.
Stored procedures are now cached.
Bugs Fixed
When working with multiple threads, character set initialization would generate errors. (Bug #17106)
When using MySqlDataAdapter, connections to a
MySQL server may remain open and active, even though the use of
the connection has been completed and the data received.
(Bug #8131)
Submitting an empty string to a command object through
prepare raises an
System.IndexOutOfRangeException, rather than
a MySQL Connector/Net exception.
(Bug #18391)
Called MySqlCommandBuilder.DeriveParameters
for a stored procedure that has no paramers would cause an
application crash.
(Bug #15077)
The connection string parser did not permit single or double quotation marks in the password. (Bug #16659)
The CommandBuilder ignored Unsigned flag at Parameter creation. (Bug #17375)
Executing multiple queries as part of a transaction returns
There is already an openDataReader associated with this
Connection which must be closed first.
(Bug #7248)
CHAR type added to MySqlDbType. (Bug #17749)
Using ExecuteScalar with a datetime field,
where the value of the field is "0000-00-00 00:00:00", a
MySqlConversionException exception would be
raised.
(Bug #11991)
Parameter substitution in queries where the order of parameters and table fields did not match would substitute incorrect values. (Bug #19261)
The MySqlDateTime class did not contain
constructors.
(Bug #15112)
When running a query that included a date comparison, a DateReader error would be raised. (Bug #19481)
When using an unsigned 64-bit integer in a stored procedure, the unsigned bit would be lost stored. (Bug #16934)
Incorrect field/data lengths could be returned for
VARCHAR UTF8 columns.
(Bug #14592)
A SELECT query on a table with a
date with a value of '0000-00-00' would hang
the application.
(Bug #17736)
You can now install the MySQL Connector/Net MSI package from the command line
using the /passive,
/quiet, /q options.
(Bug #19994)
An MySql.Data.Types.MySqlConversionException
would be raised when trying to update a row that contained a
date field, where the date field contained a zero value
(0000-00-00 00:00:00).
(Bug #9619)
The DiscoverParameters function would fail when a stored
procedure used a NUMERIC
parameter type.
(Bug #19515)
Unsigned data types were not properly supported. (Bug #16788)
The # would not be accepted within
column/table names, even though it was valid.
(Bug #21521)
DataReader would show the value of the
previous row (or last row with nonnull data) if the current row
contained a datetime field with a null value.
(Bug #16884)
IDataRecord.GetString would raise
NullPointerException for null values in
returned rows. Method now throws
SqlNullValueException.
(Bug #19294)
MySQL Connector/Net on a Turkish operating system, may fail to execute certain SQL statements correctly. (Bug #22452)
Calling Close on a connection after
calling a stored procedure would trigger a
NullReferenceException.
(Bug #20581)
An exception would be raised when using an output parameter to a
System.String value.
(Bug #17814)
