Debian Codegraph @

mysql-test/suite/galera/r/sql_log_bin.result

raw
1 connection node_2;
2 connection node_1;
3
4 # On node_1
5 connection node_1;
6 USE test;
7 CREATE TABLE t1(c1 INT PRIMARY KEY) ENGINE=INNODB;
8 INSERT INTO t1 VALUES (1);
9 # Disable binary logging for current session
10 SET SQL_LOG_BIN=OFF;
11 INSERT INTO t1 VALUES (2);
12 FLUSH BINARY LOGS;
13 CREATE TABLE t2(c1 INT PRIMARY KEY) ENGINE=INNODB;
14 INSERT INTO t2 VALUES (1);
15 CREATE TABLE test.t3 AS SELECT * from t1;
16 # Enable binary logging for current session
17 SET SQL_LOG_BIN=ON;
18 INSERT INTO t2 VALUES (2);
19 CREATE TABLE t4 AS SELECT * from t2;
20 SELECT * FROM t1;
21 c1
22 1
23 2
24 SELECT * FROM t2;
25 c1
26 1
27 2
28 SELECT * FROM t3;
29 c1
30 1
31 2
32 SELECT * FROM t4;
33 c1
34 1
35 2
36
37 # On node_2
38 connection node_2;
39 USE test;
40 SELECT * FROM t1;
41 c1
42 1
43 2
44 SELECT * FROM t2;
45 c1
46 1
47 2
48 SELECT * FROM t3;
49 c1
50 1
51 2
52 SELECT * FROM t4;
53 c1
54 1
55 2
56 DROP TABLE t1, t2, t3, t4;
57 disconnect node_2;
58 disconnect node_1;
59 # End of test