Debian Codegraph @

mysql-test/suite/binlog_gtid/r/binlog_gtid_unknown_xid.result

raw
1 CREATE TABLE t2(a INT);
2 SET @@AUTOCOMMIT=0;
3 SET SESSION GTID_NEXT='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee:1';
4 INSERT INTO t2 VALUES(1);
5 XA ROLLBACK 'xa1';
6 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the NON-EXISTING state
7 SET @@AUTOCOMMIT=1;
8 SET @@AUTOCOMMIT=0;
9 SET SESSION GTID_NEXT='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee:2';
10 INSERT INTO t2 VALUES(2);
11 XA COMMIT 'xa1';
12 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the NON-EXISTING state
13 SET @@AUTOCOMMIT=1;
14 XA START 'xa1';
15 XA END 'xa1';
16 XA PREPARE 'xa1';
17 SET @@AUTOCOMMIT=0;
18 SET SESSION GTID_NEXT='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee:3';
19 INSERT INTO t2 VALUES(3);
20 XA ROLLBACK 'xa1';
21 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the NON-EXISTING state
22 SET @@AUTOCOMMIT=1;
23 SET @@AUTOCOMMIT=0;
24 SET SESSION GTID_NEXT='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee:4';
25 INSERT INTO t2 VALUES(4);
26 XA COMMIT 'xa1';
27 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the NON-EXISTING state
28 SET @@AUTOCOMMIT=1;
29 include/assert.inc [All inserts were committed, XA statements and respective failures, were disregarded]
30 SET SESSION GTID_NEXT='AUTOMATIC';
31 XA ROLLBACK 'xa1';
32 include/assert.inc [All XA transactions were cleared]
33 DROP TABLE t2;
34 SET @@AUTOCOMMIT=DEFAULT_AUTOCOMMIT;
35 RESET MASTER;