--let $rpl_skip_start_slave=1 --source include/master-slave.inc --source include/have_binlog_format_row.inc # Add data on source CREATE TABLE t1(a INT PRIMARY KEY); DROP TABLE t1; --let $source_pos=query_get_value('SHOW BINARY LOGS','File_size',1) --let $source_file=query_get_value('SHOW BINARY LOGS','Log_name',1) --source include/rpl_connection_slave.inc # Execute START REPLICA with MASTER_LOG_FILE and MASTER_LOG_POS param --replace_result $source_file source_file $source_pos source_pos --eval START REPLICA UNTIL MASTER_LOG_FILE='$source_file',MASTER_LOG_POS=$source_pos # Check Until_Condition value is 'Source' in the output of # SHOW REPLICA STATUS --let $replica_until_cond=query_get_value('SHOW REPLICA STATUS','Until_Condition',1) --let $assert_cond= "$replica_until_cond" = "Source" --let $assert_text= Until condition is 'source' on replica --source include/assert.inc --source include/wait_for_slave_sql_to_stop.inc # Start replication to continue --source include/start_slave.inc # # SHOW REPLICAS # --source include/rpl_connection_master.inc # first assert that the fields are in the result set with the expected # name (old and new names). Do not record in the result file, since # the output is not deterministic --let $dontcare = query_get_value(SHOW SLAVE HOSTS, Slave_UUID, 1) --let $dontcare = query_get_value(SHOW SLAVE HOSTS, Master_id, 1) # new syntax and assert that the new names of the fields are # the ones used --let $dontcare = query_get_value(SHOW REPLICAS, Replica_UUID, 1) --let $dontcare = query_get_value(SHOW REPLICAS, Source_Id, 1) --disable_result_log # emits a deprecation warning SHOW SLAVE HOSTS; --enable_result_log SHOW WARNINGS; --disable_result_log # does not emit a warning SHOW REPLICAS; --enable_result_log SHOW WARNINGS; # # SHOW REPLICA STATUS # --source include/rpl_connection_slave.inc # first assert that the fields are in the result set with the expected # name (old and new names). Do not record in the result file, since # the output is not deterministic --let $dontcare = query_get_value(SHOW SLAVE STATUS, Slave_IO_State, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_Host, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_User, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_Port, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_Log_File, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Read_Master_Log_Pos, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Relay_Master_Log_File, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Slave_IO_Running, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Slave_SQL_Running, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Exec_Master_Log_Pos, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_SSL_Allowed, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_SSL_CA_File, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_SSL_CA_Path, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_SSL_Cert, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_SSL_Cipher, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_SSL_Key, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Seconds_Behind_Master, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_SSL_Verify_Server_Cert, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_Server_Id, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_UUID, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_Info_File, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Slave_SQL_Running_State, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_Retry_Count, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_Bind, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_SSL_Crl, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_SSL_Crlpath, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_TLS_Version, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Master_public_key_path, 1) --let $dontcare = query_get_value(SHOW SLAVE STATUS, Get_master_public_key, 1) # new syntax and assert that the new names of the fields are # the ones used --let $dontcare = query_get_value(SHOW REPLICA STATUS, Replica_IO_State, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_Host, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_User, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_Port, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_Log_File, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Read_Source_Log_Pos, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Relay_Source_Log_File, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Replica_IO_Running, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Replica_SQL_Running, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Exec_Source_Log_Pos, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_SSL_Allowed, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_SSL_CA_File, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_SSL_CA_Path, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_SSL_Cert, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_SSL_Cipher, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_SSL_Key, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Seconds_Behind_Source, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_SSL_Verify_Server_Cert, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_Server_Id, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_UUID, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_Info_File, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Replica_SQL_Running_State, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_Retry_Count, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_Bind, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_SSL_Crl, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_SSL_Crlpath, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_TLS_Version, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Source_public_key_path, 1) --let $dontcare = query_get_value(SHOW REPLICA STATUS, Get_Source_public_key, 1) # Now check for the deprecation warning and record it in the result file. # We output a single deterministic field to make the test case resilient. --disable_result_log # emits a deprecation warning SHOW SLAVE STATUS; --enable_result_log SHOW WARNINGS; --disable_result_log # does not emit a deprecation warning SHOW REPLICA STATUS; --enable_result_log SHOW WARNINGS; # # RESET REPLICA # --source include/stop_slave.inc # must emit a deprecation warning RESET SLAVE; # must not emit a deprecation warning RESET REPLICA; # must emit a deprecation warning START SLAVE; --source include/wait_for_slave_to_start.inc # must emit a deprecation warning STOP SLAVE; --source include/wait_for_slave_to_stop.inc # must not emit a deprecation warning START REPLICA; --source include/wait_for_slave_to_start.inc # must not emit a deprecation warning STOP REPLICA; --source include/wait_for_slave_to_stop.inc # must emit a deprecation warning RESET SLAVE ALL; # must not emit a deprecation warning RESET REPLICA ALL; --replace_result $MASTER_MYPORT MASTER_PORT --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1',SOURCE_PORT=$MASTER_MYPORT,SOURCE_USER='root' for CHANNEL '' ### START REPLICA UNTIL SOURCE_LOG_FILE and SOURCE_LOG_POS --source include/rpl_connection_master.inc CREATE TABLE t1 (c1 INT); INSERT INTO t1 VALUES (1); --let $log_file= query_get_value(SHOW MASTER STATUS, File, 1) --let $log_pos= query_get_value(SHOW MASTER STATUS, Position, 1) --source include/rpl_connection_slave.inc # Once deprecation warnings are introduced, this statement shall # continue to not produce any warnings --replace_result $log_file LOG_FILE $log_pos LOG_POS --eval START REPLICA UNTIL SOURCE_LOG_FILE='$log_file', SOURCE_LOG_POS=$log_pos --source include/wait_for_slave_sql_to_stop.inc --source include/stop_slave.inc --let $diff_tables=master:t1,slave:t1 --source include/diff_tables.inc DROP TABLE t1; RESET REPLICA; RESET MASTER; # Once deprecation warnings are introduced, this statement shall # produce warnings --replace_result $log_file LOG_FILE $log_pos LOG_POS --eval START REPLICA UNTIL MASTER_LOG_FILE='$log_file', MASTER_LOG_POS=$log_pos --source include/wait_for_slave_sql_to_stop.inc --source include/stop_slave.inc --let $diff_tables=master:t1,slave:t1 --source include/diff_tables.inc --source include/rpl_connection_master.inc DROP TABLE t1; RESET MASTER; --source include/rpl_connection_slave.inc DROP TABLE t1; RESET REPLICA; RESET MASTER; --source include/start_slave.inc --source include/rpl_connection_master.inc --source include/rpl_end.inc