Edit File: rpl_semi_sync_master_wait_no_slave_basic.test
# # exists as a global only # # 2010-01-21 OBN - Added # # source include/not_embedded.inc; source include/have_semisync_plugin.inc; # The following is to prevent a mis-match on windows that has the name of of the lib ending with 'dll' --replace_regex /\.dll/.so/ eval INSTALL PLUGIN rpl_semi_sync_master SONAME '$SEMISYNC_MASTER_PLUGIN'; select @@global.rpl_semi_sync_master_wait_no_slave; SET @start_global_value = @@global.rpl_semi_sync_master_wait_no_slave; select @@global.rpl_semi_sync_master_wait_no_slave in (0,1); --error ER_INCORRECT_GLOBAL_LOCAL_VAR select @@session.rpl_semi_sync_master_wait_no_slave; show global variables like 'rpl_semi_sync_master_wait_no_slave'; show session variables like 'rpl_semi_sync_master_wait_no_slave'; select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_wait_no_slave'; select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_wait_no_slave'; # # show that it's writable # set global rpl_semi_sync_master_wait_no_slave=0; --error ER_GLOBAL_VARIABLE set session rpl_semi_sync_master_wait_no_slave=0; select @@global.rpl_semi_sync_master_wait_no_slave; --error ER_INCORRECT_GLOBAL_LOCAL_VAR select @@session.rpl_semi_sync_master_wait_no_slave; show global variables like 'rpl_semi_sync_master_wait_no_slave'; show session variables like 'rpl_semi_sync_master_wait_no_slave'; select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_wait_no_slave'; select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_wait_no_slave'; set global rpl_semi_sync_master_wait_no_slave=1; --error ER_GLOBAL_VARIABLE set session rpl_semi_sync_master_wait_no_slave=1; select @@global.rpl_semi_sync_master_wait_no_slave; --error ER_INCORRECT_GLOBAL_LOCAL_VAR select @@session.rpl_semi_sync_master_wait_no_slave; show global variables like 'rpl_semi_sync_master_wait_no_slave'; show session variables like 'rpl_semi_sync_master_wait_no_slave'; select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_wait_no_slave'; select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_wait_no_slave'; # # incorrect types # --error ER_WRONG_TYPE_FOR_VAR set global rpl_semi_sync_master_wait_no_slave=1.1; --error ER_WRONG_TYPE_FOR_VAR set global rpl_semi_sync_master_wait_no_slave=1e1; --error ER_WRONG_VALUE_FOR_VAR set global rpl_semi_sync_master_wait_no_slave="some text"; # # Cleanup # SET @@global.rpl_semi_sync_master_wait_no_slave = @start_global_value; select @@global.rpl_semi_sync_master_wait_no_slave; UNINSTALL PLUGIN rpl_semi_sync_master;
Back to File Manager