SET @start_value = @@global.general_log_file; SELECT length(@start_value) > 0; length(@start_value) > 0 1 '#---------------------FN_DYNVARS_004_01-------------------------#' SET @@global.general_log_file = DEFAULT; SELECT length(@@global.general_log_file) > 0; length(@@global.general_log_file) > 0 1 '#--------------------FN_DYNVARS_004_02------------------------#' SET @@global.general_log_file = mytest.log; ERROR 42000: Incorrect argument type to variable 'general_log_file' SET @@global.general_log_file = 12; ERROR 42000: Incorrect argument type to variable 'general_log_file' SET @@global.general_log_file = 'my.cnf'; ERROR 42000: Variable 'general_log_file' can't be set to the value of 'my.cnf' SET @@global.general_log_file = '/tmp/my.cnf'; ERROR 42000: Variable 'general_log_file' can't be set to the value of '/tmp/my.cnf' SET @@global.general_log_file = '.my.cnf'; ERROR 42000: Variable 'general_log_file' can't be set to the value of '.my.cnf' SET @@global.general_log_file = 'my.cnf\0foo'; ERROR 42000: Variable 'general_log_file' can't be set to the value of 'my.cnf\0000foo' SET @@global.general_log_file = 'my.ini'; ERROR 42000: Variable 'general_log_file' can't be set to the value of 'my.ini' '#----------------------FN_DYNVARS_004_03------------------------#' SELECT @@global.general_log_file = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='general_log_file'; @@global.general_log_file = VARIABLE_VALUE 1 SET @@global.general_log_file= @start_value;