diff options
Diffstat (limited to 'mysql-test/suite/parts/r/rpl_partition.result')
-rw-r--r-- | mysql-test/suite/parts/r/rpl_partition.result | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/mysql-test/suite/parts/r/rpl_partition.result b/mysql-test/suite/parts/r/rpl_partition.result index 2e6f0a5d1ba..9969d53a3d7 100644 --- a/mysql-test/suite/parts/r/rpl_partition.result +++ b/mysql-test/suite/parts/r/rpl_partition.result @@ -7,7 +7,7 @@ SET SESSION binlog_format = 'ROW'; select @@global.binlog_format, @@session.binlog_format; @@global.binlog_format ROW @@session.binlog_format ROW -[on slave] +connection slave; set @old_global_binlog_format= @@global.binlog_format; set @old_session_binlog_format= @@session.binlog_format; SET GLOBAL binlog_format = 'ROW'; @@ -17,7 +17,7 @@ select @@global.binlog_format, @@session.binlog_format; @@session.binlog_format ROW include/stop_slave.inc include/start_slave.inc -[on master] +connection master; CREATE TABLE t1(id MEDIUMINT NOT NULL AUTO_INCREMENT, dt TIMESTAMP, user CHAR(255), uuidf LONGBLOB, fkid MEDIUMINT, filler VARCHAR(255), @@ -122,6 +122,8 @@ CALL p3(); commit; SELECT count(*) as "Master byrange" FROM t3; Master byrange 500 +connection slave; +connection slave; show create table t3; Table t3 Create Table CREATE TABLE `t3` ( @@ -154,13 +156,14 @@ SELECT count(*) "Slave bykey" FROM t2; Slave bykey 500 SELECT count(*) "Slave byrange" FROM t3; Slave byrange 500 +connection master; set @@global.binlog_format= @old_global_binlog_format; set @@session.binlog_format= @old_session_binlog_format; DROP TABLE t1, t2, t3; DROP PROCEDURE p1; DROP PROCEDURE p2; DROP PROCEDURE p3; -[on slave] +connection slave; set @@global.binlog_format= @old_global_binlog_format; set @@session.binlog_format= @old_session_binlog_format; include/rpl_end.inc |