summaryrefslogtreecommitdiff
path: root/mysql-test/t/ps_change_master.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/ps_change_master.test')
-rw-r--r--mysql-test/t/ps_change_master.test45
1 files changed, 0 insertions, 45 deletions
diff --git a/mysql-test/t/ps_change_master.test b/mysql-test/t/ps_change_master.test
deleted file mode 100644
index d756b8cd4fb..00000000000
--- a/mysql-test/t/ps_change_master.test
+++ /dev/null
@@ -1,45 +0,0 @@
---source include/not_embedded.inc
---source include/have_log_bin.inc
-
---echo #
---echo # CHANGE MASTER TO doesn't work with prepared statements
---echo #
-
-CHANGE MASTER TO MASTER_HOST='host1', MASTER_USER='user1';
-
-let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1);
-let $master_user= query_get_value(SHOW SLAVE STATUS, Master_User, 1);
-
---echo # Master_Host : $master_host
---echo # Master_User : $master_user
-
-SET @s := "CHANGE MASTER TO MASTER_HOST='host2'";
-PREPARE stmt FROM @s;
-EXECUTE stmt;
-DEALLOCATE PREPARE stmt;
-
-let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1);
-let $master_user= query_get_value(SHOW SLAVE STATUS, Master_User, 1);
-
---echo # Master_Host : $master_host
---echo # Master_User : $master_user
-
-SET @s := "CHANGE MASTER TO MASTER_USER='user2'";
-PREPARE stmt FROM @s;
-EXECUTE stmt;
-# Multiple executions should not hurt.
-EXECUTE stmt;
-EXECUTE stmt;
-DEALLOCATE PREPARE stmt;
-
-let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1);
-let $master_user= query_get_value(SHOW SLAVE STATUS, Master_User, 1);
-
---echo # Master_Host : $master_host
---echo # Master_User : $master_user
-
-
-# Reset
-CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_USER='root';
-
---echo # End of test