Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.max_error_count;
2 SELECT @start_global_value;
3 @start_global_value
4 1024
5 SET @start_session_value = @@session.max_error_count;
6 SELECT @start_session_value;
7 @start_session_value
8 1024
9 '#--------------------FN_DYNVARS_076_01-------------------------#'
10 SET @@global.max_error_count = 1000;
11 SET @@global.max_error_count = DEFAULT;
12 SELECT @@global.max_error_count;
13 @@global.max_error_count
14 1024
15 SET @@session.max_error_count = 20000;
16 SET @@session.max_error_count = DEFAULT;
17 SELECT @@session.max_error_count;
18 @@session.max_error_count
19 1024
20 '#--------------------FN_DYNVARS_076_02-------------------------#'
21 SET @@global.max_error_count = DEFAULT;
22 SELECT @@global.max_error_count = 1024;
23 @@global.max_error_count = 1024
24 1
25 SET @@session.max_error_count = DEFAULT;
26 SELECT @@session.max_error_count = 1024;
27 @@session.max_error_count = 1024
28 1
29 '#--------------------FN_DYNVARS_076_03-------------------------#'
30 SET @@global.max_error_count = 1;
31 SELECT @@global.max_error_count;
32 @@global.max_error_count
33 1
34 SET @@global.max_error_count = 0;
35 SELECT @@global.max_error_count;
36 @@global.max_error_count
37 0
38 SET @@global.max_error_count = 65535;
39 SELECT @@global.max_error_count;
40 @@global.max_error_count
41 65535
42 SET @@global.max_error_count = 65534;
43 SELECT @@global.max_error_count;
44 @@global.max_error_count
45 65534
46 '#--------------------FN_DYNVARS_076_04-------------------------#'
47 SET @@session.max_error_count = 0;
48 SELECT @@session.max_error_count;
49 @@session.max_error_count
50 0
51 SET @@session.max_error_count = 1;
52 SELECT @@session.max_error_count;
53 @@session.max_error_count
54 1
55 SET @@session.max_error_count = 65535;
56 SELECT @@session.max_error_count;
57 @@session.max_error_count
58 65535
59 SET @@session.max_error_count = 65534;
60 SELECT @@session.max_error_count;
61 @@session.max_error_count
62 65534
63 '#------------------FN_DYNVARS_076_05-----------------------#'
64 SET @@global.max_error_count = -1;
65 Warnings:
66 Warning 1292 Truncated incorrect max_error_count value: '-1'
67 SELECT @@global.max_error_count;
68 @@global.max_error_count
69 0
70 SET @@global.max_error_count = -1024;
71 Warnings:
72 Warning 1292 Truncated incorrect max_error_count value: '-1024'
73 SELECT @@global.max_error_count;
74 @@global.max_error_count
75 0
76 SET @@global.max_error_count = 65536;
77 Warnings:
78 Warning 1292 Truncated incorrect max_error_count value: '65536'
79 SELECT @@global.max_error_count;
80 @@global.max_error_count
81 65535
82 SET @@global.max_error_count = 10737418241;
83 Warnings:
84 Warning 1292 Truncated incorrect max_error_count value: '10737418241'
85 SELECT @@global.max_error_count;
86 @@global.max_error_count
87 65535
88 SET @@global.max_error_count = 65530.34;
89 ERROR 42000: Incorrect argument type to variable 'max_error_count'
90 SELECT @@global.max_error_count;
91 @@global.max_error_count
92 65535
93 SET @@global.max_error_count = test;
94 ERROR 42000: Incorrect argument type to variable 'max_error_count'
95 SELECT @@global.max_error_count;
96 @@global.max_error_count
97 65535
98 SET @@global.max_error_count = ' ';
99 ERROR 42000: Incorrect argument type to variable 'max_error_count'
100 SELECT @@global.max_error_count;
101 @@global.max_error_count
102 65535
103 SET @@session.max_error_count = -1;
104 Warnings:
105 Warning 1292 Truncated incorrect max_error_count value: '-1'
106 SELECT @@session.max_error_count;
107 @@session.max_error_count
108 0
109 SET @@session.max_error_count = 65536;
110 SELECT @@session.max_error_count;
111 @@session.max_error_count
112 65535
113 SET @@session.max_error_count = -2;
114 Warnings:
115 Warning 1292 Truncated incorrect max_error_count value: '-2'
116 SELECT @@session.max_error_count;
117 @@session.max_error_count
118 0
119 SET @@session.max_error_count = -1024;
120 SELECT @@session.max_error_count;
121 @@session.max_error_count
122 0
123 SET @@session.max_error_count = 65530.34;
124 ERROR 42000: Incorrect argument type to variable 'max_error_count'
125 SET @@session.max_error_count = 10737418241;
126 SELECT @@session.max_error_count;
127 @@session.max_error_count
128 65535
129 SET @@session.max_error_count = test;
130 ERROR 42000: Incorrect argument type to variable 'max_error_count'
131 SELECT @@session.max_error_count;
132 @@session.max_error_count
133 65535
134 SET @@session.max_error_count = ' ';
135 ERROR 42000: Incorrect argument type to variable 'max_error_count'
136 SELECT @@session.max_error_count;
137 @@session.max_error_count
138 65535
139 '#------------------FN_DYNVARS_076_06-----------------------#'
140 SELECT @@global.max_error_count = VARIABLE_VALUE
141 FROM performance_schema.global_variables
142 WHERE VARIABLE_NAME='max_error_count';
143 @@global.max_error_count = VARIABLE_VALUE
144 1
145 '#------------------FN_DYNVARS_076_07-----------------------#'
146 SELECT @@session.max_error_count = VARIABLE_VALUE
147 FROM performance_schema.session_variables
148 WHERE VARIABLE_NAME='max_error_count';
149 @@session.max_error_count = VARIABLE_VALUE
150 1
151 '#------------------FN_DYNVARS_076_08-----------------------#'
152 SET @@global.max_error_count = TRUE;
153 SELECT @@global.max_error_count;
154 @@global.max_error_count
155 1
156 SET @@global.max_error_count = FALSE;
157 SELECT @@global.max_error_count;
158 @@global.max_error_count
159 0
160 '#---------------------FN_DYNVARS_001_09----------------------#'
161 SET @@global.max_error_count = 2048;
162 SELECT @@max_error_count = @@global.max_error_count;
163 @@max_error_count = @@global.max_error_count
164 0
165 '#---------------------FN_DYNVARS_001_10----------------------#'
166 SET @@max_error_count = 60000;
167 SELECT @@max_error_count = @@local.max_error_count;
168 @@max_error_count = @@local.max_error_count
169 1
170 SELECT @@local.max_error_count = @@session.max_error_count;
171 @@local.max_error_count = @@session.max_error_count
172 1
173 '#---------------------FN_DYNVARS_001_11----------------------#'
174 SET max_error_count = 1024;
175 SELECT @@max_error_count;
176 @@max_error_count
177 1024
178 SELECT local.max_error_count;
179 ERROR 42S02: Unknown table 'local' in field list
180 SELECT session.max_error_count;
181 ERROR 42S02: Unknown table 'session' in field list
182 SELECT max_error_count = @@session.max_error_count;
183 ERROR 42S22: Unknown column 'max_error_count' in 'field list'
184 '#---------------------FN_DYNVARS_001_12----------------------#'
185 CREATE USER foo, bar;
186 GRANT SESSION_VARIABLES_ADMIN ON *.* TO bar;
187 SELECT @@session.max_error_count;
188 @@session.max_error_count
189 2048
190 SET @@session.max_error_count = 2048;
191 ERROR 42000: Access denied; you need (at least one of) the SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation
192 SELECT @@session.max_error_count;
193 @@session.max_error_count
194 2048
195 SET @@session.max_error_count = 2048;
196 SELECT @@session.max_error_count;
197 @@session.max_error_count
198 2048
199 DROP USER foo, bar;
200 SET @@global.max_error_count = @start_global_value;
201 SELECT @@global.max_error_count;
202 @@global.max_error_count
203 1024
204 SET @@session.max_error_count = @start_session_value;
205 SELECT @@session.max_error_count;
206 @@session.max_error_count
207 1024