Debian Codegraph @

mysql-test/suite/sys_vars/r/log_output_basic.result

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