EVOLUTION-MANAGER

Edit File: sql_log_bin.result

# On node_1 connection node_1; USE test; CREATE TABLE t1(c1 INT PRIMARY KEY) ENGINE=INNODB; INSERT INTO t1 VALUES (1); # Disable binary logging for current session SET SQL_LOG_BIN=OFF; INSERT INTO t1 VALUES (2); FLUSH BINARY LOGS; CREATE TABLE t2(c1 INT PRIMARY KEY) ENGINE=INNODB; INSERT INTO t2 VALUES (1); CREATE TABLE test.t3 AS SELECT * from t1; # Enable binary logging for current session SET SQL_LOG_BIN=ON; INSERT INTO t2 VALUES (2); CREATE TABLE t4 AS SELECT * from t2; SELECT * FROM t1; c1 1 2 SELECT * FROM t2; c1 1 2 SELECT * FROM t3; c1 1 2 SELECT * FROM t4; c1 1 2 # On node_2 connection node_2; USE test; SELECT * FROM t1; c1 1 2 SELECT * FROM t2; c1 1 2 SELECT * FROM t3; c1 1 2 SELECT * FROM t4; c1 1 2 DROP TABLE t1, t2, t3, t4; disconnect node_2; disconnect node_1; # End of test