Debian Codegraph @

mysql-test/suite/innodb/r/innodb_bug52663.result

raw
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);
5 begin;
6 set session transaction isolation level read committed;
7 begin;
8 update innodb_bug52663 set count = count + 1 where what = 'total' and id = 0;
9 select * from innodb_bug52663;
10 what id count
11 total 0 1
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;
15 what id count
16 total 0 0
17 commit;
18 update innodb_bug52663 set count = count + 1 where what = 'total' and id = 0;
19 commit;
20 select * from innodb_bug52663;
21 what id count
22 total 0 2
23 select * from innodb_bug52663;
24 what id count
25 total 0 2
26 drop table innodb_bug52663;