Description:
MySqlParameterCollection.Add checks if a named parameter has already been added, but it throws inconsistently based on the order in which parameters are added. For example, assume that `cmd` is a MySqlCommand object.
cmd.Parameters.AddWithValue("foo", 1);
cmd.Parameters.AddWithValue("foo", 2);
^ throws MySqlException: Parameter 'foo' has already been defined.
cmd.Parameters.AddWithValue("foo", 1);
cmd.Parameters.AddWithValue("@foo", 2);
^ throws MySqlException: Parameter '@foo' has already been defined.
cmd.Parameters.AddWithValue("@foo", 1);
cmd.Parameters.AddWithValue("@foo", 2);
^ throws MySqlException: Parameter '@foo' has already been defined.
cmd.Parameters.AddWithValue("@foo", 1);
cmd.Parameters.AddWithValue("foo", 2);
^ doesn't throw
The last example should be consistent with the first three and throw a MySqlException that "Parameter 'foo' has already been defined."
How to repeat:
Run the following C# code:
using (var connection = new MySqlConnection("..."))
{
connection.Open();
using (var cmd = connection.CreateCommand())
{
cmd.Parameters.AddWithValue("@foo", 1);
cmd.Parameters.AddWithValue("foo", 2);
// expect exception to be thrown but it isn't
}
}
Description: MySqlParameterCollection.Add checks if a named parameter has already been added, but it throws inconsistently based on the order in which parameters are added. For example, assume that `cmd` is a MySqlCommand object. cmd.Parameters.AddWithValue("foo", 1); cmd.Parameters.AddWithValue("foo", 2); ^ throws MySqlException: Parameter 'foo' has already been defined. cmd.Parameters.AddWithValue("foo", 1); cmd.Parameters.AddWithValue("@foo", 2); ^ throws MySqlException: Parameter '@foo' has already been defined. cmd.Parameters.AddWithValue("@foo", 1); cmd.Parameters.AddWithValue("@foo", 2); ^ throws MySqlException: Parameter '@foo' has already been defined. cmd.Parameters.AddWithValue("@foo", 1); cmd.Parameters.AddWithValue("foo", 2); ^ doesn't throw The last example should be consistent with the first three and throw a MySqlException that "Parameter 'foo' has already been defined." How to repeat: Run the following C# code: using (var connection = new MySqlConnection("...")) { connection.Open(); using (var cmd = connection.CreateCommand()) { cmd.Parameters.AddWithValue("@foo", 1); cmd.Parameters.AddWithValue("foo", 2); // expect exception to be thrown but it isn't } }