Bug #32094 Size property on string parameter throws an exception

Description:
When the Size property of a MySqlParameter is greater than the length of the string contained in the Value property you will get the following exception:

Index and length must refer to a location within the string.
Parameter name: length

This is caused by the Substring call in the MySqlString class within the connector.

string v = val.ToString();
if (length > 0)
    v = v.Substring(0, length);

In my example below, the string is only 3 long and he Size parameter is 50, so the Substring method throws the exception.

How to repeat:
MySqlConnection MyConnection = new MySqlConnection( "Database=dbname;Data Source=localhost;User Id=user;Password=password;" );
MySqlParameter NewParam = new MySqlParameter("P1", MySql.Data.MySqlClient.MySqlDbType.VarChar);
NewParam.Value = "dog";
NewParam.Size = 50;
MySqlCommand MyCommand = new MySqlCommand("UPDATE TableName SET FieldName = ?P1 WHERE ID = 999;", MyConnection);
MyCommand.Parameters.Add( NewParam );
MyConnection.Open();
MyCommand.ExecuteNonQuery();
MyConnection.Close();

Suggested fix:
This code should be fixed by only using the Substring method to truncate the string if its length is greater than Size property value.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/37112

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/37113

Fixed in 5.0.9 and 5.1.4

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/37115

Also fixed in 1.0.11

A note has been added to the 1.0.11, 5.0.9 and 5.1.4 changelogs: 

        Setting the size of a string parameter after the value could
        cause an exception.