Debian Codegraph @

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

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