Debian Codegraph @

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

raw
1
2 # Bug #49164 READ-COMMITTED reports "matched: 0" on compound PK
3 # a duplicate of
4 # Bug #52663 Lost update incrementing column value under READ COMMITTED
5
6 connect (con1,localhost,root,,);
7 connect (con2,localhost,root,,);
8
9 connection con1;
10 SET transaction_isolation = 'READ-COMMITTED';
11
12 CREATE TABLE bug49164 (a INT, b BIGINT, c TINYINT, PRIMARY KEY (a, b))
13 ENGINE=InnoDB;
14
15 insert into bug49164 values (1,1,1), (2,2,2), (3,3,3);
16
17 begin;
18 update bug49164 set c=7;
19 select * from bug49164;
20 rollback;
21 select * from bug49164;
22 begin;
23 update bug49164 set c=7;
24
25 connection con2;
26
27 SET transaction_isolation = 'READ-COMMITTED';
28 begin;
29 select * from bug49164;
30 commit;
31 begin;
32 --send
33 update bug49164 set c=6 where a=1 and b=1;
34
35 connection con1;
36 rollback;
37 select * from bug49164;
38 connection con2;
39 reap;
40 commit;
41 connection con1;
42 select * from bug49164;
43 connection default;
44 disconnect con1;
45 disconnect con2;
46 drop table bug49164;