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 9SET @start_global_value = @@global.relay_log_recovery; 10SELECT @start_global_value; 11 12# 13# exists as global only 14# 15select @@global.relay_log_recovery; 16--error ER_INCORRECT_GLOBAL_LOCAL_VAR 17select @@session.relay_log_recovery; 18show global variables like 'relay_log_recovery'; 19show session variables like 'relay_log_recovery'; 20select * from information_schema.global_variables where variable_name='relay_log_recovery'; 21select * from information_schema.session_variables where variable_name='relay_log_recovery'; 22 23# 24# show that it's writable 25# 26set global relay_log_recovery=1; 27select @@global.relay_log_recovery; 28select * from information_schema.global_variables where variable_name='relay_log_recovery'; 29select * from information_schema.session_variables where variable_name='relay_log_recovery'; 30set global relay_log_recovery=OFF; 31select @@global.relay_log_recovery; 32select * from information_schema.global_variables where variable_name='relay_log_recovery'; 33select * from information_schema.session_variables where variable_name='relay_log_recovery'; 34--error ER_GLOBAL_VARIABLE 35set session relay_log_recovery=1; 36 37# 38# incorrect types 39# 40--error ER_WRONG_TYPE_FOR_VAR 41set global relay_log_recovery=1.1; 42--error ER_WRONG_TYPE_FOR_VAR 43set global relay_log_recovery=1e1; 44--error ER_WRONG_VALUE_FOR_VAR 45set global relay_log_recovery="foo"; 46 47SET @@global.relay_log_recovery = @start_global_value; 48SELECT @@global.relay_log_recovery; 49 50