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.
MySQL Connector/Net on a Turkish operating system, may fail to execute certain SQL statements correctly. (Bug #22452)
# would not be accepted within
column/table names, even though it was valid.
Close on a connection after
calling a stored procedure would trigger a
You can now install the MySQL Connector/Net MSI package from the command line
The DiscoverParameters function failed when a stored procedure
NUMERIC parameter type.
When running a query that included a date comparison, a DateReader error would be raised. (Bug #19481)
IDataRecord.GetString would raise
NullPointerException for null values in
returned rows. Method now throws
Parameter substitution in queries where the order of parameters and table fields did not match would substitute incorrect values. (Bug #19261)
Submitting an empty string to a command object through
prepare raises an
System.IndexOutOfRangeException, rather than
a MySQL Connector/Net exception.
An exception would be raised when using an output parameter to a
CHAR type added to MySqlDbType. (Bug #17749)
SELECT query on a table with a
date with a value of
'0000-00-00' would hang
The CommandBuilder ignored Unsigned flag at Parameter creation. (Bug #17375)
When working with multiple threads, character set initialization would generate errors. (Bug #17106)
When using an unsigned 64-bit integer in a stored procedure, the unsigned bit would be lost stored. (Bug #16934)
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.
Unsigned data types were not properly supported. (Bug #16788)
The connection string parser did not permit single or double quotation marks in the password. (Bug #16659)
MySqlDateTime class did not contain
for a stored procedure that has no paramers would cause an
Incorrect field/data lengths could be returned for
VARCHAR UTF8 columns.
ExecuteScalar with a datetime field,
where the value of the field is "0000-00-00 00:00:00", a
MySqlConversionException exception would be
would be raised when trying to update a row that contained a
date field, where the date field contained a zero value
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.
Executing multiple queries as part of a transaction returns
There is already an openDataReader associated with this
Connection which must be closed first.