Debian Codegraph @

mysql-test/suite/binlog/r/binlog_xa_handling.result

raw
1 CALL mtr.add_suppression("Statement is unsafe because it is being used inside a XA transaction");
2 CREATE TABLE t1(f1 int);
3 XA START'','';
4 INSERT INTO t1 VALUES(10);
5 BINLOG '
6 SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA
7 AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';
8 ERROR HY000: The system variable gtid_next cannot be set when there is an ongoing transaction.
9 XA END'';
10 XA PREPARE'';
11 XA COMMIT'';
12 SET @sav.pseudo_replica_mode= @@session.pseudo_replica_mode;
13 SELECT @@session.pseudo_replica_mode;
14 @@session.pseudo_replica_mode
15 0
16 SET @@session.pseudo_replica_mode=1;
17 Warnings:
18 Warning 1231 'pseudo_replica_mode' is already ON.
19 BINLOG '
20 SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA
21 AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';
22 SET @@gtid_next = "AUTOMATIC";
23 XA START 'xa_rollback';
24 INSERT INTO t1 VALUES(10);
25 XA END 'xa_rollback';
26 XA ROLLBACK 'xa_rollback';
27 SET @@session.pseudo_replica_mode=1;
28 BINLOG '
29 SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA
30 AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';
31 SET @@gtid_next = "AUTOMATIC";
32 XA START 'xa_disconnect';
33 INSERT INTO t1 VALUES(10);
34 XA START 'xa_commit';
35 INSERT INTO t1 VALUES(10);
36 XA END 'xa_commit';
37 XA PREPARE 'xa_commit';
38 XA COMMIT 'xa_commit';
39 SET @@session.pseudo_replica_mode= @sav.pseudo_replica_mode;
40 DROP TABLE t1;
41 RESET MASTER;
42 CREATE TABLE t1 (c1 INT);
43 XA BEGIN 'xa1';
44 INSERT INTO t1 VALUES (1);
45 XA END 'xa1';
46 XA COMMIT 'xa1' ONE PHASE;
47 [Validate that SHOW BINLOG EVENTS shows the ONE PHASE statement.]
48 DROP TABLE t1;
49 RESET MASTER;