1 set session transaction isolation level read committed;
2 create table innodb_bug52663 (what varchar(5), id integer, count integer, primary key
3 (what, id)) engine=innodb;
4 insert into innodb_bug52663 values ('total', 0, 0);
6 set session transaction isolation level read committed;
8 update innodb_bug52663 set count = count + 1 where what = 'total' and id = 0;
9 select * from innodb_bug52663;
12 update innodb_bug52663 set count = count + 1 where what = 'total' and id = 0;
13 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
14 select * from innodb_bug52663;
18 update innodb_bug52663 set count = count + 1 where what = 'total' and id = 0;
20 select * from innodb_bug52663;
23 select * from innodb_bug52663;
26 drop table innodb_bug52663;