Using the same connection string multiple times would result in Database=dbname appearing multiple times in the resulting string. (Bug#29123)

Certain operations would not check the UsageAdvisor setting, causing log messages from the Usage Advisor even when it was disabled. (Bug#29124)

Using the membership/role providers when validationKey or decryptionKey parameters are set to AutoGenerate, an exception would be raised when accessing the corresponding values. (Bug#29235)

An exception would be thrown when using the Manage Role functionality within the web administrator to assign a role to a user. (Bug#29236)

Visual Studio Plugin: Adding a new query based on a stored procedure that uses the SELECT statement would terminate the query/TableAdapter wizard. (Bug#29098)

Visual Studio Plugin: Update commands would not be generated correctly when using the TableAdapter wizard. (Bug#26347)

Visual Studio Plugin: Adding a new query based on a stored procedure that used a UPDATE, INSERT or DELETE statement would terminate the query/TableAdapter wizard. (Bug#28536)

Visual Studio Plugin: Query Builder would fail to show TINYTEXT columns, and any columns listed after a TINYTEXT column correctly. (Bug#28437)

Log messages would be truncated to 300 bytes. (Bug#28706)

Creating a user would fail due to the application name being set incorrectly. (Bug#28648)

Accessing the results from a large query when using data compression in the connection would fail to return all the data. (Bug#28204)

Running the statement SHOW PROCESSLIST would return columns as byte arrays instead of native columns. (Bug#28448)

Connector/NET would look for the wrong table when executing User.IsRole(). (Bug#28251)

DATETIME fields from versions of MySQL bgefore 4.1 would be incorrectly parsed, resulting in a exception. (Bug#23342)

Installation of the Connector/NET on Windows would fail if VisualStudio had not already been installed. (Bug#28260)

Using MySQLDataAdapter.FillSchema() on a stored procedure would raise an exception: Invalid attempt to access a field before calling Read(). (Bug#27668)

Building a connection string within a tight loop would show slow peformance. (Bug#28167)

The UNSIGNED flag for parameters in a stored procedure would be ignored when using MySqlCommandBuilder to obtain the parameter information. (Bug#27679)

Fixed password property on MySqlConnectionStringBuilder to use PasswordPropertyText attribute. This causes dots to show instead of actual password text.

Added Membership and Role provider contributed by Sean Wright (thanks!).

Now compiles for .NET CF 2.0.

Rewrote stored procedure parsing code using a new SQL tokenizer. Really nasty procedures including nested comments are now supported.

GetSchema will now report objects relative to the currently selected database. What this means is that passing in null as a database restriction will report objects on the currently selected database only.

Using the same connection string multiple times would result in Database=dbname appearing multiple times in the resulting string. (Bug#29123)

Certain operations would not check the UsageAdvisor setting, causing log messages from the Usage Advisor even when it was disabled. (Bug#29124)

Log messages would be truncated to 300 bytes. (Bug#28706)

Accessing the results from a large querry when using data compression in the connection will fail to return all the data. (Bug#28204)

Running the statement SHOW PROCESSLIST would return columns as byte arrays instead of native columns. (Bug#28448)

Enlisting a null transaction would affect the current connection object, such that further enlistment operations to the transaction are not possible. (Bug#26754)

Attempting to change the the Connection Protocol property within a PropertyGrid control would raise an exception. (Bug#26472)

DATETIME fields from versions of MySQL bgefore 4.1 would be incorrectly parsed, resulting in a exception. (Bug#23342)

Using MySQLDataAdapter.FillSchema() on a stored procedure would raise an exception: Invalid attempt to access a field before calling Read(). (Bug#27668)

Building a connection string within a tight loop would show slow peformance. (Bug#28167)

The UNSIGNED flag for parameters in a stored procedure would be ignored when using MySqlCommandBuilder to obtain the parameter information. (Bug#27679)

Using logging (with the logging=true parameter to the connection string) would not generate a log file. (Bug#27765)

The CreateFormat column of the DataTypes collection did not contain a format specification for creating a new column type. (Bug#25947)

The characterset property would not be identified during a connection (also affected Visual Studion Plugin). (Bug#27240, Bug#26147)

When cloning an open MySqlClient.MySqlConnection with the Persist Security Info=False option set, the cloned connection is not usable because the security information has not been cloned. (Bug#27269)

If you close an open connection with an active transaction, the transaction is not automatically rolled back. (Bug#27289)

MySqlParameterCollection and parameters added with Insert method can not be retrieved later using ParameterName. (Bug#27135)

Publisher listed in "Add/Remove Programs" is not consistent with other MySQL products. (Bug#27253)

cmd.Parameters.RemoveAt("Id") will cause an error if the last item is requested. (Bug#27187)

Exception thrown when using large values in UInt64 parameters. (Bug#27093)

DESCRIBE .... SQL command returns byte arrays rather than data on MySQL versions older than 4.1.15. (Bug#27221)

MySQL Visual Studio Plugin 1.1.2 does not work with Connector/Net 5.0.5. (Bug#26960)

Return parameters created with DeriveParameters now have the name RETURN_VALUE.

Fixed problem with parameter name hashing where the hashes were not getting updated when parameters were removed from the collection.

Fixed problem with calling stored functions when a return parameter was not given.

Fixed problem that prevented use of SchemaOnly or SingleRow command behaviors with stored procedures or prepared statements.

Assembly now properly appears in the Visual Studio 2005 Add/Remove Reference dialog.

Added MySqlParameterCollection.AddWithValue and marked the Add(name, value) method as obsolete.

Added Use Procedure Bodies connection string option to allow calling procedures without using procedure metadata.

Reverted behavior that required parameter names to start with the parameter marker. We apologize for this back and forth but we mistakenly changed the behavior to not match what SqlClient supports. We now support using either syntax for adding parameters however we also respond exactly like SqlClient in that if you ask for the index of a parameter using a syntax different than you added the parameter, the result will be -1.

The UpdateRowSource.FirstReturnedRecord method does not work. (Bug#25569)

A critical ConnectionPool error would result in repeated System.NullReferenceException. (Bug#25603)

Applications would crash when calling with CommandType set to StoredProcedure.

BINARY and VARBINARY columns would be returned as a string, not binary, datatype. (Bug#25605)

MySqlConnection.GetSchema fails with NullReferenceException for Foreign Keys. (Bug#26660)

When a MySqlConversionException is raised on a remote object, the client application would receive a SerializationException instead. (Bug#24957)

High CPU utilization would be experienced when there is no idle connection waiting when using pooled connections through MySqlPool.GetConnection. (Bug#24373)

Connector/NET would not compile properly when used with Mono 1.2. (Bug#24263)

Opening a connection would be slow due to hostname lookup. (Bug#26152).

Connector/NET would fail to install under Windows Vista. (Bug#26430)

Incorrect values/formats would be applied when the OldSyntax connection string option was used. (Bug#25950)

Registry would be incorrectly populated with installation locations. (Bug#25928)

Filling a table schema through a stored procedure triggers a runtime error. (Bug#25609)

MySqlConnection throws an exception when connecting to MySQL v4.1.7. (Bug#25726)

Returned data types of a DataTypes collection do not contain the right correctl CLR Datatype. (Bug#25907)

GetSchema and DataTypes would throw an exception due to an incorrect table name. (Bug#25906)

Times with negative values would be returned incorrectly. (Bug#25912)

SELECT did not work correctly when using a WHERE clause containing a UTF-8 string. (Bug#25651)

When closing and then re-opening a connection to a database, the character set specification is lost. (Bug#25614)

When connecting to a MySQL Server earlier than version 4.1, the connection would hang when reading data. (Bug#25458)

When connecting to a server, the return code from the connection could be zero, even though the hostname was incorrect. (Bug#24802)

Using ExecuteScalar() with more than one query, where one query fails, will hang the connection. (Bug#25443)

SSL support has been updated.

The ViewColumns GetSchema collection has been updated.

The CommandBuilder.DeriveParameters function has been updated to the procedure cache.

Improved speed and performance by re-architecting certain sections of the code.

Usage Advisor has been implemented. The Usage Advisor checks your queries and will report if you are usiing the connection inefficiently.

The MySqlCommand object now supports asynchronous query methods. This is implemented useg the BeginExecuteNonQuery and EndExecuteNonQuery methods.

Metadata from storaed procedures and stored function execution are cached.

PerfMon hooks have been added to monitor the stored procedure cache hits and misses.

The ShapZipLib library has been replaced with the deflate support provided within .NET 2.0.

Support for the embedded server and client library have been removed from this release. Support will be added back to a later release.

An exception would be raised, or the process would hang, if SELECT privileges on a database were not granted and a stored procedure was used. (Bug#25033)

Nested transactions (which are unsupported)do not raise an error or warning. (Bug#22400)

When adding parameter objects to a command object, if the parameter direction is set to ReturnValue before the parameter is added to the command object then when the command is executed it throws an error. (Bug#25013)

Additional text added to error message (Bug#25178)

Stored procedure executions are not thread safe. (Bug#23905)

Using Driver.IsTooOld() would return the wrong value. (Bug#24661)

Deleting a connection to a disconnected server when using the Visual Studio Plugin would cause an assertion failure. (Bug#23687)

When using a DbNull.Value as the value for a parameter value, and then later setting a specific value type, the command would fail with an exception because the wrong type was implied from the DbNull.Value. (Bug#24565)

Important change: Due to a number of issues with the use of server-side prepared statements, Connector/NET 5.0.2 has disabled their use by default. The disabling of server-side prepared statements does not affect the operation of the connector in any way.

To enable server-side prepared statements you must add the following configuration property to your connector string properties:

ignore prepare=false

The default value of this property is true.

Implemented a stored procedure cache. By default, the connector caches the metadata for the last 25 procedures that are seen. You can change the numbver of procedures that are cacheds by using the procedure cache connection string.

An Ignore Prepare option has been added to the connection string options. If enabled, prepared statements will be disabled application-wide. The default for this option is true.

Creating a connection through the Server Explorer when using the Visual Studio Plugin would fail. The installer for the Visual Studio Plugin has been updated to ensure that Connector/NET 5.0.2 must be installed. (Bug#23071)

Within Mono, using the PreparedStatement interface could result in an error due to a BitArray copying error. (Bug#18186)

Using Windows Vista (RC2) as a non-privileged user would raise a Registry key 'Global' access denied. (Bug#22882)

One system where IPv6 was enabled, Connector/NET would incorrectly resolve hostnames. (Bug#23758)

Column names with accented characters were not parsed properly causing malformed column names in result sets. (Bug#23657)

Connector/NET did not work as a data source for the SqlDataSource object used by ASP.NET 2.0. (Bug#16126)

A System.FormatException exception would be raised when invoking a stored procedure with an ENUM input parameter. (Bug#23268)

During installation, an antivirus error message would be raised (indicating a malicious script problem). (Bug#23245)

An exception would be thrown when calling GetSchemaTable and fields was null. (Bug#23538)

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)

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)

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)

Starting a transaction on a connection created by MySql.Data.MySqlClient.MySqlClientFactory, using BeginTransaction without specifying an isolation level, causes the SQL statement to fail with a syntax error. (Bug#22042)

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)

The MySqlexception class is now derived from the DbException class. (Bug#21874)

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)

The # would not be accepted within column/table names, even though it was valid. (Bug#21521)

CommandText: Question mark in comment line is being parsed as a parameter. (Bug#6214)

Implemented Usage Advisor.

Added Async query methods.

Reimplemented PacketReader/PacketWriter support into MySqlStream class.

Added internal implemention of SHA1 so we don't have to distribute the OpenNetCF on mobile devices.

Added usage advisor warnings for requesting column values by the wrong type.

Reworked connection string classes to be simpler and faster.

Added procedure metadata caching.

Added perfmon hooks for stored procedure cache hits and misses.

Implemented MySqlConnectionBuilder class.

Implemented MySqlClientFactory class.

Implemented classes and interfaces for ADO.Net 2.0 support.

Replaced use of ICSharpCode with .NET 2.0 internal deflate support.

Refactored test suite to test all protocols in a single pass.

Completely refactored how column values are handled to avoid boxing in some cases.

Publisher listed in "Add/Remove Programs" is not consistent with other MySQL products. (Bug#27253)

MySqlParameterCollection and parameters added with Insert method can not be retrieved later using ParameterName. (Bug#27135)

A critical ConnectionPool error would result in repeated System.NullReferenceException. (Bug#25603)

When a MySqlConversionException is raised on a remote object, the client application would receive a SerializationException instead. (Bug#24957)

High CPU utilization would be experienced when there is no idle connection waiting when using pooled connections through MySqlPool.GetConnection. (Bug#24373)

BINARY and VARBINARY columns would be returned as a string, not binary, datatype. (Bug#25605)

Important change: Due to a number of issues with the use of server-side prepared statements, Connector/NET 5.0.2 has disabled their use by default. The disabling of server-side prepared statements does not affect the operation of the connector in any way.

To enable server-side prepared statements you must add the following configuration property to your connector string properties:

ignore prepare=false

The default value of this property is true.

Important change: Binaries for .NET 1.0 are no longer supplied with this release. If you need support for .NET 1.0, you must build from source.

Implemented a stored procedure cache. By default, the connector caches the metadata for the last 25 procedures that are seen. You can change the numbver of procedures that are cacheds by using the procedure cache connection string.

An Ignore Prepare option has been added to the connection string options. If enabled, prepared statements will be disabled application-wide. The default for this option is true.

The ICSharpCode ZipLib is no longer used by the Connector, and is no longer distributed with it.

Improved CommandBuilder.DeriveParameters to first try and use the procedure cache before querying for the stored procedure metadata. Return parameters created with DeriveParameters now have the name RETURN_VALUE.

Trying to fill a table schema through a stored procedure triggers a runtime error. (Bug#25609)

MySqlConnection throws a NullReferenceException and ArgumentNullException when connecting to MySQL v4.1.7. (Bug#25726)

SELECT did not work correctly when using a WHERE clause containing a UTF-8 string. (Bug#25651)

Times with negative values would be returned incorrectly. (Bug#25912)

When closing and then re-opening a connection to a database, the character set specification is lost. (Bug#25614)

When connecting to a server, the return code from the connection could be zero, even though the hostname was incorrect. (Bug#24802)

Using ExecuteScalar() with more than one query, where one query fails, will hang the connection. (Bug#25443)

Nested transactions do not raise an error or warning. (Bug#22400)

When adding parameter objects to a command object, if the parameter direction is set to ReturnValue before the parameter is added to the command object then when the command is executed it throws an error. (Bug#25013)

Additional text added to error message. (Bug#25178)

The CommandBuilder would mistakenly add insert parameters for a table column with auto incrementation enabled. (Bug#23862)

Stored procedure executions are not thread safe. (Bug#23905)

Using Driver.IsTooOld() would return the wrong value. (Bug#24661)

When using a DbNull.Value as the value for a parameter value, and then later setting a specific value type, the command would fail with an exception because the wrong type was implied from the DbNull.Value. (Bug#24565)

Within Mono, using the PreparedStatement interface could result in an error due to a BitArray copying error. (Bug 18186)

One system where IPv6 was enabled, Connector/NET would incorrectly resolve hostnames. (Bug#23758)

An System.OverflowException would be raised when accessing a varchar field over 255 bytes. Bug (#23749)

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)

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.

Unsigned tinyint (NET byte) would lead to and incorrectly determined parameter type from the parameter value. (Bug#18570)

The parameter collection object's Add() method added parameters to the list without first checking to see whether they already existed. Now it updates the value of the existing parameter object if it exists. (Bug#13927)

A #42000Query was empty exception occurred when executing a query built with MySqlCommandBuilder, if the query string ended with a semicolon. (Bug#14631)

Implemented the MySqlCommandBuilder.DeriveParameters method that is used to discover the parameters for a stored procedure. (Bug#13632)

Added support for the cp932 character set. (Bug#13806)

Calling a stored procedure where a parameter contained special characters (such as '@') would produce an exception. Note that ANSI_QUOTES had to be enabled to make this possible. (Bug#13753)

A statement that contained multiple references to the same parameter could not be prepared. (Bug#13541)

The Ping() method did not update the State property of the Connection object. (Bug#13658)

The nant build sequence had problems. (Bug#12978)

Serializing a parameter failed if the first value passed in was NULL. (Bug#13276)

Field names that contained the following characters caused errors: ()%<>/ (Bug#13036)

The Connector/NET 1.0.5 installer would not install alongside Connector/NET 1.0.4. (Bug#12835)

Connector/NET 1.0.5 could not connect on Mono. (Bug#13345)

With multiple hosts in the connection string, Connector/NET would not connect to the last host in the list. (Bug#12628)

Connector/NET interpreted the new decimal data type as a byte array. (Bug#11294)

The cp1250 character set was not supported. (Bug#11621)

Connection could fail when .NET thread pool had no available worker threads. (Bug#10637)

Decimal parameters caused syntax errors. (Bug#11550, Bug#10486, Bug#10152)

A call to a stored procedure caused an exception if the stored procedure had no parameters. (Bug#11542)

Certain malformed queries would trigger a Connection must be valid and open error message. (Bug#11490)

The MySqlCommandBuilder class could not handle queries that referenced tables in a database other than the default database. (Bug#8382)

Connector/NET could not work properly with certain regional settings. (WL#8228)

Trying to use a stored procedure when Connection.Database was not populated generated an exception. (Bug#11450)

Trying to read a TIMESTAMP column generated an exception. (Bug#7951)

Parameters were not recognized when they were separated by linefeeds. (Bug#9722)

Calling MySqlConnection.clone when a connection string had not yet been set on the original connection would generate an error. (Bug#10281)

Added support to call a stored function from Connector/NET. (Bug#10644)

Connector/NET could not connect to MySQL 4.1.14. (Bug#12771)

The ConnectionString property could not be set when a MySqlConnection object was added with the designer. (Bug#12551, Bug#8724)

Calling prepare causing exception. (Bug#7243)

Fixed another small problem with prepared statements.

MySqlCommand.Connection returns an IDbConnection. (Bug#7258)

MySqlAdapter.Fill method throws error message Non-negative number required. (Bug#7345)

Clone method bug in MySqlCommand. (Bug#7478)

MySqlDataReader.GetString(index) returns non-Null value when field is Null. (Bug#7612)

MySqlReader.GetInt32 throws exception if column is unsigned. (Bug#7755)

GetBytes is working no more. (Bug#7704).

Quote character \222 not quoted in EscapeString. (Bug#7724)

Fixed problem that causes named pipes to not work with some blob functionality.

Fixed problem with shared memory connections.

Problem with Multiple resultsets. (Bug#7436)

Added or filled out several more topics in the API reference documentation.

Made MySQL the default named pipe name.

Now SHOW COLLATION is used upon connection to retrieve the full list of charset ids.

Fixed Invalid character set index: 200. (Bug#6547)

Installer now includes options to install into GAC and create Start Menu items.

Int64 Support in MySqlCommand Parameters. (Bug#6863)

Connections now do not have to give a database on the connection string.

MySqlDataReader.GetChar(int i) throws IndexOutOfRange exception. (Bug#6770)

Fixed problem where multiple resultsets having different numbers of columns would cause a problem.

Exception stack trace lost when re-throwing exceptions. (Bug#6983)

Fixed major problem with detecting null values when using prepared statements.

Errors in parsing stored procedure parameters. (Bug#6902)

Integer "out" parameter from stored procedure returned as string. (Bug#6668)

MySqlDateTime in Datatables sorting by Text, not Date. (Bug#7032)

Invalid query string when using inout parameters (Bug#7133)

Test suite fails with MySQL 4.0 because of case sensitivity of table names. (Bug#6831)

Inserting DateTime causes System.InvalidCastException to be thrown. (Bug#7132)

InvalidCast when using DATE_ADD-function. (Bug#6879)

An Open Connection has been Closed by the Host System. (Bug#6634)

Added ServerThread property to MySqlConnection to expose server thread id.

Added Ping method to MySqlConnection.

Changed the name of the test suite to MySql.Data.Tests.dll.

Fixed problem with MySqlBinary where string values could not be used to update extended text columns

Fixed Installation directory ignored using custom installation (Bug#6329)

Fixed problem where setting command text leaves the command in a prepared state

Fixed double type handling in MySqlParameter(string parameterName, object value) (Bug#6428)

Fixed Zero date "0000-00-00" is returned wrong when filling Dataset (Bug#6429)

Fixed problem where calling stored procedures might cause an "Illegal mix of collations" problem.

Added charset connection string option

Fixed #HY000 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ (Bug#6322)

Added the TableEditor CS and VB sample

Fixed Charset-map for UCS-2 (Bug#6541)

Updated the installer to include the new samples

Fixed Long inserts take very long time (Bu #5453)

Fixed Objects not being disposed (Bug#6649)

Provider is now using character set specified by server as default

Fixed Bug#5602 Possible bug in MySqlParameter(string, object) constructor

Fixed Bug#5458 Calling GetChars on a longtext column throws an exception

Fixed Bug#5474 cannot run a stored procedure populating mysqlcommand.parameters

Fixed Bug#5469 Setting DbType throws NullReferenceException

Fixed problem where connector was not issuing a CMD_QUIT before closing the socket

Fixed Bug#5392 MySqlCommand sees "?" as parameters in string literals

Fixed problem with ConnectionInternal where a key might be added more than once

CP1252 is now used for Latin1 only when the server is 4.1.2 and later

Fixed Bug#5388 DataReader reports all rows as NULL if one row is NULL

Virtualized driver subsystem so future releases could easily support client or embedded server support

Field buffers being reused to decrease memory allocations and increase speed

Fixed problem where using old syntax while using the interfaces caused problems

Using PacketWriter instead of Packet for writing to streams

Refactored compression code into CompressedStream to clean up NativeDriver

Added test case for resetting the command text on a prepared command

Fixed problem where MySqlParameterCollection.Add() would throw unclear exception when given a null value (Bug#5621)

Fixed construtor initialize problems in MySqlCommand() (Bug#5613)

Fixed Parsing the ';' char (Bug#5876)

Fixed missing Reference in DbType setter (Bug#5897)

Fixed System.OverflowException when using YEAR datatype (Bug#6036)

Added Aggregate function test (wasn't really a bug)

Fixed serializing of floating point parameters (double, numeric, single, decimal) (Bug#5900)

IsNullable error (Bug#5796)

Fixed problem where connection lifetime on the connect string was not being respected

Fixed problem where Min Pool Size was not being respected

Fixed MySqlDataReader and 'show tables from ...' behavior (Bug#5256)

Implemented SequentialAccess

Fixed MySqlDateTime sets IsZero property on all subseq.records after first zero found (Bug#6006)

Fixed Can't display Chinese correctly (Bug#5288)

Fixed Russian character support as well

Fixed Method TokenizeSql() uses only a limited set of valid characters for parameters (Bug#6217)

Fixed NET Connector source missing resx files (Bug#6216)

Fixed DBNull Values causing problems with retrieving/updating queries. (Bug#5798)

Fixed Yet Another "object reference not set to an instance of an object" (Bug#5496)

Fixed problem in PacketReader where it could try to allocate the wrong buffer size in EnsureCapacity

Fixed GetBoolean returns wrong values (Bug#6227)

Fixed IndexOutOfBounds when reading BLOB with DataReader with GetString(index) (Bug#6230)

Thai encoding not correctly supported. (Bug#3889)

Updated many of the test cases.

Fixed problem with using compression.

Bumped version number to 1.0.0 for beta 1 release.

Added COPYING.rtf file for use in installer.

Removed all of the XML comment warnings.

Removed some last references to ByteFX.

Added test fixture for prepared statements.

All type classes now implement a SerializeBinary method for sending their data to a PacketWriter.

Added PacketWriter class that will enable future low-memory large object handling.

Fixed many small bugs in running prepared statements and stored procedures.

Changed command so that an exception will not be throw in executing a stored procedure with parameters in old syntax mode.

SingleRow behavior now working right even with limit.

GetBytes now only works on binary columns.

Logger now truncates long sql commands so blob columns don't blow out our log.

host and database now have a default value of "" unless otherwise set.

Connection Timeout seems to be ignored. (Bug#5214)

Added test case for bug# 5051: GetSchema not working correctly.

Fixed problem where GetSchema would return false for IsUnique when the column is key.

MySqlDataReader GetXXX methods now using the field level MySqlValue object and not performing conversions.

DataReader returning NULL for time column. (Bug#5097)

Added test case for LOAD DATA LOCAL INFILE.

Added replacetext custom nant task.

Added CommandBuilderTest fixture.

Added Last One Wins feature to CommandBuilder.

Fixed persist security info case problem.

Fixed GetBool so that 1, true, "true", and "yes" all count as true.

Make parameter mark configurable.

Added the "old syntax" connection string parameter to allow use of @ parameter marker.

MySqlCommandBuilder. (Bug#4658)

ByteFX.MySqlClient caches passwords if Persist Security Info is false. (Bug#4864)

Updated license banner in all source files to include FLOSS exception.

Added new .Types namespace and implementations for most current MySql types.

Added MySqlField41 as a subclass of MySqlField.

Changed many classes to now use the new .Types types.

Changed type enum int to Int32, short to Int16, and bigint to Int64.

Added dummy types UInt16, UInt32, and UInt64 to allow an unsigned parameter to be made.

Connections are now reset when they are pulled from the connection pool.

Refactored auth code in driver so it can be used for both auth and reset.

Added UserReset test in PoolingTests.cs.

Connections are now reset using COM_CHANGE_USER when pulled from the pool.

Implemented SingleResultSet behavior.

Implemented support of unicode.

Added char set mappings for utf-8 and ucs-2.

Time fields overflow using bytefx .net mysql driver (Bug#4520)

Modified time test in data type test fixture to check for time spans where hours > 24.

Wrong string with backslash escaping in ByteFx.Data.MySqlClient.MySqlParameter. (Bug#4505)

Added code to Parameter test case TestQuoting to test for backslashes.

MySqlCommandBuilder fails with multi-word column names. (Bug#4486)

Fixed bug in TokenizeSql where underscore would terminate character capture in parameter name.

Added test case for spaces in column names.

MySqlDataReader.GetBytes don't works correctly. (Bug#4324)

Added GetBytes() test case to DataReader test fixture.

Now reading all server variables in InternalConnection.Configure into Hashtable.

Now using string[] for index map in CharSetMap.

Added CRInSQL test case for carriage returns in SQL.

Setting maxPacketSize to default value in Driver.ctor.

Setting MySqlDbType on a parameter doesn't set generic type. (Bug#4442)

Removed obsolete data types Long and LongLong.

Overflow exception thrown when using "use pipe" on connection string. (Bug#4071)

Changed "use pipe" keyword to "pipe name" or just "pipe".

Allow reading multiple resultsets from a single query.

Added flags attribute to ServerStatusFlags enum.

Changed name of ServerStatus enum to ServerStatusFlags.

Inserted data row doesn't update properly.

Error processing show create table. (Bug#4074)

Change Packet.ReadLenInteger to ReadPackedLong and added packet.ReadPackedInteger that alwasy reads integers packed with 2,3,4.

Added syntax.cs test fixture to test various SQL syntax bugs.

Improper handling of time values. Now time value of 00:00:00 is not treated as null. (Bug#4149)

Moved all test suite files into TestSuite folder.

Fixed bug where null column would move the result packet pointer backward.

Added new nant build script.

Clear tablename so it will be regen'ed properly during the next GenerateSchema. (Bug#3917)

GetValues was always returning zero and was also always trying to copy all fields rather than respecting the size of the array passed in. (Bug#3915)

Implemented shared memory access protocol.

Implemented prepared statements for MySQL 4.1.

Implemented stored procedures for MySQL 5.0.

Renamed MySqlInternalConnection to InternalConnection.

SQL is now parsed as chars, fixes problems with other languages.

Added logging and allow batch connection string options.

RowUpdating event not set when setting the DataAdapter property. (Bug#3888)

Fixed bug in char set mapping.

Implemented 4.1 authentication.

Improved open/auth code in driver.

Improved how connection bits are set during connection.

Database name is now passed to server during initial handshake.

Changed namespace for client to MySql.Data.MySqlClient.

Changed assembly name of client to MySql.Data.dll.

Changed license text in all source files to GPL.

Added the MySqlClient.build Nant file.

Removed the mono batch files.

Moved some of the unused files into notused folder so nant build file can use wildcards.

Implemented shared memory accesss.

Major revamp in code structure.

Prepared statements now working for MySql 4.1.1 and later.

Finished implementing auth for 4.0, 4.1.0, and 4.1.1.

Changed namespace from MySQL.Data.MySQLClient back to MySql.Data.MySqlClient.

Fixed bug in CharSetMapping where it was trying to use text names as ints.

Changed namespace to MySQL.Data.MySQLClient.

Integrated auth changes from UC2004.

Fixed bug where calling any of the GetXXX methods on a datareader before or after reading data would not throw the appropriate exception (thanks Luca Morelli).

Added TimeSpan code in parameter.cs to properly serialize a timespan object to mysql time format (thanks Gianluca Colombo).

Added TimeStamp to parameter serialization code. Prevented DataAdatper updates from working right (thanks Michael King).

Fixed a misspelling in MySqlHelper.cs (thanks Patrick Kristiansen).

Driver now using charset number given in handshake to create encoding.

Changed command editor to point to MySqlClient.Design.

Fixed bug in Version.isAtLeast.

Changed DBConnectionString to support changes done to MySqlConnectionString.

Removed SqlCommandEditor and DataAdapterPreviewDialog.

Using new long return values in many places.

Integrated new CompressedStream class.

Changed ConnectionString and added attributes to allow it to be used in MySqlClient.Design.

Changed packet.cs to support newer lengths in ReadLenInteger.

Changed other classes to use new properties and fields of MySqlConnectionString.

ConnectionInternal is now using PING to see whether the server is alive.

Moved toolbox bitmaps into resource folder.

Changed field.cs to allow values to come directly from row buffer.

Changed to use the new driver.Send syntax.

Using a new packet queueing system.

Started work handling the "broken" compression packet handling.

Fixed bug in StreamCreator where failure to connect to a host would continue to loop infinitly (thanks Kevin Casella).

Improved connectstring handling.

Moved designers into Pro product.

Removed some old commented out code from command.cs.

Fixed a problem with compression.

Fixed connection object where an exception throw prior to the connection opening would not leave the connection in the connecting state (thanks Chris Cline).

Added GUID support.

Fixed sequence out of order bug (thanks Mark Reay).

Enum values now supported as parameter values (thanks Philipp Sumi).

Year datatype now supported.

Fixed compression.

Fixed bug where a parameter with a TimeSpan as the value would not serialize properly.

Fixed bug where default constructor would not set default connection string values.

Added some XML comments to some members.

Work to fix/improve compression handling.

Improved ConnectionString handling so that it better matches the standard set by SqlClient.

A MySqlException is now thrown if a username is not included in the connection string.

Localhost is now used as the default if not specified on the connection string.

An exception is now thrown if an attempt is made to set the connection string while the connection is open.

Small changes to ConnectionString docs.

Removed MultiHostStream and MySqlStream. Replaced it with Common/StreamCreator.

Added support for Use Pipe connection string value.

Added Platform class for easier access to platform utility functions.

Fixed small pooling bug where new connection was not getting created after IsAlive fails.

Added Platform.cs and StreamCreator.cs.

Fixed Field.cs to properly handle 4.1 style timestamps.

Changed Common.Version to Common.DBVersion to avoid name conflict.

Fixed field.cs so that text columns return the right field type.

Added MySqlError class to provide some reference for error codes (thanks Geert Veenstra).

Added Unix socket support (thanks Mohammad DAMT).

Only calling Thread.Sleep when no data is available.

Improved escaping of quote characters in parameter data.

Removed misleading comments from parameter.cs.

Fixed pooling bug.

Fixed ConnectionString editor dialog (thanks marco p (pomarc)).

UserId now supported in connection strings (thanks Jeff Neeley).

Attempting to create a parameter that is not input throws an exception (thanks Ryan Gregg).

Added much documentation.

Checked in new MultiHostStream capability. Big thanks to Dan Guisinger for this. he originally submitted the code and idea of supporting multiple machines on the connect string.

Added a lot of documentation.

Fixed speed issue with 0.73.

Changed to Thread.Sleep(0) in MySqlDataStream to help optimize the case where it doesn't need to wait (thanks Todd German).

Prepopulating the idlepools to MinPoolSize.

Fixed MySqlPool deadlock condition as well as stupid bug where CreateNewPooledConnection was not ever adding new connections to the pool. Also fixed MySqlStream.ReadBytes and ReadByte to not use TicksPerSecond which does not appear to always be right. (thanks Matthew J. Peddlesden)

Fix for precision and scale (thanks Matthew J. Peddlesden).

Added Thread.Sleep(1) to stream reading methods to be more cpu friendly (thanks Sean McGinnis).

Fixed problem where ExecuteReader would sometime return null (thanks Lloyd Dupont).

Fixed major bug with null field handling (thanks Naucki).

Enclosed queries for max_allowed_packet and characterset inside try catch (and set defaults).

Fixed problem where socket was not getting closed properly (thanks Steve!).

Fixed problem where ExecuteNonQuery was not always returning the right value.

Fixed InternalConnection to not use @@session.max_allowed_packet but use @@max_allowed_packet. (Thanks Miguel)

Added many new XML doc lines.

Fixed sql parsing to not send empty queries (thanks Rory).

Fixed problem where the reader was not unpeeking the packet on close.

Fixed problem where user variables were not being handled (thanks Sami Vaaraniemi).

Fixed loop checking in the MySqlPool (thanks Steve M. Brown)

Fixed ParameterCollection.Add method to match SqlClient (thanks Joshua Mouch).

Fixed ConnectionString parsing to handle no and yes for boolean and not lowercase values (thanks Naucki).

Added InternalConnection class, changes to pooling.

Implemented Persist Security Info.

Added security.cs and version.cs to project

Fixed DateTime handling in Parameter.cs (thanks Burkhard Perkens-Golomb).

Fixed parameter serialization where some types would throw a cast exception.

Fixed DataReader to convert all returned values to prevent casting errors (thanks Keith Murray).

Added code to Command.ExecuteReader to return null if the initial SQL command throws an exception (thanks Burkhard Perkens-Golomb).

Fixed ExecuteScalar bug introduced with restructure.

Restructure to allow for LOCAL DATA INFILE and better sequencing of packets.

Fixed several bugs related to restructure.

Early work done to support more secure passwords in Mysql 4.1. Old passwords in 4.1 not supported yet.

Parameters appearing after system parameters are now handled correctly (Adam M. (adammil)).

Strings can now be assigned directly to blob fields (Adam M.).

Fixed float parameters (thanks Pent).

Improved Parameter constructor and ParameterCollection.Add methods to better match SqlClient (thanks Joshua Mouch).

Corrected Connection.CreateCommand to return a MySqlCommand type.

Fixed connection string designer dialog box problem (thanks Abraham Guyt).

Fixed problem with sending commands not always reading the response packet (thanks Joshua Mouch).

Fixed parameter serialization where some blobs types were not being handled (thanks Sean McGinnis).

Removed spurious MessageBox.show from DataReader code (thanks Joshua Mouch).

Fixed a nasty bug in the split sql code (thanks everyone!).

Fixed bug in MySqlStream where too much data could attempt to be read (thanks Peter Belbin)

Implemented HasRows (thanks Nash Pherson).

Fixed bug where tables with more than 252 columns cause an exception (thanks Joshua Kessler).

Fixed bug where SQL statements ending in ; would cause a problem (thanks Shane Krueger).

Fixed bug in driver where error messages were getting truncated by 1 character (thanks Shane Krueger).

Made MySqlException serializable (thanks Mathias Hasselmann).

Updated some of the character code pages to be more accurate.

Fixed problem where readers could be opened on connections that had readers open.

Moved test to separate assembly MySqlClientTests.

Fixed stupid problem in driver with sequence out of order (Thanks Peter Belbin).

Added some pipe tests.

Increased default max pool size to 50.

Compiles with Mono 0-24.

Fixed connection and data reader dispose problems.

Added String datatype handling to parameter serialization.

Fixed sequence problem in driver that occurred after thrown exception (thanks Burkhard Perkens-Golomb).

Added support for CommandBehavior.SingleRow to DataReader.

Fixed command sql processing so quotes are better handled (thanks Theo Spears).

Fixed parsing of double, single, and decimal values to account for non-English separators. You still have to use the right syntax if you using hard coded sql, but if you use parameters the code will convert floating point types to use '.' appropriately internal both into the server and out.

Added MySqlStream class to simplify timeouts and driver coding.

Fixed DataReader so that it is closed properly when the associated connection is closed. [thanks smishra]

Made client more SqlClient compliant so that DataReaders have to be closed before the connection can be used to run another command.

Improved DBNull.Value handling in the fields.

Added several unit tests.

Fixed MySqlException base class.

Improved driver coding

Fixed bug where NextResult was returning false on the last resultset.

Added more tests for MySQL.

Improved casting problems by equating unsigned 32bit values to Int64 and usigned 16bit values to Int32, and so forth.

Added new constructor for MySqlParameter for (name, type, size, srccol)

Fixed bug in MySqlDataReader where it didn't check for null fieldlist before returning field count.

Started adding MySqlClient unit tests (added MySqlClient/Tests folder and some test cases).

Fixed some things in Connection String handling.

Moved INIT_DB to MySqlPool. I may move it again, this is in preparation of the conference.

Fixed bug inside CommandBuilder that prevented inserts from happening properly.

Reworked some of the internals so that all three execute methods of Command worked properly.

Fixed many small bugs found during benchmarking.

The first cut of CoonectionPooling is working. "min pool size" and "max pool size" are respected.

Work to enable multiple resultsets to be returned.

Character sets are handled much more intelligently now. The driver queries MySQL at startup for the default character set. That character set is then used for conversions if that code page can be loaded. If not, then the default code page for the current OS is used.

Added code to save the inferred type in the name,value constructor of Parameter.

Also, inferred type if value of null parameter is changed using Value property.

Converted all files to use proper Camel case. MySQL is now MySql in all files. PgSQL is now PgSql.

Added attribute to PgSql code to prevent designer from trying to show.

Added MySQLDbType property to Parameter object and added proper conversion code to convert from DbType to MySQLDbType).

Removed unused ObjectToString method from MySQLParameter.cs.

Fixed Add(..) method in ParameterCollection so that it doesn't use Add(name, value) instead.

Fixed IndexOf and Contains in ParameterCollection to be aware that parameter names are now stored without @.

Fixed Command.ConvertSQLToBytes so it only allows characters that can be in MySQL variable names.

Fixed DataReader and Field so that blob fields read their data from Field.cs and GetBytes works right.

Added simple query builder editor to CommandText property of MySQLCommand.

Fixed CommandBuilder and Parameter serialization to account for Parameters not storing @ in their names.

Removed MySQLFieldType enum from Field.cs. Now using MySQLDbType enum.

Added Designer attribute to several classes to prevent designer view when using VS.Net.

Fixed Initial catalog typo in ConnectionString designer.

Removed 3 parameter constructor for MySQLParameter that conflicted with (name, type, value).

Changed MySQLParameter so paramName is now stored without leading @ (this fixed null inserts when using designer).

Changed TypeConverter for MySQLParameter to use the constructor with all properties.

Fixed sequence issue in driver.

Added DbParametersEditor to make parameter editing more like SqlClient.

Fixed Command class so that parameters can be edited using the designer

Update connection string designer to support Use Compression flag.

Fixed string encoding so that European characters like д will work correctly.

Creating base classes to aid in building new data providers.

Added support for UID key in connection string.

Field, parameter, command now using DBNull.Value instead of null.

CommandBuilder using DBNull.Value.

CommandBuilder now builds insert command correctly when an auto_insert field is not present.

Field now uses typeof keyword to return System.Types (performance).

MySQLCommandBuilder now implemented.

Transaction support now implemented (not all table types support this).

GetSchemaTable fixed to not use xsd (for Mono).

Driver is now Mono-compatible.

TIME data type now supported.

More work to improve Timestamp data type handling.

Changed signatures of all classes to match corresponding SqlClient classes.

Protocol compression using SharpZipLib (www.icsharpcode.net).

Named pipes on Windows now working properly.

Work done to improve Timestamp data type handling.

Implemented IEnumerable on DataReader so DataGrid would work.

Speed increased dramatically by removing bugging network sync code.

Driver no longer buffers rows of data (more ADO.Net compliant).

Conversion bugs related to TIMESTAMP and DATETIME fields fixed.