Debian Codegraph @

mysql-test/suite/galera/r/MDEV-37229.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_2;
4 connection node_1;
5 CREATE TABLE t1 (i INT NOT NULL PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
6 SET GLOBAL wsrep_forced_binlog_format='STATEMENT';
7 START TRANSACTION;
8 INSERT INTO t1(i) VALUES(NULL);
9 Warnings:
10 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave
11 INSERT INTO t1(i) VALUES(NULL);
12 Warnings:
13 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave
14 SET GLOBAL wsrep_forced_binlog_format='ROW';
15 INSERT INTO t1(i) VALUES(NULL);
16 INSERT INTO t1(i) VALUES(NULL);
17 COMMIT;
18 SET GLOBAL wsrep_forced_binlog_format='ROW';
19 START TRANSACTION;
20 INSERT INTO t1(i) VALUES(NULL);
21 INSERT INTO t1(i) VALUES(NULL);
22 SET GLOBAL wsrep_forced_binlog_format='STATEMENT';
23 INSERT INTO t1(i) VALUES(NULL);
24 Warnings:
25 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave
26 INSERT INTO t1(i) VALUES(NULL);
27 Warnings:
28 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave
29 COMMIT;
30 SELECT * FROM t1 ORDER BY i;
31 i
32 1
33 3
34 5
35 7
36 9
37 11
38 13
39 15
40 connection node_2;
41 SELECT * FROM t1 ORDER BY i;
42 i
43 1
44 3
45 5
46 7
47 9
48 11
49 13
50 15
51 connection node_1;
52 SET GLOBAL wsrep_forced_binlog_format='NONE';
53 DROP TABLE t1;