Debian Codegraph @

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

raw
1 call mtr.add_suppression("Found 2 prepared XA transactions");
2 FLUSH TABLES;
3 DROP TABLE IF EXISTS t1;
4 connect con1,localhost,root,,;
5 connect con2,localhost,root,,;
6 connection con1;
7 CREATE TABLE t1 (a <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
8 XA START 'xa1';
9 INSERT INTO t1 (a) VALUES (1),(2);
10 XA END 'xa1';
11 XA PREPARE 'xa1';
12 connection con2;
13 XA START 'xa2';
14 INSERT INTO t1 (a) VALUES (3);
15 INSERT INTO t1 (a) VALUES (4);
16 XA END 'xa2';
17 XA PREPARE 'xa2';
18 connection default;
19 XA RECOVER;
20 formatID gtrid_length bqual_length data
21 1 3 0 xa1
22 1 3 0 xa2
23 XA ROLLBACK 'xa1';
24 XA COMMIT 'xa2';
25 SELECT a FROM t1;
26 a
27 3
28 4
29 DROP TABLE t1;