Re: ON DUPLICATE KEY UPDATE - Always returns positive integer

[Adrian Game]

Hopefully this will get some a solution soon.

I can confirm that I have the same result in my application.

I am using Visual Studio 2013 and the connector for .Net version 6.9.9.

As you did I also confirmed that the method gives the expected results using workbench for the same data. It looks like it is specifically a connector issue.

//Code Snippet
conn = new MySqlConnection(DB_ConnectionString);
conn.Open();

//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(query, conn);

int rowsAffected = Convert.ToInt32(cmd.ExecuteNonQuery());