Debian Codegraph @

mysql-test/suite/galera/t/galera_sbr.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_innodb.inc
8 --source include/galera_cluster.inc
9
10 --connection node_1
11 #SET GLOBAL binlog_format = 'STATEMENT';
12 SET SESSION binlog_format = 'STATEMENT';
13
14 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
15 INSERT INTO t1 VALUES (1);
16
17 SET SESSION binlog_format = 'MIXED';
18
19 INSERT INTO t1 VALUES (2);
20
21 --connection node_2
22 SELECT COUNT(*) = 2 FROM t1;
23
24 DROP TABLE t1;
25
26 --connection node_1
27 SET GLOBAL binlog_format = 'ROW';