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