DROP TABLE IF EXISTS t1;
connect  con1,localhost,root,,;
connect  con2,localhost,root,,;
connection con1;
CREATE TABLE t1 (a <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
connection con2;
XA START 'xa1';
INSERT INTO t1 (a) VALUES (1);
connection con1;
SELECT a FROM t1;
a
connection con2;
INSERT INTO t1 (a) VALUES (2);
XA END 'xa1';
connection con1;
SELECT a FROM t1;
a
connection con2;
XA PREPARE 'xa1';
connection con1;
SELECT a FROM t1;
a
connection con2;
XA RECOVER;
formatID	gtrid_length	bqual_length	data
1	3	0	xa1
XA COMMIT 'xa1';
connection con1;
SELECT a FROM t1;
a
1
2
connection con2;
XA START 'xa2';
INSERT INTO t1 (a) VALUES (3);
connection con1;
SELECT a FROM t1;
a
1
2
connection con2;
INSERT INTO t1 (a) VALUES (4);
XA END 'xa2';
connection con1;
SELECT a FROM t1;
a
1
2
connection con2;
XA COMMIT 'xa2' ONE PHASE;
connection con1;
SELECT a FROM t1;
a
1
2
3
4
connection con2;
XA START 'xa3';
INSERT INTO t1 (a) VALUES (5);
connection con1;
SELECT a FROM t1;
a
1
2
3
4
connection con2;
INSERT INTO t1 (a) VALUES (6);
XA END 'xa3';
connection con1;
SELECT a FROM t1;
a
1
2
3
4
connection con2;
XA PREPARE 'xa3';
connection con1;
SELECT a FROM t1;
a
1
2
3
4
connection con2;
XA ROLLBACK 'xa3';
connection con1;
SELECT a FROM t1;
a
1
2
3
4
DROP TABLE t1;