Debian Codegraph @

mysql-test/suite/test_service_sql_api/r/test_sql_sqlmode.result

raw
1 SET @sql_mode_global = @@global.sql_mode;
2 SET @sql_mode_session = @@session.sql_mode;
3 CREATE TABLE t1(a varchar(20) not null, b varchar(20));
4 CREATE TABLE t2(a varchar(20) null, b varchar(20));
5 INSERT INTO t1 VALUES('t1a1','t1b1');
6 INSERT INTO t1 VALUES('t1a2','t1b2');
7 INSERT INTO t1 VALUES('t1a3','t1b3');
8 INSERT INTO t1 VALUES('t1a4','t1b4');
9 INSERT INTO t2 VALUES('t2a1','t2b1');
10 INSERT INTO t2 VALUES('t2a2','t2b2');
11 INSERT INTO t2 VALUES('t2a3','t2b3');
12 INSERT INTO t2 VALUES('t2a4','t2b4');
13 SET @@global.sql_mode = NO_UNSIGNED_SUBTRACTION;
14 SELECT @@global.sql_mode;
15 @@global.sql_mode
16 NO_UNSIGNED_SUBTRACTION
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 ##########################################
21 # Run plugin
22 ##########################################
23 INSTALL PLUGIN test_sql_sqlmode SONAME 'TEST_SQL_SQLMODE';
24 ##########################################
25 # Stop plugin
26 ##########################################
27 UNINSTALL PLUGIN test_sql_sqlmode;
28 ##########################################
29 # Plugin log
30 ##########################################
31 ========================================================================
32 Test in a server thread
33 [srv_session_open]
34 ------------------------------------------------------------------
35 EXECUTING:[35][SELECT 'first complex command' as a]
36 [CS_TEXT_REPRESENTATION]
37 [meta] rows: 1
38 [meta] cols: 1
39 [meta] server status: 2
40 [meta] server status: AUTOCOMMIT
41 [meta] warning count: 0
42
43 [meta][field] db name:
44 [meta][field] table name:
45 [meta][field] org table name:
46 [meta][field] col name: a
47 [meta][field] org col name:
48 [meta][field] length: 63
49 [meta][field] charsetnr: 33
50 [meta][field] flags: 1 (NOT_NULL )
51 [meta][field] decimals: 31
52 [meta][field] type: VARCHAR (15)
53
54
55 [meta][charset result] number: 33
56 [meta][charset result] name: utf8mb3
57 [meta][charset result] collation: utf8mb3_general_ci
58 [meta][charset result] sort order:
59
60 [data][.a][ 21][first complex command]
61
62 [end] server status: 2
63 [end] server status: AUTOCOMMIT
64 [end] warning count: 0
65 [end] affected rows: 0
66 [end] last insert id: 0
67 [end] message:
68 [CS_BINARY_REPRESENTATION]
69 [meta] rows: 1
70 [meta] cols: 1
71 [meta] server status: 2
72 [meta] server status: AUTOCOMMIT
73 [meta] warning count: 0
74
75 [meta][field] db name:
76 [meta][field] table name:
77 [meta][field] org table name:
78 [meta][field] col name: a
79 [meta][field] org col name:
80 [meta][field] length: 63
81 [meta][field] charsetnr: 33
82 [meta][field] flags: 1 (NOT_NULL )
83 [meta][field] decimals: 31
84 [meta][field] type: VARCHAR (15)
85
86
87 [meta][charset result] number: 33
88 [meta][charset result] name: utf8mb3
89 [meta][charset result] collation: utf8mb3_general_ci
90 [meta][charset result] sort order:
91
92 [data][.a][ 21][first complex command]
93
94 [end] server status: 2
95 [end] server status: AUTOCOMMIT
96 [end] warning count: 0
97 [end] affected rows: 0
98 [end] last insert id: 0
99 [end] message:
100 ------------------------------------------------------------------
101 EXECUTING:[24][SELECT @@global.sql_mode]
102 [CS_TEXT_REPRESENTATION]
103 [meta] rows: 1
104 [meta] cols: 1
105 [meta] server status: 2
106 [meta] server status: AUTOCOMMIT
107 [meta] warning count: 0
108
109 [meta][field] db name:
110 [meta][field] table name:
111 [meta][field] org table name:
112 [meta][field] col name: @@global.sql_mode
113 [meta][field] org col name:
114 [meta][field] length: 65535
115 [meta][field] charsetnr: 33
116 [meta][field] flags: 0
117 [meta][field] decimals: 31
118 [meta][field] type: VARCHAR (15)
119
120
121 [meta][charset result] number: 33
122 [meta][charset result] name: utf8mb3
123 [meta][charset result] collation: utf8mb3_general_ci
124 [meta][charset result] sort order:
125
126 [data][.@@global.sql_mode][ 23][NO_UNSIGNED_SUBTRACTION]
127
128 [end] server status: 2
129 [end] server status: AUTOCOMMIT
130 [end] warning count: 0
131 [end] affected rows: 0
132 [end] last insert id: 0
133 [end] message:
134 [CS_BINARY_REPRESENTATION]
135 [meta] rows: 1
136 [meta] cols: 1
137 [meta] server status: 2
138 [meta] server status: AUTOCOMMIT
139 [meta] warning count: 0
140
141 [meta][field] db name:
142 [meta][field] table name:
143 [meta][field] org table name:
144 [meta][field] col name: @@global.sql_mode
145 [meta][field] org col name:
146 [meta][field] length: 65535
147 [meta][field] charsetnr: 33
148 [meta][field] flags: 0
149 [meta][field] decimals: 31
150 [meta][field] type: VARCHAR (15)
151
152
153 [meta][charset result] number: 33
154 [meta][charset result] name: utf8mb3
155 [meta][charset result] collation: utf8mb3_general_ci
156 [meta][charset result] sort order:
157
158 [data][.@@global.sql_mode][ 23][NO_UNSIGNED_SUBTRACTION]
159
160 [end] server status: 2
161 [end] server status: AUTOCOMMIT
162 [end] warning count: 0
163 [end] affected rows: 0
164 [end] last insert id: 0
165 [end] message:
166 ------------------------------------------------------------------
167 EXECUTING:[25][SELECT @@session.sql_mode]
168 [CS_TEXT_REPRESENTATION]
169 [meta] rows: 1
170 [meta] cols: 1
171 [meta] server status: 2
172 [meta] server status: AUTOCOMMIT
173 [meta] warning count: 0
174
175 [meta][field] db name:
176 [meta][field] table name:
177 [meta][field] org table name:
178 [meta][field] col name: @@session.sql_mode
179 [meta][field] org col name:
180 [meta][field] length: 65535
181 [meta][field] charsetnr: 33
182 [meta][field] flags: 0
183 [meta][field] decimals: 31
184 [meta][field] type: VARCHAR (15)
185
186
187 [meta][charset result] number: 33
188 [meta][charset result] name: utf8mb3
189 [meta][charset result] collation: utf8mb3_general_ci
190 [meta][charset result] sort order:
191
192 [data][.@@session.sql_mode][ 23][NO_UNSIGNED_SUBTRACTION]
193
194 [end] server status: 2
195 [end] server status: AUTOCOMMIT
196 [end] warning count: 0
197 [end] affected rows: 0
198 [end] last insert id: 0
199 [end] message:
200 [CS_BINARY_REPRESENTATION]
201 [meta] rows: 1
202 [meta] cols: 1
203 [meta] server status: 2
204 [meta] server status: AUTOCOMMIT
205 [meta] warning count: 0
206
207 [meta][field] db name:
208 [meta][field] table name:
209 [meta][field] org table name:
210 [meta][field] col name: @@session.sql_mode
211 [meta][field] org col name:
212 [meta][field] length: 65535
213 [meta][field] charsetnr: 33
214 [meta][field] flags: 0
215 [meta][field] decimals: 31
216 [meta][field] type: VARCHAR (15)
217
218
219 [meta][charset result] number: 33
220 [meta][charset result] name: utf8mb3
221 [meta][charset result] collation: utf8mb3_general_ci
222 [meta][charset result] sort order:
223
224 [data][.@@session.sql_mode][ 23][NO_UNSIGNED_SUBTRACTION]
225
226 [end] server status: 2
227 [end] server status: AUTOCOMMIT
228 [end] warning count: 0
229 [end] affected rows: 0
230 [end] last insert id: 0
231 [end] message:
232 ------------------------------------------------------------------
233 EXECUTING:[42][SET @@session.sql_mode = @@global.sql_mode]
234 [CS_TEXT_REPRESENTATION]
235 [meta] rows: 0
236 [meta] cols: 0
237 [meta] server status: 0
238 [meta] server status:
239 [meta] warning count: 0
240
241 [meta] no columns
242
243 [meta] no charset
244
245 [data] no rows
246
247 [end] server status: 2
248 [end] server status: AUTOCOMMIT
249 [end] warning count: 0
250 [end] affected rows: 0
251 [end] last insert id: 0
252 [end] message:
253 ------------------------------------------------------------------
254 EXECUTING:[24][SELECT @@global.sql_mode]
255 [CS_TEXT_REPRESENTATION]
256 [meta] rows: 1
257 [meta] cols: 1
258 [meta] server status: 2
259 [meta] server status: AUTOCOMMIT
260 [meta] warning count: 0
261
262 [meta][field] db name:
263 [meta][field] table name:
264 [meta][field] org table name:
265 [meta][field] col name: @@global.sql_mode
266 [meta][field] org col name:
267 [meta][field] length: 65535
268 [meta][field] charsetnr: 33
269 [meta][field] flags: 0
270 [meta][field] decimals: 31
271 [meta][field] type: VARCHAR (15)
272
273
274 [meta][charset result] number: 33
275 [meta][charset result] name: utf8mb3
276 [meta][charset result] collation: utf8mb3_general_ci
277 [meta][charset result] sort order:
278
279 [data][.@@global.sql_mode][ 23][NO_UNSIGNED_SUBTRACTION]
280
281 [end] server status: 2
282 [end] server status: AUTOCOMMIT
283 [end] warning count: 0
284 [end] affected rows: 0
285 [end] last insert id: 0
286 [end] message:
287 [CS_BINARY_REPRESENTATION]
288 [meta] rows: 1
289 [meta] cols: 1
290 [meta] server status: 2
291 [meta] server status: AUTOCOMMIT
292 [meta] warning count: 0
293
294 [meta][field] db name:
295 [meta][field] table name:
296 [meta][field] org table name:
297 [meta][field] col name: @@global.sql_mode
298 [meta][field] org col name:
299 [meta][field] length: 65535
300 [meta][field] charsetnr: 33
301 [meta][field] flags: 0
302 [meta][field] decimals: 31
303 [meta][field] type: VARCHAR (15)
304
305
306 [meta][charset result] number: 33
307 [meta][charset result] name: utf8mb3
308 [meta][charset result] collation: utf8mb3_general_ci
309 [meta][charset result] sort order:
310
311 [data][.@@global.sql_mode][ 23][NO_UNSIGNED_SUBTRACTION]
312
313 [end] server status: 2
314 [end] server status: AUTOCOMMIT
315 [end] warning count: 0
316 [end] affected rows: 0
317 [end] last insert id: 0
318 [end] message:
319 ------------------------------------------------------------------
320 EXECUTING:[25][SELECT @@session.sql_mode]
321 [CS_TEXT_REPRESENTATION]
322 [meta] rows: 1
323 [meta] cols: 1
324 [meta] server status: 2
325 [meta] server status: AUTOCOMMIT
326 [meta] warning count: 0
327
328 [meta][field] db name:
329 [meta][field] table name:
330 [meta][field] org table name:
331 [meta][field] col name: @@session.sql_mode
332 [meta][field] org col name:
333 [meta][field] length: 65535
334 [meta][field] charsetnr: 33
335 [meta][field] flags: 0
336 [meta][field] decimals: 31
337 [meta][field] type: VARCHAR (15)
338
339
340 [meta][charset result] number: 33
341 [meta][charset result] name: utf8mb3
342 [meta][charset result] collation: utf8mb3_general_ci
343 [meta][charset result] sort order:
344
345 [data][.@@session.sql_mode][ 23][NO_UNSIGNED_SUBTRACTION]
346
347 [end] server status: 2
348 [end] server status: AUTOCOMMIT
349 [end] warning count: 0
350 [end] affected rows: 0
351 [end] last insert id: 0
352 [end] message:
353 [CS_BINARY_REPRESENTATION]
354 [meta] rows: 1
355 [meta] cols: 1
356 [meta] server status: 2
357 [meta] server status: AUTOCOMMIT
358 [meta] warning count: 0
359
360 [meta][field] db name:
361 [meta][field] table name:
362 [meta][field] org table name:
363 [meta][field] col name: @@session.sql_mode
364 [meta][field] org col name:
365 [meta][field] length: 65535
366 [meta][field] charsetnr: 33
367 [meta][field] flags: 0
368 [meta][field] decimals: 31
369 [meta][field] type: VARCHAR (15)
370
371
372 [meta][charset result] number: 33
373 [meta][charset result] name: utf8mb3
374 [meta][charset result] collation: utf8mb3_general_ci
375 [meta][charset result] sort order:
376
377 [data][.@@session.sql_mode][ 23][NO_UNSIGNED_SUBTRACTION]
378
379 [end] server status: 2
380 [end] server status: AUTOCOMMIT
381 [end] warning count: 0
382 [end] affected rows: 0
383 [end] last insert id: 0
384 [end] message:
385 ------------------------------------------------------------------
386 EXECUTING:[30][SELECT CAST(0 AS UNSIGNED) - 1]
387 [CS_TEXT_REPRESENTATION]
388 [meta] rows: 1
389 [meta] cols: 1
390 [meta] server status: 2
391 [meta] server status: AUTOCOMMIT
392 [meta] warning count: 0
393
394 [meta][field] db name:
395 [meta][field] table name:
396 [meta][field] org table name:
397 [meta][field] col name: CAST(0 AS UNSIGNED) - 1
398 [meta][field] org col name:
399 [meta][field] length: 22
400 [meta][field] charsetnr: 8
401 [meta][field] flags: 129 (NOT_NULL BINARY )
402 [meta][field] decimals: 0
403 [meta][field] type: LONGLONG (8)
404
405
406 [meta][charset result] number: 33
407 [meta][charset result] name: utf8mb3
408 [meta][charset result] collation: utf8mb3_general_ci
409 [meta][charset result] sort order:
410
411 [data][.CAST(0 AS UNSIGNED) - 1][ 2][-1]
412
413 [end] server status: 2
414 [end] server status: AUTOCOMMIT
415 [end] warning count: 0
416 [end] affected rows: 0
417 [end] last insert id: 0
418 [end] message:
419 [CS_BINARY_REPRESENTATION]
420 [meta] rows: 1
421 [meta] cols: 1
422 [meta] server status: 2
423 [meta] server status: AUTOCOMMIT
424 [meta] warning count: 0
425
426 [meta][field] db name:
427 [meta][field] table name:
428 [meta][field] org table name:
429 [meta][field] col name: CAST(0 AS UNSIGNED) - 1
430 [meta][field] org col name:
431 [meta][field] length: 22
432 [meta][field] charsetnr: 8
433 [meta][field] flags: 129 (NOT_NULL BINARY )
434 [meta][field] decimals: 0
435 [meta][field] type: LONGLONG (8)
436
437
438 [meta][charset result] number: 33
439 [meta][charset result] name: utf8mb3
440 [meta][charset result] collation: utf8mb3_general_ci
441 [meta][charset result] sort order:
442
443 [data][.CAST(0 AS UNSIGNED) - 1][ 2][-1]
444
445 [end] server status: 2
446 [end] server status: AUTOCOMMIT
447 [end] warning count: 0
448 [end] affected rows: 0
449 [end] last insert id: 0
450 [end] message:
451 ------------------------------------------------------------------
452 EXECUTING:[36][SET @@global.sql_mode = NO_ZERO_DATE]
453 [CS_TEXT_REPRESENTATION]
454 [meta] rows: 0
455 [meta] cols: 0
456 [meta] server status: 0
457 [meta] server status:
458 [meta] warning count: 0
459
460 [meta] no columns
461
462 [meta] no charset
463
464 [data] no rows
465
466 [end] server status: 2
467 [end] server status: AUTOCOMMIT
468 [end] warning count: 1
469 [end] affected rows: 0
470 [end] last insert id: 0
471 [end] message:
472 ------------------------------------------------------------------
473 EXECUTING:[37][SET @@session.sql_mode = NO_ZERO_DATE]
474 [CS_TEXT_REPRESENTATION]
475 [meta] rows: 0
476 [meta] cols: 0
477 [meta] server status: 0
478 [meta] server status:
479 [meta] warning count: 0
480
481 [meta] no columns
482
483 [meta] no charset
484
485 [data] no rows
486
487 [end] server status: 2
488 [end] server status: AUTOCOMMIT
489 [end] warning count: 1
490 [end] affected rows: 0
491 [end] last insert id: 0
492 [end] message:
493 ------------------------------------------------------------------
494 EXECUTING:[24][SELECT @@global.sql_mode]
495 [CS_TEXT_REPRESENTATION]
496 [meta] rows: 1
497 [meta] cols: 1
498 [meta] server status: 2
499 [meta] server status: AUTOCOMMIT
500 [meta] warning count: 0
501
502 [meta][field] db name:
503 [meta][field] table name:
504 [meta][field] org table name:
505 [meta][field] col name: @@global.sql_mode
506 [meta][field] org col name:
507 [meta][field] length: 65535
508 [meta][field] charsetnr: 33
509 [meta][field] flags: 0
510 [meta][field] decimals: 31
511 [meta][field] type: VARCHAR (15)
512
513
514 [meta][charset result] number: 33
515 [meta][charset result] name: utf8mb3
516 [meta][charset result] collation: utf8mb3_general_ci
517 [meta][charset result] sort order:
518
519 [data][.@@global.sql_mode][ 12][NO_ZERO_DATE]
520
521 [end] server status: 2
522 [end] server status: AUTOCOMMIT
523 [end] warning count: 0
524 [end] affected rows: 0
525 [end] last insert id: 0
526 [end] message:
527 [CS_BINARY_REPRESENTATION]
528 [meta] rows: 1
529 [meta] cols: 1
530 [meta] server status: 2
531 [meta] server status: AUTOCOMMIT
532 [meta] warning count: 0
533
534 [meta][field] db name:
535 [meta][field] table name:
536 [meta][field] org table name:
537 [meta][field] col name: @@global.sql_mode
538 [meta][field] org col name:
539 [meta][field] length: 65535
540 [meta][field] charsetnr: 33
541 [meta][field] flags: 0
542 [meta][field] decimals: 31
543 [meta][field] type: VARCHAR (15)
544
545
546 [meta][charset result] number: 33
547 [meta][charset result] name: utf8mb3
548 [meta][charset result] collation: utf8mb3_general_ci
549 [meta][charset result] sort order:
550
551 [data][.@@global.sql_mode][ 12][NO_ZERO_DATE]
552
553 [end] server status: 2
554 [end] server status: AUTOCOMMIT
555 [end] warning count: 0
556 [end] affected rows: 0
557 [end] last insert id: 0
558 [end] message:
559 ------------------------------------------------------------------
560 EXECUTING:[25][SELECT @@session.sql_mode]
561 [CS_TEXT_REPRESENTATION]
562 [meta] rows: 1
563 [meta] cols: 1
564 [meta] server status: 2
565 [meta] server status: AUTOCOMMIT
566 [meta] warning count: 0
567
568 [meta][field] db name:
569 [meta][field] table name:
570 [meta][field] org table name:
571 [meta][field] col name: @@session.sql_mode
572 [meta][field] org col name:
573 [meta][field] length: 65535
574 [meta][field] charsetnr: 33
575 [meta][field] flags: 0
576 [meta][field] decimals: 31
577 [meta][field] type: VARCHAR (15)
578
579
580 [meta][charset result] number: 33
581 [meta][charset result] name: utf8mb3
582 [meta][charset result] collation: utf8mb3_general_ci
583 [meta][charset result] sort order:
584
585 [data][.@@session.sql_mode][ 12][NO_ZERO_DATE]
586
587 [end] server status: 2
588 [end] server status: AUTOCOMMIT
589 [end] warning count: 0
590 [end] affected rows: 0
591 [end] last insert id: 0
592 [end] message:
593 [CS_BINARY_REPRESENTATION]
594 [meta] rows: 1
595 [meta] cols: 1
596 [meta] server status: 2
597 [meta] server status: AUTOCOMMIT
598 [meta] warning count: 0
599
600 [meta][field] db name:
601 [meta][field] table name:
602 [meta][field] org table name:
603 [meta][field] col name: @@session.sql_mode
604 [meta][field] org col name:
605 [meta][field] length: 65535
606 [meta][field] charsetnr: 33
607 [meta][field] flags: 0
608 [meta][field] decimals: 31
609 [meta][field] type: VARCHAR (15)
610
611
612 [meta][charset result] number: 33
613 [meta][charset result] name: utf8mb3
614 [meta][charset result] collation: utf8mb3_general_ci
615 [meta][charset result] sort order:
616
617 [data][.@@session.sql_mode][ 12][NO_ZERO_DATE]
618
619 [end] server status: 2
620 [end] server status: AUTOCOMMIT
621 [end] warning count: 0
622 [end] affected rows: 0
623 [end] last insert id: 0
624 [end] message:
625 ------------------------------------------------------------------
626 EXECUTING:[31][SET @@global.sql_mode = DEFAULT]
627 [CS_TEXT_REPRESENTATION]
628 [meta] rows: 0
629 [meta] cols: 0
630 [meta] server status: 0
631 [meta] server status:
632 [meta] warning count: 0
633
634 [meta] no columns
635
636 [meta] no charset
637
638 [data] no rows
639
640 [end] server status: 2
641 [end] server status: AUTOCOMMIT
642 [end] warning count: 0
643 [end] affected rows: 0
644 [end] last insert id: 0
645 [end] message:
646 ------------------------------------------------------------------
647 EXECUTING:[32][SET @@session.sql_mode = DEFAULT]
648 [CS_TEXT_REPRESENTATION]
649 [meta] rows: 0
650 [meta] cols: 0
651 [meta] server status: 0
652 [meta] server status:
653 [meta] warning count: 0
654
655 [meta] no columns
656
657 [meta] no charset
658
659 [data] no rows
660
661 [end] server status: 2
662 [end] server status: AUTOCOMMIT
663 [end] warning count: 0
664 [end] affected rows: 0
665 [end] last insert id: 0
666 [end] message:
667 ------------------------------------------------------------------
668 EXECUTING:[24][SELECT @@global.sql_mode]
669 [CS_TEXT_REPRESENTATION]
670 [meta] rows: 1
671 [meta] cols: 1
672 [meta] server status: 2
673 [meta] server status: AUTOCOMMIT
674 [meta] warning count: 0
675
676 [meta][field] db name:
677 [meta][field] table name:
678 [meta][field] org table name:
679 [meta][field] col name: @@global.sql_mode
680 [meta][field] org col name:
681 [meta][field] length: 65535
682 [meta][field] charsetnr: 33
683 [meta][field] flags: 0
684 [meta][field] decimals: 31
685 [meta][field] type: VARCHAR (15)
686
687
688 [meta][charset result] number: 33
689 [meta][charset result] name: utf8mb3
690 [meta][charset result] collation: utf8mb3_general_ci
691 [meta][charset result] sort order:
692
693 [data][.@@global.sql_mode][117][ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION]
694
695 [end] server status: 2
696 [end] server status: AUTOCOMMIT
697 [end] warning count: 0
698 [end] affected rows: 0
699 [end] last insert id: 0
700 [end] message:
701 [CS_BINARY_REPRESENTATION]
702 [meta] rows: 1
703 [meta] cols: 1
704 [meta] server status: 2
705 [meta] server status: AUTOCOMMIT
706 [meta] warning count: 0
707
708 [meta][field] db name:
709 [meta][field] table name:
710 [meta][field] org table name:
711 [meta][field] col name: @@global.sql_mode
712 [meta][field] org col name:
713 [meta][field] length: 65535
714 [meta][field] charsetnr: 33
715 [meta][field] flags: 0
716 [meta][field] decimals: 31
717 [meta][field] type: VARCHAR (15)
718
719
720 [meta][charset result] number: 33
721 [meta][charset result] name: utf8mb3
722 [meta][charset result] collation: utf8mb3_general_ci
723 [meta][charset result] sort order:
724
725 [data][.@@global.sql_mode][117][ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION]
726
727 [end] server status: 2
728 [end] server status: AUTOCOMMIT
729 [end] warning count: 0
730 [end] affected rows: 0
731 [end] last insert id: 0
732 [end] message:
733 ------------------------------------------------------------------
734 EXECUTING:[25][SELECT @@session.sql_mode]
735 [CS_TEXT_REPRESENTATION]
736 [meta] rows: 1
737 [meta] cols: 1
738 [meta] server status: 2
739 [meta] server status: AUTOCOMMIT
740 [meta] warning count: 0
741
742 [meta][field] db name:
743 [meta][field] table name:
744 [meta][field] org table name:
745 [meta][field] col name: @@session.sql_mode
746 [meta][field] org col name:
747 [meta][field] length: 65535
748 [meta][field] charsetnr: 33
749 [meta][field] flags: 0
750 [meta][field] decimals: 31
751 [meta][field] type: VARCHAR (15)
752
753
754 [meta][charset result] number: 33
755 [meta][charset result] name: utf8mb3
756 [meta][charset result] collation: utf8mb3_general_ci
757 [meta][charset result] sort order:
758
759 [data][.@@session.sql_mode][117][ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION]
760
761 [end] server status: 2
762 [end] server status: AUTOCOMMIT
763 [end] warning count: 0
764 [end] affected rows: 0
765 [end] last insert id: 0
766 [end] message:
767 [CS_BINARY_REPRESENTATION]
768 [meta] rows: 1
769 [meta] cols: 1
770 [meta] server status: 2
771 [meta] server status: AUTOCOMMIT
772 [meta] warning count: 0
773
774 [meta][field] db name:
775 [meta][field] table name:
776 [meta][field] org table name:
777 [meta][field] col name: @@session.sql_mode
778 [meta][field] org col name:
779 [meta][field] length: 65535
780 [meta][field] charsetnr: 33
781 [meta][field] flags: 0
782 [meta][field] decimals: 31
783 [meta][field] type: VARCHAR (15)
784
785
786 [meta][charset result] number: 33
787 [meta][charset result] name: utf8mb3
788 [meta][charset result] collation: utf8mb3_general_ci
789 [meta][charset result] sort order:
790
791 [data][.@@session.sql_mode][117][ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION]
792
793 [end] server status: 2
794 [end] server status: AUTOCOMMIT
795 [end] warning count: 0
796 [end] affected rows: 0
797 [end] last insert id: 0
798 [end] message:
799 ------------------------------------------------------------------
800 EXECUTING:[COM_INIT_DB][test]
801 ------------------------------------------------------------------
802 EXECUTING:[57][SELECT * FROM t1 WHERE t1.a IN (SELECT MAX(t1.b) FROM t2)]
803 [CS_TEXT_REPRESENTATION]
804 [meta] rows: 0
805 [meta] cols: 2
806 [meta] server status: 34
807 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
808 [meta] warning count: 0
809
810 [meta][field] db name: test
811 [meta][field] table name: t1
812 [meta][field] org table name: t1
813 [meta][field] col name: a
814 [meta][field] org col name: a
815 [meta][field] length: 80
816 [meta][field] charsetnr: 255
817 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
818 [meta][field] decimals: 0
819 [meta][field] type: VARCHAR (15)
820
821 [meta][field] db name: test
822 [meta][field] table name: t1
823 [meta][field] org table name: t1
824 [meta][field] col name: b
825 [meta][field] org col name: b
826 [meta][field] length: 80
827 [meta][field] charsetnr: 255
828 [meta][field] flags: 0
829 [meta][field] decimals: 0
830 [meta][field] type: VARCHAR (15)
831
832
833 [meta][charset result] number: 33
834 [meta][charset result] name: utf8mb3
835 [meta][charset result] collation: utf8mb3_general_ci
836 [meta][charset result] sort order:
837
838 [data] no rows
839
840 [end] server status: 34
841 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
842 [end] warning count: 0
843 [end] affected rows: 0
844 [end] last insert id: 0
845 [end] message:
846 [CS_BINARY_REPRESENTATION]
847 [meta] rows: 0
848 [meta] cols: 2
849 [meta] server status: 34
850 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
851 [meta] warning count: 0
852
853 [meta][field] db name: test
854 [meta][field] table name: t1
855 [meta][field] org table name: t1
856 [meta][field] col name: a
857 [meta][field] org col name: a
858 [meta][field] length: 80
859 [meta][field] charsetnr: 255
860 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
861 [meta][field] decimals: 0
862 [meta][field] type: VARCHAR (15)
863
864 [meta][field] db name: test
865 [meta][field] table name: t1
866 [meta][field] org table name: t1
867 [meta][field] col name: b
868 [meta][field] org col name: b
869 [meta][field] length: 80
870 [meta][field] charsetnr: 255
871 [meta][field] flags: 0
872 [meta][field] decimals: 0
873 [meta][field] type: VARCHAR (15)
874
875
876 [meta][charset result] number: 33
877 [meta][charset result] name: utf8mb3
878 [meta][charset result] collation: utf8mb3_general_ci
879 [meta][charset result] sort order:
880
881 [data] no rows
882
883 [end] server status: 34
884 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
885 [end] warning count: 0
886 [end] affected rows: 0
887 [end] last insert id: 0
888 [end] message:
889 ------------------------------------------------------------------
890 EXECUTING:[29][SET @@session.sql_mode = ANSI]
891 [CS_TEXT_REPRESENTATION]
892 [meta] rows: 0
893 [meta] cols: 0
894 [meta] server status: 0
895 [meta] server status:
896 [meta] warning count: 0
897
898 [meta] no columns
899
900 [meta] no charset
901
902 [data] no rows
903
904 [end] server status: 2
905 [end] server status: AUTOCOMMIT
906 [end] warning count: 0
907 [end] affected rows: 0
908 [end] last insert id: 0
909 [end] message:
910 ------------------------------------------------------------------
911 EXECUTING:[25][SELECT @@session.sql_mode]
912 [CS_TEXT_REPRESENTATION]
913 [meta] rows: 1
914 [meta] cols: 1
915 [meta] server status: 2
916 [meta] server status: AUTOCOMMIT
917 [meta] warning count: 0
918
919 [meta][field] db name:
920 [meta][field] table name:
921 [meta][field] org table name:
922 [meta][field] col name: @@session.sql_mode
923 [meta][field] org col name:
924 [meta][field] length: 65535
925 [meta][field] charsetnr: 33
926 [meta][field] flags: 0
927 [meta][field] decimals: 31
928 [meta][field] type: VARCHAR (15)
929
930
931 [meta][charset result] number: 33
932 [meta][charset result] name: utf8mb3
933 [meta][charset result] collation: utf8mb3_general_ci
934 [meta][charset result] sort order:
935
936 [data][.@@session.sql_mode][ 78][REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,ANSI]
937
938 [end] server status: 2
939 [end] server status: AUTOCOMMIT
940 [end] warning count: 0
941 [end] affected rows: 0
942 [end] last insert id: 0
943 [end] message:
944 [CS_BINARY_REPRESENTATION]
945 [meta] rows: 1
946 [meta] cols: 1
947 [meta] server status: 2
948 [meta] server status: AUTOCOMMIT
949 [meta] warning count: 0
950
951 [meta][field] db name:
952 [meta][field] table name:
953 [meta][field] org table name:
954 [meta][field] col name: @@session.sql_mode
955 [meta][field] org col name:
956 [meta][field] length: 65535
957 [meta][field] charsetnr: 33
958 [meta][field] flags: 0
959 [meta][field] decimals: 31
960 [meta][field] type: VARCHAR (15)
961
962
963 [meta][charset result] number: 33
964 [meta][charset result] name: utf8mb3
965 [meta][charset result] collation: utf8mb3_general_ci
966 [meta][charset result] sort order:
967
968 [data][.@@session.sql_mode][ 78][REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,ANSI]
969
970 [end] server status: 2
971 [end] server status: AUTOCOMMIT
972 [end] warning count: 0
973 [end] affected rows: 0
974 [end] last insert id: 0
975 [end] message:
976 ------------------------------------------------------------------
977 EXECUTING:[COM_INIT_DB][test]
978 ------------------------------------------------------------------
979 EXECUTING:[57][SELECT * FROM t1 WHERE t1.a IN (SELECT MAX(t1.b) FROM t2)]
980 [CS_TEXT_REPRESENTATION]
981 [1111][HY000][Invalid use of group function]
982 [meta] rows: 0
983 [meta] cols: 0
984 [meta] server status: 0
985 [meta] server status:
986 [meta] warning count: 0
987
988 [meta] no columns
989
990 [meta] no charset
991
992 [data] no rows
993
994 [end] server status: 0
995 [end] server status:
996 [end] warning count: 0
997 [end] affected rows: 0
998 [end] last insert id: 0
999 [end] message:
1000 [CS_BINARY_REPRESENTATION]
1001 [1111][HY000][Invalid use of group function]
1002 [meta] rows: 0
1003 [meta] cols: 0
1004 [meta] server status: 0
1005 [meta] server status:
1006 [meta] warning count: 0
1007
1008 [meta] no columns
1009
1010 [meta] no charset
1011
1012 [data] no rows
1013
1014 [end] server status: 0
1015 [end] server status:
1016 [end] warning count: 0
1017 [end] affected rows: 0
1018 [end] last insert id: 0
1019 [end] message:
1020 ------------------------------------------------------------------
1021 EXECUTING:[COM_INIT_DB][test]
1022 ------------------------------------------------------------------
1023 EXECUTING:[44][SET @@session.sql_mode = STRICT_TRANS_TABLES]
1024 [CS_TEXT_REPRESENTATION]
1025 [meta] rows: 0
1026 [meta] cols: 0
1027 [meta] server status: 0
1028 [meta] server status:
1029 [meta] warning count: 0
1030
1031 [meta] no columns
1032
1033 [meta] no charset
1034
1035 [data] no rows
1036
1037 [end] server status: 2
1038 [end] server status: AUTOCOMMIT
1039 [end] warning count: 1
1040 [end] affected rows: 0
1041 [end] last insert id: 0
1042 [end] message:
1043 ------------------------------------------------------------------
1044 EXECUTING:[25][SELECT @@session.sql_mode]
1045 [CS_TEXT_REPRESENTATION]
1046 [meta] rows: 1
1047 [meta] cols: 1
1048 [meta] server status: 2
1049 [meta] server status: AUTOCOMMIT
1050 [meta] warning count: 0
1051
1052 [meta][field] db name:
1053 [meta][field] table name:
1054 [meta][field] org table name:
1055 [meta][field] col name: @@session.sql_mode
1056 [meta][field] org col name:
1057 [meta][field] length: 65535
1058 [meta][field] charsetnr: 33
1059 [meta][field] flags: 0
1060 [meta][field] decimals: 31
1061 [meta][field] type: VARCHAR (15)
1062
1063
1064 [meta][charset result] number: 33
1065 [meta][charset result] name: utf8mb3
1066 [meta][charset result] collation: utf8mb3_general_ci
1067 [meta][charset result] sort order:
1068
1069 [data][.@@session.sql_mode][ 19][STRICT_TRANS_TABLES]
1070
1071 [end] server status: 2
1072 [end] server status: AUTOCOMMIT
1073 [end] warning count: 0
1074 [end] affected rows: 0
1075 [end] last insert id: 0
1076 [end] message:
1077 [CS_BINARY_REPRESENTATION]
1078 [meta] rows: 1
1079 [meta] cols: 1
1080 [meta] server status: 2
1081 [meta] server status: AUTOCOMMIT
1082 [meta] warning count: 0
1083
1084 [meta][field] db name:
1085 [meta][field] table name:
1086 [meta][field] org table name:
1087 [meta][field] col name: @@session.sql_mode
1088 [meta][field] org col name:
1089 [meta][field] length: 65535
1090 [meta][field] charsetnr: 33
1091 [meta][field] flags: 0
1092 [meta][field] decimals: 31
1093 [meta][field] type: VARCHAR (15)
1094
1095
1096 [meta][charset result] number: 33
1097 [meta][charset result] name: utf8mb3
1098 [meta][charset result] collation: utf8mb3_general_ci
1099 [meta][charset result] sort order:
1100
1101 [data][.@@session.sql_mode][ 19][STRICT_TRANS_TABLES]
1102
1103 [end] server status: 2
1104 [end] server status: AUTOCOMMIT
1105 [end] warning count: 0
1106 [end] affected rows: 0
1107 [end] last insert id: 0
1108 [end] message:
1109 ------------------------------------------------------------------
1110 EXECUTING:[COM_INIT_DB][test]
1111 ------------------------------------------------------------------
1112 EXECUTING:[34][INSERT INTO t2 VALUES(NULL,'t2b1')]
1113 [CS_TEXT_REPRESENTATION]
1114 [meta] rows: 0
1115 [meta] cols: 0
1116 [meta] server status: 0
1117 [meta] server status:
1118 [meta] warning count: 0
1119
1120 [meta] no columns
1121
1122 [meta] no charset
1123
1124 [data] no rows
1125
1126 [end] server status: 2
1127 [end] server status: AUTOCOMMIT
1128 [end] warning count: 0
1129 [end] affected rows: 1
1130 [end] last insert id: 0
1131 [end] message:
1132 ------------------------------------------------------------------
1133 EXECUTING:[COM_INIT_DB][test]
1134 ------------------------------------------------------------------
1135 EXECUTING:[31][INSERT INTO t1 SELECT * FROM t2]
1136 [CS_TEXT_REPRESENTATION]
1137 [1048][23000][Column 'a' cannot be null]
1138 [meta] rows: 0
1139 [meta] cols: 0
1140 [meta] server status: 0
1141 [meta] server status:
1142 [meta] warning count: 0
1143
1144 [meta] no columns
1145
1146 [meta] no charset
1147
1148 [data] no rows
1149
1150 [end] server status: 0
1151 [end] server status:
1152 [end] warning count: 0
1153 [end] affected rows: 0
1154 [end] last insert id: 0
1155 [end] message:
1156 ------------------------------------------------------------------
1157 EXECUTING:[COM_INIT_DB][test]
1158 ------------------------------------------------------------------
1159 EXECUTING:[33][SELECT * FROM t1 WHERE a = 't2a2']
1160 [CS_TEXT_REPRESENTATION]
1161 [meta] rows: 0
1162 [meta] cols: 2
1163 [meta] server status: 34
1164 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1165 [meta] warning count: 0
1166
1167 [meta][field] db name: test
1168 [meta][field] table name: t1
1169 [meta][field] org table name: t1
1170 [meta][field] col name: a
1171 [meta][field] org col name: a
1172 [meta][field] length: 80
1173 [meta][field] charsetnr: 255
1174 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
1175 [meta][field] decimals: 0
1176 [meta][field] type: VARCHAR (15)
1177
1178 [meta][field] db name: test
1179 [meta][field] table name: t1
1180 [meta][field] org table name: t1
1181 [meta][field] col name: b
1182 [meta][field] org col name: b
1183 [meta][field] length: 80
1184 [meta][field] charsetnr: 255
1185 [meta][field] flags: 0
1186 [meta][field] decimals: 0
1187 [meta][field] type: VARCHAR (15)
1188
1189
1190 [meta][charset result] number: 33
1191 [meta][charset result] name: utf8mb3
1192 [meta][charset result] collation: utf8mb3_general_ci
1193 [meta][charset result] sort order:
1194
1195 [data] no rows
1196
1197 [end] server status: 34
1198 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1199 [end] warning count: 0
1200 [end] affected rows: 0
1201 [end] last insert id: 0
1202 [end] message:
1203 [CS_BINARY_REPRESENTATION]
1204 [meta] rows: 0
1205 [meta] cols: 2
1206 [meta] server status: 34
1207 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1208 [meta] warning count: 0
1209
1210 [meta][field] db name: test
1211 [meta][field] table name: t1
1212 [meta][field] org table name: t1
1213 [meta][field] col name: a
1214 [meta][field] org col name: a
1215 [meta][field] length: 80
1216 [meta][field] charsetnr: 255
1217 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
1218 [meta][field] decimals: 0
1219 [meta][field] type: VARCHAR (15)
1220
1221 [meta][field] db name: test
1222 [meta][field] table name: t1
1223 [meta][field] org table name: t1
1224 [meta][field] col name: b
1225 [meta][field] org col name: b
1226 [meta][field] length: 80
1227 [meta][field] charsetnr: 255
1228 [meta][field] flags: 0
1229 [meta][field] decimals: 0
1230 [meta][field] type: VARCHAR (15)
1231
1232
1233 [meta][charset result] number: 33
1234 [meta][charset result] name: utf8mb3
1235 [meta][charset result] collation: utf8mb3_general_ci
1236 [meta][charset result] sort order:
1237
1238 [data] no rows
1239
1240 [end] server status: 34
1241 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1242 [end] warning count: 0
1243 [end] affected rows: 0
1244 [end] last insert id: 0
1245 [end] message:
1246 ------------------------------------------------------------------
1247 EXECUTING:[COM_INIT_DB][test]
1248 ------------------------------------------------------------------
1249 EXECUTING:[36][SET @@session.sql_mode = TRADITIONAL]
1250 [CS_TEXT_REPRESENTATION]
1251 [meta] rows: 0
1252 [meta] cols: 0
1253 [meta] server status: 0
1254 [meta] server status:
1255 [meta] warning count: 0
1256
1257 [meta] no columns
1258
1259 [meta] no charset
1260
1261 [data] no rows
1262
1263 [end] server status: 2
1264 [end] server status: AUTOCOMMIT
1265 [end] warning count: 0
1266 [end] affected rows: 0
1267 [end] last insert id: 0
1268 [end] message:
1269 ------------------------------------------------------------------
1270 EXECUTING:[25][SELECT @@session.sql_mode]
1271 [CS_TEXT_REPRESENTATION]
1272 [meta] rows: 1
1273 [meta] cols: 1
1274 [meta] server status: 2
1275 [meta] server status: AUTOCOMMIT
1276 [meta] warning count: 0
1277
1278 [meta][field] db name:
1279 [meta][field] table name:
1280 [meta][field] org table name:
1281 [meta][field] col name: @@session.sql_mode
1282 [meta][field] org col name:
1283 [meta][field] length: 65535
1284 [meta][field] charsetnr: 33
1285 [meta][field] flags: 0
1286 [meta][field] decimals: 31
1287 [meta][field] type: VARCHAR (15)
1288
1289
1290 [meta][charset result] number: 33
1291 [meta][charset result] name: utf8mb3
1292 [meta][charset result] collation: utf8mb3_general_ci
1293 [meta][charset result] sort order:
1294
1295 [data][.@@session.sql_mode][128][STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION]
1296
1297 [end] server status: 2
1298 [end] server status: AUTOCOMMIT
1299 [end] warning count: 0
1300 [end] affected rows: 0
1301 [end] last insert id: 0
1302 [end] message:
1303 [CS_BINARY_REPRESENTATION]
1304 [meta] rows: 1
1305 [meta] cols: 1
1306 [meta] server status: 2
1307 [meta] server status: AUTOCOMMIT
1308 [meta] warning count: 0
1309
1310 [meta][field] db name:
1311 [meta][field] table name:
1312 [meta][field] org table name:
1313 [meta][field] col name: @@session.sql_mode
1314 [meta][field] org col name:
1315 [meta][field] length: 65535
1316 [meta][field] charsetnr: 33
1317 [meta][field] flags: 0
1318 [meta][field] decimals: 31
1319 [meta][field] type: VARCHAR (15)
1320
1321
1322 [meta][charset result] number: 33
1323 [meta][charset result] name: utf8mb3
1324 [meta][charset result] collation: utf8mb3_general_ci
1325 [meta][charset result] sort order:
1326
1327 [data][.@@session.sql_mode][128][STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION]
1328
1329 [end] server status: 2
1330 [end] server status: AUTOCOMMIT
1331 [end] warning count: 0
1332 [end] affected rows: 0
1333 [end] last insert id: 0
1334 [end] message:
1335 ------------------------------------------------------------------
1336 EXECUTING:[COM_INIT_DB][test]
1337 ------------------------------------------------------------------
1338 EXECUTING:[34][INSERT INTO t2 VALUES(NULL,'t2b1')]
1339 [CS_TEXT_REPRESENTATION]
1340 [meta] rows: 0
1341 [meta] cols: 0
1342 [meta] server status: 0
1343 [meta] server status:
1344 [meta] warning count: 0
1345
1346 [meta] no columns
1347
1348 [meta] no charset
1349
1350 [data] no rows
1351
1352 [end] server status: 2
1353 [end] server status: AUTOCOMMIT
1354 [end] warning count: 0
1355 [end] affected rows: 1
1356 [end] last insert id: 0
1357 [end] message:
1358 ------------------------------------------------------------------
1359 EXECUTING:[COM_INIT_DB][test]
1360 ------------------------------------------------------------------
1361 EXECUTING:[31][INSERT INTO t1 SELECT * FROM t2]
1362 [CS_TEXT_REPRESENTATION]
1363 [1048][23000][Column 'a' cannot be null]
1364 [meta] rows: 0
1365 [meta] cols: 0
1366 [meta] server status: 0
1367 [meta] server status:
1368 [meta] warning count: 0
1369
1370 [meta] no columns
1371
1372 [meta] no charset
1373
1374 [data] no rows
1375
1376 [end] server status: 0
1377 [end] server status:
1378 [end] warning count: 0
1379 [end] affected rows: 0
1380 [end] last insert id: 0
1381 [end] message:
1382 ------------------------------------------------------------------
1383 EXECUTING:[COM_INIT_DB][test]
1384 ------------------------------------------------------------------
1385 EXECUTING:[33][SELECT * FROM t1 WHERE a = 't2a2']
1386 [CS_TEXT_REPRESENTATION]
1387 [meta] rows: 0
1388 [meta] cols: 2
1389 [meta] server status: 34
1390 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1391 [meta] warning count: 0
1392
1393 [meta][field] db name: test
1394 [meta][field] table name: t1
1395 [meta][field] org table name: t1
1396 [meta][field] col name: a
1397 [meta][field] org col name: a
1398 [meta][field] length: 80
1399 [meta][field] charsetnr: 255
1400 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
1401 [meta][field] decimals: 0
1402 [meta][field] type: VARCHAR (15)
1403
1404 [meta][field] db name: test
1405 [meta][field] table name: t1
1406 [meta][field] org table name: t1
1407 [meta][field] col name: b
1408 [meta][field] org col name: b
1409 [meta][field] length: 80
1410 [meta][field] charsetnr: 255
1411 [meta][field] flags: 0
1412 [meta][field] decimals: 0
1413 [meta][field] type: VARCHAR (15)
1414
1415
1416 [meta][charset result] number: 33
1417 [meta][charset result] name: utf8mb3
1418 [meta][charset result] collation: utf8mb3_general_ci
1419 [meta][charset result] sort order:
1420
1421 [data] no rows
1422
1423 [end] server status: 34
1424 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1425 [end] warning count: 0
1426 [end] affected rows: 0
1427 [end] last insert id: 0
1428 [end] message:
1429 [CS_BINARY_REPRESENTATION]
1430 [meta] rows: 0
1431 [meta] cols: 2
1432 [meta] server status: 34
1433 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1434 [meta] warning count: 0
1435
1436 [meta][field] db name: test
1437 [meta][field] table name: t1
1438 [meta][field] org table name: t1
1439 [meta][field] col name: a
1440 [meta][field] org col name: a
1441 [meta][field] length: 80
1442 [meta][field] charsetnr: 255
1443 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
1444 [meta][field] decimals: 0
1445 [meta][field] type: VARCHAR (15)
1446
1447 [meta][field] db name: test
1448 [meta][field] table name: t1
1449 [meta][field] org table name: t1
1450 [meta][field] col name: b
1451 [meta][field] org col name: b
1452 [meta][field] length: 80
1453 [meta][field] charsetnr: 255
1454 [meta][field] flags: 0
1455 [meta][field] decimals: 0
1456 [meta][field] type: VARCHAR (15)
1457
1458
1459 [meta][charset result] number: 33
1460 [meta][charset result] name: utf8mb3
1461 [meta][charset result] collation: utf8mb3_general_ci
1462 [meta][charset result] sort order:
1463
1464 [data] no rows
1465
1466 [end] server status: 34
1467 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1468 [end] warning count: 0
1469 [end] affected rows: 0
1470 [end] last insert id: 0
1471 [end] message:
1472 ------------------------------------------------------------------
1473 EXECUTING:[47][SET @@global.sql_mode = NO_UNSIGNED_SUBTRACTION]
1474 [CS_TEXT_REPRESENTATION]
1475 [meta] rows: 0
1476 [meta] cols: 0
1477 [meta] server status: 0
1478 [meta] server status:
1479 [meta] warning count: 0
1480
1481 [meta] no columns
1482
1483 [meta] no charset
1484
1485 [data] no rows
1486
1487 [end] server status: 2
1488 [end] server status: AUTOCOMMIT
1489 [end] warning count: 0
1490 [end] affected rows: 0
1491 [end] last insert id: 0
1492 [end] message:
1493 ------------------------------------------------------------------
1494 EXECUTING:[48][SET @@session.sql_mode = NO_UNSIGNED_SUBTRACTION]
1495 [CS_TEXT_REPRESENTATION]
1496 [meta] rows: 0
1497 [meta] cols: 0
1498 [meta] server status: 0
1499 [meta] server status:
1500 [meta] warning count: 0
1501
1502 [meta] no columns
1503
1504 [meta] no charset
1505
1506 [data] no rows
1507
1508 [end] server status: 2
1509 [end] server status: AUTOCOMMIT
1510 [end] warning count: 0
1511 [end] affected rows: 0
1512 [end] last insert id: 0
1513 [end] message:
1514 ------------------------------------------------------------------
1515 [srv_session_close]
1516 Follows threaded run
1517 ========================================================================
1518 init thread
1519 [srv_session_open]
1520 ------------------------------------------------------------------
1521 EXECUTING:[35][SELECT 'first complex command' as a]
1522 [CS_TEXT_REPRESENTATION]
1523 [meta] rows: 1
1524 [meta] cols: 1
1525 [meta] server status: 2
1526 [meta] server status: AUTOCOMMIT
1527 [meta] warning count: 0
1528
1529 [meta][field] db name:
1530 [meta][field] table name:
1531 [meta][field] org table name:
1532 [meta][field] col name: a
1533 [meta][field] org col name:
1534 [meta][field] length: 63
1535 [meta][field] charsetnr: 33
1536 [meta][field] flags: 1 (NOT_NULL )
1537 [meta][field] decimals: 31
1538 [meta][field] type: VARCHAR (15)
1539
1540
1541 [meta][charset result] number: 33
1542 [meta][charset result] name: utf8mb3
1543 [meta][charset result] collation: utf8mb3_general_ci
1544 [meta][charset result] sort order:
1545
1546 [data][.a][ 21][first complex command]
1547
1548 [end] server status: 2
1549 [end] server status: AUTOCOMMIT
1550 [end] warning count: 0
1551 [end] affected rows: 0
1552 [end] last insert id: 0
1553 [end] message:
1554 [CS_BINARY_REPRESENTATION]
1555 [meta] rows: 1
1556 [meta] cols: 1
1557 [meta] server status: 2
1558 [meta] server status: AUTOCOMMIT
1559 [meta] warning count: 0
1560
1561 [meta][field] db name:
1562 [meta][field] table name:
1563 [meta][field] org table name:
1564 [meta][field] col name: a
1565 [meta][field] org col name:
1566 [meta][field] length: 63
1567 [meta][field] charsetnr: 33
1568 [meta][field] flags: 1 (NOT_NULL )
1569 [meta][field] decimals: 31
1570 [meta][field] type: VARCHAR (15)
1571
1572
1573 [meta][charset result] number: 33
1574 [meta][charset result] name: utf8mb3
1575 [meta][charset result] collation: utf8mb3_general_ci
1576 [meta][charset result] sort order:
1577
1578 [data][.a][ 21][first complex command]
1579
1580 [end] server status: 2
1581 [end] server status: AUTOCOMMIT
1582 [end] warning count: 0
1583 [end] affected rows: 0
1584 [end] last insert id: 0
1585 [end] message:
1586 ------------------------------------------------------------------
1587 EXECUTING:[24][SELECT @@global.sql_mode]
1588 [CS_TEXT_REPRESENTATION]
1589 [meta] rows: 1
1590 [meta] cols: 1
1591 [meta] server status: 2
1592 [meta] server status: AUTOCOMMIT
1593 [meta] warning count: 0
1594
1595 [meta][field] db name:
1596 [meta][field] table name:
1597 [meta][field] org table name:
1598 [meta][field] col name: @@global.sql_mode
1599 [meta][field] org col name:
1600 [meta][field] length: 65535
1601 [meta][field] charsetnr: 33
1602 [meta][field] flags: 0
1603 [meta][field] decimals: 31
1604 [meta][field] type: VARCHAR (15)
1605
1606
1607 [meta][charset result] number: 33
1608 [meta][charset result] name: utf8mb3
1609 [meta][charset result] collation: utf8mb3_general_ci
1610 [meta][charset result] sort order:
1611
1612 [data][.@@global.sql_mode][ 23][NO_UNSIGNED_SUBTRACTION]
1613
1614 [end] server status: 2
1615 [end] server status: AUTOCOMMIT
1616 [end] warning count: 0
1617 [end] affected rows: 0
1618 [end] last insert id: 0
1619 [end] message:
1620 [CS_BINARY_REPRESENTATION]
1621 [meta] rows: 1
1622 [meta] cols: 1
1623 [meta] server status: 2
1624 [meta] server status: AUTOCOMMIT
1625 [meta] warning count: 0
1626
1627 [meta][field] db name:
1628 [meta][field] table name:
1629 [meta][field] org table name:
1630 [meta][field] col name: @@global.sql_mode
1631 [meta][field] org col name:
1632 [meta][field] length: 65535
1633 [meta][field] charsetnr: 33
1634 [meta][field] flags: 0
1635 [meta][field] decimals: 31
1636 [meta][field] type: VARCHAR (15)
1637
1638
1639 [meta][charset result] number: 33
1640 [meta][charset result] name: utf8mb3
1641 [meta][charset result] collation: utf8mb3_general_ci
1642 [meta][charset result] sort order:
1643
1644 [data][.@@global.sql_mode][ 23][NO_UNSIGNED_SUBTRACTION]
1645
1646 [end] server status: 2
1647 [end] server status: AUTOCOMMIT
1648 [end] warning count: 0
1649 [end] affected rows: 0
1650 [end] last insert id: 0
1651 [end] message:
1652 ------------------------------------------------------------------
1653 EXECUTING:[25][SELECT @@session.sql_mode]
1654 [CS_TEXT_REPRESENTATION]
1655 [meta] rows: 1
1656 [meta] cols: 1
1657 [meta] server status: 2
1658 [meta] server status: AUTOCOMMIT
1659 [meta] warning count: 0
1660
1661 [meta][field] db name:
1662 [meta][field] table name:
1663 [meta][field] org table name:
1664 [meta][field] col name: @@session.sql_mode
1665 [meta][field] org col name:
1666 [meta][field] length: 65535
1667 [meta][field] charsetnr: 33
1668 [meta][field] flags: 0
1669 [meta][field] decimals: 31
1670 [meta][field] type: VARCHAR (15)
1671
1672
1673 [meta][charset result] number: 33
1674 [meta][charset result] name: utf8mb3
1675 [meta][charset result] collation: utf8mb3_general_ci
1676 [meta][charset result] sort order:
1677
1678 [data][.@@session.sql_mode][ 23][NO_UNSIGNED_SUBTRACTION]
1679
1680 [end] server status: 2
1681 [end] server status: AUTOCOMMIT
1682 [end] warning count: 0
1683 [end] affected rows: 0
1684 [end] last insert id: 0
1685 [end] message:
1686 [CS_BINARY_REPRESENTATION]
1687 [meta] rows: 1
1688 [meta] cols: 1
1689 [meta] server status: 2
1690 [meta] server status: AUTOCOMMIT
1691 [meta] warning count: 0
1692
1693 [meta][field] db name:
1694 [meta][field] table name:
1695 [meta][field] org table name:
1696 [meta][field] col name: @@session.sql_mode
1697 [meta][field] org col name:
1698 [meta][field] length: 65535
1699 [meta][field] charsetnr: 33
1700 [meta][field] flags: 0
1701 [meta][field] decimals: 31
1702 [meta][field] type: VARCHAR (15)
1703
1704
1705 [meta][charset result] number: 33
1706 [meta][charset result] name: utf8mb3
1707 [meta][charset result] collation: utf8mb3_general_ci
1708 [meta][charset result] sort order:
1709
1710 [data][.@@session.sql_mode][ 23][NO_UNSIGNED_SUBTRACTION]
1711
1712 [end] server status: 2
1713 [end] server status: AUTOCOMMIT
1714 [end] warning count: 0
1715 [end] affected rows: 0
1716 [end] last insert id: 0
1717 [end] message:
1718 ------------------------------------------------------------------
1719 EXECUTING:[42][SET @@session.sql_mode = @@global.sql_mode]
1720 [CS_TEXT_REPRESENTATION]
1721 [meta] rows: 0
1722 [meta] cols: 0
1723 [meta] server status: 0
1724 [meta] server status:
1725 [meta] warning count: 0
1726
1727 [meta] no columns
1728
1729 [meta] no charset
1730
1731 [data] no rows
1732
1733 [end] server status: 2
1734 [end] server status: AUTOCOMMIT
1735 [end] warning count: 0
1736 [end] affected rows: 0
1737 [end] last insert id: 0
1738 [end] message:
1739 ------------------------------------------------------------------
1740 EXECUTING:[24][SELECT @@global.sql_mode]
1741 [CS_TEXT_REPRESENTATION]
1742 [meta] rows: 1
1743 [meta] cols: 1
1744 [meta] server status: 2
1745 [meta] server status: AUTOCOMMIT
1746 [meta] warning count: 0
1747
1748 [meta][field] db name:
1749 [meta][field] table name:
1750 [meta][field] org table name:
1751 [meta][field] col name: @@global.sql_mode
1752 [meta][field] org col name:
1753 [meta][field] length: 65535
1754 [meta][field] charsetnr: 33
1755 [meta][field] flags: 0
1756 [meta][field] decimals: 31
1757 [meta][field] type: VARCHAR (15)
1758
1759
1760 [meta][charset result] number: 33
1761 [meta][charset result] name: utf8mb3
1762 [meta][charset result] collation: utf8mb3_general_ci
1763 [meta][charset result] sort order:
1764
1765 [data][.@@global.sql_mode][ 23][NO_UNSIGNED_SUBTRACTION]
1766
1767 [end] server status: 2
1768 [end] server status: AUTOCOMMIT
1769 [end] warning count: 0
1770 [end] affected rows: 0
1771 [end] last insert id: 0
1772 [end] message:
1773 [CS_BINARY_REPRESENTATION]
1774 [meta] rows: 1
1775 [meta] cols: 1
1776 [meta] server status: 2
1777 [meta] server status: AUTOCOMMIT
1778 [meta] warning count: 0
1779
1780 [meta][field] db name:
1781 [meta][field] table name:
1782 [meta][field] org table name:
1783 [meta][field] col name: @@global.sql_mode
1784 [meta][field] org col name:
1785 [meta][field] length: 65535
1786 [meta][field] charsetnr: 33
1787 [meta][field] flags: 0
1788 [meta][field] decimals: 31
1789 [meta][field] type: VARCHAR (15)
1790
1791
1792 [meta][charset result] number: 33
1793 [meta][charset result] name: utf8mb3
1794 [meta][charset result] collation: utf8mb3_general_ci
1795 [meta][charset result] sort order:
1796
1797 [data][.@@global.sql_mode][ 23][NO_UNSIGNED_SUBTRACTION]
1798
1799 [end] server status: 2
1800 [end] server status: AUTOCOMMIT
1801 [end] warning count: 0
1802 [end] affected rows: 0
1803 [end] last insert id: 0
1804 [end] message:
1805 ------------------------------------------------------------------
1806 EXECUTING:[25][SELECT @@session.sql_mode]
1807 [CS_TEXT_REPRESENTATION]
1808 [meta] rows: 1
1809 [meta] cols: 1
1810 [meta] server status: 2
1811 [meta] server status: AUTOCOMMIT
1812 [meta] warning count: 0
1813
1814 [meta][field] db name:
1815 [meta][field] table name:
1816 [meta][field] org table name:
1817 [meta][field] col name: @@session.sql_mode
1818 [meta][field] org col name:
1819 [meta][field] length: 65535
1820 [meta][field] charsetnr: 33
1821 [meta][field] flags: 0
1822 [meta][field] decimals: 31
1823 [meta][field] type: VARCHAR (15)
1824
1825
1826 [meta][charset result] number: 33
1827 [meta][charset result] name: utf8mb3
1828 [meta][charset result] collation: utf8mb3_general_ci
1829 [meta][charset result] sort order:
1830
1831 [data][.@@session.sql_mode][ 23][NO_UNSIGNED_SUBTRACTION]
1832
1833 [end] server status: 2
1834 [end] server status: AUTOCOMMIT
1835 [end] warning count: 0
1836 [end] affected rows: 0
1837 [end] last insert id: 0
1838 [end] message:
1839 [CS_BINARY_REPRESENTATION]
1840 [meta] rows: 1
1841 [meta] cols: 1
1842 [meta] server status: 2
1843 [meta] server status: AUTOCOMMIT
1844 [meta] warning count: 0
1845
1846 [meta][field] db name:
1847 [meta][field] table name:
1848 [meta][field] org table name:
1849 [meta][field] col name: @@session.sql_mode
1850 [meta][field] org col name:
1851 [meta][field] length: 65535
1852 [meta][field] charsetnr: 33
1853 [meta][field] flags: 0
1854 [meta][field] decimals: 31
1855 [meta][field] type: VARCHAR (15)
1856
1857
1858 [meta][charset result] number: 33
1859 [meta][charset result] name: utf8mb3
1860 [meta][charset result] collation: utf8mb3_general_ci
1861 [meta][charset result] sort order:
1862
1863 [data][.@@session.sql_mode][ 23][NO_UNSIGNED_SUBTRACTION]
1864
1865 [end] server status: 2
1866 [end] server status: AUTOCOMMIT
1867 [end] warning count: 0
1868 [end] affected rows: 0
1869 [end] last insert id: 0
1870 [end] message:
1871 ------------------------------------------------------------------
1872 EXECUTING:[30][SELECT CAST(0 AS UNSIGNED) - 1]
1873 [CS_TEXT_REPRESENTATION]
1874 [meta] rows: 1
1875 [meta] cols: 1
1876 [meta] server status: 2
1877 [meta] server status: AUTOCOMMIT
1878 [meta] warning count: 0
1879
1880 [meta][field] db name:
1881 [meta][field] table name:
1882 [meta][field] org table name:
1883 [meta][field] col name: CAST(0 AS UNSIGNED) - 1
1884 [meta][field] org col name:
1885 [meta][field] length: 22
1886 [meta][field] charsetnr: 8
1887 [meta][field] flags: 129 (NOT_NULL BINARY )
1888 [meta][field] decimals: 0
1889 [meta][field] type: LONGLONG (8)
1890
1891
1892 [meta][charset result] number: 33
1893 [meta][charset result] name: utf8mb3
1894 [meta][charset result] collation: utf8mb3_general_ci
1895 [meta][charset result] sort order:
1896
1897 [data][.CAST(0 AS UNSIGNED) - 1][ 2][-1]
1898
1899 [end] server status: 2
1900 [end] server status: AUTOCOMMIT
1901 [end] warning count: 0
1902 [end] affected rows: 0
1903 [end] last insert id: 0
1904 [end] message:
1905 [CS_BINARY_REPRESENTATION]
1906 [meta] rows: 1
1907 [meta] cols: 1
1908 [meta] server status: 2
1909 [meta] server status: AUTOCOMMIT
1910 [meta] warning count: 0
1911
1912 [meta][field] db name:
1913 [meta][field] table name:
1914 [meta][field] org table name:
1915 [meta][field] col name: CAST(0 AS UNSIGNED) - 1
1916 [meta][field] org col name:
1917 [meta][field] length: 22
1918 [meta][field] charsetnr: 8
1919 [meta][field] flags: 129 (NOT_NULL BINARY )
1920 [meta][field] decimals: 0
1921 [meta][field] type: LONGLONG (8)
1922
1923
1924 [meta][charset result] number: 33
1925 [meta][charset result] name: utf8mb3
1926 [meta][charset result] collation: utf8mb3_general_ci
1927 [meta][charset result] sort order:
1928
1929 [data][.CAST(0 AS UNSIGNED) - 1][ 2][-1]
1930
1931 [end] server status: 2
1932 [end] server status: AUTOCOMMIT
1933 [end] warning count: 0
1934 [end] affected rows: 0
1935 [end] last insert id: 0
1936 [end] message:
1937 ------------------------------------------------------------------
1938 EXECUTING:[36][SET @@global.sql_mode = NO_ZERO_DATE]
1939 [CS_TEXT_REPRESENTATION]
1940 [meta] rows: 0
1941 [meta] cols: 0
1942 [meta] server status: 0
1943 [meta] server status:
1944 [meta] warning count: 0
1945
1946 [meta] no columns
1947
1948 [meta] no charset
1949
1950 [data] no rows
1951
1952 [end] server status: 2
1953 [end] server status: AUTOCOMMIT
1954 [end] warning count: 1
1955 [end] affected rows: 0
1956 [end] last insert id: 0
1957 [end] message:
1958 ------------------------------------------------------------------
1959 EXECUTING:[37][SET @@session.sql_mode = NO_ZERO_DATE]
1960 [CS_TEXT_REPRESENTATION]
1961 [meta] rows: 0
1962 [meta] cols: 0
1963 [meta] server status: 0
1964 [meta] server status:
1965 [meta] warning count: 0
1966
1967 [meta] no columns
1968
1969 [meta] no charset
1970
1971 [data] no rows
1972
1973 [end] server status: 2
1974 [end] server status: AUTOCOMMIT
1975 [end] warning count: 1
1976 [end] affected rows: 0
1977 [end] last insert id: 0
1978 [end] message:
1979 ------------------------------------------------------------------
1980 EXECUTING:[24][SELECT @@global.sql_mode]
1981 [CS_TEXT_REPRESENTATION]
1982 [meta] rows: 1
1983 [meta] cols: 1
1984 [meta] server status: 2
1985 [meta] server status: AUTOCOMMIT
1986 [meta] warning count: 0
1987
1988 [meta][field] db name:
1989 [meta][field] table name:
1990 [meta][field] org table name:
1991 [meta][field] col name: @@global.sql_mode
1992 [meta][field] org col name:
1993 [meta][field] length: 65535
1994 [meta][field] charsetnr: 33
1995 [meta][field] flags: 0
1996 [meta][field] decimals: 31
1997 [meta][field] type: VARCHAR (15)
1998
1999
2000 [meta][charset result] number: 33
2001 [meta][charset result] name: utf8mb3
2002 [meta][charset result] collation: utf8mb3_general_ci
2003 [meta][charset result] sort order:
2004
2005 [data][.@@global.sql_mode][ 12][NO_ZERO_DATE]
2006
2007 [end] server status: 2
2008 [end] server status: AUTOCOMMIT
2009 [end] warning count: 0
2010 [end] affected rows: 0
2011 [end] last insert id: 0
2012 [end] message:
2013 [CS_BINARY_REPRESENTATION]
2014 [meta] rows: 1
2015 [meta] cols: 1
2016 [meta] server status: 2
2017 [meta] server status: AUTOCOMMIT
2018 [meta] warning count: 0
2019
2020 [meta][field] db name:
2021 [meta][field] table name:
2022 [meta][field] org table name:
2023 [meta][field] col name: @@global.sql_mode
2024 [meta][field] org col name:
2025 [meta][field] length: 65535
2026 [meta][field] charsetnr: 33
2027 [meta][field] flags: 0
2028 [meta][field] decimals: 31
2029 [meta][field] type: VARCHAR (15)
2030
2031
2032 [meta][charset result] number: 33
2033 [meta][charset result] name: utf8mb3
2034 [meta][charset result] collation: utf8mb3_general_ci
2035 [meta][charset result] sort order:
2036
2037 [data][.@@global.sql_mode][ 12][NO_ZERO_DATE]
2038
2039 [end] server status: 2
2040 [end] server status: AUTOCOMMIT
2041 [end] warning count: 0
2042 [end] affected rows: 0
2043 [end] last insert id: 0
2044 [end] message:
2045 ------------------------------------------------------------------
2046 EXECUTING:[25][SELECT @@session.sql_mode]
2047 [CS_TEXT_REPRESENTATION]
2048 [meta] rows: 1
2049 [meta] cols: 1
2050 [meta] server status: 2
2051 [meta] server status: AUTOCOMMIT
2052 [meta] warning count: 0
2053
2054 [meta][field] db name:
2055 [meta][field] table name:
2056 [meta][field] org table name:
2057 [meta][field] col name: @@session.sql_mode
2058 [meta][field] org col name:
2059 [meta][field] length: 65535
2060 [meta][field] charsetnr: 33
2061 [meta][field] flags: 0
2062 [meta][field] decimals: 31
2063 [meta][field] type: VARCHAR (15)
2064
2065
2066 [meta][charset result] number: 33
2067 [meta][charset result] name: utf8mb3
2068 [meta][charset result] collation: utf8mb3_general_ci
2069 [meta][charset result] sort order:
2070
2071 [data][.@@session.sql_mode][ 12][NO_ZERO_DATE]
2072
2073 [end] server status: 2
2074 [end] server status: AUTOCOMMIT
2075 [end] warning count: 0
2076 [end] affected rows: 0
2077 [end] last insert id: 0
2078 [end] message:
2079 [CS_BINARY_REPRESENTATION]
2080 [meta] rows: 1
2081 [meta] cols: 1
2082 [meta] server status: 2
2083 [meta] server status: AUTOCOMMIT
2084 [meta] warning count: 0
2085
2086 [meta][field] db name:
2087 [meta][field] table name:
2088 [meta][field] org table name:
2089 [meta][field] col name: @@session.sql_mode
2090 [meta][field] org col name:
2091 [meta][field] length: 65535
2092 [meta][field] charsetnr: 33
2093 [meta][field] flags: 0
2094 [meta][field] decimals: 31
2095 [meta][field] type: VARCHAR (15)
2096
2097
2098 [meta][charset result] number: 33
2099 [meta][charset result] name: utf8mb3
2100 [meta][charset result] collation: utf8mb3_general_ci
2101 [meta][charset result] sort order:
2102
2103 [data][.@@session.sql_mode][ 12][NO_ZERO_DATE]
2104
2105 [end] server status: 2
2106 [end] server status: AUTOCOMMIT
2107 [end] warning count: 0
2108 [end] affected rows: 0
2109 [end] last insert id: 0
2110 [end] message:
2111 ------------------------------------------------------------------
2112 EXECUTING:[31][SET @@global.sql_mode = DEFAULT]
2113 [CS_TEXT_REPRESENTATION]
2114 [meta] rows: 0
2115 [meta] cols: 0
2116 [meta] server status: 0
2117 [meta] server status:
2118 [meta] warning count: 0
2119
2120 [meta] no columns
2121
2122 [meta] no charset
2123
2124 [data] no rows
2125
2126 [end] server status: 2
2127 [end] server status: AUTOCOMMIT
2128 [end] warning count: 0
2129 [end] affected rows: 0
2130 [end] last insert id: 0
2131 [end] message:
2132 ------------------------------------------------------------------
2133 EXECUTING:[32][SET @@session.sql_mode = DEFAULT]
2134 [CS_TEXT_REPRESENTATION]
2135 [meta] rows: 0
2136 [meta] cols: 0
2137 [meta] server status: 0
2138 [meta] server status:
2139 [meta] warning count: 0
2140
2141 [meta] no columns
2142
2143 [meta] no charset
2144
2145 [data] no rows
2146
2147 [end] server status: 2
2148 [end] server status: AUTOCOMMIT
2149 [end] warning count: 0
2150 [end] affected rows: 0
2151 [end] last insert id: 0
2152 [end] message:
2153 ------------------------------------------------------------------
2154 EXECUTING:[24][SELECT @@global.sql_mode]
2155 [CS_TEXT_REPRESENTATION]
2156 [meta] rows: 1
2157 [meta] cols: 1
2158 [meta] server status: 2
2159 [meta] server status: AUTOCOMMIT
2160 [meta] warning count: 0
2161
2162 [meta][field] db name:
2163 [meta][field] table name:
2164 [meta][field] org table name:
2165 [meta][field] col name: @@global.sql_mode
2166 [meta][field] org col name:
2167 [meta][field] length: 65535
2168 [meta][field] charsetnr: 33
2169 [meta][field] flags: 0
2170 [meta][field] decimals: 31
2171 [meta][field] type: VARCHAR (15)
2172
2173
2174 [meta][charset result] number: 33
2175 [meta][charset result] name: utf8mb3
2176 [meta][charset result] collation: utf8mb3_general_ci
2177 [meta][charset result] sort order:
2178
2179 [data][.@@global.sql_mode][117][ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION]
2180
2181 [end] server status: 2
2182 [end] server status: AUTOCOMMIT
2183 [end] warning count: 0
2184 [end] affected rows: 0
2185 [end] last insert id: 0
2186 [end] message:
2187 [CS_BINARY_REPRESENTATION]
2188 [meta] rows: 1
2189 [meta] cols: 1
2190 [meta] server status: 2
2191 [meta] server status: AUTOCOMMIT
2192 [meta] warning count: 0
2193
2194 [meta][field] db name:
2195 [meta][field] table name:
2196 [meta][field] org table name:
2197 [meta][field] col name: @@global.sql_mode
2198 [meta][field] org col name:
2199 [meta][field] length: 65535
2200 [meta][field] charsetnr: 33
2201 [meta][field] flags: 0
2202 [meta][field] decimals: 31
2203 [meta][field] type: VARCHAR (15)
2204
2205
2206 [meta][charset result] number: 33
2207 [meta][charset result] name: utf8mb3
2208 [meta][charset result] collation: utf8mb3_general_ci
2209 [meta][charset result] sort order:
2210
2211 [data][.@@global.sql_mode][117][ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION]
2212
2213 [end] server status: 2
2214 [end] server status: AUTOCOMMIT
2215 [end] warning count: 0
2216 [end] affected rows: 0
2217 [end] last insert id: 0
2218 [end] message:
2219 ------------------------------------------------------------------
2220 EXECUTING:[25][SELECT @@session.sql_mode]
2221 [CS_TEXT_REPRESENTATION]
2222 [meta] rows: 1
2223 [meta] cols: 1
2224 [meta] server status: 2
2225 [meta] server status: AUTOCOMMIT
2226 [meta] warning count: 0
2227
2228 [meta][field] db name:
2229 [meta][field] table name:
2230 [meta][field] org table name:
2231 [meta][field] col name: @@session.sql_mode
2232 [meta][field] org col name:
2233 [meta][field] length: 65535
2234 [meta][field] charsetnr: 33
2235 [meta][field] flags: 0
2236 [meta][field] decimals: 31
2237 [meta][field] type: VARCHAR (15)
2238
2239
2240 [meta][charset result] number: 33
2241 [meta][charset result] name: utf8mb3
2242 [meta][charset result] collation: utf8mb3_general_ci
2243 [meta][charset result] sort order:
2244
2245 [data][.@@session.sql_mode][117][ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION]
2246
2247 [end] server status: 2
2248 [end] server status: AUTOCOMMIT
2249 [end] warning count: 0
2250 [end] affected rows: 0
2251 [end] last insert id: 0
2252 [end] message:
2253 [CS_BINARY_REPRESENTATION]
2254 [meta] rows: 1
2255 [meta] cols: 1
2256 [meta] server status: 2
2257 [meta] server status: AUTOCOMMIT
2258 [meta] warning count: 0
2259
2260 [meta][field] db name:
2261 [meta][field] table name:
2262 [meta][field] org table name:
2263 [meta][field] col name: @@session.sql_mode
2264 [meta][field] org col name:
2265 [meta][field] length: 65535
2266 [meta][field] charsetnr: 33
2267 [meta][field] flags: 0
2268 [meta][field] decimals: 31
2269 [meta][field] type: VARCHAR (15)
2270
2271
2272 [meta][charset result] number: 33
2273 [meta][charset result] name: utf8mb3
2274 [meta][charset result] collation: utf8mb3_general_ci
2275 [meta][charset result] sort order:
2276
2277 [data][.@@session.sql_mode][117][ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION]
2278
2279 [end] server status: 2
2280 [end] server status: AUTOCOMMIT
2281 [end] warning count: 0
2282 [end] affected rows: 0
2283 [end] last insert id: 0
2284 [end] message:
2285 ------------------------------------------------------------------
2286 EXECUTING:[COM_INIT_DB][test]
2287 ------------------------------------------------------------------
2288 EXECUTING:[57][SELECT * FROM t1 WHERE t1.a IN (SELECT MAX(t1.b) FROM t2)]
2289 [CS_TEXT_REPRESENTATION]
2290 [meta] rows: 0
2291 [meta] cols: 2
2292 [meta] server status: 34
2293 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2294 [meta] warning count: 0
2295
2296 [meta][field] db name: test
2297 [meta][field] table name: t1
2298 [meta][field] org table name: t1
2299 [meta][field] col name: a
2300 [meta][field] org col name: a
2301 [meta][field] length: 80
2302 [meta][field] charsetnr: 255
2303 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
2304 [meta][field] decimals: 0
2305 [meta][field] type: VARCHAR (15)
2306
2307 [meta][field] db name: test
2308 [meta][field] table name: t1
2309 [meta][field] org table name: t1
2310 [meta][field] col name: b
2311 [meta][field] org col name: b
2312 [meta][field] length: 80
2313 [meta][field] charsetnr: 255
2314 [meta][field] flags: 0
2315 [meta][field] decimals: 0
2316 [meta][field] type: VARCHAR (15)
2317
2318
2319 [meta][charset result] number: 33
2320 [meta][charset result] name: utf8mb3
2321 [meta][charset result] collation: utf8mb3_general_ci
2322 [meta][charset result] sort order:
2323
2324 [data] no rows
2325
2326 [end] server status: 34
2327 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2328 [end] warning count: 0
2329 [end] affected rows: 0
2330 [end] last insert id: 0
2331 [end] message:
2332 [CS_BINARY_REPRESENTATION]
2333 [meta] rows: 0
2334 [meta] cols: 2
2335 [meta] server status: 34
2336 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2337 [meta] warning count: 0
2338
2339 [meta][field] db name: test
2340 [meta][field] table name: t1
2341 [meta][field] org table name: t1
2342 [meta][field] col name: a
2343 [meta][field] org col name: a
2344 [meta][field] length: 80
2345 [meta][field] charsetnr: 255
2346 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
2347 [meta][field] decimals: 0
2348 [meta][field] type: VARCHAR (15)
2349
2350 [meta][field] db name: test
2351 [meta][field] table name: t1
2352 [meta][field] org table name: t1
2353 [meta][field] col name: b
2354 [meta][field] org col name: b
2355 [meta][field] length: 80
2356 [meta][field] charsetnr: 255
2357 [meta][field] flags: 0
2358 [meta][field] decimals: 0
2359 [meta][field] type: VARCHAR (15)
2360
2361
2362 [meta][charset result] number: 33
2363 [meta][charset result] name: utf8mb3
2364 [meta][charset result] collation: utf8mb3_general_ci
2365 [meta][charset result] sort order:
2366
2367 [data] no rows
2368
2369 [end] server status: 34
2370 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2371 [end] warning count: 0
2372 [end] affected rows: 0
2373 [end] last insert id: 0
2374 [end] message:
2375 ------------------------------------------------------------------
2376 EXECUTING:[29][SET @@session.sql_mode = ANSI]
2377 [CS_TEXT_REPRESENTATION]
2378 [meta] rows: 0
2379 [meta] cols: 0
2380 [meta] server status: 0
2381 [meta] server status:
2382 [meta] warning count: 0
2383
2384 [meta] no columns
2385
2386 [meta] no charset
2387
2388 [data] no rows
2389
2390 [end] server status: 2
2391 [end] server status: AUTOCOMMIT
2392 [end] warning count: 0
2393 [end] affected rows: 0
2394 [end] last insert id: 0
2395 [end] message:
2396 ------------------------------------------------------------------
2397 EXECUTING:[25][SELECT @@session.sql_mode]
2398 [CS_TEXT_REPRESENTATION]
2399 [meta] rows: 1
2400 [meta] cols: 1
2401 [meta] server status: 2
2402 [meta] server status: AUTOCOMMIT
2403 [meta] warning count: 0
2404
2405 [meta][field] db name:
2406 [meta][field] table name:
2407 [meta][field] org table name:
2408 [meta][field] col name: @@session.sql_mode
2409 [meta][field] org col name:
2410 [meta][field] length: 65535
2411 [meta][field] charsetnr: 33
2412 [meta][field] flags: 0
2413 [meta][field] decimals: 31
2414 [meta][field] type: VARCHAR (15)
2415
2416
2417 [meta][charset result] number: 33
2418 [meta][charset result] name: utf8mb3
2419 [meta][charset result] collation: utf8mb3_general_ci
2420 [meta][charset result] sort order:
2421
2422 [data][.@@session.sql_mode][ 78][REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,ANSI]
2423
2424 [end] server status: 2
2425 [end] server status: AUTOCOMMIT
2426 [end] warning count: 0
2427 [end] affected rows: 0
2428 [end] last insert id: 0
2429 [end] message:
2430 [CS_BINARY_REPRESENTATION]
2431 [meta] rows: 1
2432 [meta] cols: 1
2433 [meta] server status: 2
2434 [meta] server status: AUTOCOMMIT
2435 [meta] warning count: 0
2436
2437 [meta][field] db name:
2438 [meta][field] table name:
2439 [meta][field] org table name:
2440 [meta][field] col name: @@session.sql_mode
2441 [meta][field] org col name:
2442 [meta][field] length: 65535
2443 [meta][field] charsetnr: 33
2444 [meta][field] flags: 0
2445 [meta][field] decimals: 31
2446 [meta][field] type: VARCHAR (15)
2447
2448
2449 [meta][charset result] number: 33
2450 [meta][charset result] name: utf8mb3
2451 [meta][charset result] collation: utf8mb3_general_ci
2452 [meta][charset result] sort order:
2453
2454 [data][.@@session.sql_mode][ 78][REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,ANSI]
2455
2456 [end] server status: 2
2457 [end] server status: AUTOCOMMIT
2458 [end] warning count: 0
2459 [end] affected rows: 0
2460 [end] last insert id: 0
2461 [end] message:
2462 ------------------------------------------------------------------
2463 EXECUTING:[COM_INIT_DB][test]
2464 ------------------------------------------------------------------
2465 EXECUTING:[57][SELECT * FROM t1 WHERE t1.a IN (SELECT MAX(t1.b) FROM t2)]
2466 [CS_TEXT_REPRESENTATION]
2467 [1111][HY000][Invalid use of group function]
2468 [meta] rows: 0
2469 [meta] cols: 0
2470 [meta] server status: 0
2471 [meta] server status:
2472 [meta] warning count: 0
2473
2474 [meta] no columns
2475
2476 [meta] no charset
2477
2478 [data] no rows
2479
2480 [end] server status: 0
2481 [end] server status:
2482 [end] warning count: 0
2483 [end] affected rows: 0
2484 [end] last insert id: 0
2485 [end] message:
2486 [CS_BINARY_REPRESENTATION]
2487 [1111][HY000][Invalid use of group function]
2488 [meta] rows: 0
2489 [meta] cols: 0
2490 [meta] server status: 0
2491 [meta] server status:
2492 [meta] warning count: 0
2493
2494 [meta] no columns
2495
2496 [meta] no charset
2497
2498 [data] no rows
2499
2500 [end] server status: 0
2501 [end] server status:
2502 [end] warning count: 0
2503 [end] affected rows: 0
2504 [end] last insert id: 0
2505 [end] message:
2506 ------------------------------------------------------------------
2507 EXECUTING:[COM_INIT_DB][test]
2508 ------------------------------------------------------------------
2509 EXECUTING:[44][SET @@session.sql_mode = STRICT_TRANS_TABLES]
2510 [CS_TEXT_REPRESENTATION]
2511 [meta] rows: 0
2512 [meta] cols: 0
2513 [meta] server status: 0
2514 [meta] server status:
2515 [meta] warning count: 0
2516
2517 [meta] no columns
2518
2519 [meta] no charset
2520
2521 [data] no rows
2522
2523 [end] server status: 2
2524 [end] server status: AUTOCOMMIT
2525 [end] warning count: 1
2526 [end] affected rows: 0
2527 [end] last insert id: 0
2528 [end] message:
2529 ------------------------------------------------------------------
2530 EXECUTING:[25][SELECT @@session.sql_mode]
2531 [CS_TEXT_REPRESENTATION]
2532 [meta] rows: 1
2533 [meta] cols: 1
2534 [meta] server status: 2
2535 [meta] server status: AUTOCOMMIT
2536 [meta] warning count: 0
2537
2538 [meta][field] db name:
2539 [meta][field] table name:
2540 [meta][field] org table name:
2541 [meta][field] col name: @@session.sql_mode
2542 [meta][field] org col name:
2543 [meta][field] length: 65535
2544 [meta][field] charsetnr: 33
2545 [meta][field] flags: 0
2546 [meta][field] decimals: 31
2547 [meta][field] type: VARCHAR (15)
2548
2549
2550 [meta][charset result] number: 33
2551 [meta][charset result] name: utf8mb3
2552 [meta][charset result] collation: utf8mb3_general_ci
2553 [meta][charset result] sort order:
2554
2555 [data][.@@session.sql_mode][ 19][STRICT_TRANS_TABLES]
2556
2557 [end] server status: 2
2558 [end] server status: AUTOCOMMIT
2559 [end] warning count: 0
2560 [end] affected rows: 0
2561 [end] last insert id: 0
2562 [end] message:
2563 [CS_BINARY_REPRESENTATION]
2564 [meta] rows: 1
2565 [meta] cols: 1
2566 [meta] server status: 2
2567 [meta] server status: AUTOCOMMIT
2568 [meta] warning count: 0
2569
2570 [meta][field] db name:
2571 [meta][field] table name:
2572 [meta][field] org table name:
2573 [meta][field] col name: @@session.sql_mode
2574 [meta][field] org col name:
2575 [meta][field] length: 65535
2576 [meta][field] charsetnr: 33
2577 [meta][field] flags: 0
2578 [meta][field] decimals: 31
2579 [meta][field] type: VARCHAR (15)
2580
2581
2582 [meta][charset result] number: 33
2583 [meta][charset result] name: utf8mb3
2584 [meta][charset result] collation: utf8mb3_general_ci
2585 [meta][charset result] sort order:
2586
2587 [data][.@@session.sql_mode][ 19][STRICT_TRANS_TABLES]
2588
2589 [end] server status: 2
2590 [end] server status: AUTOCOMMIT
2591 [end] warning count: 0
2592 [end] affected rows: 0
2593 [end] last insert id: 0
2594 [end] message:
2595 ------------------------------------------------------------------
2596 EXECUTING:[COM_INIT_DB][test]
2597 ------------------------------------------------------------------
2598 EXECUTING:[34][INSERT INTO t2 VALUES(NULL,'t2b1')]
2599 [CS_TEXT_REPRESENTATION]
2600 [meta] rows: 0
2601 [meta] cols: 0
2602 [meta] server status: 0
2603 [meta] server status:
2604 [meta] warning count: 0
2605
2606 [meta] no columns
2607
2608 [meta] no charset
2609
2610 [data] no rows
2611
2612 [end] server status: 2
2613 [end] server status: AUTOCOMMIT
2614 [end] warning count: 0
2615 [end] affected rows: 1
2616 [end] last insert id: 0
2617 [end] message:
2618 ------------------------------------------------------------------
2619 EXECUTING:[COM_INIT_DB][test]
2620 ------------------------------------------------------------------
2621 EXECUTING:[31][INSERT INTO t1 SELECT * FROM t2]
2622 [CS_TEXT_REPRESENTATION]
2623 [1048][23000][Column 'a' cannot be null]
2624 [meta] rows: 0
2625 [meta] cols: 0
2626 [meta] server status: 0
2627 [meta] server status:
2628 [meta] warning count: 0
2629
2630 [meta] no columns
2631
2632 [meta] no charset
2633
2634 [data] no rows
2635
2636 [end] server status: 0
2637 [end] server status:
2638 [end] warning count: 0
2639 [end] affected rows: 0
2640 [end] last insert id: 0
2641 [end] message:
2642 ------------------------------------------------------------------
2643 EXECUTING:[COM_INIT_DB][test]
2644 ------------------------------------------------------------------
2645 EXECUTING:[33][SELECT * FROM t1 WHERE a = 't2a2']
2646 [CS_TEXT_REPRESENTATION]
2647 [meta] rows: 0
2648 [meta] cols: 2
2649 [meta] server status: 34
2650 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2651 [meta] warning count: 0
2652
2653 [meta][field] db name: test
2654 [meta][field] table name: t1
2655 [meta][field] org table name: t1
2656 [meta][field] col name: a
2657 [meta][field] org col name: a
2658 [meta][field] length: 80
2659 [meta][field] charsetnr: 255
2660 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
2661 [meta][field] decimals: 0
2662 [meta][field] type: VARCHAR (15)
2663
2664 [meta][field] db name: test
2665 [meta][field] table name: t1
2666 [meta][field] org table name: t1
2667 [meta][field] col name: b
2668 [meta][field] org col name: b
2669 [meta][field] length: 80
2670 [meta][field] charsetnr: 255
2671 [meta][field] flags: 0
2672 [meta][field] decimals: 0
2673 [meta][field] type: VARCHAR (15)
2674
2675
2676 [meta][charset result] number: 33
2677 [meta][charset result] name: utf8mb3
2678 [meta][charset result] collation: utf8mb3_general_ci
2679 [meta][charset result] sort order:
2680
2681 [data] no rows
2682
2683 [end] server status: 34
2684 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2685 [end] warning count: 0
2686 [end] affected rows: 0
2687 [end] last insert id: 0
2688 [end] message:
2689 [CS_BINARY_REPRESENTATION]
2690 [meta] rows: 0
2691 [meta] cols: 2
2692 [meta] server status: 34
2693 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2694 [meta] warning count: 0
2695
2696 [meta][field] db name: test
2697 [meta][field] table name: t1
2698 [meta][field] org table name: t1
2699 [meta][field] col name: a
2700 [meta][field] org col name: a
2701 [meta][field] length: 80
2702 [meta][field] charsetnr: 255
2703 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
2704 [meta][field] decimals: 0
2705 [meta][field] type: VARCHAR (15)
2706
2707 [meta][field] db name: test
2708 [meta][field] table name: t1
2709 [meta][field] org table name: t1
2710 [meta][field] col name: b
2711 [meta][field] org col name: b
2712 [meta][field] length: 80
2713 [meta][field] charsetnr: 255
2714 [meta][field] flags: 0
2715 [meta][field] decimals: 0
2716 [meta][field] type: VARCHAR (15)
2717
2718
2719 [meta][charset result] number: 33
2720 [meta][charset result] name: utf8mb3
2721 [meta][charset result] collation: utf8mb3_general_ci
2722 [meta][charset result] sort order:
2723
2724 [data] no rows
2725
2726 [end] server status: 34
2727 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2728 [end] warning count: 0
2729 [end] affected rows: 0
2730 [end] last insert id: 0
2731 [end] message:
2732 ------------------------------------------------------------------
2733 EXECUTING:[COM_INIT_DB][test]
2734 ------------------------------------------------------------------
2735 EXECUTING:[36][SET @@session.sql_mode = TRADITIONAL]
2736 [CS_TEXT_REPRESENTATION]
2737 [meta] rows: 0
2738 [meta] cols: 0
2739 [meta] server status: 0
2740 [meta] server status:
2741 [meta] warning count: 0
2742
2743 [meta] no columns
2744
2745 [meta] no charset
2746
2747 [data] no rows
2748
2749 [end] server status: 2
2750 [end] server status: AUTOCOMMIT
2751 [end] warning count: 0
2752 [end] affected rows: 0
2753 [end] last insert id: 0
2754 [end] message:
2755 ------------------------------------------------------------------
2756 EXECUTING:[25][SELECT @@session.sql_mode]
2757 [CS_TEXT_REPRESENTATION]
2758 [meta] rows: 1
2759 [meta] cols: 1
2760 [meta] server status: 2
2761 [meta] server status: AUTOCOMMIT
2762 [meta] warning count: 0
2763
2764 [meta][field] db name:
2765 [meta][field] table name:
2766 [meta][field] org table name:
2767 [meta][field] col name: @@session.sql_mode
2768 [meta][field] org col name:
2769 [meta][field] length: 65535
2770 [meta][field] charsetnr: 33
2771 [meta][field] flags: 0
2772 [meta][field] decimals: 31
2773 [meta][field] type: VARCHAR (15)
2774
2775
2776 [meta][charset result] number: 33
2777 [meta][charset result] name: utf8mb3
2778 [meta][charset result] collation: utf8mb3_general_ci
2779 [meta][charset result] sort order:
2780
2781 [data][.@@session.sql_mode][128][STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION]
2782
2783 [end] server status: 2
2784 [end] server status: AUTOCOMMIT
2785 [end] warning count: 0
2786 [end] affected rows: 0
2787 [end] last insert id: 0
2788 [end] message:
2789 [CS_BINARY_REPRESENTATION]
2790 [meta] rows: 1
2791 [meta] cols: 1
2792 [meta] server status: 2
2793 [meta] server status: AUTOCOMMIT
2794 [meta] warning count: 0
2795
2796 [meta][field] db name:
2797 [meta][field] table name:
2798 [meta][field] org table name:
2799 [meta][field] col name: @@session.sql_mode
2800 [meta][field] org col name:
2801 [meta][field] length: 65535
2802 [meta][field] charsetnr: 33
2803 [meta][field] flags: 0
2804 [meta][field] decimals: 31
2805 [meta][field] type: VARCHAR (15)
2806
2807
2808 [meta][charset result] number: 33
2809 [meta][charset result] name: utf8mb3
2810 [meta][charset result] collation: utf8mb3_general_ci
2811 [meta][charset result] sort order:
2812
2813 [data][.@@session.sql_mode][128][STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION]
2814
2815 [end] server status: 2
2816 [end] server status: AUTOCOMMIT
2817 [end] warning count: 0
2818 [end] affected rows: 0
2819 [end] last insert id: 0
2820 [end] message:
2821 ------------------------------------------------------------------
2822 EXECUTING:[COM_INIT_DB][test]
2823 ------------------------------------------------------------------
2824 EXECUTING:[34][INSERT INTO t2 VALUES(NULL,'t2b1')]
2825 [CS_TEXT_REPRESENTATION]
2826 [meta] rows: 0
2827 [meta] cols: 0
2828 [meta] server status: 0
2829 [meta] server status:
2830 [meta] warning count: 0
2831
2832 [meta] no columns
2833
2834 [meta] no charset
2835
2836 [data] no rows
2837
2838 [end] server status: 2
2839 [end] server status: AUTOCOMMIT
2840 [end] warning count: 0
2841 [end] affected rows: 1
2842 [end] last insert id: 0
2843 [end] message:
2844 ------------------------------------------------------------------
2845 EXECUTING:[COM_INIT_DB][test]
2846 ------------------------------------------------------------------
2847 EXECUTING:[31][INSERT INTO t1 SELECT * FROM t2]
2848 [CS_TEXT_REPRESENTATION]
2849 [1048][23000][Column 'a' cannot be null]
2850 [meta] rows: 0
2851 [meta] cols: 0
2852 [meta] server status: 0
2853 [meta] server status:
2854 [meta] warning count: 0
2855
2856 [meta] no columns
2857
2858 [meta] no charset
2859
2860 [data] no rows
2861
2862 [end] server status: 0
2863 [end] server status:
2864 [end] warning count: 0
2865 [end] affected rows: 0
2866 [end] last insert id: 0
2867 [end] message:
2868 ------------------------------------------------------------------
2869 EXECUTING:[COM_INIT_DB][test]
2870 ------------------------------------------------------------------
2871 EXECUTING:[33][SELECT * FROM t1 WHERE a = 't2a2']
2872 [CS_TEXT_REPRESENTATION]
2873 [meta] rows: 0
2874 [meta] cols: 2
2875 [meta] server status: 34
2876 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2877 [meta] warning count: 0
2878
2879 [meta][field] db name: test
2880 [meta][field] table name: t1
2881 [meta][field] org table name: t1
2882 [meta][field] col name: a
2883 [meta][field] org col name: a
2884 [meta][field] length: 80
2885 [meta][field] charsetnr: 255
2886 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
2887 [meta][field] decimals: 0
2888 [meta][field] type: VARCHAR (15)
2889
2890 [meta][field] db name: test
2891 [meta][field] table name: t1
2892 [meta][field] org table name: t1
2893 [meta][field] col name: b
2894 [meta][field] org col name: b
2895 [meta][field] length: 80
2896 [meta][field] charsetnr: 255
2897 [meta][field] flags: 0
2898 [meta][field] decimals: 0
2899 [meta][field] type: VARCHAR (15)
2900
2901
2902 [meta][charset result] number: 33
2903 [meta][charset result] name: utf8mb3
2904 [meta][charset result] collation: utf8mb3_general_ci
2905 [meta][charset result] sort order:
2906
2907 [data] no rows
2908
2909 [end] server status: 34
2910 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2911 [end] warning count: 0
2912 [end] affected rows: 0
2913 [end] last insert id: 0
2914 [end] message:
2915 [CS_BINARY_REPRESENTATION]
2916 [meta] rows: 0
2917 [meta] cols: 2
2918 [meta] server status: 34
2919 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2920 [meta] warning count: 0
2921
2922 [meta][field] db name: test
2923 [meta][field] table name: t1
2924 [meta][field] org table name: t1
2925 [meta][field] col name: a
2926 [meta][field] org col name: a
2927 [meta][field] length: 80
2928 [meta][field] charsetnr: 255
2929 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
2930 [meta][field] decimals: 0
2931 [meta][field] type: VARCHAR (15)
2932
2933 [meta][field] db name: test
2934 [meta][field] table name: t1
2935 [meta][field] org table name: t1
2936 [meta][field] col name: b
2937 [meta][field] org col name: b
2938 [meta][field] length: 80
2939 [meta][field] charsetnr: 255
2940 [meta][field] flags: 0
2941 [meta][field] decimals: 0
2942 [meta][field] type: VARCHAR (15)
2943
2944
2945 [meta][charset result] number: 33
2946 [meta][charset result] name: utf8mb3
2947 [meta][charset result] collation: utf8mb3_general_ci
2948 [meta][charset result] sort order:
2949
2950 [data] no rows
2951
2952 [end] server status: 34
2953 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2954 [end] warning count: 0
2955 [end] affected rows: 0
2956 [end] last insert id: 0
2957 [end] message:
2958 ------------------------------------------------------------------
2959 EXECUTING:[47][SET @@global.sql_mode = NO_UNSIGNED_SUBTRACTION]
2960 [CS_TEXT_REPRESENTATION]
2961 [meta] rows: 0
2962 [meta] cols: 0
2963 [meta] server status: 0
2964 [meta] server status:
2965 [meta] warning count: 0
2966
2967 [meta] no columns
2968
2969 [meta] no charset
2970
2971 [data] no rows
2972
2973 [end] server status: 2
2974 [end] server status: AUTOCOMMIT
2975 [end] warning count: 0
2976 [end] affected rows: 0
2977 [end] last insert id: 0
2978 [end] message:
2979 ------------------------------------------------------------------
2980 EXECUTING:[48][SET @@session.sql_mode = NO_UNSIGNED_SUBTRACTION]
2981 [CS_TEXT_REPRESENTATION]
2982 [meta] rows: 0
2983 [meta] cols: 0
2984 [meta] server status: 0
2985 [meta] server status:
2986 [meta] warning count: 0
2987
2988 [meta] no columns
2989
2990 [meta] no charset
2991
2992 [data] no rows
2993
2994 [end] server status: 2
2995 [end] server status: AUTOCOMMIT
2996 [end] warning count: 0
2997 [end] affected rows: 0
2998 [end] last insert id: 0
2999 [end] message:
3000 ------------------------------------------------------------------
3001 [srv_session_close]
3002 deinit thread
3003 SELECT @@global.sql_mode;
3004 @@global.sql_mode
3005 NO_UNSIGNED_SUBTRACTION
3006 SELECT @@session.sql_mode;
3007 @@session.sql_mode
3008 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
3009 SET @@session.sql_mode = @@global.sql_mode;
3010 SELECT @@session.sql_mode;
3011 @@session.sql_mode
3012 NO_UNSIGNED_SUBTRACTION
3013 # SQL_MODE : NO_UNSIGNED_SUBTRACTION(Checking whether subtraction result is signed)
3014 SELECT CAST(0 AS UNSIGNED) - 1;
3015 CAST(0 AS UNSIGNED) - 1
3016 -1
3017 ##########################################
3018 # Cleanup
3019 ##########################################
3020 # Dropping the created tables
3021 DROP TABLE t1;
3022 DROP TABLE t2;
3023 SET @@global.sql_mode = @sql_mode_global;
3024 SET @@session.sql_mode = @sql_mode_session;