Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.sql_mode;
2 SELECT @global_start_value;
3 @global_start_value
4 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
5 SET @session_start_value = @@session.sql_mode;
6 SELECT @session_start_value;
7 @session_start_value
8 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
9 '#--------------------FN_DYNVARS_152_01------------------------#'
10 SET @@global.sql_mode = ANSI;
11 SET @@global.sql_mode = DEFAULT;
12 SELECT @@global.sql_mode;
13 @@global.sql_mode
14 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
15 SET @@session.sql_mode = ANSI;
16 SET @@session.sql_mode = DEFAULT;
17 SELECT @@session.sql_mode;
18 @@session.sql_mode
19 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
20 '#---------------------FN_DYNVARS_152_02-------------------------#'
21 SET @@global.sql_mode = NULL;
22 ERROR 42000: Variable 'sql_mode' can't be set to the value of 'NULL'
23 SET @@global.sql_mode = '';
24 SELECT @@global.sql_mode;
25 @@global.sql_mode
26
27 SET @@global.sql_mode = ' ';
28 SELECT @@global.sql_mode;
29 @@global.sql_mode
30
31 SET @@session.sql_mode = NULL;
32 ERROR 42000: Variable 'sql_mode' can't be set to the value of 'NULL'
33 SET @@session.sql_mode = '';
34 SELECT @@session.sql_mode;
35 @@session.sql_mode
36
37 SET @@session.sql_mode = ' ';
38 SELECT @@session.sql_mode;
39 @@session.sql_mode
40
41 '#--------------------FN_DYNVARS_152_03------------------------#'
42 SET @@global.sql_mode = ANSI;
43 SELECT @@global.sql_mode;
44 @@global.sql_mode
45 REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,ANSI
46 SET @@global.sql_mode = STRICT_TRANS_TABLES;
47 Warnings:
48 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
49 SELECT @@global.sql_mode;
50 @@global.sql_mode
51 STRICT_TRANS_TABLES
52 SET @@global.sql_mode = TRADITIONAL;
53 SELECT @@global.sql_mode;
54 @@global.sql_mode
55 STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
56 SET @@global.sql_mode = ALLOW_INVALID_DATES;
57 SELECT @@global.sql_mode;
58 @@global.sql_mode
59 ALLOW_INVALID_DATES
60 SET @@global.sql_mode = ANSI_QUOTES;
61 SELECT @@global.sql_mode;
62 @@global.sql_mode
63 ANSI_QUOTES
64 SET @@global.sql_mode = ERROR_FOR_DIVISION_BY_ZERO;
65 Warnings:
66 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
67 SELECT @@global.sql_mode;
68 @@global.sql_mode
69 ERROR_FOR_DIVISION_BY_ZERO
70 SET @@global.sql_mode = HIGH_NOT_PRECEDENCE;
71 SELECT @@global.sql_mode;
72 @@global.sql_mode
73 HIGH_NOT_PRECEDENCE
74 SET @@global.sql_mode = IGNORE_SPACE;
75 SELECT @@global.sql_mode;
76 @@global.sql_mode
77 IGNORE_SPACE
78 SET @@global.sql_mode = NO_AUTO_VALUE_ON_ZERO;
79 SELECT @@global.sql_mode;
80 @@global.sql_mode
81 NO_AUTO_VALUE_ON_ZERO
82 SET @@global.sql_mode = NO_BACKSLASH_ESCAPES;
83 SELECT @@global.sql_mode;
84 @@global.sql_mode
85 NO_BACKSLASH_ESCAPES
86 SET @@global.sql_mode = NO_DIR_IN_CREATE;
87 SELECT @@global.sql_mode;
88 @@global.sql_mode
89 NO_DIR_IN_CREATE
90 SET @@global.sql_mode = NO_ENGINE_SUBSTITUTION;
91 SELECT @@global.sql_mode;
92 @@global.sql_mode
93 NO_ENGINE_SUBSTITUTION
94 SET @@global.sql_mode = NO_UNSIGNED_SUBTRACTION;
95 SELECT @@global.sql_mode;
96 @@global.sql_mode
97 NO_UNSIGNED_SUBTRACTION
98 SET @@global.sql_mode = NO_ZERO_DATE;
99 Warnings:
100 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
101 SELECT @@global.sql_mode;
102 @@global.sql_mode
103 NO_ZERO_DATE
104 SET @@global.sql_mode = NO_ZERO_IN_DATE;
105 Warnings:
106 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
107 SELECT @@global.sql_mode;
108 @@global.sql_mode
109 NO_ZERO_IN_DATE
110 SET @@global.sql_mode = ONLY_FULL_GROUP_BY;
111 SELECT @@global.sql_mode;
112 @@global.sql_mode
113 ONLY_FULL_GROUP_BY
114 SET @@global.sql_mode = PIPES_AS_CONCAT;
115 SELECT @@global.sql_mode;
116 @@global.sql_mode
117 PIPES_AS_CONCAT
118 SET @@global.sql_mode = REAL_AS_FLOAT;
119 SELECT @@global.sql_mode;
120 @@global.sql_mode
121 REAL_AS_FLOAT
122 SET @@global.sql_mode = STRICT_ALL_TABLES;
123 Warnings:
124 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
125 SELECT @@global.sql_mode;
126 @@global.sql_mode
127 STRICT_ALL_TABLES
128 SET @@global.sql_mode = STRICT_TRANS_TABLES;
129 Warnings:
130 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
131 SELECT @@global.sql_mode;
132 @@global.sql_mode
133 STRICT_TRANS_TABLES
134 SET @@global.sql_mode = TRADITIONAL;
135 SELECT @@global.sql_mode;
136 @@global.sql_mode
137 STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
138 SET @@global.sql_mode = OFF;
139 ERROR 42000: Variable 'sql_mode' can't be set to the value of 'OFF'
140 SET @@session.sql_mode = ANSI;
141 SELECT @@session.sql_mode;
142 @@session.sql_mode
143 REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,ANSI
144 SET @@session.sql_mode = STRICT_TRANS_TABLES;
145 Warnings:
146 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
147 SELECT @@session.sql_mode;
148 @@session.sql_mode
149 STRICT_TRANS_TABLES
150 SET @@session.sql_mode = TRADITIONAL;
151 SELECT @@session.sql_mode;
152 @@session.sql_mode
153 STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
154 SET @@session.sql_mode = ALLOW_INVALID_DATES;
155 SELECT @@session.sql_mode;
156 @@session.sql_mode
157 ALLOW_INVALID_DATES
158 SET @@session.sql_mode = ANSI_QUOTES;
159 SELECT @@session.sql_mode;
160 @@session.sql_mode
161 ANSI_QUOTES
162 SET @@session.sql_mode = ERROR_FOR_DIVISION_BY_ZERO;
163 Warnings:
164 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
165 SELECT @@session.sql_mode;
166 @@session.sql_mode
167 ERROR_FOR_DIVISION_BY_ZERO
168 SET @@session.sql_mode = HIGH_NOT_PRECEDENCE;
169 SELECT @@session.sql_mode;
170 @@session.sql_mode
171 HIGH_NOT_PRECEDENCE
172 SET @@session.sql_mode = IGNORE_SPACE;
173 SELECT @@session.sql_mode;
174 @@session.sql_mode
175 IGNORE_SPACE
176 SET @@session.sql_mode = NO_AUTO_VALUE_ON_ZERO;
177 SELECT @@session.sql_mode;
178 @@session.sql_mode
179 NO_AUTO_VALUE_ON_ZERO
180 SET @@session.sql_mode = NO_BACKSLASH_ESCAPES;
181 SELECT @@session.sql_mode;
182 @@session.sql_mode
183 NO_BACKSLASH_ESCAPES
184 SET @@session.sql_mode = NO_DIR_IN_CREATE;
185 SELECT @@session.sql_mode;
186 @@session.sql_mode
187 NO_DIR_IN_CREATE
188 SET @@session.sql_mode = NO_ENGINE_SUBSTITUTION;
189 SELECT @@session.sql_mode;
190 @@session.sql_mode
191 NO_ENGINE_SUBSTITUTION
192 SET @@session.sql_mode = NO_UNSIGNED_SUBTRACTION;
193 SELECT @@session.sql_mode;
194 @@session.sql_mode
195 NO_UNSIGNED_SUBTRACTION
196 SET @@session.sql_mode = NO_ZERO_DATE;
197 Warnings:
198 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
199 SELECT @@session.sql_mode;
200 @@session.sql_mode
201 NO_ZERO_DATE
202 SET @@session.sql_mode = NO_ZERO_IN_DATE;
203 Warnings:
204 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
205 SELECT @@session.sql_mode;
206 @@session.sql_mode
207 NO_ZERO_IN_DATE
208 SET @@session.sql_mode = ONLY_FULL_GROUP_BY;
209 SELECT @@session.sql_mode;
210 @@session.sql_mode
211 ONLY_FULL_GROUP_BY
212 SET @@session.sql_mode = PIPES_AS_CONCAT;
213 SELECT @@session.sql_mode;
214 @@session.sql_mode
215 PIPES_AS_CONCAT
216 SET @@session.sql_mode = REAL_AS_FLOAT;
217 SELECT @@session.sql_mode;
218 @@session.sql_mode
219 REAL_AS_FLOAT
220 SET @@session.sql_mode = STRICT_ALL_TABLES;
221 Warnings:
222 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
223 SELECT @@session.sql_mode;
224 @@session.sql_mode
225 STRICT_ALL_TABLES
226 SET @@session.sql_mode = STRICT_TRANS_TABLES;
227 Warnings:
228 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
229 SELECT @@session.sql_mode;
230 @@session.sql_mode
231 STRICT_TRANS_TABLES
232 SET @@session.sql_mode = TRADITIONAL;
233 SELECT @@session.sql_mode;
234 @@session.sql_mode
235 STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
236 SET @@session.sql_mode = OFF;
237 ERROR 42000: Variable 'sql_mode' can't be set to the value of 'OFF'
238 SET @@global.sql_mode = '?';
239 ERROR 42000: Variable 'sql_mode' can't be set to the value of '?'
240 SELECT @@global.sql_mode;
241 @@global.sql_mode
242 STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
243 '#--------------------FN_DYNVARS_152_04-------------------------#'
244 SET @@global.sql_mode = -1;
245 ERROR 42000: Variable 'sql_mode' can't be set to the value of '-1'
246 SET @@global.sql_mode = ASCII;
247 ERROR 42000: Variable 'sql_mode' can't be set to the value of 'ASCII'
248 SET @@global.sql_mode = NON_TRADITIONAL;
249 ERROR 42000: Variable 'sql_mode' can't be set to the value of 'NON_TRADITIONAL'
250 SET @@global.sql_mode = 'OF';
251 ERROR 42000: Variable 'sql_mode' can't be set to the value of 'OF'
252 SET @@global.sql_mode = NONE;
253 ERROR 42000: Variable 'sql_mode' can't be set to the value of 'NONE'
254 SET @@session.sql_mode = -1;
255 ERROR 42000: Variable 'sql_mode' can't be set to the value of '-1'
256 SET @@session.sql_mode = ANSI_SINGLE_QUOTES;
257 ERROR 42000: Variable 'sql_mode' can't be set to the value of 'ANSI_SINGLE_QUOTES'
258 SET @@session.sql_mode = 'ON';
259 ERROR 42000: Variable 'sql_mode' can't be set to the value of 'ON'
260 SET @@session.sql_mode = 'OF';
261 ERROR 42000: Variable 'sql_mode' can't be set to the value of 'OF'
262 SET @@session.sql_mode = DISABLE;
263 ERROR 42000: Variable 'sql_mode' can't be set to the value of 'DISABLE'
264 '#-------------------FN_DYNVARS_152_05----------------------------#'
265 SELECT @@session.sql_mode = VARIABLE_VALUE
266 FROM performance_schema.session_variables
267 WHERE VARIABLE_NAME='sql_mode';
268 @@session.sql_mode = VARIABLE_VALUE
269 1
270 '#----------------------FN_DYNVARS_152_06------------------------#'
271 SELECT @@global.sql_mode = VARIABLE_VALUE
272 FROM performance_schema.global_variables
273 WHERE VARIABLE_NAME='sql_mode';
274 @@global.sql_mode = VARIABLE_VALUE
275 1
276 '#---------------------FN_DYNVARS_152_07-------------------------#'
277 SET @@global.sql_mode = 0;
278 SELECT @@global.sql_mode;
279 @@global.sql_mode
280
281 SET @@global.sql_mode = 1;
282 SELECT @@global.sql_mode;
283 @@global.sql_mode
284 REAL_AS_FLOAT
285 SET @@global.sql_mode = 2;
286 SELECT @@global.sql_mode;
287 @@global.sql_mode
288 PIPES_AS_CONCAT
289 SET @@global.sql_mode = 3;
290 SELECT @@global.sql_mode;
291 @@global.sql_mode
292 REAL_AS_FLOAT,PIPES_AS_CONCAT
293 SET @@global.sql_mode = 8589934592;
294 ERROR 42000: Variable 'sql_mode' can't be set to the value of '8589934592'
295 SET @@global.sql_mode = 0.4;
296 ERROR 42000: Incorrect argument type to variable 'sql_mode'
297 '#---------------------FN_DYNVARS_152_08----------------------#'
298 SET @@global.sql_mode = TRUE;
299 SELECT @@global.sql_mode;
300 @@global.sql_mode
301 REAL_AS_FLOAT
302 SET @@global.sql_mode = FALSE;
303 SELECT @@global.sql_mode;
304 @@global.sql_mode
305
306 '#---------------------FN_DYNVARS_152_09----------------------#'
307 SET sql_mode = 'ANSI';
308 SET session.sql_mode = 'ANSI';
309 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'session.sql_mode = 'ANSI'' at line 1
310 SET global.sql_mode = 'ANSI';
311 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.sql_mode = 'ANSI'' at line 1
312 SET session sql_mode = 1;
313 SELECT @@sql_mode;
314 @@sql_mode
315 REAL_AS_FLOAT
316 SET global sql_mode = 0;
317 SELECT @@global.sql_mode;
318 @@global.sql_mode
319
320 '#---------------------FN_DYNVARS_152_10----------------------#'
321 SET @@session.sql_mode = 'TRADITIONAL,ALLOW_INVALID_DATES,ANSI_QUOTES';
322 SELECT @@session.sql_mode;
323 @@session.sql_mode
324 ANSI_QUOTES,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
325 SET @@global.sql_mode = 'ONLY_FULL_GROUP_BY,PIPES_AS_CONCAT,REAL_AS_FLOAT';
326 SELECT @@global.sql_mode;
327 @@global.sql_mode
328 REAL_AS_FLOAT,PIPES_AS_CONCAT,ONLY_FULL_GROUP_BY
329 SET @@session.sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,FOOBAR,IGNORE_SPACE';
330 ERROR 42000: Variable 'sql_mode' can't be set to the value of 'FOOBAR'
331 SET @@sql_mode=',';
332 SELECT @@sql_mode;
333 @@sql_mode
334
335 SET @@sql_mode=',,,,ANSI_QUOTES,,,';
336 SELECT @@sql_mode;
337 @@sql_mode
338 ANSI_QUOTES
339 SET @@sql_mode=',,,,FOOBAR,,,,,';
340 ERROR 42000: Variable 'sql_mode' can't be set to the value of 'FOOBAR'
341 SELECT @@sql_mode;
342 @@sql_mode
343 ANSI_QUOTES
344 '#---------------------FN_DYNVARS_152_11----------------------#'
345 SET @@session.sql_mode= cast(pow(2,0) as unsigned integer);
346 SELECT @@session.sql_mode;
347 @@session.sql_mode
348 REAL_AS_FLOAT
349 SET @@global.sql_mode= cast(pow(2,0) as unsigned integer);
350 SELECT @@global.sql_mode;
351 @@global.sql_mode
352 REAL_AS_FLOAT
353 SET @@session.sql_mode= cast(pow(2,1) as unsigned integer);
354 SELECT @@session.sql_mode;
355 @@session.sql_mode
356 PIPES_AS_CONCAT
357 SET @@global.sql_mode= cast(pow(2,1) as unsigned integer);
358 SELECT @@global.sql_mode;
359 @@global.sql_mode
360 PIPES_AS_CONCAT
361 SET @@session.sql_mode= cast(pow(2,2) as unsigned integer);
362 SELECT @@session.sql_mode;
363 @@session.sql_mode
364 ANSI_QUOTES
365 SET @@global.sql_mode= cast(pow(2,2) as unsigned integer);
366 SELECT @@global.sql_mode;
367 @@global.sql_mode
368 ANSI_QUOTES
369 SET @@session.sql_mode= cast(pow(2,3) as unsigned integer);
370 SELECT @@session.sql_mode;
371 @@session.sql_mode
372 IGNORE_SPACE
373 SET @@global.sql_mode= cast(pow(2,3) as unsigned integer);
374 SELECT @@global.sql_mode;
375 @@global.sql_mode
376 IGNORE_SPACE
377 SET @@session.sql_mode= cast(pow(2,4) as unsigned integer);
378 SELECT @@session.sql_mode;
379 @@session.sql_mode
380 NOT_USED
381 SET @@global.sql_mode= cast(pow(2,4) as unsigned integer);
382 SELECT @@global.sql_mode;
383 @@global.sql_mode
384 NOT_USED
385 SET @@session.sql_mode= cast(pow(2,5) as unsigned integer);
386 SELECT @@session.sql_mode;
387 @@session.sql_mode
388 ONLY_FULL_GROUP_BY
389 SET @@global.sql_mode= cast(pow(2,5) as unsigned integer);
390 SELECT @@global.sql_mode;
391 @@global.sql_mode
392 ONLY_FULL_GROUP_BY
393 SET @@session.sql_mode= cast(pow(2,6) as unsigned integer);
394 SELECT @@session.sql_mode;
395 @@session.sql_mode
396 NO_UNSIGNED_SUBTRACTION
397 SET @@global.sql_mode= cast(pow(2,6) as unsigned integer);
398 SELECT @@global.sql_mode;
399 @@global.sql_mode
400 NO_UNSIGNED_SUBTRACTION
401 SET @@session.sql_mode= cast(pow(2,7) as unsigned integer);
402 SELECT @@session.sql_mode;
403 @@session.sql_mode
404 NO_DIR_IN_CREATE
405 SET @@global.sql_mode= cast(pow(2,7) as unsigned integer);
406 SELECT @@global.sql_mode;
407 @@global.sql_mode
408 NO_DIR_IN_CREATE
409 SET @@session.sql_mode= cast(pow(2,8) as unsigned integer);
410 ERROR HY000: sql_mode=0x00000100 is not supported.
411 SELECT @@session.sql_mode;
412 @@session.sql_mode
413 NO_DIR_IN_CREATE
414 SET @@global.sql_mode= cast(pow(2,8) as unsigned integer);
415 ERROR HY000: sql_mode=0x00000100 is not supported.
416 SELECT @@global.sql_mode;
417 @@global.sql_mode
418 NO_DIR_IN_CREATE
419 SET @@session.sql_mode= cast(pow(2,9) as unsigned integer);
420 ERROR HY000: sql_mode=0x00000200 is not supported.
421 SELECT @@session.sql_mode;
422 @@session.sql_mode
423 NO_DIR_IN_CREATE
424 SET @@global.sql_mode= cast(pow(2,9) as unsigned integer);
425 ERROR HY000: sql_mode=0x00000200 is not supported.
426 SELECT @@global.sql_mode;
427 @@global.sql_mode
428 NO_DIR_IN_CREATE
429 SET @@session.sql_mode= cast(pow(2,10) as unsigned integer);
430 ERROR HY000: sql_mode=0x00000400 is not supported.
431 SELECT @@session.sql_mode;
432 @@session.sql_mode
433 NO_DIR_IN_CREATE
434 SET @@global.sql_mode= cast(pow(2,10) as unsigned integer);
435 ERROR HY000: sql_mode=0x00000400 is not supported.
436 SELECT @@global.sql_mode;
437 @@global.sql_mode
438 NO_DIR_IN_CREATE
439 SET @@session.sql_mode= cast(pow(2,11) as unsigned integer);
440 ERROR HY000: sql_mode=0x00000800 is not supported.
441 SELECT @@session.sql_mode;
442 @@session.sql_mode
443 NO_DIR_IN_CREATE
444 SET @@global.sql_mode= cast(pow(2,11) as unsigned integer);
445 ERROR HY000: sql_mode=0x00000800 is not supported.
446 SELECT @@global.sql_mode;
447 @@global.sql_mode
448 NO_DIR_IN_CREATE
449 SET @@session.sql_mode= cast(pow(2,12) as unsigned integer);
450 ERROR HY000: sql_mode=0x00001000 is not supported.
451 SELECT @@session.sql_mode;
452 @@session.sql_mode
453 NO_DIR_IN_CREATE
454 SET @@global.sql_mode= cast(pow(2,12) as unsigned integer);
455 ERROR HY000: sql_mode=0x00001000 is not supported.
456 SELECT @@global.sql_mode;
457 @@global.sql_mode
458 NO_DIR_IN_CREATE
459 SET @@session.sql_mode= cast(pow(2,13) as unsigned integer);
460 ERROR HY000: sql_mode=0x00002000 is not supported.
461 SELECT @@session.sql_mode;
462 @@session.sql_mode
463 NO_DIR_IN_CREATE
464 SET @@global.sql_mode= cast(pow(2,13) as unsigned integer);
465 ERROR HY000: sql_mode=0x00002000 is not supported.
466 SELECT @@global.sql_mode;
467 @@global.sql_mode
468 NO_DIR_IN_CREATE
469 SET @@session.sql_mode= cast(pow(2,14) as unsigned integer);
470 ERROR HY000: sql_mode=0x00004000 is not supported.
471 SELECT @@session.sql_mode;
472 @@session.sql_mode
473 NO_DIR_IN_CREATE
474 SET @@global.sql_mode= cast(pow(2,14) as unsigned integer);
475 ERROR HY000: sql_mode=0x00004000 is not supported.
476 SELECT @@global.sql_mode;
477 @@global.sql_mode
478 NO_DIR_IN_CREATE
479 SET @@session.sql_mode= cast(pow(2,15) as unsigned integer);
480 ERROR HY000: sql_mode=0x00008000 is not supported.
481 SELECT @@session.sql_mode;
482 @@session.sql_mode
483 NO_DIR_IN_CREATE
484 SET @@global.sql_mode= cast(pow(2,15) as unsigned integer);
485 ERROR HY000: sql_mode=0x00008000 is not supported.
486 SELECT @@global.sql_mode;
487 @@global.sql_mode
488 NO_DIR_IN_CREATE
489 SET @@session.sql_mode= cast(pow(2,16) as unsigned integer);
490 ERROR HY000: sql_mode=0x00010000 is not supported.
491 SELECT @@session.sql_mode;
492 @@session.sql_mode
493 NO_DIR_IN_CREATE
494 SET @@global.sql_mode= cast(pow(2,16) as unsigned integer);
495 ERROR HY000: sql_mode=0x00010000 is not supported.
496 SELECT @@global.sql_mode;
497 @@global.sql_mode
498 NO_DIR_IN_CREATE
499 SET @@session.sql_mode= cast(pow(2,17) as unsigned integer);
500 ERROR HY000: sql_mode=0x00020000 is not supported.
501 SELECT @@session.sql_mode;
502 @@session.sql_mode
503 NO_DIR_IN_CREATE
504 SET @@global.sql_mode= cast(pow(2,17) as unsigned integer);
505 ERROR HY000: sql_mode=0x00020000 is not supported.
506 SELECT @@global.sql_mode;
507 @@global.sql_mode
508 NO_DIR_IN_CREATE
509 SET @@session.sql_mode= cast(pow(2,18) as unsigned integer);
510 SELECT @@session.sql_mode;
511 @@session.sql_mode
512 REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,ANSI
513 SET @@global.sql_mode= cast(pow(2,18) as unsigned integer);
514 SELECT @@global.sql_mode;
515 @@global.sql_mode
516 REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,ANSI
517 SET @@session.sql_mode= cast(pow(2,19) as unsigned integer);
518 SELECT @@session.sql_mode;
519 @@session.sql_mode
520 NO_AUTO_VALUE_ON_ZERO
521 SET @@global.sql_mode= cast(pow(2,19) as unsigned integer);
522 SELECT @@global.sql_mode;
523 @@global.sql_mode
524 NO_AUTO_VALUE_ON_ZERO
525 SET @@session.sql_mode= cast(pow(2,20) as unsigned integer);
526 SELECT @@session.sql_mode;
527 @@session.sql_mode
528 NO_BACKSLASH_ESCAPES
529 SET @@global.sql_mode= cast(pow(2,20) as unsigned integer);
530 SELECT @@global.sql_mode;
531 @@global.sql_mode
532 NO_BACKSLASH_ESCAPES
533 SET @@session.sql_mode= cast(pow(2,21) as unsigned integer);
534 Warnings:
535 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
536 SELECT @@session.sql_mode;
537 @@session.sql_mode
538 STRICT_TRANS_TABLES
539 SET @@global.sql_mode= cast(pow(2,21) as unsigned integer);
540 Warnings:
541 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
542 SELECT @@global.sql_mode;
543 @@global.sql_mode
544 STRICT_TRANS_TABLES
545 SET @@session.sql_mode= cast(pow(2,22) as unsigned integer);
546 Warnings:
547 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
548 SELECT @@session.sql_mode;
549 @@session.sql_mode
550 STRICT_ALL_TABLES
551 SET @@global.sql_mode= cast(pow(2,22) as unsigned integer);
552 Warnings:
553 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
554 SELECT @@global.sql_mode;
555 @@global.sql_mode
556 STRICT_ALL_TABLES
557 SET @@session.sql_mode= cast(pow(2,23) as unsigned integer);
558 Warnings:
559 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
560 SELECT @@session.sql_mode;
561 @@session.sql_mode
562 NO_ZERO_IN_DATE
563 SET @@global.sql_mode= cast(pow(2,23) as unsigned integer);
564 Warnings:
565 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
566 SELECT @@global.sql_mode;
567 @@global.sql_mode
568 NO_ZERO_IN_DATE
569 SET @@session.sql_mode= cast(pow(2,24) as unsigned integer);
570 Warnings:
571 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
572 SELECT @@session.sql_mode;
573 @@session.sql_mode
574 NO_ZERO_DATE
575 SET @@global.sql_mode= cast(pow(2,24) as unsigned integer);
576 Warnings:
577 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
578 SELECT @@global.sql_mode;
579 @@global.sql_mode
580 NO_ZERO_DATE
581 SET @@session.sql_mode= cast(pow(2,25) as unsigned integer);
582 SELECT @@session.sql_mode;
583 @@session.sql_mode
584 ALLOW_INVALID_DATES
585 SET @@global.sql_mode= cast(pow(2,25) as unsigned integer);
586 SELECT @@global.sql_mode;
587 @@global.sql_mode
588 ALLOW_INVALID_DATES
589 SET @@session.sql_mode= cast(pow(2,26) as unsigned integer);
590 Warnings:
591 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
592 SELECT @@session.sql_mode;
593 @@session.sql_mode
594 ERROR_FOR_DIVISION_BY_ZERO
595 SET @@global.sql_mode= cast(pow(2,26) as unsigned integer);
596 Warnings:
597 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
598 SELECT @@global.sql_mode;
599 @@global.sql_mode
600 ERROR_FOR_DIVISION_BY_ZERO
601 SET @@session.sql_mode= cast(pow(2,27) as unsigned integer);
602 SELECT @@session.sql_mode;
603 @@session.sql_mode
604 STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
605 SET @@global.sql_mode= cast(pow(2,27) as unsigned integer);
606 SELECT @@global.sql_mode;
607 @@global.sql_mode
608 STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
609 SET @@session.sql_mode= cast(pow(2,28) as unsigned integer);
610 ERROR HY000: sql_mode=0x10000000 is not supported.
611 SELECT @@session.sql_mode;
612 @@session.sql_mode
613 STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
614 SET @@global.sql_mode= cast(pow(2,28) as unsigned integer);
615 ERROR HY000: sql_mode=0x10000000 is not supported.
616 SELECT @@global.sql_mode;
617 @@global.sql_mode
618 STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
619 SET @@session.sql_mode= cast(pow(2,29) as unsigned integer);
620 SELECT @@session.sql_mode;
621 @@session.sql_mode
622 HIGH_NOT_PRECEDENCE
623 SET @@global.sql_mode= cast(pow(2,29) as unsigned integer);
624 SELECT @@global.sql_mode;
625 @@global.sql_mode
626 HIGH_NOT_PRECEDENCE
627 SET @@session.sql_mode= cast(pow(2,30) as unsigned integer);
628 SELECT @@session.sql_mode;
629 @@session.sql_mode
630 NO_ENGINE_SUBSTITUTION
631 SET @@global.sql_mode= cast(pow(2,30) as unsigned integer);
632 SELECT @@global.sql_mode;
633 @@global.sql_mode
634 NO_ENGINE_SUBSTITUTION
635 SET @@session.sql_mode= cast(pow(2,31) as unsigned integer);
636 Warnings:
637 Warning 3090 Changing sql mode 'PAD_CHAR_TO_FULL_LENGTH' is deprecated. It will be removed in a future release.
638 SELECT @@session.sql_mode;
639 @@session.sql_mode
640 PAD_CHAR_TO_FULL_LENGTH
641 SET @@global.sql_mode= cast(pow(2,31) as unsigned integer);
642 Warnings:
643 Warning 3090 Changing sql mode 'PAD_CHAR_TO_FULL_LENGTH' is deprecated. It will be removed in a future release.
644 SELECT @@global.sql_mode;
645 @@global.sql_mode
646 PAD_CHAR_TO_FULL_LENGTH
647 SET @@session.sql_mode= cast(pow(2,32) as unsigned integer);
648 SELECT @@session.sql_mode;
649 @@session.sql_mode
650 TIME_TRUNCATE_FRACTIONAL
651 SET @@global.sql_mode= cast(pow(2,32) as unsigned integer);
652 SELECT @@global.sql_mode;
653 @@global.sql_mode
654 TIME_TRUNCATE_FRACTIONAL
655 #
656 # Bug#27828236: ERROR 1231 WHEN 8.0 CLIENT TRIES TO READ THE OUTPUT OF
657 # MYSQLBINLOG 5.7
658 #
659 SET @@session.sql_mode = 0;
660 CREATE TABLE t1 (i INT);
661 CREATE TRIGGER trg1 BEFORE INSERT ON t1 FOR EACH ROW SET @@session.sql_mode=1436549152;
662 CREATE PROCEDURE p1() SET @@session.sql_mode=1436549152;
663 # pseudo_replica_mode is "off", assignment should fail as before:
664 SET @@session.sql_mode=1436549152;
665 ERROR HY000: sql_mode=0x10000000 is not supported.
666 SELECT @@session.sql_mode;
667 @@session.sql_mode
668
669 INSERT INTO t1 VALUES (1);
670 ERROR HY000: sql_mode=0x10000000 is not supported.
671 SELECT @@session.sql_mode;
672 @@session.sql_mode
673
674 CALL p1;
675 ERROR HY000: sql_mode=0x10000000 is not supported.
676 SELECT @@session.sql_mode;
677 @@session.sql_mode
678
679 #
680 SET @session_pseudo_replica_mode = @@session.pseudo_replica_mode;
681 SET @@session.pseudo_replica_mode = TRUE;
682 # pseudo_replica_mode is "on", assignment should succeed:
683 SET @@session.sql_mode=1436549152;
684 Warnings:
685 Warning 13249 sql_mode=0x10000000 has been removed and will be ignored
686 SELECT @@session.sql_mode;
687 @@session.sql_mode
688 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
689 # ... but the assignment in SBR-invoked triggers should continue to fail:
690 SET @@session.sql_mode = 0;
691 INSERT INTO t1 VALUES (1);
692 ERROR HY000: sql_mode=0x10000000 is not supported.
693 SELECT @@session.sql_mode;
694 @@session.sql_mode
695
696 # ... and in procedure calls:
697 CALL p1;
698 ERROR HY000: sql_mode=0x10000000 is not supported.
699 SELECT @@session.sql_mode;
700 @@session.sql_mode
701
702 DROP PROCEDURE p1;
703 DROP TABLE t1;
704 SET @@session.pseudo_replica_mode = @session_pseudo_replica_mode;
705 Warnings:
706 Warning 1231 Replica applier execution mode not active, statement ineffective.
707 SET @@session.sql_mode = DEFAULT;
708 SET @@global.sql_mode = @global_start_value;
709 SELECT @@global.sql_mode;
710 @@global.sql_mode
711 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
712 SET @@session.sql_mode = @session_start_value;
713 SELECT @@session.sql_mode;
714 @@session.sql_mode
715 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION