1set session transaction isolation level read committed;
2create table innodb_bug52663 (what varchar(5), id integer, count integer, primary key
3(what, id)) engine=innodb;
4insert into innodb_bug52663 values ('total', 0, 0);
5begin;
6connect  addconroot, localhost, root,,;
7connection addconroot;
8set session transaction isolation level read committed;
9begin;
10connection default;
11update innodb_bug52663 set count = count + 1 where what = 'total' and id = 0;
12select * from innodb_bug52663;
13what	id	count
14total	0	1
15connection addconroot;
16update innodb_bug52663 set count = count + 1 where what = 'total' and id = 0;
17ERROR HY000: Lock wait timeout exceeded; try restarting transaction
18select * from innodb_bug52663;
19what	id	count
20total	0	0
21connection default;
22commit;
23connection addconroot;
24update innodb_bug52663 set count = count + 1 where what = 'total' and id = 0;
25commit;
26select * from innodb_bug52663;
27what	id	count
28total	0	2
29connection default;
30select * from innodb_bug52663;
31what	id	count
32total	0	2
33drop table innodb_bug52663;
34