Description:
mysql Information: 7 : 1: Statement prepared: sql='select ?', statement id=1
mysql Information: 8 : 1: Statement executed: statement id = 385875968
How to repeat:
enable verbose trace info and check the output.
http://dev.mysql.com/doc/connector-net/en/connector-net-programming-tracing-mysql.html
e.g.
string connstring = "server=192.168.1.4;uid=root;database=test;Charset=utf8;IgnorePrepare=false;logging=True";
try
{
MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection(connstring);
conn.Open();
System.Console.WriteLine("connected to: " + conn.ServerVersion);
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = conn;
string longq = "select @a1";
cmd.CommandText = longq;
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@a1",1);
cmd.Prepare();
MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Console.WriteLine(dr[0]);
}
dr.Close();
conn.Close();
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
System.Console.WriteLine("errno: " + ex.Number + " error: " + ex.Message);
}
Suggested fix:
I guess the bug is in function ExecuteStatement(MySqlPacket packetToExecute) in TracingDriver.cs.