MySQL BUG#11766576 - 59715: UPDATE IGNORE, 1 ROW AFFECTED

--echo #

--echo # BUG #11766576 - 59715: UPDATE IGNORE, 1 ROW AFFECTED

--echo #

--disable_warnings

DROP TABLE IF EXISTS t1, t2;

--enable_warnings

CREATE TABLE t1 (id INT PRIMARY KEY);

INSERT INTO t1 VALUES (1), (2);

--enable_info

UPDATE IGNORE t1, (SELECT 1 AS duplicate_id) AS t2 SET t1.id=t2.duplicate_id;

--disable_info

--echo # Check that no rows changed.

SELECT * FROM t1;

DROP TABLE t1;

revno: 3402.1.251

committer: Raghav Kapoor <raghav.kapoor@oracle.com>

branch nick: mysql-trunk-bug-11766576

timestamp: Tue 2011-12-13 19:40:33 +0530

message:

  BUG#11766576 - 59715: UPDATE IGNORE, 1 ROW AFFECTED

  BACKGROUND:

  UPDATE IGNORE returns the wrong number of rows updated when there

  are duplicate key conflicts in the multi table update.

  FIX:

  This bug has been fixed by putting a check on updated variable

  in mysql_multi_update::do_update function so that count is not

  updated when duplicate key conflicts occur (and the corresponding

  rows are not updated).