diff options
Diffstat (limited to 'mysql-test/suite/galera/r/galera_as_master.result')
-rw-r--r-- | mysql-test/suite/galera/r/galera_as_master.result | 48 |
1 files changed, 48 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_as_master.result b/mysql-test/suite/galera/r/galera_as_master.result new file mode 100644 index 00000000000..d87a744000c --- /dev/null +++ b/mysql-test/suite/galera/r/galera_as_master.result @@ -0,0 +1,48 @@ +START SLAVE; +CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB; +INSERT INTO t1 VALUES(1); +# Disable binary logging for current session +SET SQL_LOG_BIN=OFF; +CREATE TABLE t2 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB; +INSERT INTO t2 VALUES(1); +INSERT INTO t1 VALUES(2); +CREATE TABLE test.t3 AS SELECT * from t1; +SET SQL_LOG_BIN=ON; +INSERT INTO t1 VALUES(3); +CREATE TABLE test.t4 AS SELECT * from t1; +SELECT * FROM t1; +f1 +1 +2 +3 +SELECT * FROM t2; +f1 +1 +SELECT * FROM t3; +f1 +1 +2 +SELECT * FROM t4; +f1 +1 +2 +3 +SHOW TABLES; +Tables_in_test +t1 +t4 +SELECT * FROM t1; +f1 +1 +3 +SELECT * FROM t4; +f1 +1 +2 +3 +# Cleanup +DROP TABLE t1, t4; +SET SQL_LOG_BIN=OFF; +DROP TABLE t2, t3; +STOP SLAVE; +RESET SLAVE ALL; |