Debian Codegraph @

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

raw
1 connect con1,localhost,root,,;
2 connect con2,localhost,root,,;
3 connection con1;
4 SET transaction_isolation = 'READ-COMMITTED';
5 CREATE TABLE bug49164 (a INT, b BIGINT, c TINYINT, PRIMARY KEY (a, b))
6 ENGINE=InnoDB;
7 insert into bug49164 values (1,1,1), (2,2,2), (3,3,3);
8 begin;
9 update bug49164 set c=7;
10 select * from bug49164;
11 a b c
12 1 1 7
13 2 2 7
14 3 3 7
15 rollback;
16 select * from bug49164;
17 a b c
18 1 1 1
19 2 2 2
20 3 3 3
21 begin;
22 update bug49164 set c=7;
23 connection con2;
24 SET transaction_isolation = 'READ-COMMITTED';
25 begin;
26 select * from bug49164;
27 a b c
28 1 1 1
29 2 2 2
30 3 3 3
31 commit;
32 begin;
33 update bug49164 set c=6 where a=1 and b=1;
34 connection con1;
35 rollback;
36 select * from bug49164;
37 a b c
38 1 1 1
39 2 2 2
40 3 3 3
41 connection con2;
42 commit;
43 connection con1;
44 select * from bug49164;
45 a b c
46 1 1 6
47 2 2 2
48 3 3 3
49 connection default;
50 disconnect con1;
51 disconnect con2;
52 drop table bug49164;