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.
When working with multiple threads, character set initialization would generate errors. (Bug #17106)
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.
Submitting an empty string to a command object through
prepare raises an
System.IndexOutOfRangeException, rather than
a MySQL Connector/Net exception.
for a stored procedure that has no paramers would cause an
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.
CHAR type added to MySqlDbType. (Bug #17749)
ExecuteScalar with a datetime field,
where the value of the field is "0000-00-00 00:00:00", a
MySqlConversionException exception would be
Parameter substitution in queries where the order of parameters and table fields did not match would substitute incorrect values. (Bug #19261)
MySqlDateTime class did not contain
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.
SELECT query on a table with a
date with a value of
'0000-00-00' would hang
You can now install the MySQL Connector/Net MSI package from the command line
would be raised when trying to update a row that contained a
date field, where the date field contained a zero value
The DiscoverParameters function would fail when a stored
procedure used a
Unsigned data types were not properly supported. (Bug #16788)
# would not be accepted within
column/table names, even though it was valid.
DataReader would show the value of the
previous row (or last row with nonnull data) if the current row
datetime field with a null value.
IDataRecord.GetString would raise
NullPointerException for null values in
returned rows. Method now throws
MySQL Connector/Net on a Turkish operating system, may fail to execute certain SQL statements correctly. (Bug #22452)
Close on a connection after
calling a stored procedure would trigger a
An exception would be raised when using an output parameter to a