summaryrefslogtreecommitdiff
path: root/mysql-test/suite/rpl/r/rpl_row_log_innodb.result
diff options
context:
space:
mode:
authorSergey Vojtovich <svoj@mariadb.org>2016-03-25 20:51:22 +0400
committerSergey Vojtovich <svoj@mariadb.org>2016-03-31 10:11:16 +0400
commit282497dd6d1049b4fb963641504c2733752845a7 (patch)
tree7288d17c29fbbe9ac47ec51f6988fb954f59a361 /mysql-test/suite/rpl/r/rpl_row_log_innodb.result
parent5052e2479e873461bebfcedbc674bbaf57d3c968 (diff)
downloadmariadb-git-282497dd6d1049b4fb963641504c2733752845a7.tar.gz
MDEV-6720 - enable connection log in mysqltest by default
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_row_log_innodb.result')
-rw-r--r--mysql-test/suite/rpl/r/rpl_row_log_innodb.result11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_row_log_innodb.result b/mysql-test/suite/rpl/r/rpl_row_log_innodb.result
index 3b9733a18e8..c7598f072d9 100644
--- a/mysql-test/suite/rpl/r/rpl_row_log_innodb.result
+++ b/mysql-test/suite/rpl/r/rpl_row_log_innodb.result
@@ -1,13 +1,16 @@
include/master-slave.inc
[connection master]
+connection slave;
include/stop_slave.inc
include/wait_for_slave_to_stop.inc
reset master;
reset slave;
start slave;
include/wait_for_slave_to_start.inc
+connection slave;
set @save_slave_ddl_exec_mode=@@global.slave_ddl_exec_mode;
set @@global.slave_ddl_exec_mode=STRICT;
+connection master;
create table t1(n int not null auto_increment primary key)ENGINE=InnoDB;
insert into t1 values (NULL);
drop table t1;
@@ -49,6 +52,7 @@ master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
master-bin.000001 # Xid # # COMMIT /* XID */
flush logs;
create table t3 (a int)ENGINE=InnoDB;
+connection master;
select * from t1 order by 1 asc;
word
Aarhus
@@ -120,6 +124,7 @@ Aberdeen
Abernathy
aberrant
aberration
+connection slave;
select * from t1 order by 1 asc;
word
Aarhus
@@ -194,6 +199,7 @@ aberration
flush logs;
include/stop_slave.inc
include/start_slave.inc
+connection master;
create table t2 (n int)ENGINE=InnoDB;
insert into t2 values (1);
include/show_binlog_events.inc
@@ -228,6 +234,7 @@ show binary logs;
Log_name File_size
master-bin.000001 #
master-bin.000002 #
+connection slave;
show binary logs;
Log_name File_size
slave-bin.000001 #
@@ -263,10 +270,12 @@ slave-bin.000002 # Xid # # COMMIT /* XID */
include/check_slave_is_running.inc
show binlog events in 'slave-bin.000005' from 4;
ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log
+connection master;
DROP TABLE t1;
DROP TABLE t2;
DROP TABLE t3;
include/rpl_reset.inc
+connection master;
create table t1(a int auto_increment primary key, b int);
insert into t1 values (NULL, 1);
set insert_id=5;
@@ -289,5 +298,7 @@ a b
5 1
6 1
drop table t1;
+connection slave;
set @@global.slave_ddl_exec_mode=@save_slave_ddl_exec_mode;
+connection master;
include/rpl_end.inc