non effective update returns deadlock error

[Seppo Jaakola]

If an UPDATE statement does not modify any rows, deadlock error is returned.
Correct behavior would be to return OK status and show rows changd value as 0.

Howto reproduce:

Start one Galera node and issue:

mysql> CREATE TABLE test.t (i int);
mysql> INSERT INTO test.t VALUES (1);
mysql> UPDATE test.t set i=2;
ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction

[Seppo Jaakola (seppo-jaakola)]

Fix was pushed in change set: http://bazaar.launchpad.net/~codership/codership-mysql/wsrep-5.5/revision/3610

[Seppo Jaakola (seppo-jaakola)]

Another related fix to do post commit cleanup for empty transactions in: http://bazaar.launchpad.net/~codership/codership-mysql/wsrep-5.5/revision/3625