Bug #33370 wrong update row count
Submitted: 19 Dec 2007 16:28 Modified: 25 Dec 2007 18:17
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:* OS:Any
Assigned to: CPU Architecture:Any
Tags: qc

[19 Dec 2007 16:28] Peter Laursen
Description:
this one http://bugs.mysql.com/1873
got closed and I did not get a reply to this: 

mysql> insert into t1 values(1,2),(2,3),(3,4) on duplicate key update
num=values(num);
Query OK, 6 rows affected (0.03 sec)

Why 6 rows??

How to repeat:
see above
[19 Dec 2007 19:46] Susanne Ebrecht
I added answer in bug #1873
[19 Dec 2007 19:47] Susanne Ebrecht
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.
[20 Dec 2007 9:29] Peter Laursen
I totally disagree!

3 rows are updated, the server returns the message that 6 rows were updated!

That is a bug with that message!
[25 Dec 2007 18:17] Valeriy Kravchuk
This is not a bug but intended and explicitely documented behaviour. Read http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html.

If you want to change this behaviour it will be a feature request formally.