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;