Debian Codegraph @

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

raw
1 CREATE TABLE t(a INT PRIMARY KEY, b INT)ENGINE=InnoDB;
2 INSERT INTO t VALUES(2,2),(4,4),(8,8),(16,16),(32,32);
3 COMMIT;
4 XA START '123';
5 INSERT INTO t VALUES(1,1);
6 XA END '123';
7 XA PREPARE '123';
8 CONNECT con1,localhost,root,,;
9 XA START '456';
10 INSERT INTO t VALUES(3,47),(5,67);
11 UPDATE t SET b=2*b WHERE a BETWEEN 5 AND 8;
12 XA END '456';
13 XA PREPARE '456';
14 CONNECT con2,localhost,root,,;
15 XA START '789';
16 UPDATE t SET b=4*a WHERE a=32;
17 XA END '789';
18 XA PREPARE '789';
19 CONNECT con3,localhost,root,,;
20 # restart
21 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
22 SELECT * FROM t;
23 a b
24 1 1
25 2 2
26 3 47
27 4 4
28 5 134
29 8 16
30 16 16
31 32 128
32 COMMIT;
33 # restart
34 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
35 SELECT * FROM t;
36 a b
37 1 1
38 2 2
39 3 47
40 4 4
41 5 134
42 8 16
43 16 16
44 32 128
45 COMMIT;
46 XA RECOVER;
47 formatID gtrid_length bqual_length data
48 1 3 0 123
49 1 3 0 456
50 1 3 0 789
51 XA ROLLBACK '123';
52 XA ROLLBACK '456';
53 XA COMMIT '789';
54 SELECT * FROM t;
55 a b
56 2 2
57 4 4
58 8 8
59 16 16
60 32 128
61 DROP TABLE t;