diff options
author | Sergey Vojtovich <svoj@mariadb.org> | 2016-03-25 20:51:22 +0400 |
---|---|---|
committer | Sergey Vojtovich <svoj@mariadb.org> | 2016-03-31 10:11:16 +0400 |
commit | 282497dd6d1049b4fb963641504c2733752845a7 (patch) | |
tree | 7288d17c29fbbe9ac47ec51f6988fb954f59a361 /mysql-test/suite/rpl/r/rpl_stm_innodb.result | |
parent | 5052e2479e873461bebfcedbc674bbaf57d3c968 (diff) | |
download | mariadb-git-282497dd6d1049b4fb963641504c2733752845a7.tar.gz |
MDEV-6720 - enable connection log in mysqltest by default
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 |