1 2 3# 4# 2010-01-10 - Added check for I_S values aver variable value change 5# 6 7--source include/not_embedded.inc 8 9# 10# exists as global only 11# 12select @@global.relay_log_recovery; 13--error ER_INCORRECT_GLOBAL_LOCAL_VAR 14select @@session.relay_log_recovery; 15show global variables like 'relay_log_recovery'; 16show session variables like 'relay_log_recovery'; 17select * from information_schema.global_variables where variable_name='relay_log_recovery'; 18select * from information_schema.session_variables where variable_name='relay_log_recovery'; 19 20# 21# show that it's read-only 22# 23--error ER_INCORRECT_GLOBAL_LOCAL_VAR 24set global relay_log_recovery=1; 25select @@global.relay_log_recovery; 26select * from information_schema.global_variables where variable_name='relay_log_recovery'; 27select * from information_schema.session_variables where variable_name='relay_log_recovery'; 28 29 30