summaryrefslogtreecommitdiff
path: root/mysql-test/t/rpl_reset_slave.test
diff options
context:
space:
mode:
authorguilhem@mysql.com <>2003-08-04 10:59:44 +0200
committerguilhem@mysql.com <>2003-08-04 10:59:44 +0200
commitbb12d905cb75a813bfed1bc05c82c02e91762b59 (patch)
tree93768e5ca8014b5fc59dd1bbcddff0cd04b1b199 /mysql-test/t/rpl_reset_slave.test
parent41865cf3a670ffee10d0cf263c33e12bd7b8c2da (diff)
downloadmariadb-git-bb12d905cb75a813bfed1bc05c82c02e91762b59.tar.gz
2 bugfixes:
- Bug #985: "Between RESET SLAVE and START SLAVE, SHOW SLAVE STATUS is wrong." Now RESET SLAVE puts correct info in mi->host etc. A new test rpl_reset_slave for that. - Bug #986: "CHANGE MASTER & START SLAVE do not reset error columns in SHOW SLAVE STATUS". Now these reset the errors.
Diffstat (limited to 'mysql-test/t/rpl_reset_slave.test')
-rw-r--r--mysql-test/t/rpl_reset_slave.test26
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/t/rpl_reset_slave.test b/mysql-test/t/rpl_reset_slave.test
new file mode 100644
index 00000000000..9c58ac0c787
--- /dev/null
+++ b/mysql-test/t/rpl_reset_slave.test
@@ -0,0 +1,26 @@
+# See SHOW SLAVE STATUS displays well after RESET SLAVE (it should display the
+# --master-* options from mysqld, as this is what is going to be used next time
+# slave threads will be started). In bug 985, it displayed old values (of before
+# RESET SLAVE).
+
+source include/master-slave.inc;
+connection master;
+save_master_pos;
+connection slave;
+sync_with_master;
+--replace_result $MASTER_MYPORT MASTER_PORT
+show slave status;
+
+stop slave;
+change master to master_user='test';
+--replace_result $MASTER_MYPORT MASTER_PORT
+show slave status;
+
+reset slave;
+--replace_result $MASTER_MYPORT MASTER_PORT
+show slave status;
+
+start slave;
+sync_with_master;
+--replace_result $MASTER_MYPORT MASTER_PORT
+show slave status;