Debian Codegraph @

mysql-test/suite/storage_engine/trx/xa.result

raw
1 DROP TABLE IF EXISTS t1;
2 connect con1,localhost,root,,;
3 connect con2,localhost,root,,;
4 connection con1;
5 CREATE TABLE t1 (a <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
6 connection con2;
7 XA START 'xa1';
8 INSERT INTO t1 (a) VALUES (1);
9 connection con1;
10 SELECT a FROM t1;
11 a
12 connection con2;
13 INSERT INTO t1 (a) VALUES (2);
14 XA END 'xa1';
15 connection con1;
16 SELECT a FROM t1;
17 a
18 connection con2;
19 XA PREPARE 'xa1';
20 connection con1;
21 SELECT a FROM t1;
22 a
23 connection con2;
24 XA RECOVER;
25 formatID gtrid_length bqual_length data
26 1 3 0 xa1
27 XA COMMIT 'xa1';
28 connection con1;
29 SELECT a FROM t1;
30 a
31 1
32 2
33 connection con2;
34 XA START 'xa2';
35 INSERT INTO t1 (a) VALUES (3);
36 connection con1;
37 SELECT a FROM t1;
38 a
39 1
40 2
41 connection con2;
42 INSERT INTO t1 (a) VALUES (4);
43 XA END 'xa2';
44 connection con1;
45 SELECT a FROM t1;
46 a
47 1
48 2
49 connection con2;
50 XA COMMIT 'xa2' ONE PHASE;
51 connection con1;
52 SELECT a FROM t1;
53 a
54 1
55 2
56 3
57 4
58 connection con2;
59 XA START 'xa3';
60 INSERT INTO t1 (a) VALUES (5);
61 connection con1;
62 SELECT a FROM t1;
63 a
64 1
65 2
66 3
67 4
68 connection con2;
69 INSERT INTO t1 (a) VALUES (6);
70 XA END 'xa3';
71 connection con1;
72 SELECT a FROM t1;
73 a
74 1
75 2
76 3
77 4
78 connection con2;
79 XA PREPARE 'xa3';
80 connection con1;
81 SELECT a FROM t1;
82 a
83 1
84 2
85 3
86 4
87 connection con2;
88 XA ROLLBACK 'xa3';
89 connection con1;
90 SELECT a FROM t1;
91 a
92 1
93 2
94 3
95 4
96 DROP TABLE t1;