1SET @start_value = @@global.log_output; 2SELECT @start_value; 3@start_value 4FILE 5'#--------------------FN_DYNVARS_065_01------------------------#' 6SET @@global.log_output = FILE; 7SET @@global.log_output = DEFAULT; 8SELECT @@global.log_output; 9@@global.log_output 10FILE 11'#---------------------FN_DYNVARS_065_02-------------------------#' 12SET @@global.log_output = NULL; 13ERROR 42000: Variable 'log_output' can't be set to the value of 'NULL' 14SET @@global.log_output = ""; 15ERROR 42000: Variable 'log_output' can't be set to the value of '' 16'#--------------------FN_DYNVARS_065_03------------------------#' 17SET @@global.log_output = 'TABLE'; 18SELECT @@global.log_output; 19@@global.log_output 20TABLE 21SET @@global.log_output = 'FILE'; 22SELECT @@global.log_output; 23@@global.log_output 24FILE 25SET @@global.log_output = 'NONE'; 26SELECT @@global.log_output; 27@@global.log_output 28NONE 29SET @@global.log_output = 'FILE,TABLE'; 30SELECT @@global.log_output; 31@@global.log_output 32FILE,TABLE 33SET @@global.log_output = 'TABLE,FILE'; 34SELECT @@global.log_output; 35@@global.log_output 36FILE,TABLE 37SET @@global.log_output = 'NONE,TABLE'; 38SELECT @@global.log_output; 39@@global.log_output 40NONE,TABLE 41SET @@global.log_output = 'NONE,FILE'; 42SELECT @@global.log_output; 43@@global.log_output 44NONE,FILE 45SET @@global.log_output = 'FILE,TABLE,NONE'; 46SELECT @@global.log_output; 47@@global.log_output 48NONE,FILE,TABLE 49SET @@global.log_output = 'TABLE,NONE'; 50SELECT @@global.log_output; 51@@global.log_output 52NONE,TABLE 53SET @@global.log_output = 'TABLE,TABLE'; 54SELECT @@global.log_output; 55@@global.log_output 56TABLE 57SET @@global.log_output = ',TABLE'; 58SELECT @@global.log_output; 59@@global.log_output 60TABLE 61SET @@global.log_output = 'TABLE,,FILE,,,'; 62SELECT @@global.log_output; 63@@global.log_output 64FILE,TABLE 65'#--------------------FN_DYNVARS_065_04-------------------------#' 66SET @@global.log_output = -1; 67ERROR 42000: Variable 'log_output' can't be set to the value of '-1' 68SET @@global.log_output = TAB; 69ERROR 42000: Variable 'log_output' can't be set to the value of 'TAB' 70SET @@global.log_output = NIL; 71ERROR 42000: Variable 'log_output' can't be set to the value of 'NIL' 72SET @@global.log_output = 'FIL'; 73ERROR 42000: Variable 'log_output' can't be set to the value of 'FIL' 74SET @@global.log_output = 'T'; 75ERROR 42000: Variable 'log_output' can't be set to the value of 'T' 76SET @@global.log_output = 'TABLE, FILE'; 77ERROR 42000: Variable 'log_output' can't be set to the value of ' FILE' 78SET @@global.log_output = ' TABLE,FILE'; 79ERROR 42000: Variable 'log_output' can't be set to the value of ' TABLE' 80'#-------------------FN_DYNVARS_065_05----------------------------#' 81SET @@log_output = 0; 82ERROR HY000: Variable 'log_output' is a GLOBAL variable and should be set with SET GLOBAL 83SELECT @@session.log_output; 84ERROR HY000: Variable 'log_output' is a GLOBAL variable 85'#----------------------FN_DYNVARS_065_06------------------------#' 86SELECT @@log_output = VARIABLE_VALUE 87FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 88WHERE VARIABLE_NAME='log_output'; 89@@log_output = VARIABLE_VALUE 901 91'#---------------------FN_DYNVARS_065_07-------------------------#' 92SET @@global.log_output = 0; 93ERROR 42000: Variable 'log_output' can't be set to the value of '0' 94SELECT @@global.log_output; 95@@global.log_output 96FILE,TABLE 97SET @@global.log_output = 1; 98SELECT @@global.log_output; 99@@global.log_output 100NONE 101SET @@global.log_output = 2; 102SELECT @@global.log_output; 103@@global.log_output 104FILE 105SET @@global.log_output = 3; 106SELECT @@global.log_output; 107@@global.log_output 108NONE,FILE 109SET @@global.log_output = 4; 110SELECT @@global.log_output; 111@@global.log_output 112TABLE 113SET @@global.log_output = 5; 114SELECT @@global.log_output; 115@@global.log_output 116NONE,TABLE 117SET @@global.log_output = 6; 118SELECT @@global.log_output; 119@@global.log_output 120FILE,TABLE 121SET @@global.log_output = 7; 122SELECT @@global.log_output; 123@@global.log_output 124NONE,FILE,TABLE 125SET @@global.log_output = 8; 126ERROR 42000: Variable 'log_output' can't be set to the value of '8' 127'#---------------------FN_DYNVARS_065_08----------------------#' 128SET @@global.log_output = TRUE; 129SELECT @@global.log_output; 130@@global.log_output 131NONE 132SET @@global.log_output = FALSE; 133ERROR 42000: Variable 'log_output' can't be set to the value of '0' 134SELECT @@global.log_output; 135@@global.log_output 136NONE 137'#---------------------FN_DYNVARS_065_09----------------------#' 138SET log_output = ON; 139ERROR HY000: Variable 'log_output' is a GLOBAL variable and should be set with SET GLOBAL 140SET global log_output = 'TABLE'; 141SELECT @@global.log_output; 142@@global.log_output 143TABLE 144SET @@global.log_output = @start_value; 145SELECT @@global.log_output; 146@@global.log_output 147FILE 148