Debian Codegraph @

mysql-test/suite/galera/t/galera_sbr_binlog.test

raw
1 #
2 # Test behavior if the user attempts to use statement-based replication
3 #
4 # SBR is not currently supported but we expect that no crashes or binlog-related assertions will be triggered.
5 #
6
7 --source include/have_log_bin.inc
8 --source include/have_innodb.inc
9 --source include/galera_cluster.inc
10
11 --connection node_1
12 #SET GLOBAL binlog_format = 'STATEMENT';
13 SET SESSION binlog_format = 'STATEMENT';
14
15 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
16 INSERT INTO t1 VALUES (1);
17
18 SET SESSION binlog_format = 'MIXED';
19
20 INSERT INTO t1 VALUES (2);
21
22 --connection node_2
23 SELECT COUNT(*) = 2 FROM t1;
24
25 DROP TABLE t1;
26
27 --connection node_1
28 SET GLOBAL binlog_format = 'ROW';