diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_slave_grp_exec.result')
| -rw-r--r-- | mysql-test/suite/rpl/r/rpl_slave_grp_exec.result | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_slave_grp_exec.result b/mysql-test/suite/rpl/r/rpl_slave_grp_exec.result index d3cfbb6fa91..9a34844489f 100644 --- a/mysql-test/suite/rpl/r/rpl_slave_grp_exec.result +++ b/mysql-test/suite/rpl/r/rpl_slave_grp_exec.result @@ -2,6 +2,7 @@ include/master-slave.inc [connection master] *** Preparing data *** +connection master; CREATE TABLE t1 (a INT NOT NULL, b VARCHAR(10)) ENGINE=MyISAM; CREATE TABLE t2 LIKE t1; CREATE TABLE t3 LIKE t1; @@ -15,10 +16,13 @@ UPDATE t3 SET b='ZZ' WHERE a=NEW.a; END| *** Test non-transactional group w/o PK *** +connection master; INSERT INTO t3 VALUES(1, 'AA'); INSERT INTO t2 VALUES(1, 'AA'); INSERT INTO t1 VALUES(1, 'AA'); +connection slave; RENAME TABLE t3 TO t3_bak; +connection master; UPDATE t1 SET b = 'XX' WHERE a = 1; SELECT * FROM t1 ORDER BY a; a b @@ -29,6 +33,7 @@ a b SELECT * FROM t3 ORDER BY a; a b 1 ZZ +connection slave; call mtr.add_suppression("Slave SQL.*Table .test.t3. doesn.t exist.* error.* 1146"); include/wait_for_slave_sql_error.inc [errno=1146] SHOW TABLES LIKE 't%'; @@ -45,20 +50,27 @@ a b include/stop_slave_io.inc RENAME TABLE t3_bak TO t3; include/start_slave.inc +connection master; TRUNCATE t1; TRUNCATE t2; TRUNCATE t3; +connection slave; *** Test non-transactional group w/ PK *** +connection master; ALTER TABLE t1 ADD PRIMARY KEY (a); ALTER TABLE t2 ADD PRIMARY KEY (a); ALTER TABLE t3 ADD PRIMARY KEY (a); +connection slave; RENAME TABLE t3 TO t3_bak; +connection master; INSERT INTO t3 VALUES(2, 'B'); INSERT INTO t2 VALUES(2, 'B'); INSERT INTO t1 VALUES(2, 'B'); UPDATE t1 SET b = 'X' WHERE a = 2; +connection slave; include/wait_for_slave_sql_error.inc [errno=1146] +connection master; SELECT * FROM t1 ORDER BY a; a b 2 X @@ -68,6 +80,7 @@ a b SELECT * FROM t3 ORDER BY a; a b 2 ZZ +connection slave; SHOW TABLES LIKE 't%'; Tables_in_test (t%) t1 @@ -80,21 +93,28 @@ a b include/stop_slave_io.inc RENAME TABLE t3_bak TO t3; include/start_slave.inc +connection master; TRUNCATE t1; TRUNCATE t2; TRUNCATE t3; +connection slave; *** Test transactional group w/ PK *** +connection master; ALTER TABLE t1 ENGINE=InnoDB; ALTER TABLE t2 ENGINE=InnoDB; ALTER TABLE t3 ENGINE=InnoDB; +connection slave; RENAME TABLE t3 TO t3_bak; +connection master; BEGIN; INSERT INTO t1 VALUES (3, 'C'), (4, 'D'); INSERT INTO t2 VALUES (3, 'C'), (4, 'D'); INSERT INTO t3 VALUES (3, 'C'), (4, 'D'); COMMIT; +connection slave; include/wait_for_slave_sql_error.inc [errno=1146] +connection master; SELECT * FROM t1 ORDER BY a; a b 3 C @@ -107,6 +127,7 @@ SELECT * FROM t3 ORDER BY a; a b 3 C 4 D +connection slave; SHOW TABLES LIKE 't%'; Tables_in_test (t%) t1 @@ -120,5 +141,7 @@ include/stop_slave_io.inc RENAME TABLE t3_bak TO t3; include/start_slave.inc *** Clean up *** +connection master; DROP TABLE t1,t2,t3; +connection slave; include/rpl_end.inc |