Bugs fixed:
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)
The MySqlDateTime
class did not contain
constructors. (Bug#15112)
DataReader
would show the value of the
previous row (or last row with non-null data) if the current
row contained a datetime
field with a null
value. (Bug#16884)
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)
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)
Incorrect field/data lengths could be returned for
VARCHAR
UTF8 columns. Bug (#14592)
Submitting an empty string to a command object through
prepare
raises an
System.IndexOutOfRangeException
, rather
than a Connector/Net exception. (Bug#18391)
Connector/NET on a Tukish operating system, may fail to execute certain SQL statements correctly. (Bug#22452)
You can now install the Connector/NET MSI package from the
command line using the /passive
,
/quiet
, /q
options. (Bug#19994)
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)
Called MySqlCommandBuilder.DeriveParameters
for a stored procedure that has no paramers would cause an
application crash. (Bug#15077)
A SELECT
query on a table with a date with
a value of '0000-00-00'
would hang the
application. (Bug#17736)
The #
would not be accepted within
column/table names, even though it was valid. (Bug#21521)
Calling Close
on a connection after
calling a stored procedure would trigger a
NullReferenceException
. (Bug#20581)
IDataRecord.GetString
would raise
NullPointerException
for null values in
returned rows. Method now throws
SqlNullValueException
. (Bug#19294)
An exception would be raised when using an output parameter to
a System.String
value. (Bug#17814)
The DiscoverParameters function would fail when a stored
procedure used a NUMERIC
parameter type.
(Bug#19515)
When running a query that included a date comparison, a DateReader error would be raised. (Bug#19481)
Parameter substitution in queries where the order of parameters and table fields did not match would substitute incorrect values. (Bug#19261)
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)
The connection string parser did not allow single or double quotes in the password. (Bug#16659)
The CommandBuilder ignored Unsigned flag at Parameter creation. (Bug#17375)
CHAR type added to MySqlDbType. (Bug#17749)
Unsigned data types were not properly supported. (Bug#16788)
Functionality added or changed:
Stored procedures are now cached.
The method for retrieving stored procedured metadata has been
changed so that users without SELECT
privileges on the mysql.proc
table can use
a stored procedure.