Debian Codegraph @

mysql-test/suite/innodb/t/innodb_bug52663.test

raw
1 # Adding big test option for this test.
2 --source include/big_test.inc
3
4 set session transaction isolation level read committed;
5
6 create table innodb_bug52663 (what varchar(5), id integer, count integer, primary key
7 (what, id)) engine=innodb;
8 insert into innodb_bug52663 values ('total', 0, 0);
9 begin;
10
11 connect (addconroot, localhost, root,,);
12 connection addconroot;
13 set session transaction isolation level read committed;
14 begin;
15
16 connection default;
17 update innodb_bug52663 set count = count + 1 where what = 'total' and id = 0;
18 select * from innodb_bug52663;
19
20 connection addconroot;
21 --error ER_LOCK_WAIT_TIMEOUT
22 update innodb_bug52663 set count = count + 1 where what = 'total' and id = 0;
23 select * from innodb_bug52663;
24
25 connection default;
26 commit;
27
28 connection addconroot;
29 update innodb_bug52663 set count = count + 1 where what = 'total' and id = 0;
30 commit;
31 select * from innodb_bug52663;
32
33 connection default;
34 select * from innodb_bug52663;
35 drop table innodb_bug52663;