Debian Codegraph @

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

raw
1 #
2 # Test SET SESSION sql_log_bin = 0 . We expect that updates gets repliated to
3 # other nodes while they do not show up in the binary log files.
4 # (see galera.galera_as_master)
5 #
6
7 --source include/galera_cluster.inc
8 --source include/have_innodb.inc
9
10 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
11
12 SET SESSION sql_log_bin = 0;
13
14 INSERT INTO t1 VALUES (1);
15
16 SET SESSION sql_log_bin = 1;
17
18 INSERT INTO t1 VALUES (2);
19
20 --connection node_2
21 SELECT COUNT(*) = 2 FROM t1;
22 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 1;
23
24 --connection node_1
25 DROP TABLE t1;