36 lines
1.2 KiB
Plaintext
36 lines
1.2 KiB
Plaintext
CREATE TABLE t2(a INT);
|
|
SET @@AUTOCOMMIT=0;
|
|
SET SESSION GTID_NEXT='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee:1';
|
|
INSERT INTO t2 VALUES(1);
|
|
XA ROLLBACK 'xa1';
|
|
ERROR XAE04: XAER_NOTA: Unknown XID
|
|
SET @@AUTOCOMMIT=1;
|
|
SET @@AUTOCOMMIT=0;
|
|
SET SESSION GTID_NEXT='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee:2';
|
|
INSERT INTO t2 VALUES(2);
|
|
XA COMMIT 'xa1';
|
|
ERROR XAE04: XAER_NOTA: Unknown XID
|
|
SET @@AUTOCOMMIT=1;
|
|
XA START 'xa1';
|
|
XA END 'xa1';
|
|
XA PREPARE 'xa1';
|
|
SET @@AUTOCOMMIT=0;
|
|
SET SESSION GTID_NEXT='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee:3';
|
|
INSERT INTO t2 VALUES(3);
|
|
XA ROLLBACK 'xa1';
|
|
ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the NON-EXISTING state
|
|
SET @@AUTOCOMMIT=1;
|
|
SET @@AUTOCOMMIT=0;
|
|
SET SESSION GTID_NEXT='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee:4';
|
|
INSERT INTO t2 VALUES(4);
|
|
XA COMMIT 'xa1';
|
|
ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the NON-EXISTING state
|
|
SET @@AUTOCOMMIT=1;
|
|
include/assert.inc [All inserts were committed, XA statements and respective failures, were disregarded]
|
|
SET SESSION GTID_NEXT='AUTOMATIC';
|
|
XA ROLLBACK 'xa1';
|
|
include/assert.inc [All XA transactions were cleared]
|
|
DROP TABLE t2;
|
|
SET @@AUTOCOMMIT=DEFAULT_AUTOCOMMIT;
|
|
RESET MASTER;
|