Debian Codegraph @

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

raw
1 CREATE TABLE log (
2 c1 INT AUTO_INCREMENT PRIMARY KEY,
3 c2 TEXT,
4 c3 INT NOT NULL DEFAULT 0);
5 RESET MASTER;
6 # 1 - Empty transaction
7 SET GTID_NEXT='SERVER_UUID:1';
8 BEGIN;
9 COMMIT;
10 SET GTID_NEXT=AUTOMATIC;
11 # 2 and 3 - XA SBR + XA COMMIT
12 XA START 'a';
13 INSERT INTO log (c2) VALUES ('XA COMMIT');
14 XA END 'a';
15 XA PREPARE 'a';
16 XA COMMIT 'a';
17 # 4 and 5 - XA SBR + XA ROLLBACK
18 XA START 'b';
19 INSERT INTO log (c2) VALUES ('XA ROLLBACK');
20 XA END 'b';
21 XA PREPARE 'b';
22 XA ROLLBACK 'b';
23 # 6 - Atomic DDL
24 CREATE TABLE t1 (c1 INT);
25 # 7 - non-atomic DDL
26 CREATE TABLE t2 (c1 INT);
27 # 8 - SBR only DML transaction
28 BEGIN;
29 INSERT INTO log (c2) VALUES ('SBR only DML transaction');
30 COMMIT;
31 # 9 - SBR and RBR DML transaction
32 BEGIN;
33 INSERT INTO log (c2) VALUES ('SBR and RBR DML transaction');
34 INSERT INTO log (c2, c3) VALUES ('SBR and RBR DML transaction', RAND()*100);
35 COMMIT;
36 # 10 - RBR only DML transaction
37 BEGIN;
38 INSERT INTO log (c2, c3) VALUES ('RBR only DML transaction', RAND()*100);
39 COMMIT;
40 # 11 - RBR only DML transaction with SAVEPOINT
41 BEGIN;
42 INSERT INTO log (c2, c3) VALUES ('RBR only DML transaction with SAVEPOINT', RAND()*100);
43 SAVEPOINT `a`;
44 INSERT INTO log (c2, c3) VALUES ('RBR only DML transaction with SAVEPOINT', RAND()*100);
45 SAVEPOINT `b`;
46 INSERT INTO log (c2, c3) VALUES ('RBR only DML transaction with SAVEPOINT', RAND()*100);
47 COMMIT;
48 # 12 - RBR only DML with rows query info
49 SET @@SESSION.binlog_rows_query_log_events = ON;
50 BEGIN;
51 INSERT INTO log (c2, c3) VALUES ('DML with rows query info', RAND()*100);
52 COMMIT;
53 SET @@SESSION.binlog_rows_query_log_events = OFF;
54 include/include/assert_rbr_only_flags.inc [no,yes,no,yes,no,no,no,no,no,yes,yes,yes]
55 DROP TABLE t1, t2, log;