diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_stm_innodb.result')
-rw-r--r-- | mysql-test/suite/rpl/r/rpl_stm_innodb.result | 32 |
1 files changed, 22 insertions, 10 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_stm_innodb.result b/mysql-test/suite/rpl/r/rpl_stm_innodb.result index 6f54b232e71..7e37277a825 100644 --- a/mysql-test/suite/rpl/r/rpl_stm_innodb.result +++ b/mysql-test/suite/rpl/r/rpl_stm_innodb.result @@ -1,5 +1,6 @@ include/master-slave.inc [connection master] +connection master; CREATE TABLE t4 ( id INT(5) unsigned NOT NULL auto_increment, name varchar(15) NOT NULL default '', @@ -15,10 +16,12 @@ SELECT * FROM t4; id name number 1 XXX 12345 2 XXY 12345 +connection slave; SELECT * FROM t4; id name number 1 XXX 12345 2 XXY 12345 +connection master; LOAD DATA INFILE '../../std_data/loaddata_pair.dat' REPLACE INTO TABLE t4 @@ -27,25 +30,32 @@ SELECT * FROM t4; id name number 4 XXX 12345 5 XXY 12345 +connection slave; SELECT * FROM t4; id name number 4 XXX 12345 5 XXY 12345 +connection master; +connection slave; +connection master; FLUSH LOGS; +connection slave; FLUSH LOGS; +connection master; DROP DATABASE IF EXISTS mysqltest1; CREATE DATABASE mysqltest1; CREATE TEMPORARY TABLE mysqltest1.tmp (f1 BIGINT); CREATE TABLE mysqltest1.t1 (f1 BIGINT) ENGINE="InnoDB"; SET AUTOCOMMIT = 0; --------- switch to slave -------- +connection slave; +connection slave; ALTER TABLE mysqltest1.t1 ENGINE = MyISAM; SHOW CREATE TABLE mysqltest1.t1; Table Create Table t1 CREATE TABLE `t1` ( `f1` bigint(20) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 --------- switch to master -------- +connection master; INSERT INTO mysqltest1.t1 SET f1= 1; DROP TEMPORARY TABLE mysqltest1.tmp; ROLLBACK; @@ -67,7 +77,8 @@ tmp2 CREATE TEMPORARY TABLE `tmp2` ( SELECT COUNT(*) FROM mysqltest1.t1; COUNT(*) 0 --------- switch to slave -------- +connection slave; +connection slave; SHOW CREATE TABLE mysqltest1.tmp; ERROR 42S02: Table 'mysqltest1.tmp' doesn't exist SHOW CREATE TABLE mysqltest1.tmp2; @@ -77,7 +88,7 @@ SELECT COUNT(*) FROM mysqltest1.t1; COUNT(*) 2 FLUSH LOGS; --------- switch to master -------- +connection master; FLUSH LOGS; DROP TEMPORARY TABLE IF EXISTS mysqltest1.tmp2; DROP DATABASE mysqltest1; @@ -100,12 +111,12 @@ b INT DEFAULT NULL INSERT INTO t1 (b) VALUES (1),(2),(3); BEGIN; INSERT INTO t1(b) VALUES (4); --------- switch to master1 -------- +connection master1; RENAME TABLE t1 TO t3, t2 TO t1;; --------- switch to master -------- +connection master; COMMIT; --------- switch to master1 -------- --------- switch to master -------- +connection master1; +connection master; SELECT * FROM t1; id b SELECT * FROM t3; @@ -114,7 +125,8 @@ id b 2 2 3 3 4 4 --------- switch to slave -------- +connection slave; +connection slave; SELECT * FROM t1; id b SELECT * FROM t3; @@ -123,7 +135,7 @@ id b 2 2 3 3 4 4 --------- switch to master -------- +connection master; DROP TABLE t1; DROP TABLE t3; End of 6.0 tests |