1--source include/not_embedded.inc 2--source include/have_log_bin.inc 3 4--echo # 5--echo # CHANGE MASTER TO doesn't work with prepared statements 6--echo # 7 8CHANGE MASTER TO MASTER_HOST='host1', MASTER_USER='user1'; 9 10let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1); 11let $master_user= query_get_value(SHOW SLAVE STATUS, Master_User, 1); 12 13--echo # Master_Host : $master_host 14--echo # Master_User : $master_user 15 16SET @s := "CHANGE MASTER TO MASTER_HOST='host2'"; 17PREPARE stmt FROM @s; 18EXECUTE stmt; 19DEALLOCATE PREPARE stmt; 20 21let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1); 22let $master_user= query_get_value(SHOW SLAVE STATUS, Master_User, 1); 23 24--echo # Master_Host : $master_host 25--echo # Master_User : $master_user 26 27SET @s := "CHANGE MASTER TO MASTER_USER='user2'"; 28PREPARE stmt FROM @s; 29EXECUTE stmt; 30# Multiple executions should not hurt. 31EXECUTE stmt; 32EXECUTE stmt; 33DEALLOCATE PREPARE stmt; 34 35let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1); 36let $master_user= query_get_value(SHOW SLAVE STATUS, Master_User, 1); 37 38--echo # Master_Host : $master_host 39--echo # Master_User : $master_user 40 41 42# Reset 43CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_USER='root'; 44 45--echo # End of test 46