First GA release.
Functionality added or changed:
The
MySqlTokenizer
failed to split fieldnames from values if they were not separated by a space. This also happened if the string contained certain characters. As a resultMySqlCommand.ExecuteNonQuery
raised an index out of range exception.The resulting errors are illustrated by the following examples. Note, the example statements do not have delimiting spaces around the
=
operator.INSERT INTO anytable SET Text='test--test';
The tokenizer incorrectly interpreted the value as containing a comment.
UPDATE anytable SET Project='123-456',Text='Can you explain this ?',Duration=15 WHERE ID=4711;'
A
MySqlException
was generated, as the?
in the value was interpreted by the tokenizer as a parameter sign. The error message generated was:Fatal error encountered during command execution. EXCEPTION: MySqlException - Parameter '?'' must be defined.
Bugs fixed:
MySQL.Data
was not displayed as a Reference inside Microsoft Visual Studio 2008 Professional.When a new C# project was created in Microsoft Visual Studio 2008 Professional,
MySQL.Data
was not displayed when , was selected. (Bug#44141)Column types for
SchemaProvider
andISSchemaProvider
did not match.When the source code in
SchemaProvider.cs
andISSchemaProvider.cs
were compared it was apparent that they were not using the same column types. The base provider used SQL such asSHOW CREATE TABLE
, whileISSchemaProvider
used the schema information tables. Column types used by the base class wereINT64
and the column types used byISSchemaProvider
wereUNSIGNED
. (Bug#44123)