Debian Codegraph @

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

raw
1 # Creating table t1
2 CREATE TABLE t1(c1 INT, c2 VARCHAR(128));
3 INSERT INTO t1 VALUES (1, 'aaa'), (2, 'bbb'), (3, 'ccc');
4 # Creating a view
5 CREATE VIEW v1 AS SELECT * FROM t1;
6 # Creating table t2
7 CREATE TABLE t2(c1 INT, c2 VARCHAR(128));
8 # Creating a trigger
9 CREATE TRIGGER trig AFTER UPDATE ON t1 FOR EACH ROW INSERT INTO t2 VALUES (1, 'aaa');
10 ##########################################
11 # Run plugin
12 ##########################################
13 INSTALL PLUGIN test_sql_views_triggers SONAME 'TEST_SQL_VIEWS_TRIGGERS';
14 ##########################################
15 # Stop plugin
16 ##########################################
17 UNINSTALL PLUGIN test_sql_views_triggers;
18 ##########################################
19 # Plugin log
20 ##########################################
21 ========================================================================
22 Test in a server thread
23 [srv_session_open]
24 ------------------------------------------------------------------
25 EXECUTING:[35][SELECT 'first complex command' as a]
26 [CS_TEXT_REPRESENTATION]
27 [meta] rows: 1
28 [meta] cols: 1
29 [meta] server status: 2
30 [meta] server status: AUTOCOMMIT
31 [meta] warning count: 0
32
33 [meta][field] db name:
34 [meta][field] table name:
35 [meta][field] org table name:
36 [meta][field] col name: a
37 [meta][field] org col name:
38 [meta][field] length: 63
39 [meta][field] charsetnr: 33
40 [meta][field] flags: 1 (NOT_NULL )
41 [meta][field] decimals: 31
42 [meta][field] type: VARCHAR (15)
43
44
45 [meta][charset result] number: 33
46 [meta][charset result] name: utf8mb3
47 [meta][charset result] collation: utf8mb3_general_ci
48 [meta][charset result] sort order:
49
50 [data][.a][ 21][first complex command]
51
52 [end] server status: 2
53 [end] server status: AUTOCOMMIT
54 [end] warning count: 0
55 [end] affected rows: 0
56 [end] last insert id: 0
57 [end] message:
58 [CS_BINARY_REPRESENTATION]
59 [meta] rows: 1
60 [meta] cols: 1
61 [meta] server status: 2
62 [meta] server status: AUTOCOMMIT
63 [meta] warning count: 0
64
65 [meta][field] db name:
66 [meta][field] table name:
67 [meta][field] org table name:
68 [meta][field] col name: a
69 [meta][field] org col name:
70 [meta][field] length: 63
71 [meta][field] charsetnr: 33
72 [meta][field] flags: 1 (NOT_NULL )
73 [meta][field] decimals: 31
74 [meta][field] type: VARCHAR (15)
75
76
77 [meta][charset result] number: 33
78 [meta][charset result] name: utf8mb3
79 [meta][charset result] collation: utf8mb3_general_ci
80 [meta][charset result] sort order:
81
82 [data][.a][ 21][first complex command]
83
84 [end] server status: 2
85 [end] server status: AUTOCOMMIT
86 [end] warning count: 0
87 [end] affected rows: 0
88 [end] last insert id: 0
89 [end] message:
90 ------------------------------------------------------------------
91 EXECUTING:[COM_INIT_DB][test]
92 ------------------------------------------------------------------
93 EXECUTING:[16][SELECT * FROM v1]
94 [CS_TEXT_REPRESENTATION]
95 [meta] rows: 3
96 [meta] cols: 2
97 [meta] server status: 34
98 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
99 [meta] warning count: 0
100
101 [meta][field] db name: test
102 [meta][field] table name: v1
103 [meta][field] org table name: v1
104 [meta][field] col name: c1
105 [meta][field] org col name: c1
106 [meta][field] length: 11
107 [meta][field] charsetnr: 8
108 [meta][field] flags: 0
109 [meta][field] decimals: 0
110 [meta][field] type: LONG (3)
111
112 [meta][field] db name: test
113 [meta][field] table name: v1
114 [meta][field] org table name: v1
115 [meta][field] col name: c2
116 [meta][field] org col name: c2
117 [meta][field] length: 512
118 [meta][field] charsetnr: 255
119 [meta][field] flags: 0
120 [meta][field] decimals: 0
121 [meta][field] type: VARCHAR (15)
122
123
124 [meta][charset result] number: 33
125 [meta][charset result] name: utf8mb3
126 [meta][charset result] collation: utf8mb3_general_ci
127 [meta][charset result] sort order:
128
129 [data][v1.c1][ 1][1]
130 [data][v1.c2][ 3][aaa]
131
132 [data][v1.c1][ 1][2]
133 [data][v1.c2][ 3][bbb]
134
135 [data][v1.c1][ 1][3]
136 [data][v1.c2][ 3][ccc]
137
138 [end] server status: 34
139 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
140 [end] warning count: 0
141 [end] affected rows: 0
142 [end] last insert id: 0
143 [end] message:
144 [CS_BINARY_REPRESENTATION]
145 [meta] rows: 3
146 [meta] cols: 2
147 [meta] server status: 34
148 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
149 [meta] warning count: 0
150
151 [meta][field] db name: test
152 [meta][field] table name: v1
153 [meta][field] org table name: v1
154 [meta][field] col name: c1
155 [meta][field] org col name: c1
156 [meta][field] length: 11
157 [meta][field] charsetnr: 8
158 [meta][field] flags: 0
159 [meta][field] decimals: 0
160 [meta][field] type: LONG (3)
161
162 [meta][field] db name: test
163 [meta][field] table name: v1
164 [meta][field] org table name: v1
165 [meta][field] col name: c2
166 [meta][field] org col name: c2
167 [meta][field] length: 512
168 [meta][field] charsetnr: 255
169 [meta][field] flags: 0
170 [meta][field] decimals: 0
171 [meta][field] type: VARCHAR (15)
172
173
174 [meta][charset result] number: 33
175 [meta][charset result] name: utf8mb3
176 [meta][charset result] collation: utf8mb3_general_ci
177 [meta][charset result] sort order:
178
179 [data][v1.c1][ 1][1]
180 [data][v1.c2][ 3][aaa]
181
182 [data][v1.c1][ 1][2]
183 [data][v1.c2][ 3][bbb]
184
185 [data][v1.c1][ 1][3]
186 [data][v1.c2][ 3][ccc]
187
188 [end] server status: 34
189 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
190 [end] warning count: 0
191 [end] affected rows: 0
192 [end] last insert id: 0
193 [end] message:
194 ------------------------------------------------------------------
195 EXECUTING:[102][SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'v1']
196 [CS_TEXT_REPRESENTATION]
197 [meta] rows: 1
198 [meta] cols: 1
199 [meta] server status: 2
200 [meta] server status: AUTOCOMMIT
201 [meta] warning count: 0
202
203 [meta][field] db name:
204 [meta][field] table name: VIEWS
205 [meta][field] org table name: VIEWS
206 [meta][field] col name: VIEW_DEFINITION
207 [meta][field] org col name: VIEW_DEFINITION
208 [meta][field] length: 4294967295
209 [meta][field] charsetnr: 83
210 [meta][field] flags: 128 (BINARY )
211 [meta][field] decimals: 31
212 [meta][field] type: BLOB (252)
213
214
215 [meta][charset result] number: 33
216 [meta][charset result] name: utf8mb3
217 [meta][charset result] collation: utf8mb3_general_ci
218 [meta][charset result] sort order:
219
220 [data][VIEWS.VIEW_DEFINITION][ 73][select `test`.`t1`.`c1` AS `c1`,`test`.`t1`.`c2` AS `c2` from `test`.`t1`]
221
222 [end] server status: 2
223 [end] server status: AUTOCOMMIT
224 [end] warning count: 0
225 [end] affected rows: 0
226 [end] last insert id: 0
227 [end] message:
228 [CS_BINARY_REPRESENTATION]
229 [meta] rows: 1
230 [meta] cols: 1
231 [meta] server status: 2
232 [meta] server status: AUTOCOMMIT
233 [meta] warning count: 0
234
235 [meta][field] db name:
236 [meta][field] table name: VIEWS
237 [meta][field] org table name: VIEWS
238 [meta][field] col name: VIEW_DEFINITION
239 [meta][field] org col name: VIEW_DEFINITION
240 [meta][field] length: 4294967295
241 [meta][field] charsetnr: 83
242 [meta][field] flags: 128 (BINARY )
243 [meta][field] decimals: 31
244 [meta][field] type: BLOB (252)
245
246
247 [meta][charset result] number: 33
248 [meta][charset result] name: utf8mb3
249 [meta][charset result] collation: utf8mb3_general_ci
250 [meta][charset result] sort order:
251
252 [data][VIEWS.VIEW_DEFINITION][ 73][select `test`.`t1`.`c1` AS `c1`,`test`.`t1`.`c2` AS `c2` from `test`.`t1`]
253
254 [end] server status: 2
255 [end] server status: AUTOCOMMIT
256 [end] warning count: 0
257 [end] affected rows: 0
258 [end] last insert id: 0
259 [end] message:
260 ------------------------------------------------------------------
261 EXECUTING:[COM_INIT_DB][test]
262 ------------------------------------------------------------------
263 EXECUTING:[12][DROP VIEW v1]
264 [CS_TEXT_REPRESENTATION]
265 [meta] rows: 0
266 [meta] cols: 0
267 [meta] server status: 0
268 [meta] server status:
269 [meta] warning count: 0
270
271 [meta] no columns
272
273 [meta] no charset
274
275 [data] no rows
276
277 [end] server status: 2
278 [end] server status: AUTOCOMMIT
279 [end] warning count: 0
280 [end] affected rows: 0
281 [end] last insert id: 0
282 [end] message:
283 ------------------------------------------------------------------
284 EXECUTING:[COM_INIT_DB][test]
285 ------------------------------------------------------------------
286 EXECUTING:[34][CREATE VIEW v1 AS SELECT * FROM t1]
287 [CS_TEXT_REPRESENTATION]
288 [meta] rows: 0
289 [meta] cols: 0
290 [meta] server status: 0
291 [meta] server status:
292 [meta] warning count: 0
293
294 [meta] no columns
295
296 [meta] no charset
297
298 [data] no rows
299
300 [end] server status: 2
301 [end] server status: AUTOCOMMIT
302 [end] warning count: 0
303 [end] affected rows: 0
304 [end] last insert id: 0
305 [end] message:
306 ------------------------------------------------------------------
307 EXECUTING:[COM_INIT_DB][test]
308 ------------------------------------------------------------------
309 EXECUTING:[16][SELECT * FROM v1]
310 [CS_TEXT_REPRESENTATION]
311 [meta] rows: 3
312 [meta] cols: 2
313 [meta] server status: 34
314 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
315 [meta] warning count: 0
316
317 [meta][field] db name: test
318 [meta][field] table name: v1
319 [meta][field] org table name: v1
320 [meta][field] col name: c1
321 [meta][field] org col name: c1
322 [meta][field] length: 11
323 [meta][field] charsetnr: 8
324 [meta][field] flags: 0
325 [meta][field] decimals: 0
326 [meta][field] type: LONG (3)
327
328 [meta][field] db name: test
329 [meta][field] table name: v1
330 [meta][field] org table name: v1
331 [meta][field] col name: c2
332 [meta][field] org col name: c2
333 [meta][field] length: 512
334 [meta][field] charsetnr: 255
335 [meta][field] flags: 0
336 [meta][field] decimals: 0
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][v1.c1][ 1][1]
346 [data][v1.c2][ 3][aaa]
347
348 [data][v1.c1][ 1][2]
349 [data][v1.c2][ 3][bbb]
350
351 [data][v1.c1][ 1][3]
352 [data][v1.c2][ 3][ccc]
353
354 [end] server status: 34
355 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
356 [end] warning count: 0
357 [end] affected rows: 0
358 [end] last insert id: 0
359 [end] message:
360 [CS_BINARY_REPRESENTATION]
361 [meta] rows: 3
362 [meta] cols: 2
363 [meta] server status: 34
364 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
365 [meta] warning count: 0
366
367 [meta][field] db name: test
368 [meta][field] table name: v1
369 [meta][field] org table name: v1
370 [meta][field] col name: c1
371 [meta][field] org col name: c1
372 [meta][field] length: 11
373 [meta][field] charsetnr: 8
374 [meta][field] flags: 0
375 [meta][field] decimals: 0
376 [meta][field] type: LONG (3)
377
378 [meta][field] db name: test
379 [meta][field] table name: v1
380 [meta][field] org table name: v1
381 [meta][field] col name: c2
382 [meta][field] org col name: c2
383 [meta][field] length: 512
384 [meta][field] charsetnr: 255
385 [meta][field] flags: 0
386 [meta][field] decimals: 0
387 [meta][field] type: VARCHAR (15)
388
389
390 [meta][charset result] number: 33
391 [meta][charset result] name: utf8mb3
392 [meta][charset result] collation: utf8mb3_general_ci
393 [meta][charset result] sort order:
394
395 [data][v1.c1][ 1][1]
396 [data][v1.c2][ 3][aaa]
397
398 [data][v1.c1][ 1][2]
399 [data][v1.c2][ 3][bbb]
400
401 [data][v1.c1][ 1][3]
402 [data][v1.c2][ 3][ccc]
403
404 [end] server status: 34
405 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
406 [end] warning count: 0
407 [end] affected rows: 0
408 [end] last insert id: 0
409 [end] message:
410 ------------------------------------------------------------------
411 EXECUTING:[COM_INIT_DB][test]
412 ------------------------------------------------------------------
413 EXECUTING:[39][UPDATE t1 SET c2 = 'abcde' WHERE c1 = 1]
414 [CS_TEXT_REPRESENTATION]
415 [meta] rows: 0
416 [meta] cols: 0
417 [meta] server status: 0
418 [meta] server status:
419 [meta] warning count: 0
420
421 [meta] no columns
422
423 [meta] no charset
424
425 [data] no rows
426
427 [end] server status: 34
428 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
429 [end] warning count: 0
430 [end] affected rows: 1
431 [end] last insert id: 0
432 [end] message: Rows matched: 1 Changed: 1 Warnings: 0
433 ------------------------------------------------------------------
434 EXECUTING:[COM_INIT_DB][test]
435 ------------------------------------------------------------------
436 EXECUTING:[16][SELECT * FROM t2]
437 [CS_TEXT_REPRESENTATION]
438 [meta] rows: 1
439 [meta] cols: 2
440 [meta] server status: 34
441 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
442 [meta] warning count: 0
443
444 [meta][field] db name: test
445 [meta][field] table name: t2
446 [meta][field] org table name: t2
447 [meta][field] col name: c1
448 [meta][field] org col name: c1
449 [meta][field] length: 11
450 [meta][field] charsetnr: 8
451 [meta][field] flags: 0
452 [meta][field] decimals: 0
453 [meta][field] type: LONG (3)
454
455 [meta][field] db name: test
456 [meta][field] table name: t2
457 [meta][field] org table name: t2
458 [meta][field] col name: c2
459 [meta][field] org col name: c2
460 [meta][field] length: 512
461 [meta][field] charsetnr: 255
462 [meta][field] flags: 0
463 [meta][field] decimals: 0
464 [meta][field] type: VARCHAR (15)
465
466
467 [meta][charset result] number: 33
468 [meta][charset result] name: utf8mb3
469 [meta][charset result] collation: utf8mb3_general_ci
470 [meta][charset result] sort order:
471
472 [data][t2.c1][ 1][1]
473 [data][t2.c2][ 3][aaa]
474
475 [end] server status: 34
476 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
477 [end] warning count: 0
478 [end] affected rows: 0
479 [end] last insert id: 0
480 [end] message:
481 [CS_BINARY_REPRESENTATION]
482 [meta] rows: 1
483 [meta] cols: 2
484 [meta] server status: 34
485 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
486 [meta] warning count: 0
487
488 [meta][field] db name: test
489 [meta][field] table name: t2
490 [meta][field] org table name: t2
491 [meta][field] col name: c1
492 [meta][field] org col name: c1
493 [meta][field] length: 11
494 [meta][field] charsetnr: 8
495 [meta][field] flags: 0
496 [meta][field] decimals: 0
497 [meta][field] type: LONG (3)
498
499 [meta][field] db name: test
500 [meta][field] table name: t2
501 [meta][field] org table name: t2
502 [meta][field] col name: c2
503 [meta][field] org col name: c2
504 [meta][field] length: 512
505 [meta][field] charsetnr: 255
506 [meta][field] flags: 0
507 [meta][field] decimals: 0
508 [meta][field] type: VARCHAR (15)
509
510
511 [meta][charset result] number: 33
512 [meta][charset result] name: utf8mb3
513 [meta][charset result] collation: utf8mb3_general_ci
514 [meta][charset result] sort order:
515
516 [data][t2.c1][ 1][1]
517 [data][t2.c2][ 3][aaa]
518
519 [end] server status: 34
520 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
521 [end] warning count: 0
522 [end] affected rows: 0
523 [end] last insert id: 0
524 [end] message:
525 ------------------------------------------------------------------
526 EXECUTING:[108][SELECT TRIGGER_NAME FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_SCHEMA = 'test' AND TRIGGER_NAME = 'trig']
527 [CS_TEXT_REPRESENTATION]
528 [meta] rows: 1
529 [meta] cols: 1
530 [meta] server status: 34
531 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
532 [meta] warning count: 0
533
534 [meta][field] db name: information_schema
535 [meta][field] table name: TRIGGERS
536 [meta][field] org table name: TRIGGERS
537 [meta][field] col name: TRIGGER_NAME
538 [meta][field] org col name: TRIGGER_NAME
539 [meta][field] length: 192
540 [meta][field] charsetnr: 33
541 [meta][field] flags: 20481 (NOT_NULL NO_DEFAULT_VALUE PART_KEY )
542 [meta][field] decimals: 0
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][TRIGGERS.TRIGGER_NAME][ 4][trig]
552
553 [end] server status: 34
554 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
555 [end] warning count: 0
556 [end] affected rows: 0
557 [end] last insert id: 0
558 [end] message:
559 [CS_BINARY_REPRESENTATION]
560 [meta] rows: 1
561 [meta] cols: 1
562 [meta] server status: 34
563 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
564 [meta] warning count: 0
565
566 [meta][field] db name: information_schema
567 [meta][field] table name: TRIGGERS
568 [meta][field] org table name: TRIGGERS
569 [meta][field] col name: TRIGGER_NAME
570 [meta][field] org col name: TRIGGER_NAME
571 [meta][field] length: 192
572 [meta][field] charsetnr: 33
573 [meta][field] flags: 20481 (NOT_NULL NO_DEFAULT_VALUE PART_KEY )
574 [meta][field] decimals: 0
575 [meta][field] type: VARCHAR (15)
576
577
578 [meta][charset result] number: 33
579 [meta][charset result] name: utf8mb3
580 [meta][charset result] collation: utf8mb3_general_ci
581 [meta][charset result] sort order:
582
583 [data][TRIGGERS.TRIGGER_NAME][ 4][trig]
584
585 [end] server status: 34
586 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
587 [end] warning count: 0
588 [end] affected rows: 0
589 [end] last insert id: 0
590 [end] message:
591 ------------------------------------------------------------------
592 EXECUTING:[COM_INIT_DB][test]
593 ------------------------------------------------------------------
594 EXECUTING:[17][DROP TRIGGER trig]
595 [CS_TEXT_REPRESENTATION]
596 [meta] rows: 0
597 [meta] cols: 0
598 [meta] server status: 0
599 [meta] server status:
600 [meta] warning count: 0
601
602 [meta] no columns
603
604 [meta] no charset
605
606 [data] no rows
607
608 [end] server status: 2
609 [end] server status: AUTOCOMMIT
610 [end] warning count: 0
611 [end] affected rows: 0
612 [end] last insert id: 0
613 [end] message:
614 ------------------------------------------------------------------
615 EXECUTING:[COM_INIT_DB][test]
616 ------------------------------------------------------------------
617 EXECUTING:[84][CREATE TRIGGER trig AFTER UPDATE ON t1 FOR EACH ROW INSERT INTO t2 VALUES (1, 'aaa')]
618 [CS_TEXT_REPRESENTATION]
619 [meta] rows: 0
620 [meta] cols: 0
621 [meta] server status: 0
622 [meta] server status:
623 [meta] warning count: 0
624
625 [meta] no columns
626
627 [meta] no charset
628
629 [data] no rows
630
631 [end] server status: 2
632 [end] server status: AUTOCOMMIT
633 [end] warning count: 0
634 [end] affected rows: 0
635 [end] last insert id: 0
636 [end] message:
637 ------------------------------------------------------------------
638 EXECUTING:[COM_INIT_DB][test]
639 ------------------------------------------------------------------
640 EXECUTING:[39][UPDATE t1 SET c2 = 'abcde' WHERE c1 = 1]
641 [CS_TEXT_REPRESENTATION]
642 [meta] rows: 0
643 [meta] cols: 0
644 [meta] server status: 0
645 [meta] server status:
646 [meta] warning count: 0
647
648 [meta] no columns
649
650 [meta] no charset
651
652 [data] no rows
653
654 [end] server status: 34
655 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
656 [end] warning count: 0
657 [end] affected rows: 0
658 [end] last insert id: 0
659 [end] message: Rows matched: 1 Changed: 0 Warnings: 0
660 ------------------------------------------------------------------
661 EXECUTING:[COM_INIT_DB][test]
662 ------------------------------------------------------------------
663 EXECUTING:[16][SELECT * FROM t2]
664 [CS_TEXT_REPRESENTATION]
665 [meta] rows: 2
666 [meta] cols: 2
667 [meta] server status: 34
668 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
669 [meta] warning count: 0
670
671 [meta][field] db name: test
672 [meta][field] table name: t2
673 [meta][field] org table name: t2
674 [meta][field] col name: c1
675 [meta][field] org col name: c1
676 [meta][field] length: 11
677 [meta][field] charsetnr: 8
678 [meta][field] flags: 0
679 [meta][field] decimals: 0
680 [meta][field] type: LONG (3)
681
682 [meta][field] db name: test
683 [meta][field] table name: t2
684 [meta][field] org table name: t2
685 [meta][field] col name: c2
686 [meta][field] org col name: c2
687 [meta][field] length: 512
688 [meta][field] charsetnr: 255
689 [meta][field] flags: 0
690 [meta][field] decimals: 0
691 [meta][field] type: VARCHAR (15)
692
693
694 [meta][charset result] number: 33
695 [meta][charset result] name: utf8mb3
696 [meta][charset result] collation: utf8mb3_general_ci
697 [meta][charset result] sort order:
698
699 [data][t2.c1][ 1][1]
700 [data][t2.c2][ 3][aaa]
701
702 [data][t2.c1][ 1][1]
703 [data][t2.c2][ 3][aaa]
704
705 [end] server status: 34
706 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
707 [end] warning count: 0
708 [end] affected rows: 0
709 [end] last insert id: 0
710 [end] message:
711 [CS_BINARY_REPRESENTATION]
712 [meta] rows: 2
713 [meta] cols: 2
714 [meta] server status: 34
715 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
716 [meta] warning count: 0
717
718 [meta][field] db name: test
719 [meta][field] table name: t2
720 [meta][field] org table name: t2
721 [meta][field] col name: c1
722 [meta][field] org col name: c1
723 [meta][field] length: 11
724 [meta][field] charsetnr: 8
725 [meta][field] flags: 0
726 [meta][field] decimals: 0
727 [meta][field] type: LONG (3)
728
729 [meta][field] db name: test
730 [meta][field] table name: t2
731 [meta][field] org table name: t2
732 [meta][field] col name: c2
733 [meta][field] org col name: c2
734 [meta][field] length: 512
735 [meta][field] charsetnr: 255
736 [meta][field] flags: 0
737 [meta][field] decimals: 0
738 [meta][field] type: VARCHAR (15)
739
740
741 [meta][charset result] number: 33
742 [meta][charset result] name: utf8mb3
743 [meta][charset result] collation: utf8mb3_general_ci
744 [meta][charset result] sort order:
745
746 [data][t2.c1][ 1][1]
747 [data][t2.c2][ 3][aaa]
748
749 [data][t2.c1][ 1][1]
750 [data][t2.c2][ 3][aaa]
751
752 [end] server status: 34
753 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
754 [end] warning count: 0
755 [end] affected rows: 0
756 [end] last insert id: 0
757 [end] message:
758 ------------------------------------------------------------------
759 [srv_session_close]
760 Follows threaded run
761 ========================================================================
762 init thread
763 [srv_session_open]
764 ------------------------------------------------------------------
765 EXECUTING:[35][SELECT 'first complex command' as a]
766 [CS_TEXT_REPRESENTATION]
767 [meta] rows: 1
768 [meta] cols: 1
769 [meta] server status: 2
770 [meta] server status: AUTOCOMMIT
771 [meta] warning count: 0
772
773 [meta][field] db name:
774 [meta][field] table name:
775 [meta][field] org table name:
776 [meta][field] col name: a
777 [meta][field] org col name:
778 [meta][field] length: 63
779 [meta][field] charsetnr: 33
780 [meta][field] flags: 1 (NOT_NULL )
781 [meta][field] decimals: 31
782 [meta][field] type: VARCHAR (15)
783
784
785 [meta][charset result] number: 33
786 [meta][charset result] name: utf8mb3
787 [meta][charset result] collation: utf8mb3_general_ci
788 [meta][charset result] sort order:
789
790 [data][.a][ 21][first complex command]
791
792 [end] server status: 2
793 [end] server status: AUTOCOMMIT
794 [end] warning count: 0
795 [end] affected rows: 0
796 [end] last insert id: 0
797 [end] message:
798 [CS_BINARY_REPRESENTATION]
799 [meta] rows: 1
800 [meta] cols: 1
801 [meta] server status: 2
802 [meta] server status: AUTOCOMMIT
803 [meta] warning count: 0
804
805 [meta][field] db name:
806 [meta][field] table name:
807 [meta][field] org table name:
808 [meta][field] col name: a
809 [meta][field] org col name:
810 [meta][field] length: 63
811 [meta][field] charsetnr: 33
812 [meta][field] flags: 1 (NOT_NULL )
813 [meta][field] decimals: 31
814 [meta][field] type: VARCHAR (15)
815
816
817 [meta][charset result] number: 33
818 [meta][charset result] name: utf8mb3
819 [meta][charset result] collation: utf8mb3_general_ci
820 [meta][charset result] sort order:
821
822 [data][.a][ 21][first complex command]
823
824 [end] server status: 2
825 [end] server status: AUTOCOMMIT
826 [end] warning count: 0
827 [end] affected rows: 0
828 [end] last insert id: 0
829 [end] message:
830 ------------------------------------------------------------------
831 EXECUTING:[COM_INIT_DB][test]
832 ------------------------------------------------------------------
833 EXECUTING:[16][SELECT * FROM v1]
834 [CS_TEXT_REPRESENTATION]
835 [meta] rows: 3
836 [meta] cols: 2
837 [meta] server status: 34
838 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
839 [meta] warning count: 0
840
841 [meta][field] db name: test
842 [meta][field] table name: v1
843 [meta][field] org table name: v1
844 [meta][field] col name: c1
845 [meta][field] org col name: c1
846 [meta][field] length: 11
847 [meta][field] charsetnr: 8
848 [meta][field] flags: 0
849 [meta][field] decimals: 0
850 [meta][field] type: LONG (3)
851
852 [meta][field] db name: test
853 [meta][field] table name: v1
854 [meta][field] org table name: v1
855 [meta][field] col name: c2
856 [meta][field] org col name: c2
857 [meta][field] length: 512
858 [meta][field] charsetnr: 255
859 [meta][field] flags: 0
860 [meta][field] decimals: 0
861 [meta][field] type: VARCHAR (15)
862
863
864 [meta][charset result] number: 33
865 [meta][charset result] name: utf8mb3
866 [meta][charset result] collation: utf8mb3_general_ci
867 [meta][charset result] sort order:
868
869 [data][v1.c1][ 1][1]
870 [data][v1.c2][ 5][abcde]
871
872 [data][v1.c1][ 1][2]
873 [data][v1.c2][ 3][bbb]
874
875 [data][v1.c1][ 1][3]
876 [data][v1.c2][ 3][ccc]
877
878 [end] server status: 34
879 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
880 [end] warning count: 0
881 [end] affected rows: 0
882 [end] last insert id: 0
883 [end] message:
884 [CS_BINARY_REPRESENTATION]
885 [meta] rows: 3
886 [meta] cols: 2
887 [meta] server status: 34
888 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
889 [meta] warning count: 0
890
891 [meta][field] db name: test
892 [meta][field] table name: v1
893 [meta][field] org table name: v1
894 [meta][field] col name: c1
895 [meta][field] org col name: c1
896 [meta][field] length: 11
897 [meta][field] charsetnr: 8
898 [meta][field] flags: 0
899 [meta][field] decimals: 0
900 [meta][field] type: LONG (3)
901
902 [meta][field] db name: test
903 [meta][field] table name: v1
904 [meta][field] org table name: v1
905 [meta][field] col name: c2
906 [meta][field] org col name: c2
907 [meta][field] length: 512
908 [meta][field] charsetnr: 255
909 [meta][field] flags: 0
910 [meta][field] decimals: 0
911 [meta][field] type: VARCHAR (15)
912
913
914 [meta][charset result] number: 33
915 [meta][charset result] name: utf8mb3
916 [meta][charset result] collation: utf8mb3_general_ci
917 [meta][charset result] sort order:
918
919 [data][v1.c1][ 1][1]
920 [data][v1.c2][ 5][abcde]
921
922 [data][v1.c1][ 1][2]
923 [data][v1.c2][ 3][bbb]
924
925 [data][v1.c1][ 1][3]
926 [data][v1.c2][ 3][ccc]
927
928 [end] server status: 34
929 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
930 [end] warning count: 0
931 [end] affected rows: 0
932 [end] last insert id: 0
933 [end] message:
934 ------------------------------------------------------------------
935 EXECUTING:[102][SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'v1']
936 [CS_TEXT_REPRESENTATION]
937 [meta] rows: 1
938 [meta] cols: 1
939 [meta] server status: 2
940 [meta] server status: AUTOCOMMIT
941 [meta] warning count: 0
942
943 [meta][field] db name:
944 [meta][field] table name: VIEWS
945 [meta][field] org table name: VIEWS
946 [meta][field] col name: VIEW_DEFINITION
947 [meta][field] org col name: VIEW_DEFINITION
948 [meta][field] length: 4294967295
949 [meta][field] charsetnr: 83
950 [meta][field] flags: 128 (BINARY )
951 [meta][field] decimals: 31
952 [meta][field] type: BLOB (252)
953
954
955 [meta][charset result] number: 33
956 [meta][charset result] name: utf8mb3
957 [meta][charset result] collation: utf8mb3_general_ci
958 [meta][charset result] sort order:
959
960 [data][VIEWS.VIEW_DEFINITION][ 73][select `test`.`t1`.`c1` AS `c1`,`test`.`t1`.`c2` AS `c2` from `test`.`t1`]
961
962 [end] server status: 2
963 [end] server status: AUTOCOMMIT
964 [end] warning count: 0
965 [end] affected rows: 0
966 [end] last insert id: 0
967 [end] message:
968 [CS_BINARY_REPRESENTATION]
969 [meta] rows: 1
970 [meta] cols: 1
971 [meta] server status: 2
972 [meta] server status: AUTOCOMMIT
973 [meta] warning count: 0
974
975 [meta][field] db name:
976 [meta][field] table name: VIEWS
977 [meta][field] org table name: VIEWS
978 [meta][field] col name: VIEW_DEFINITION
979 [meta][field] org col name: VIEW_DEFINITION
980 [meta][field] length: 4294967295
981 [meta][field] charsetnr: 83
982 [meta][field] flags: 128 (BINARY )
983 [meta][field] decimals: 31
984 [meta][field] type: BLOB (252)
985
986
987 [meta][charset result] number: 33
988 [meta][charset result] name: utf8mb3
989 [meta][charset result] collation: utf8mb3_general_ci
990 [meta][charset result] sort order:
991
992 [data][VIEWS.VIEW_DEFINITION][ 73][select `test`.`t1`.`c1` AS `c1`,`test`.`t1`.`c2` AS `c2` from `test`.`t1`]
993
994 [end] server status: 2
995 [end] server status: AUTOCOMMIT
996 [end] warning count: 0
997 [end] affected rows: 0
998 [end] last insert id: 0
999 [end] message:
1000 ------------------------------------------------------------------
1001 EXECUTING:[COM_INIT_DB][test]
1002 ------------------------------------------------------------------
1003 EXECUTING:[12][DROP VIEW v1]
1004 [CS_TEXT_REPRESENTATION]
1005 [meta] rows: 0
1006 [meta] cols: 0
1007 [meta] server status: 0
1008 [meta] server status:
1009 [meta] warning count: 0
1010
1011 [meta] no columns
1012
1013 [meta] no charset
1014
1015 [data] no rows
1016
1017 [end] server status: 2
1018 [end] server status: AUTOCOMMIT
1019 [end] warning count: 0
1020 [end] affected rows: 0
1021 [end] last insert id: 0
1022 [end] message:
1023 ------------------------------------------------------------------
1024 EXECUTING:[COM_INIT_DB][test]
1025 ------------------------------------------------------------------
1026 EXECUTING:[34][CREATE VIEW v1 AS SELECT * FROM t1]
1027 [CS_TEXT_REPRESENTATION]
1028 [meta] rows: 0
1029 [meta] cols: 0
1030 [meta] server status: 0
1031 [meta] server status:
1032 [meta] warning count: 0
1033
1034 [meta] no columns
1035
1036 [meta] no charset
1037
1038 [data] no rows
1039
1040 [end] server status: 2
1041 [end] server status: AUTOCOMMIT
1042 [end] warning count: 0
1043 [end] affected rows: 0
1044 [end] last insert id: 0
1045 [end] message:
1046 ------------------------------------------------------------------
1047 EXECUTING:[COM_INIT_DB][test]
1048 ------------------------------------------------------------------
1049 EXECUTING:[16][SELECT * FROM v1]
1050 [CS_TEXT_REPRESENTATION]
1051 [meta] rows: 3
1052 [meta] cols: 2
1053 [meta] server status: 34
1054 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1055 [meta] warning count: 0
1056
1057 [meta][field] db name: test
1058 [meta][field] table name: v1
1059 [meta][field] org table name: v1
1060 [meta][field] col name: c1
1061 [meta][field] org col name: c1
1062 [meta][field] length: 11
1063 [meta][field] charsetnr: 8
1064 [meta][field] flags: 0
1065 [meta][field] decimals: 0
1066 [meta][field] type: LONG (3)
1067
1068 [meta][field] db name: test
1069 [meta][field] table name: v1
1070 [meta][field] org table name: v1
1071 [meta][field] col name: c2
1072 [meta][field] org col name: c2
1073 [meta][field] length: 512
1074 [meta][field] charsetnr: 255
1075 [meta][field] flags: 0
1076 [meta][field] decimals: 0
1077 [meta][field] type: VARCHAR (15)
1078
1079
1080 [meta][charset result] number: 33
1081 [meta][charset result] name: utf8mb3
1082 [meta][charset result] collation: utf8mb3_general_ci
1083 [meta][charset result] sort order:
1084
1085 [data][v1.c1][ 1][1]
1086 [data][v1.c2][ 5][abcde]
1087
1088 [data][v1.c1][ 1][2]
1089 [data][v1.c2][ 3][bbb]
1090
1091 [data][v1.c1][ 1][3]
1092 [data][v1.c2][ 3][ccc]
1093
1094 [end] server status: 34
1095 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1096 [end] warning count: 0
1097 [end] affected rows: 0
1098 [end] last insert id: 0
1099 [end] message:
1100 [CS_BINARY_REPRESENTATION]
1101 [meta] rows: 3
1102 [meta] cols: 2
1103 [meta] server status: 34
1104 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1105 [meta] warning count: 0
1106
1107 [meta][field] db name: test
1108 [meta][field] table name: v1
1109 [meta][field] org table name: v1
1110 [meta][field] col name: c1
1111 [meta][field] org col name: c1
1112 [meta][field] length: 11
1113 [meta][field] charsetnr: 8
1114 [meta][field] flags: 0
1115 [meta][field] decimals: 0
1116 [meta][field] type: LONG (3)
1117
1118 [meta][field] db name: test
1119 [meta][field] table name: v1
1120 [meta][field] org table name: v1
1121 [meta][field] col name: c2
1122 [meta][field] org col name: c2
1123 [meta][field] length: 512
1124 [meta][field] charsetnr: 255
1125 [meta][field] flags: 0
1126 [meta][field] decimals: 0
1127 [meta][field] type: VARCHAR (15)
1128
1129
1130 [meta][charset result] number: 33
1131 [meta][charset result] name: utf8mb3
1132 [meta][charset result] collation: utf8mb3_general_ci
1133 [meta][charset result] sort order:
1134
1135 [data][v1.c1][ 1][1]
1136 [data][v1.c2][ 5][abcde]
1137
1138 [data][v1.c1][ 1][2]
1139 [data][v1.c2][ 3][bbb]
1140
1141 [data][v1.c1][ 1][3]
1142 [data][v1.c2][ 3][ccc]
1143
1144 [end] server status: 34
1145 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1146 [end] warning count: 0
1147 [end] affected rows: 0
1148 [end] last insert id: 0
1149 [end] message:
1150 ------------------------------------------------------------------
1151 EXECUTING:[COM_INIT_DB][test]
1152 ------------------------------------------------------------------
1153 EXECUTING:[39][UPDATE t1 SET c2 = 'abcde' WHERE c1 = 1]
1154 [CS_TEXT_REPRESENTATION]
1155 [meta] rows: 0
1156 [meta] cols: 0
1157 [meta] server status: 0
1158 [meta] server status:
1159 [meta] warning count: 0
1160
1161 [meta] no columns
1162
1163 [meta] no charset
1164
1165 [data] no rows
1166
1167 [end] server status: 34
1168 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1169 [end] warning count: 0
1170 [end] affected rows: 0
1171 [end] last insert id: 0
1172 [end] message: Rows matched: 1 Changed: 0 Warnings: 0
1173 ------------------------------------------------------------------
1174 EXECUTING:[COM_INIT_DB][test]
1175 ------------------------------------------------------------------
1176 EXECUTING:[16][SELECT * FROM t2]
1177 [CS_TEXT_REPRESENTATION]
1178 [meta] rows: 3
1179 [meta] cols: 2
1180 [meta] server status: 34
1181 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1182 [meta] warning count: 0
1183
1184 [meta][field] db name: test
1185 [meta][field] table name: t2
1186 [meta][field] org table name: t2
1187 [meta][field] col name: c1
1188 [meta][field] org col name: c1
1189 [meta][field] length: 11
1190 [meta][field] charsetnr: 8
1191 [meta][field] flags: 0
1192 [meta][field] decimals: 0
1193 [meta][field] type: LONG (3)
1194
1195 [meta][field] db name: test
1196 [meta][field] table name: t2
1197 [meta][field] org table name: t2
1198 [meta][field] col name: c2
1199 [meta][field] org col name: c2
1200 [meta][field] length: 512
1201 [meta][field] charsetnr: 255
1202 [meta][field] flags: 0
1203 [meta][field] decimals: 0
1204 [meta][field] type: VARCHAR (15)
1205
1206
1207 [meta][charset result] number: 33
1208 [meta][charset result] name: utf8mb3
1209 [meta][charset result] collation: utf8mb3_general_ci
1210 [meta][charset result] sort order:
1211
1212 [data][t2.c1][ 1][1]
1213 [data][t2.c2][ 3][aaa]
1214
1215 [data][t2.c1][ 1][1]
1216 [data][t2.c2][ 3][aaa]
1217
1218 [data][t2.c1][ 1][1]
1219 [data][t2.c2][ 3][aaa]
1220
1221 [end] server status: 34
1222 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1223 [end] warning count: 0
1224 [end] affected rows: 0
1225 [end] last insert id: 0
1226 [end] message:
1227 [CS_BINARY_REPRESENTATION]
1228 [meta] rows: 3
1229 [meta] cols: 2
1230 [meta] server status: 34
1231 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1232 [meta] warning count: 0
1233
1234 [meta][field] db name: test
1235 [meta][field] table name: t2
1236 [meta][field] org table name: t2
1237 [meta][field] col name: c1
1238 [meta][field] org col name: c1
1239 [meta][field] length: 11
1240 [meta][field] charsetnr: 8
1241 [meta][field] flags: 0
1242 [meta][field] decimals: 0
1243 [meta][field] type: LONG (3)
1244
1245 [meta][field] db name: test
1246 [meta][field] table name: t2
1247 [meta][field] org table name: t2
1248 [meta][field] col name: c2
1249 [meta][field] org col name: c2
1250 [meta][field] length: 512
1251 [meta][field] charsetnr: 255
1252 [meta][field] flags: 0
1253 [meta][field] decimals: 0
1254 [meta][field] type: VARCHAR (15)
1255
1256
1257 [meta][charset result] number: 33
1258 [meta][charset result] name: utf8mb3
1259 [meta][charset result] collation: utf8mb3_general_ci
1260 [meta][charset result] sort order:
1261
1262 [data][t2.c1][ 1][1]
1263 [data][t2.c2][ 3][aaa]
1264
1265 [data][t2.c1][ 1][1]
1266 [data][t2.c2][ 3][aaa]
1267
1268 [data][t2.c1][ 1][1]
1269 [data][t2.c2][ 3][aaa]
1270
1271 [end] server status: 34
1272 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1273 [end] warning count: 0
1274 [end] affected rows: 0
1275 [end] last insert id: 0
1276 [end] message:
1277 ------------------------------------------------------------------
1278 EXECUTING:[108][SELECT TRIGGER_NAME FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_SCHEMA = 'test' AND TRIGGER_NAME = 'trig']
1279 [CS_TEXT_REPRESENTATION]
1280 [meta] rows: 1
1281 [meta] cols: 1
1282 [meta] server status: 34
1283 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1284 [meta] warning count: 0
1285
1286 [meta][field] db name: information_schema
1287 [meta][field] table name: TRIGGERS
1288 [meta][field] org table name: TRIGGERS
1289 [meta][field] col name: TRIGGER_NAME
1290 [meta][field] org col name: TRIGGER_NAME
1291 [meta][field] length: 192
1292 [meta][field] charsetnr: 33
1293 [meta][field] flags: 20481 (NOT_NULL NO_DEFAULT_VALUE PART_KEY )
1294 [meta][field] decimals: 0
1295 [meta][field] type: VARCHAR (15)
1296
1297
1298 [meta][charset result] number: 33
1299 [meta][charset result] name: utf8mb3
1300 [meta][charset result] collation: utf8mb3_general_ci
1301 [meta][charset result] sort order:
1302
1303 [data][TRIGGERS.TRIGGER_NAME][ 4][trig]
1304
1305 [end] server status: 34
1306 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1307 [end] warning count: 0
1308 [end] affected rows: 0
1309 [end] last insert id: 0
1310 [end] message:
1311 [CS_BINARY_REPRESENTATION]
1312 [meta] rows: 1
1313 [meta] cols: 1
1314 [meta] server status: 34
1315 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1316 [meta] warning count: 0
1317
1318 [meta][field] db name: information_schema
1319 [meta][field] table name: TRIGGERS
1320 [meta][field] org table name: TRIGGERS
1321 [meta][field] col name: TRIGGER_NAME
1322 [meta][field] org col name: TRIGGER_NAME
1323 [meta][field] length: 192
1324 [meta][field] charsetnr: 33
1325 [meta][field] flags: 20481 (NOT_NULL NO_DEFAULT_VALUE PART_KEY )
1326 [meta][field] decimals: 0
1327 [meta][field] type: VARCHAR (15)
1328
1329
1330 [meta][charset result] number: 33
1331 [meta][charset result] name: utf8mb3
1332 [meta][charset result] collation: utf8mb3_general_ci
1333 [meta][charset result] sort order:
1334
1335 [data][TRIGGERS.TRIGGER_NAME][ 4][trig]
1336
1337 [end] server status: 34
1338 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1339 [end] warning count: 0
1340 [end] affected rows: 0
1341 [end] last insert id: 0
1342 [end] message:
1343 ------------------------------------------------------------------
1344 EXECUTING:[COM_INIT_DB][test]
1345 ------------------------------------------------------------------
1346 EXECUTING:[17][DROP TRIGGER trig]
1347 [CS_TEXT_REPRESENTATION]
1348 [meta] rows: 0
1349 [meta] cols: 0
1350 [meta] server status: 0
1351 [meta] server status:
1352 [meta] warning count: 0
1353
1354 [meta] no columns
1355
1356 [meta] no charset
1357
1358 [data] no rows
1359
1360 [end] server status: 2
1361 [end] server status: AUTOCOMMIT
1362 [end] warning count: 0
1363 [end] affected rows: 0
1364 [end] last insert id: 0
1365 [end] message:
1366 ------------------------------------------------------------------
1367 EXECUTING:[COM_INIT_DB][test]
1368 ------------------------------------------------------------------
1369 EXECUTING:[84][CREATE TRIGGER trig AFTER UPDATE ON t1 FOR EACH ROW INSERT INTO t2 VALUES (1, 'aaa')]
1370 [CS_TEXT_REPRESENTATION]
1371 [meta] rows: 0
1372 [meta] cols: 0
1373 [meta] server status: 0
1374 [meta] server status:
1375 [meta] warning count: 0
1376
1377 [meta] no columns
1378
1379 [meta] no charset
1380
1381 [data] no rows
1382
1383 [end] server status: 2
1384 [end] server status: AUTOCOMMIT
1385 [end] warning count: 0
1386 [end] affected rows: 0
1387 [end] last insert id: 0
1388 [end] message:
1389 ------------------------------------------------------------------
1390 EXECUTING:[COM_INIT_DB][test]
1391 ------------------------------------------------------------------
1392 EXECUTING:[39][UPDATE t1 SET c2 = 'abcde' WHERE c1 = 1]
1393 [CS_TEXT_REPRESENTATION]
1394 [meta] rows: 0
1395 [meta] cols: 0
1396 [meta] server status: 0
1397 [meta] server status:
1398 [meta] warning count: 0
1399
1400 [meta] no columns
1401
1402 [meta] no charset
1403
1404 [data] no rows
1405
1406 [end] server status: 34
1407 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1408 [end] warning count: 0
1409 [end] affected rows: 0
1410 [end] last insert id: 0
1411 [end] message: Rows matched: 1 Changed: 0 Warnings: 0
1412 ------------------------------------------------------------------
1413 EXECUTING:[COM_INIT_DB][test]
1414 ------------------------------------------------------------------
1415 EXECUTING:[16][SELECT * FROM t2]
1416 [CS_TEXT_REPRESENTATION]
1417 [meta] rows: 4
1418 [meta] cols: 2
1419 [meta] server status: 34
1420 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1421 [meta] warning count: 0
1422
1423 [meta][field] db name: test
1424 [meta][field] table name: t2
1425 [meta][field] org table name: t2
1426 [meta][field] col name: c1
1427 [meta][field] org col name: c1
1428 [meta][field] length: 11
1429 [meta][field] charsetnr: 8
1430 [meta][field] flags: 0
1431 [meta][field] decimals: 0
1432 [meta][field] type: LONG (3)
1433
1434 [meta][field] db name: test
1435 [meta][field] table name: t2
1436 [meta][field] org table name: t2
1437 [meta][field] col name: c2
1438 [meta][field] org col name: c2
1439 [meta][field] length: 512
1440 [meta][field] charsetnr: 255
1441 [meta][field] flags: 0
1442 [meta][field] decimals: 0
1443 [meta][field] type: VARCHAR (15)
1444
1445
1446 [meta][charset result] number: 33
1447 [meta][charset result] name: utf8mb3
1448 [meta][charset result] collation: utf8mb3_general_ci
1449 [meta][charset result] sort order:
1450
1451 [data][t2.c1][ 1][1]
1452 [data][t2.c2][ 3][aaa]
1453
1454 [data][t2.c1][ 1][1]
1455 [data][t2.c2][ 3][aaa]
1456
1457 [data][t2.c1][ 1][1]
1458 [data][t2.c2][ 3][aaa]
1459
1460 [data][t2.c1][ 1][1]
1461 [data][t2.c2][ 3][aaa]
1462
1463 [end] server status: 34
1464 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1465 [end] warning count: 0
1466 [end] affected rows: 0
1467 [end] last insert id: 0
1468 [end] message:
1469 [CS_BINARY_REPRESENTATION]
1470 [meta] rows: 4
1471 [meta] cols: 2
1472 [meta] server status: 34
1473 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1474 [meta] warning count: 0
1475
1476 [meta][field] db name: test
1477 [meta][field] table name: t2
1478 [meta][field] org table name: t2
1479 [meta][field] col name: c1
1480 [meta][field] org col name: c1
1481 [meta][field] length: 11
1482 [meta][field] charsetnr: 8
1483 [meta][field] flags: 0
1484 [meta][field] decimals: 0
1485 [meta][field] type: LONG (3)
1486
1487 [meta][field] db name: test
1488 [meta][field] table name: t2
1489 [meta][field] org table name: t2
1490 [meta][field] col name: c2
1491 [meta][field] org col name: c2
1492 [meta][field] length: 512
1493 [meta][field] charsetnr: 255
1494 [meta][field] flags: 0
1495 [meta][field] decimals: 0
1496 [meta][field] type: VARCHAR (15)
1497
1498
1499 [meta][charset result] number: 33
1500 [meta][charset result] name: utf8mb3
1501 [meta][charset result] collation: utf8mb3_general_ci
1502 [meta][charset result] sort order:
1503
1504 [data][t2.c1][ 1][1]
1505 [data][t2.c2][ 3][aaa]
1506
1507 [data][t2.c1][ 1][1]
1508 [data][t2.c2][ 3][aaa]
1509
1510 [data][t2.c1][ 1][1]
1511 [data][t2.c2][ 3][aaa]
1512
1513 [data][t2.c1][ 1][1]
1514 [data][t2.c2][ 3][aaa]
1515
1516 [end] server status: 34
1517 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1518 [end] warning count: 0
1519 [end] affected rows: 0
1520 [end] last insert id: 0
1521 [end] message:
1522 ------------------------------------------------------------------
1523 [srv_session_close]
1524 deinit thread
1525 # Checking the view created in test plugin is visible in MTR test
1526 SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'v1';
1527 VIEW_DEFINITION
1528 select `test`.`t1`.`c1` AS `c1`,`test`.`t1`.`c2` AS `c2` from `test`.`t1`
1529 # Checking the contents of the view created
1530 SELECT * FROM v1;
1531 c1 c2
1532 1 abcde
1533 2 bbb
1534 3 ccc
1535 # Checking the trigger created in test plugin is visible in MTR test
1536 SELECT TRIGGER_NAME FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_SCHEMA = 'test' AND TRIGGER_NAME = 'trig';
1537 TRIGGER_NAME
1538 trig
1539 # Calling the trigger created in test plugin
1540 UPDATE t1 SET c2 = 'abcde' WHERE c1 = 1;
1541 SELECT * FROM t2;
1542 c1 c2
1543 1 aaa
1544 1 aaa
1545 1 aaa
1546 1 aaa
1547 1 aaa
1548 ##########################################
1549 # Cleanup
1550 ##########################################
1551 # Dropping the created view
1552 DROP VIEW v1;
1553 # Dropping the created trigger
1554 DROP TRIGGER trig;
1555 # Dropping the created tables
1556 DROP TABLE t1;
1557 DROP TABLE t2;