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 XA START '456';
9 INSERT INTO t VALUES(3,47),(5,67);
10 UPDATE t SET b=2*b WHERE a BETWEEN 5 AND 8;
11 XA END '456';
12 XA PREPARE '456';
13 XA START '789';
14 UPDATE t SET b=4*a WHERE a=32;
15 XA END '789';
16 XA PREPARE '789';
17 call mtr.add_suppression("Found 3 prepared XA transactions");
18 # Kill and restart
19 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
20 SELECT * FROM t;
21 a b
22 1 1
23 2 2
24 3 47
25 4 4
26 5 134
27 8 16
28 16 16
29 32 128
30 COMMIT;
31 # restart
32 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
33 SELECT * FROM t;
34 a b
35 1 1
36 2 2
37 3 47
38 4 4
39 5 134
40 8 16
41 16 16
42 32 128
43 COMMIT;
44 XA RECOVER;
45 formatID gtrid_length bqual_length data
46 1 3 0 123
47 1 3 0 456
48 1 3 0 789
49 XA ROLLBACK '123';
50 XA ROLLBACK '456';
51 XA COMMIT '789';
52 SELECT * FROM t;
53 a b
54 2 2
55 4 4
56 8 8
57 16 16
58 32 128
59 DROP TABLE t;