diff options
Diffstat (limited to 'mysql-test/suite/galera/r/galera_as_slave.result')
-rw-r--r-- | mysql-test/suite/galera/r/galera_as_slave.result | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_as_slave.result b/mysql-test/suite/galera/r/galera_as_slave.result new file mode 100644 index 00000000..1035fe1e --- /dev/null +++ b/mysql-test/suite/galera/r/galera_as_slave.result @@ -0,0 +1,32 @@ +connection node_2; +connection node_1; +connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3; +connection node_2; +START SLAVE; +connection node_3; +CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB; +INSERT INTO t1 VALUES(1); +connection node_2; +INSERT INTO t1 VALUES (2); +connection node_1; +SELECT COUNT(*) = 2 FROM t1; +COUNT(*) = 2 +1 +INSERT INTO t1 VALUES (3); +connection node_2; +SELECT COUNT(*) = 3 FROM t1; +COUNT(*) = 3 +1 +connection node_3; +SET @@session.binlog_alter_two_phase = 1; +ALTER TABLE t1 ADD COLUMN f2 INT; +INSERT INTO t1 VALUES (4,1); +connection node_1; +connection node_2; +connection node_3; +DROP TABLE t1; +connection node_2; +STOP SLAVE; +RESET SLAVE ALL; +connection node_3; +RESET MASTER; |