Debian Codegraph @

mysql-test/suite/sys_vars/t/sql_mode_basic.test

raw
1 #################### mysql-test\t\sql_mode_basic.test #########################
2 # #
3 # Variable Name: sql_mode #
4 # Scope: GLOBAL | SESSION #
5 # Access Type: Dynamic #
6 # Data Type: enumeration #
7 # Default Value: YES #
8 # Valid Values : ANSI, STRICT_TRANS_TABLES, TRADITIONAL, #
9 # ERROR_FOR_DIVISION_BY_ZERO, ANSI_QUOTES, HIGH_NOT_PRECEDENCE,#
10 # IGNORE_SPACE, ONLY_FULL_GROUP_BY, #
11 # NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES, #
12 # NO_UNSIGNED_SUBTRACTION, OFF #
13 # #
14 # #
15 # Creation Date: 2008-02-07 #
16 # Author: Rizwan #
17 # #
18 # Description: Test Cases of Dynamic System Variable sql_mode #
19 # that checks the behavior of this variable in the following ways#
20 # * Default Value #
21 # * Valid & Invalid values #
22 # * Scope & Access method #
23 # * Data Integrity #
24 # #
25 # Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
26 # server-system-variables.html #
27 # #
28 ###############################################################################
29
30 --source include/load_sysvars.inc
31
32 ################################################################
33 # START OF sql_mode TESTS #
34 ################################################################
35
36
37 ###################################################################
38 # Saving initial value of sql_mode in a temporary variable #
39 ###################################################################
40
41 SET @global_start_value = @@global.sql_mode;
42 SELECT @global_start_value;
43
44 SET @session_start_value = @@session.sql_mode;
45 SELECT @session_start_value;
46
47 --echo '#--------------------FN_DYNVARS_152_01------------------------#'
48 ################################################################
49 # Display the DEFAULT value of sql_mode #
50 ################################################################
51
52 SET @@global.sql_mode = ANSI;
53 SET @@global.sql_mode = DEFAULT;
54 SELECT @@global.sql_mode;
55
56 SET @@session.sql_mode = ANSI;
57 SET @@session.sql_mode = DEFAULT;
58 SELECT @@session.sql_mode;
59
60 --echo '#---------------------FN_DYNVARS_152_02-------------------------#'
61 #########################################################
62 # Check if NULL or empty value is accepeted #
63 #########################################################
64
65 --Error ER_WRONG_VALUE_FOR_VAR
66 SET @@global.sql_mode = NULL;
67
68 # resets sql mode to nothing
69 SET @@global.sql_mode = '';
70 SELECT @@global.sql_mode;
71
72 SET @@global.sql_mode = ' ';
73 SELECT @@global.sql_mode;
74
75 --Error ER_WRONG_VALUE_FOR_VAR
76 SET @@session.sql_mode = NULL;
77
78 SET @@session.sql_mode = '';
79 SELECT @@session.sql_mode;
80
81 SET @@session.sql_mode = ' ';
82 SELECT @@session.sql_mode;
83
84
85 --echo '#--------------------FN_DYNVARS_152_03------------------------#'
86 ########################################################################
87 # Change the value of sql_mode to a valid value #
88 ########################################################################
89
90 # sql modes ref: http://dev.mysql.com/doc/refman/5.1/en/server-sql-mode.html
91
92 # check valid values for global
93
94 SET @@global.sql_mode = ANSI;
95 SELECT @@global.sql_mode;
96 SET @@global.sql_mode = STRICT_TRANS_TABLES;
97 SELECT @@global.sql_mode;
98 SET @@global.sql_mode = TRADITIONAL;
99 SELECT @@global.sql_mode;
100 SET @@global.sql_mode = ALLOW_INVALID_DATES;
101 SELECT @@global.sql_mode;
102 SET @@global.sql_mode = ANSI_QUOTES;
103 SELECT @@global.sql_mode;
104 SET @@global.sql_mode = ERROR_FOR_DIVISION_BY_ZERO;
105 SELECT @@global.sql_mode;
106 SET @@global.sql_mode = HIGH_NOT_PRECEDENCE;
107 SELECT @@global.sql_mode;
108 SET @@global.sql_mode = IGNORE_SPACE;
109 SELECT @@global.sql_mode;
110 SET @@global.sql_mode = NO_AUTO_VALUE_ON_ZERO;
111 SELECT @@global.sql_mode;
112 SET @@global.sql_mode = NO_BACKSLASH_ESCAPES;
113 SELECT @@global.sql_mode;
114 SET @@global.sql_mode = NO_DIR_IN_CREATE;
115 SELECT @@global.sql_mode;
116 SET @@global.sql_mode = NO_ENGINE_SUBSTITUTION;
117 SELECT @@global.sql_mode;
118 SET @@global.sql_mode = NO_UNSIGNED_SUBTRACTION;
119 SELECT @@global.sql_mode;
120 SET @@global.sql_mode = NO_ZERO_DATE;
121 SELECT @@global.sql_mode;
122 SET @@global.sql_mode = NO_ZERO_IN_DATE;
123 SELECT @@global.sql_mode;
124 SET @@global.sql_mode = ONLY_FULL_GROUP_BY;
125 SELECT @@global.sql_mode;
126 SET @@global.sql_mode = PIPES_AS_CONCAT;
127 SELECT @@global.sql_mode;
128 SET @@global.sql_mode = REAL_AS_FLOAT;
129 SELECT @@global.sql_mode;
130 SET @@global.sql_mode = STRICT_ALL_TABLES;
131 SELECT @@global.sql_mode;
132 SET @@global.sql_mode = STRICT_TRANS_TABLES;
133 SELECT @@global.sql_mode;
134 SET @@global.sql_mode = TRADITIONAL;
135 SELECT @@global.sql_mode;
136
137 --Error ER_WRONG_VALUE_FOR_VAR
138 SET @@global.sql_mode = OFF;
139
140 #check valid values for session
141 SET @@session.sql_mode = ANSI;
142 SELECT @@session.sql_mode;
143 SET @@session.sql_mode = STRICT_TRANS_TABLES;
144 SELECT @@session.sql_mode;
145 SET @@session.sql_mode = TRADITIONAL;
146 SELECT @@session.sql_mode;
147 SET @@session.sql_mode = ALLOW_INVALID_DATES;
148 SELECT @@session.sql_mode;
149 SET @@session.sql_mode = ANSI_QUOTES;
150 SELECT @@session.sql_mode;
151 SET @@session.sql_mode = ERROR_FOR_DIVISION_BY_ZERO;
152 SELECT @@session.sql_mode;
153 SET @@session.sql_mode = HIGH_NOT_PRECEDENCE;
154 SELECT @@session.sql_mode;
155 SET @@session.sql_mode = IGNORE_SPACE;
156 SELECT @@session.sql_mode;
157 SET @@session.sql_mode = NO_AUTO_VALUE_ON_ZERO;
158 SELECT @@session.sql_mode;
159 SET @@session.sql_mode = NO_BACKSLASH_ESCAPES;
160 SELECT @@session.sql_mode;
161 SET @@session.sql_mode = NO_DIR_IN_CREATE;
162 SELECT @@session.sql_mode;
163 SET @@session.sql_mode = NO_ENGINE_SUBSTITUTION;
164 SELECT @@session.sql_mode;
165 SET @@session.sql_mode = NO_UNSIGNED_SUBTRACTION;
166 SELECT @@session.sql_mode;
167 SET @@session.sql_mode = NO_ZERO_DATE;
168 SELECT @@session.sql_mode;
169 SET @@session.sql_mode = NO_ZERO_IN_DATE;
170 SELECT @@session.sql_mode;
171 SET @@session.sql_mode = ONLY_FULL_GROUP_BY;
172 SELECT @@session.sql_mode;
173 SET @@session.sql_mode = PIPES_AS_CONCAT;
174 SELECT @@session.sql_mode;
175 SET @@session.sql_mode = REAL_AS_FLOAT;
176 SELECT @@session.sql_mode;
177 SET @@session.sql_mode = STRICT_ALL_TABLES;
178 SELECT @@session.sql_mode;
179 SET @@session.sql_mode = STRICT_TRANS_TABLES;
180 SELECT @@session.sql_mode;
181 SET @@session.sql_mode = TRADITIONAL;
182 SELECT @@session.sql_mode;
183
184 --Error ER_WRONG_VALUE_FOR_VAR
185 SET @@session.sql_mode = OFF;
186
187 --Error ER_WRONG_VALUE_FOR_VAR
188 SET @@global.sql_mode = '?';
189 SELECT @@global.sql_mode;
190
191 --echo '#--------------------FN_DYNVARS_152_04-------------------------#'
192 ###########################################################################
193 # Change the value of sql_mode to invalid value #
194 ###########################################################################
195
196 # invalid values for global
197 --Error ER_WRONG_VALUE_FOR_VAR
198 SET @@global.sql_mode = -1;
199 --Error ER_WRONG_VALUE_FOR_VAR
200 SET @@global.sql_mode = ASCII;
201 --Error ER_WRONG_VALUE_FOR_VAR
202 SET @@global.sql_mode = NON_TRADITIONAL;
203 --Error ER_WRONG_VALUE_FOR_VAR
204 SET @@global.sql_mode = 'OF';
205 --Error ER_WRONG_VALUE_FOR_VAR
206 SET @@global.sql_mode = NONE;
207 --Error ER_WRONG_VALUE_FOR_VAR
208
209 #invalid values for session
210
211 --Error ER_WRONG_VALUE_FOR_VAR
212 SET @@session.sql_mode = -1;
213 --Error ER_WRONG_VALUE_FOR_VAR
214 SET @@session.sql_mode = ANSI_SINGLE_QUOTES;
215 --Error ER_WRONG_VALUE_FOR_VAR
216 SET @@session.sql_mode = 'ON';
217 --Error ER_WRONG_VALUE_FOR_VAR
218 SET @@session.sql_mode = 'OF';
219 --Error ER_WRONG_VALUE_FOR_VAR
220 SET @@session.sql_mode = DISABLE;
221
222
223 --echo '#-------------------FN_DYNVARS_152_05----------------------------#'
224 #########################################################################
225 # Check if the value in session Table matches value in variable #
226 #########################################################################
227
228 --disable_warnings
229 SELECT @@session.sql_mode = VARIABLE_VALUE
230 FROM performance_schema.session_variables
231 WHERE VARIABLE_NAME='sql_mode';
232 --enable_warnings
233
234 --echo '#----------------------FN_DYNVARS_152_06------------------------#'
235 #########################################################################
236 # Check if the value in GLOBAL Table matches value in variable #
237 #########################################################################
238
239 --disable_warnings
240 SELECT @@global.sql_mode = VARIABLE_VALUE
241 FROM performance_schema.global_variables
242 WHERE VARIABLE_NAME='sql_mode';
243 --enable_warnings
244
245
246 --echo '#---------------------FN_DYNVARS_152_07-------------------------#'
247 ###################################################################
248 # Check if numbers can be used on variable #
249 ###################################################################
250
251 # test if variable accepts 0,1,2
252 SET @@global.sql_mode = 0;
253 SELECT @@global.sql_mode;
254
255 SET @@global.sql_mode = 1;
256 SELECT @@global.sql_mode;
257
258 SET @@global.sql_mode = 2;
259 SELECT @@global.sql_mode;
260
261 SET @@global.sql_mode = 3;
262 SELECT @@global.sql_mode;
263
264 --Error ER_WRONG_VALUE_FOR_VAR
265 SET @@global.sql_mode = 8589934592;
266
267 # use of decimal values
268
269 --Error ER_WRONG_TYPE_FOR_VAR
270 SET @@global.sql_mode = 0.4;
271
272 --echo '#---------------------FN_DYNVARS_152_08----------------------#'
273 ###################################################################
274 # Check if TRUE and FALSE values can be used on variable #
275 ###################################################################
276
277 SET @@global.sql_mode = TRUE;
278 SELECT @@global.sql_mode;
279 SET @@global.sql_mode = FALSE;
280 SELECT @@global.sql_mode;
281
282 --echo '#---------------------FN_DYNVARS_152_09----------------------#'
283 #########################################################################
284 # Check if sql_mode can be accessed with and without @@ sign #
285 #########################################################################
286
287
288 SET sql_mode = 'ANSI';
289
290 --Error ER_PARSE_ERROR
291 SET session.sql_mode = 'ANSI';
292 --Error ER_PARSE_ERROR
293 SET global.sql_mode = 'ANSI';
294
295 SET session sql_mode = 1;
296 SELECT @@sql_mode;
297
298 SET global sql_mode = 0;
299 SELECT @@global.sql_mode;
300
301 --echo '#---------------------FN_DYNVARS_152_10----------------------#'
302 #######################################################################
303 # Check if sql_mode values can be combined as specified #
304 #######################################################################
305
306 SET @@session.sql_mode = 'TRADITIONAL,ALLOW_INVALID_DATES,ANSI_QUOTES';
307 SELECT @@session.sql_mode;
308
309 SET @@global.sql_mode = 'ONLY_FULL_GROUP_BY,PIPES_AS_CONCAT,REAL_AS_FLOAT';
310 SELECT @@global.sql_mode;
311
312 #try combining invalid mode with correct mode
313 --Error ER_WRONG_VALUE_FOR_VAR
314 SET @@session.sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,FOOBAR,IGNORE_SPACE';
315
316 #zero-length values are ok
317 SET @@sql_mode=',';
318 SELECT @@sql_mode;
319 SET @@sql_mode=',,,,ANSI_QUOTES,,,';
320 SELECT @@sql_mode;
321 --Error ER_WRONG_VALUE_FOR_VAR
322 SET @@sql_mode=',,,,FOOBAR,,,,,';
323 SELECT @@sql_mode;
324
325 --echo '#---------------------FN_DYNVARS_152_11----------------------#'
326 #######################################################################
327 # Check if sql_mode can be set using pow(2,x) #
328 #######################################################################
329
330 SET @@session.sql_mode= cast(pow(2,0) as unsigned integer);
331 SELECT @@session.sql_mode;
332 SET @@global.sql_mode= cast(pow(2,0) as unsigned integer);
333 SELECT @@global.sql_mode;
334
335 SET @@session.sql_mode= cast(pow(2,1) as unsigned integer);
336 SELECT @@session.sql_mode;
337 SET @@global.sql_mode= cast(pow(2,1) as unsigned integer);
338 SELECT @@global.sql_mode;
339
340 SET @@session.sql_mode= cast(pow(2,2) as unsigned integer);
341 SELECT @@session.sql_mode;
342 SET @@global.sql_mode= cast(pow(2,2) as unsigned integer);
343 SELECT @@global.sql_mode;
344
345 SET @@session.sql_mode= cast(pow(2,3) as unsigned integer);
346 SELECT @@session.sql_mode;
347 SET @@global.sql_mode= cast(pow(2,3) as unsigned integer);
348 SELECT @@global.sql_mode;
349
350 SET @@session.sql_mode= cast(pow(2,4) as unsigned integer);
351 SELECT @@session.sql_mode;
352 SET @@global.sql_mode= cast(pow(2,4) as unsigned integer);
353 SELECT @@global.sql_mode;
354
355 SET @@session.sql_mode= cast(pow(2,5) as unsigned integer);
356 SELECT @@session.sql_mode;
357 SET @@global.sql_mode= cast(pow(2,5) as unsigned integer);
358 SELECT @@global.sql_mode;
359
360 SET @@session.sql_mode= cast(pow(2,6) as unsigned integer);
361 SELECT @@session.sql_mode;
362 SET @@global.sql_mode= cast(pow(2,6) as unsigned integer);
363 SELECT @@global.sql_mode;
364
365 SET @@session.sql_mode= cast(pow(2,7) as unsigned integer);
366 SELECT @@session.sql_mode;
367 SET @@global.sql_mode= cast(pow(2,7) as unsigned integer);
368 SELECT @@global.sql_mode;
369
370 --error ER_UNSUPPORTED_SQL_MODE
371 SET @@session.sql_mode= cast(pow(2,8) as unsigned integer);
372 SELECT @@session.sql_mode;
373 --error ER_UNSUPPORTED_SQL_MODE
374 SET @@global.sql_mode= cast(pow(2,8) as unsigned integer);
375 SELECT @@global.sql_mode;
376
377 --error ER_UNSUPPORTED_SQL_MODE
378 SET @@session.sql_mode= cast(pow(2,9) as unsigned integer);
379 SELECT @@session.sql_mode;
380 --error ER_UNSUPPORTED_SQL_MODE
381 SET @@global.sql_mode= cast(pow(2,9) as unsigned integer);
382 SELECT @@global.sql_mode;
383
384 --error ER_UNSUPPORTED_SQL_MODE
385 SET @@session.sql_mode= cast(pow(2,10) as unsigned integer);
386 SELECT @@session.sql_mode;
387 --error ER_UNSUPPORTED_SQL_MODE
388 SET @@global.sql_mode= cast(pow(2,10) as unsigned integer);
389 SELECT @@global.sql_mode;
390
391 --error ER_UNSUPPORTED_SQL_MODE
392 SET @@session.sql_mode= cast(pow(2,11) as unsigned integer);
393 SELECT @@session.sql_mode;
394 --error ER_UNSUPPORTED_SQL_MODE
395 SET @@global.sql_mode= cast(pow(2,11) as unsigned integer);
396 SELECT @@global.sql_mode;
397
398 --error ER_UNSUPPORTED_SQL_MODE
399 SET @@session.sql_mode= cast(pow(2,12) as unsigned integer);
400 SELECT @@session.sql_mode;
401 --error ER_UNSUPPORTED_SQL_MODE
402 SET @@global.sql_mode= cast(pow(2,12) as unsigned integer);
403 SELECT @@global.sql_mode;
404
405 --error ER_UNSUPPORTED_SQL_MODE
406 SET @@session.sql_mode= cast(pow(2,13) as unsigned integer);
407 SELECT @@session.sql_mode;
408 --error ER_UNSUPPORTED_SQL_MODE
409 SET @@global.sql_mode= cast(pow(2,13) as unsigned integer);
410 SELECT @@global.sql_mode;
411
412 --error ER_UNSUPPORTED_SQL_MODE
413 SET @@session.sql_mode= cast(pow(2,14) as unsigned integer);
414 SELECT @@session.sql_mode;
415 --error ER_UNSUPPORTED_SQL_MODE
416 SET @@global.sql_mode= cast(pow(2,14) as unsigned integer);
417 SELECT @@global.sql_mode;
418
419 --error ER_UNSUPPORTED_SQL_MODE
420 SET @@session.sql_mode= cast(pow(2,15) as unsigned integer);
421 SELECT @@session.sql_mode;
422 --error ER_UNSUPPORTED_SQL_MODE
423 SET @@global.sql_mode= cast(pow(2,15) as unsigned integer);
424 SELECT @@global.sql_mode;
425
426 --error ER_UNSUPPORTED_SQL_MODE
427 SET @@session.sql_mode= cast(pow(2,16) as unsigned integer);
428 SELECT @@session.sql_mode;
429 --error ER_UNSUPPORTED_SQL_MODE
430 SET @@global.sql_mode= cast(pow(2,16) as unsigned integer);
431 SELECT @@global.sql_mode;
432
433 --error ER_UNSUPPORTED_SQL_MODE
434 SET @@session.sql_mode= cast(pow(2,17) as unsigned integer);
435 SELECT @@session.sql_mode;
436 --error ER_UNSUPPORTED_SQL_MODE
437 SET @@global.sql_mode= cast(pow(2,17) as unsigned integer);
438 SELECT @@global.sql_mode;
439
440 SET @@session.sql_mode= cast(pow(2,18) as unsigned integer);
441 SELECT @@session.sql_mode;
442 SET @@global.sql_mode= cast(pow(2,18) as unsigned integer);
443 SELECT @@global.sql_mode;
444
445 SET @@session.sql_mode= cast(pow(2,19) as unsigned integer);
446 SELECT @@session.sql_mode;
447 SET @@global.sql_mode= cast(pow(2,19) as unsigned integer);
448 SELECT @@global.sql_mode;
449
450 SET @@session.sql_mode= cast(pow(2,20) as unsigned integer);
451 SELECT @@session.sql_mode;
452 SET @@global.sql_mode= cast(pow(2,20) as unsigned integer);
453 SELECT @@global.sql_mode;
454
455 SET @@session.sql_mode= cast(pow(2,21) as unsigned integer);
456 SELECT @@session.sql_mode;
457 SET @@global.sql_mode= cast(pow(2,21) as unsigned integer);
458 SELECT @@global.sql_mode;
459
460 SET @@session.sql_mode= cast(pow(2,22) as unsigned integer);
461 SELECT @@session.sql_mode;
462 SET @@global.sql_mode= cast(pow(2,22) as unsigned integer);
463 SELECT @@global.sql_mode;
464
465 SET @@session.sql_mode= cast(pow(2,23) as unsigned integer);
466 SELECT @@session.sql_mode;
467 SET @@global.sql_mode= cast(pow(2,23) as unsigned integer);
468 SELECT @@global.sql_mode;
469
470 SET @@session.sql_mode= cast(pow(2,24) as unsigned integer);
471 SELECT @@session.sql_mode;
472 SET @@global.sql_mode= cast(pow(2,24) as unsigned integer);
473 SELECT @@global.sql_mode;
474
475 SET @@session.sql_mode= cast(pow(2,25) as unsigned integer);
476 SELECT @@session.sql_mode;
477 SET @@global.sql_mode= cast(pow(2,25) as unsigned integer);
478 SELECT @@global.sql_mode;
479
480 SET @@session.sql_mode= cast(pow(2,26) as unsigned integer);
481 SELECT @@session.sql_mode;
482 SET @@global.sql_mode= cast(pow(2,26) as unsigned integer);
483 SELECT @@global.sql_mode;
484
485 SET @@session.sql_mode= cast(pow(2,27) as unsigned integer);
486 SELECT @@session.sql_mode;
487 SET @@global.sql_mode= cast(pow(2,27) as unsigned integer);
488 SELECT @@global.sql_mode;
489
490 --error ER_UNSUPPORTED_SQL_MODE
491 SET @@session.sql_mode= cast(pow(2,28) as unsigned integer);
492 SELECT @@session.sql_mode;
493 --error ER_UNSUPPORTED_SQL_MODE
494 SET @@global.sql_mode= cast(pow(2,28) as unsigned integer);
495 SELECT @@global.sql_mode;
496
497 SET @@session.sql_mode= cast(pow(2,29) as unsigned integer);
498 SELECT @@session.sql_mode;
499 SET @@global.sql_mode= cast(pow(2,29) as unsigned integer);
500 SELECT @@global.sql_mode;
501
502 SET @@session.sql_mode= cast(pow(2,30) as unsigned integer);
503 SELECT @@session.sql_mode;
504 SET @@global.sql_mode= cast(pow(2,30) as unsigned integer);
505 SELECT @@global.sql_mode;
506
507 SET @@session.sql_mode= cast(pow(2,31) as unsigned integer);
508 SELECT @@session.sql_mode;
509 SET @@global.sql_mode= cast(pow(2,31) as unsigned integer);
510 SELECT @@global.sql_mode;
511
512 SET @@session.sql_mode= cast(pow(2,32) as unsigned integer);
513 SELECT @@session.sql_mode;
514 SET @@global.sql_mode= cast(pow(2,32) as unsigned integer);
515 SELECT @@global.sql_mode;
516
517 --echo #
518 --echo # Bug#27828236: ERROR 1231 WHEN 8.0 CLIENT TRIES TO READ THE OUTPUT OF
519 --echo # MYSQLBINLOG 5.7
520 --echo #
521
522 SET @@session.sql_mode = 0;
523
524 CREATE TABLE t1 (i INT);
525 CREATE TRIGGER trg1 BEFORE INSERT ON t1 FOR EACH ROW SET @@session.sql_mode=1436549152;
526 CREATE PROCEDURE p1() SET @@session.sql_mode=1436549152;
527
528 --echo # pseudo_replica_mode is "off", assignment should fail as before:
529
530 --error ER_UNSUPPORTED_SQL_MODE
531 SET @@session.sql_mode=1436549152;
532 SELECT @@session.sql_mode;
533
534 --error ER_UNSUPPORTED_SQL_MODE
535 INSERT INTO t1 VALUES (1);
536 SELECT @@session.sql_mode;
537
538 --error ER_UNSUPPORTED_SQL_MODE
539 CALL p1;
540 SELECT @@session.sql_mode;
541
542 --echo #
543
544 SET @session_pseudo_replica_mode = @@session.pseudo_replica_mode;
545 SET @@session.pseudo_replica_mode = TRUE;
546
547 --echo # pseudo_replica_mode is "on", assignment should succeed:
548
549 SET @@session.sql_mode=1436549152;
550 SELECT @@session.sql_mode;
551
552 --echo # ... but the assignment in SBR-invoked triggers should continue to fail:
553
554 SET @@session.sql_mode = 0;
555 --error ER_UNSUPPORTED_SQL_MODE
556 INSERT INTO t1 VALUES (1);
557 SELECT @@session.sql_mode;
558
559 --echo # ... and in procedure calls:
560
561 --error ER_UNSUPPORTED_SQL_MODE
562 CALL p1;
563 SELECT @@session.sql_mode;
564
565 # Cleanup
566
567 DROP PROCEDURE p1;
568 DROP TABLE t1;
569 SET @@session.pseudo_replica_mode = @session_pseudo_replica_mode;
570 SET @@session.sql_mode = DEFAULT;
571
572 ##############################
573 # Restore initial value #
574 ##############################
575
576 SET @@global.sql_mode = @global_start_value;
577 SELECT @@global.sql_mode;
578
579 SET @@session.sql_mode = @session_start_value;
580 SELECT @@session.sql_mode;
581
582 ################################################################
583 # END OF sql_mode TESTS #
584 ################################################################
585