Debian Codegraph @

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

raw
1 ------ Run plugin ------------------------------------------------
2 INSTALL PLUGIN test_sql_complex SONAME 'TEST_SQL_COMPLEX';
3 ------ Stop plugin -----------------------------------------------
4 UNINSTALL PLUGIN test_sql_complex;
5 ------ plugin log ------------------------------------------------
6 ========================================================================
7 Test in a server thread
8 [srv_session_open]
9 ------------------------------------------------------------------
10 EXECUTING:[35][SELECT 'first complex command' as a]
11 [CS_TEXT_REPRESENTATION]
12 [meta] rows: 1
13 [meta] cols: 1
14 [meta] server status: 2
15 [meta] server status: AUTOCOMMIT
16 [meta] warning count: 0
17
18 [meta][field] db name:
19 [meta][field] table name:
20 [meta][field] org table name:
21 [meta][field] col name: a
22 [meta][field] org col name:
23 [meta][field] length: 63
24 [meta][field] charsetnr: 33
25 [meta][field] flags: 1 (NOT_NULL )
26 [meta][field] decimals: 31
27 [meta][field] type: VARCHAR (15)
28
29
30 [meta][charset result] number: 33
31 [meta][charset result] name: utf8mb3
32 [meta][charset result] collation: utf8mb3_general_ci
33 [meta][charset result] sort order:
34
35 [data][.a][ 21][first complex command]
36
37 [end] server status: 2
38 [end] server status: AUTOCOMMIT
39 [end] warning count: 0
40 [end] affected rows: 0
41 [end] last insert id: 0
42 [end] message:
43 [CS_BINARY_REPRESENTATION]
44 [meta] rows: 1
45 [meta] cols: 1
46 [meta] server status: 2
47 [meta] server status: AUTOCOMMIT
48 [meta] warning count: 0
49
50 [meta][field] db name:
51 [meta][field] table name:
52 [meta][field] org table name:
53 [meta][field] col name: a
54 [meta][field] org col name:
55 [meta][field] length: 63
56 [meta][field] charsetnr: 33
57 [meta][field] flags: 1 (NOT_NULL )
58 [meta][field] decimals: 31
59 [meta][field] type: VARCHAR (15)
60
61
62 [meta][charset result] number: 33
63 [meta][charset result] name: utf8mb3
64 [meta][charset result] collation: utf8mb3_general_ci
65 [meta][charset result] sort order:
66
67 [data][.a][ 21][first complex command]
68
69 [end] server status: 2
70 [end] server status: AUTOCOMMIT
71 [end] warning count: 0
72 [end] affected rows: 0
73 [end] last insert id: 0
74 [end] message:
75 ------------------------------------------------------------------
76 EXECUTING:[21][CREATE DATABASE test1]
77 [CS_TEXT_REPRESENTATION]
78 [meta] rows: 0
79 [meta] cols: 0
80 [meta] server status: 0
81 [meta] server status:
82 [meta] warning count: 0
83
84 [meta] no columns
85
86 [meta] no charset
87
88 [data] no rows
89
90 [end] server status: 2
91 [end] server status: AUTOCOMMIT
92 [end] warning count: 0
93 [end] affected rows: 1
94 [end] last insert id: 0
95 [end] message:
96 ------------------------------------------------------------------
97 EXECUTING:[8][USE test]
98 [CS_TEXT_REPRESENTATION]
99 [meta] rows: 0
100 [meta] cols: 0
101 [meta] server status: 0
102 [meta] server status:
103 [meta] warning count: 0
104
105 [meta] no columns
106
107 [meta] no charset
108
109 [data] no rows
110
111 [end] server status: 2
112 [end] server status: AUTOCOMMIT
113 [end] warning count: 0
114 [end] affected rows: 0
115 [end] last insert id: 0
116 [end] message:
117 ------------------------------------------------------------------
118 EXECUTING:[343][CREATE TABLE test_inserts( a INT UNSIGNED, b VARCHAR(100), c DOUBLE, d INT, e FLOAT,f DATETIME, g DATE, h TIME, i TINYINT, k TINYINT UNSIGNED,l SMALLINT, m SMALLINT UNSIGNED, n MEDIUMINT, o MEDIUMINT UNSIGNED,p INTEGER, q INTEGER UNSIGNED, r BIGINT, s BIGINT UNSIGNED,t YEAR, u DECIMAL(5,2) UNSIGNED, v DECIMAL(5,2), PRIMARY KEY(a), INDEX(d));]
119 [CS_TEXT_REPRESENTATION]
120 [meta] rows: 0
121 [meta] cols: 0
122 [meta] server status: 0
123 [meta] server status:
124 [meta] warning count: 0
125
126 [meta] no columns
127
128 [meta] no charset
129
130 [data] no rows
131
132 [end] server status: 2
133 [end] server status: AUTOCOMMIT
134 [end] warning count: 1
135 [end] affected rows: 0
136 [end] last insert id: 0
137 [end] message:
138 ------------------------------------------------------------------
139 EXECUTING:[244][INSERT INTO test_inserts VALUES (1, 'one', 1.23, -1, 11.2323, '2014-07-06 07:06:05', '1980-02-19', '-830:12:23', 127, 255, 32767, 65535, 8388607, 16777215, 2147483647, 4294967295, 9223372036854775807, 18446744073709551615,1901, 999.99, -999.99)]
140 [CS_TEXT_REPRESENTATION]
141 [meta] rows: 0
142 [meta] cols: 0
143 [meta] server status: 0
144 [meta] server status:
145 [meta] warning count: 0
146
147 [meta] no columns
148
149 [meta] no charset
150
151 [data] no rows
152
153 [end] server status: 2
154 [end] server status: AUTOCOMMIT
155 [end] warning count: 0
156 [end] affected rows: 1
157 [end] last insert id: 0
158 [end] message:
159 ------------------------------------------------------------------
160 EXECUTING:[236][INSERT INTO test_inserts VALUES (2, 'two', 2.34, -2, 22.3434, '2015-07-06 21:22:23', '2014-06-05', '356:22:33', -128, 0, -32768, 32768, -8388608, 8388607, -2147483648, 0, -9223372036854775808, 18446744073709551615,2039, 123.45, -543.21)]
161 [CS_TEXT_REPRESENTATION]
162 [meta] rows: 0
163 [meta] cols: 0
164 [meta] server status: 0
165 [meta] server status:
166 [meta] warning count: 0
167
168 [meta] no columns
169
170 [meta] no charset
171
172 [data] no rows
173
174 [end] server status: 2
175 [end] server status: AUTOCOMMIT
176 [end] warning count: 0
177 [end] affected rows: 1
178 [end] last insert id: 0
179 [end] message:
180 ------------------------------------------------------------------
181 EXECUTING:[179][INSERT INTO test_inserts VALUES (3, 'three',3.45,-3, 33.4545, '2016-09-12 11:12:13', '2013-05-04', '821:33:44', -1, 128, -1, 65534, -1, 16777214, 1, 2, 3, 4,2155, 222.22, -567.89)]
182 [CS_TEXT_REPRESENTATION]
183 [meta] rows: 0
184 [meta] cols: 0
185 [meta] server status: 0
186 [meta] server status:
187 [meta] warning count: 0
188
189 [meta] no columns
190
191 [meta] no charset
192
193 [data] no rows
194
195 [end] server status: 2
196 [end] server status: AUTOCOMMIT
197 [end] warning count: 0
198 [end] affected rows: 1
199 [end] last insert id: 0
200 [end] message:
201 ------------------------------------------------------------------
202 EXECUTING:[43][SELECT * FROM test1.test_inserts ORDER BY a]
203 [CS_TEXT_REPRESENTATION]
204 [meta] rows: 3
205 [meta] cols: 21
206 [meta] server status: 2
207 [meta] server status: AUTOCOMMIT
208 [meta] warning count: 0
209
210 [meta][field] db name: test1
211 [meta][field] table name: test_inserts
212 [meta][field] org table name: test_inserts
213 [meta][field] col name: a
214 [meta][field] org col name: a
215 [meta][field] length: 10
216 [meta][field] charsetnr: 8
217 [meta][field] flags: 20515 (NOT_NULL PRI_KEY UNSIGNED NO_DEFAULT_VALUE PART_KEY )
218 [meta][field] decimals: 0
219 [meta][field] type: LONG (3)
220
221 [meta][field] db name: test1
222 [meta][field] table name: test_inserts
223 [meta][field] org table name: test_inserts
224 [meta][field] col name: b
225 [meta][field] org col name: b
226 [meta][field] length: 400
227 [meta][field] charsetnr: 255
228 [meta][field] flags: 0
229 [meta][field] decimals: 0
230 [meta][field] type: VARCHAR (15)
231
232 [meta][field] db name: test1
233 [meta][field] table name: test_inserts
234 [meta][field] org table name: test_inserts
235 [meta][field] col name: c
236 [meta][field] org col name: c
237 [meta][field] length: 22
238 [meta][field] charsetnr: 8
239 [meta][field] flags: 0
240 [meta][field] decimals: 31
241 [meta][field] type: DOUBLE (5)
242
243 [meta][field] db name: test1
244 [meta][field] table name: test_inserts
245 [meta][field] org table name: test_inserts
246 [meta][field] col name: d
247 [meta][field] org col name: d
248 [meta][field] length: 11
249 [meta][field] charsetnr: 8
250 [meta][field] flags: 16392 (MULTIPLE_KEY PART_KEY )
251 [meta][field] decimals: 0
252 [meta][field] type: LONG (3)
253
254 [meta][field] db name: test1
255 [meta][field] table name: test_inserts
256 [meta][field] org table name: test_inserts
257 [meta][field] col name: e
258 [meta][field] org col name: e
259 [meta][field] length: 12
260 [meta][field] charsetnr: 8
261 [meta][field] flags: 0
262 [meta][field] decimals: 31
263 [meta][field] type: FLOAT (4)
264
265 [meta][field] db name: test1
266 [meta][field] table name: test_inserts
267 [meta][field] org table name: test_inserts
268 [meta][field] col name: f
269 [meta][field] org col name: f
270 [meta][field] length: 19
271 [meta][field] charsetnr: 8
272 [meta][field] flags: 128 (BINARY )
273 [meta][field] decimals: 0
274 [meta][field] type: DATETIME (12)
275
276 [meta][field] db name: test1
277 [meta][field] table name: test_inserts
278 [meta][field] org table name: test_inserts
279 [meta][field] col name: g
280 [meta][field] org col name: g
281 [meta][field] length: 10
282 [meta][field] charsetnr: 8
283 [meta][field] flags: 128 (BINARY )
284 [meta][field] decimals: 0
285 [meta][field] type: DATE (10)
286
287 [meta][field] db name: test1
288 [meta][field] table name: test_inserts
289 [meta][field] org table name: test_inserts
290 [meta][field] col name: h
291 [meta][field] org col name: h
292 [meta][field] length: 10
293 [meta][field] charsetnr: 8
294 [meta][field] flags: 128 (BINARY )
295 [meta][field] decimals: 0
296 [meta][field] type: TIME (11)
297
298 [meta][field] db name: test1
299 [meta][field] table name: test_inserts
300 [meta][field] org table name: test_inserts
301 [meta][field] col name: i
302 [meta][field] org col name: i
303 [meta][field] length: 4
304 [meta][field] charsetnr: 8
305 [meta][field] flags: 0
306 [meta][field] decimals: 0
307 [meta][field] type: TINY (1)
308
309 [meta][field] db name: test1
310 [meta][field] table name: test_inserts
311 [meta][field] org table name: test_inserts
312 [meta][field] col name: k
313 [meta][field] org col name: k
314 [meta][field] length: 3
315 [meta][field] charsetnr: 8
316 [meta][field] flags: 32 (UNSIGNED )
317 [meta][field] decimals: 0
318 [meta][field] type: TINY (1)
319
320 [meta][field] db name: test1
321 [meta][field] table name: test_inserts
322 [meta][field] org table name: test_inserts
323 [meta][field] col name: l
324 [meta][field] org col name: l
325 [meta][field] length: 6
326 [meta][field] charsetnr: 8
327 [meta][field] flags: 0
328 [meta][field] decimals: 0
329 [meta][field] type: SHORT (2)
330
331 [meta][field] db name: test1
332 [meta][field] table name: test_inserts
333 [meta][field] org table name: test_inserts
334 [meta][field] col name: m
335 [meta][field] org col name: m
336 [meta][field] length: 5
337 [meta][field] charsetnr: 8
338 [meta][field] flags: 32 (UNSIGNED )
339 [meta][field] decimals: 0
340 [meta][field] type: SHORT (2)
341
342 [meta][field] db name: test1
343 [meta][field] table name: test_inserts
344 [meta][field] org table name: test_inserts
345 [meta][field] col name: n
346 [meta][field] org col name: n
347 [meta][field] length: 9
348 [meta][field] charsetnr: 8
349 [meta][field] flags: 0
350 [meta][field] decimals: 0
351 [meta][field] type: INT24 (9)
352
353 [meta][field] db name: test1
354 [meta][field] table name: test_inserts
355 [meta][field] org table name: test_inserts
356 [meta][field] col name: o
357 [meta][field] org col name: o
358 [meta][field] length: 8
359 [meta][field] charsetnr: 8
360 [meta][field] flags: 32 (UNSIGNED )
361 [meta][field] decimals: 0
362 [meta][field] type: INT24 (9)
363
364 [meta][field] db name: test1
365 [meta][field] table name: test_inserts
366 [meta][field] org table name: test_inserts
367 [meta][field] col name: p
368 [meta][field] org col name: p
369 [meta][field] length: 11
370 [meta][field] charsetnr: 8
371 [meta][field] flags: 0
372 [meta][field] decimals: 0
373 [meta][field] type: LONG (3)
374
375 [meta][field] db name: test1
376 [meta][field] table name: test_inserts
377 [meta][field] org table name: test_inserts
378 [meta][field] col name: q
379 [meta][field] org col name: q
380 [meta][field] length: 10
381 [meta][field] charsetnr: 8
382 [meta][field] flags: 32 (UNSIGNED )
383 [meta][field] decimals: 0
384 [meta][field] type: LONG (3)
385
386 [meta][field] db name: test1
387 [meta][field] table name: test_inserts
388 [meta][field] org table name: test_inserts
389 [meta][field] col name: r
390 [meta][field] org col name: r
391 [meta][field] length: 20
392 [meta][field] charsetnr: 8
393 [meta][field] flags: 0
394 [meta][field] decimals: 0
395 [meta][field] type: LONGLONG (8)
396
397 [meta][field] db name: test1
398 [meta][field] table name: test_inserts
399 [meta][field] org table name: test_inserts
400 [meta][field] col name: s
401 [meta][field] org col name: s
402 [meta][field] length: 20
403 [meta][field] charsetnr: 8
404 [meta][field] flags: 32 (UNSIGNED )
405 [meta][field] decimals: 0
406 [meta][field] type: LONGLONG (8)
407
408 [meta][field] db name: test1
409 [meta][field] table name: test_inserts
410 [meta][field] org table name: test_inserts
411 [meta][field] col name: t
412 [meta][field] org col name: t
413 [meta][field] length: 4
414 [meta][field] charsetnr: 8
415 [meta][field] flags: 96 (UNSIGNED ZEROFILL )
416 [meta][field] decimals: 0
417 [meta][field] type: YEAR (13)
418
419 [meta][field] db name: test1
420 [meta][field] table name: test_inserts
421 [meta][field] org table name: test_inserts
422 [meta][field] col name: u
423 [meta][field] org col name: u
424 [meta][field] length: 6
425 [meta][field] charsetnr: 8
426 [meta][field] flags: 32 (UNSIGNED )
427 [meta][field] decimals: 2
428 [meta][field] type: NEWDECIMAL (246)
429
430 [meta][field] db name: test1
431 [meta][field] table name: test_inserts
432 [meta][field] org table name: test_inserts
433 [meta][field] col name: v
434 [meta][field] org col name: v
435 [meta][field] length: 7
436 [meta][field] charsetnr: 8
437 [meta][field] flags: 0
438 [meta][field] decimals: 2
439 [meta][field] type: NEWDECIMAL (246)
440
441
442 [meta][charset result] number: 33
443 [meta][charset result] name: utf8mb3
444 [meta][charset result] collation: utf8mb3_general_ci
445 [meta][charset result] sort order:
446
447 [data][test_inserts.a][ 1][1]
448 [data][test_inserts.b][ 3][one]
449 [data][test_inserts.c][ 4][1.23]
450 [data][test_inserts.d][ 2][-1]
451 [data][test_inserts.e][ 7][11.2323]
452 [data][test_inserts.f][ 19][2014-07-06 07:06:05]
453 [data][test_inserts.g][ 10][1980-02-19]
454 [data][test_inserts.h][ 10][-830:12:23]
455 [data][test_inserts.i][ 3][127]
456 [data][test_inserts.k][ 3][255]
457 [data][test_inserts.l][ 5][32767]
458 [data][test_inserts.m][ 5][65535]
459 [data][test_inserts.n][ 7][8388607]
460 [data][test_inserts.o][ 8][16777215]
461 [data][test_inserts.p][ 10][2147483647]
462 [data][test_inserts.q][ 10][4294967295]
463 [data][test_inserts.r][ 19][9223372036854775807]
464 [data][test_inserts.s][ 20][18446744073709551615]
465 [data][test_inserts.t][ 4][1901]
466 [data][test_inserts.u][ 6][999.99]
467 [data][test_inserts.v][ 7][-999.99]
468
469 [data][test_inserts.a][ 1][2]
470 [data][test_inserts.b][ 3][two]
471 [data][test_inserts.c][ 4][2.34]
472 [data][test_inserts.d][ 2][-2]
473 [data][test_inserts.e][ 7][22.3434]
474 [data][test_inserts.f][ 19][2015-07-06 21:22:23]
475 [data][test_inserts.g][ 10][2014-06-05]
476 [data][test_inserts.h][ 9][356:22:33]
477 [data][test_inserts.i][ 4][-128]
478 [data][test_inserts.k][ 1][0]
479 [data][test_inserts.l][ 6][-32768]
480 [data][test_inserts.m][ 5][32768]
481 [data][test_inserts.n][ 8][-8388608]
482 [data][test_inserts.o][ 7][8388607]
483 [data][test_inserts.p][ 11][-2147483648]
484 [data][test_inserts.q][ 1][0]
485 [data][test_inserts.r][ 20][-9223372036854775808]
486 [data][test_inserts.s][ 20][18446744073709551615]
487 [data][test_inserts.t][ 4][2039]
488 [data][test_inserts.u][ 6][123.45]
489 [data][test_inserts.v][ 7][-543.21]
490
491 [data][test_inserts.a][ 1][3]
492 [data][test_inserts.b][ 5][three]
493 [data][test_inserts.c][ 4][3.45]
494 [data][test_inserts.d][ 2][-3]
495 [data][test_inserts.e][ 7][33.4545]
496 [data][test_inserts.f][ 19][2016-09-12 11:12:13]
497 [data][test_inserts.g][ 10][2013-05-04]
498 [data][test_inserts.h][ 9][821:33:44]
499 [data][test_inserts.i][ 2][-1]
500 [data][test_inserts.k][ 3][128]
501 [data][test_inserts.l][ 2][-1]
502 [data][test_inserts.m][ 5][65534]
503 [data][test_inserts.n][ 2][-1]
504 [data][test_inserts.o][ 8][16777214]
505 [data][test_inserts.p][ 1][1]
506 [data][test_inserts.q][ 1][2]
507 [data][test_inserts.r][ 1][3]
508 [data][test_inserts.s][ 1][4]
509 [data][test_inserts.t][ 4][2155]
510 [data][test_inserts.u][ 6][222.22]
511 [data][test_inserts.v][ 7][-567.89]
512
513 [end] server status: 2
514 [end] server status: AUTOCOMMIT
515 [end] warning count: 0
516 [end] affected rows: 0
517 [end] last insert id: 0
518 [end] message:
519 [CS_BINARY_REPRESENTATION]
520 [meta] rows: 3
521 [meta] cols: 21
522 [meta] server status: 2
523 [meta] server status: AUTOCOMMIT
524 [meta] warning count: 0
525
526 [meta][field] db name: test1
527 [meta][field] table name: test_inserts
528 [meta][field] org table name: test_inserts
529 [meta][field] col name: a
530 [meta][field] org col name: a
531 [meta][field] length: 10
532 [meta][field] charsetnr: 8
533 [meta][field] flags: 20515 (NOT_NULL PRI_KEY UNSIGNED NO_DEFAULT_VALUE PART_KEY )
534 [meta][field] decimals: 0
535 [meta][field] type: LONG (3)
536
537 [meta][field] db name: test1
538 [meta][field] table name: test_inserts
539 [meta][field] org table name: test_inserts
540 [meta][field] col name: b
541 [meta][field] org col name: b
542 [meta][field] length: 400
543 [meta][field] charsetnr: 255
544 [meta][field] flags: 0
545 [meta][field] decimals: 0
546 [meta][field] type: VARCHAR (15)
547
548 [meta][field] db name: test1
549 [meta][field] table name: test_inserts
550 [meta][field] org table name: test_inserts
551 [meta][field] col name: c
552 [meta][field] org col name: c
553 [meta][field] length: 22
554 [meta][field] charsetnr: 8
555 [meta][field] flags: 0
556 [meta][field] decimals: 31
557 [meta][field] type: DOUBLE (5)
558
559 [meta][field] db name: test1
560 [meta][field] table name: test_inserts
561 [meta][field] org table name: test_inserts
562 [meta][field] col name: d
563 [meta][field] org col name: d
564 [meta][field] length: 11
565 [meta][field] charsetnr: 8
566 [meta][field] flags: 16392 (MULTIPLE_KEY PART_KEY )
567 [meta][field] decimals: 0
568 [meta][field] type: LONG (3)
569
570 [meta][field] db name: test1
571 [meta][field] table name: test_inserts
572 [meta][field] org table name: test_inserts
573 [meta][field] col name: e
574 [meta][field] org col name: e
575 [meta][field] length: 12
576 [meta][field] charsetnr: 8
577 [meta][field] flags: 0
578 [meta][field] decimals: 31
579 [meta][field] type: FLOAT (4)
580
581 [meta][field] db name: test1
582 [meta][field] table name: test_inserts
583 [meta][field] org table name: test_inserts
584 [meta][field] col name: f
585 [meta][field] org col name: f
586 [meta][field] length: 19
587 [meta][field] charsetnr: 8
588 [meta][field] flags: 128 (BINARY )
589 [meta][field] decimals: 0
590 [meta][field] type: DATETIME (12)
591
592 [meta][field] db name: test1
593 [meta][field] table name: test_inserts
594 [meta][field] org table name: test_inserts
595 [meta][field] col name: g
596 [meta][field] org col name: g
597 [meta][field] length: 10
598 [meta][field] charsetnr: 8
599 [meta][field] flags: 128 (BINARY )
600 [meta][field] decimals: 0
601 [meta][field] type: DATE (10)
602
603 [meta][field] db name: test1
604 [meta][field] table name: test_inserts
605 [meta][field] org table name: test_inserts
606 [meta][field] col name: h
607 [meta][field] org col name: h
608 [meta][field] length: 10
609 [meta][field] charsetnr: 8
610 [meta][field] flags: 128 (BINARY )
611 [meta][field] decimals: 0
612 [meta][field] type: TIME (11)
613
614 [meta][field] db name: test1
615 [meta][field] table name: test_inserts
616 [meta][field] org table name: test_inserts
617 [meta][field] col name: i
618 [meta][field] org col name: i
619 [meta][field] length: 4
620 [meta][field] charsetnr: 8
621 [meta][field] flags: 0
622 [meta][field] decimals: 0
623 [meta][field] type: TINY (1)
624
625 [meta][field] db name: test1
626 [meta][field] table name: test_inserts
627 [meta][field] org table name: test_inserts
628 [meta][field] col name: k
629 [meta][field] org col name: k
630 [meta][field] length: 3
631 [meta][field] charsetnr: 8
632 [meta][field] flags: 32 (UNSIGNED )
633 [meta][field] decimals: 0
634 [meta][field] type: TINY (1)
635
636 [meta][field] db name: test1
637 [meta][field] table name: test_inserts
638 [meta][field] org table name: test_inserts
639 [meta][field] col name: l
640 [meta][field] org col name: l
641 [meta][field] length: 6
642 [meta][field] charsetnr: 8
643 [meta][field] flags: 0
644 [meta][field] decimals: 0
645 [meta][field] type: SHORT (2)
646
647 [meta][field] db name: test1
648 [meta][field] table name: test_inserts
649 [meta][field] org table name: test_inserts
650 [meta][field] col name: m
651 [meta][field] org col name: m
652 [meta][field] length: 5
653 [meta][field] charsetnr: 8
654 [meta][field] flags: 32 (UNSIGNED )
655 [meta][field] decimals: 0
656 [meta][field] type: SHORT (2)
657
658 [meta][field] db name: test1
659 [meta][field] table name: test_inserts
660 [meta][field] org table name: test_inserts
661 [meta][field] col name: n
662 [meta][field] org col name: n
663 [meta][field] length: 9
664 [meta][field] charsetnr: 8
665 [meta][field] flags: 0
666 [meta][field] decimals: 0
667 [meta][field] type: INT24 (9)
668
669 [meta][field] db name: test1
670 [meta][field] table name: test_inserts
671 [meta][field] org table name: test_inserts
672 [meta][field] col name: o
673 [meta][field] org col name: o
674 [meta][field] length: 8
675 [meta][field] charsetnr: 8
676 [meta][field] flags: 32 (UNSIGNED )
677 [meta][field] decimals: 0
678 [meta][field] type: INT24 (9)
679
680 [meta][field] db name: test1
681 [meta][field] table name: test_inserts
682 [meta][field] org table name: test_inserts
683 [meta][field] col name: p
684 [meta][field] org col name: p
685 [meta][field] length: 11
686 [meta][field] charsetnr: 8
687 [meta][field] flags: 0
688 [meta][field] decimals: 0
689 [meta][field] type: LONG (3)
690
691 [meta][field] db name: test1
692 [meta][field] table name: test_inserts
693 [meta][field] org table name: test_inserts
694 [meta][field] col name: q
695 [meta][field] org col name: q
696 [meta][field] length: 10
697 [meta][field] charsetnr: 8
698 [meta][field] flags: 32 (UNSIGNED )
699 [meta][field] decimals: 0
700 [meta][field] type: LONG (3)
701
702 [meta][field] db name: test1
703 [meta][field] table name: test_inserts
704 [meta][field] org table name: test_inserts
705 [meta][field] col name: r
706 [meta][field] org col name: r
707 [meta][field] length: 20
708 [meta][field] charsetnr: 8
709 [meta][field] flags: 0
710 [meta][field] decimals: 0
711 [meta][field] type: LONGLONG (8)
712
713 [meta][field] db name: test1
714 [meta][field] table name: test_inserts
715 [meta][field] org table name: test_inserts
716 [meta][field] col name: s
717 [meta][field] org col name: s
718 [meta][field] length: 20
719 [meta][field] charsetnr: 8
720 [meta][field] flags: 32 (UNSIGNED )
721 [meta][field] decimals: 0
722 [meta][field] type: LONGLONG (8)
723
724 [meta][field] db name: test1
725 [meta][field] table name: test_inserts
726 [meta][field] org table name: test_inserts
727 [meta][field] col name: t
728 [meta][field] org col name: t
729 [meta][field] length: 4
730 [meta][field] charsetnr: 8
731 [meta][field] flags: 96 (UNSIGNED ZEROFILL )
732 [meta][field] decimals: 0
733 [meta][field] type: YEAR (13)
734
735 [meta][field] db name: test1
736 [meta][field] table name: test_inserts
737 [meta][field] org table name: test_inserts
738 [meta][field] col name: u
739 [meta][field] org col name: u
740 [meta][field] length: 6
741 [meta][field] charsetnr: 8
742 [meta][field] flags: 32 (UNSIGNED )
743 [meta][field] decimals: 2
744 [meta][field] type: NEWDECIMAL (246)
745
746 [meta][field] db name: test1
747 [meta][field] table name: test_inserts
748 [meta][field] org table name: test_inserts
749 [meta][field] col name: v
750 [meta][field] org col name: v
751 [meta][field] length: 7
752 [meta][field] charsetnr: 8
753 [meta][field] flags: 0
754 [meta][field] decimals: 2
755 [meta][field] type: NEWDECIMAL (246)
756
757
758 [meta][charset result] number: 33
759 [meta][charset result] name: utf8mb3
760 [meta][charset result] collation: utf8mb3_general_ci
761 [meta][charset result] sort order:
762
763 [data][test_inserts.a][ 1][1]
764 [data][test_inserts.b][ 3][one]
765 [data][test_inserts.c][ 4][1.23]
766 [data][test_inserts.d][ 2][-1]
767 [data][test_inserts.e][ 7][11.2323]
768 [data][test_inserts.f][ 19][2014-07-06 07:06:05]
769 [data][test_inserts.g][ 10][1980-02-19]
770 [data][test_inserts.h][ 10][-830:12:23]
771 [data][test_inserts.i][ 3][127]
772 [data][test_inserts.k][ 3][255]
773 [data][test_inserts.l][ 5][32767]
774 [data][test_inserts.m][ 5][65535]
775 [data][test_inserts.n][ 7][8388607]
776 [data][test_inserts.o][ 8][16777215]
777 [data][test_inserts.p][ 10][2147483647]
778 [data][test_inserts.q][ 10][4294967295]
779 [data][test_inserts.r][ 19][9223372036854775807]
780 [data][test_inserts.s][ 20][18446744073709551615]
781 [data][test_inserts.t][ 4][1901]
782 [data][test_inserts.u][ 6][999.99]
783 [data][test_inserts.v][ 7][-999.99]
784
785 [data][test_inserts.a][ 1][2]
786 [data][test_inserts.b][ 3][two]
787 [data][test_inserts.c][ 4][2.34]
788 [data][test_inserts.d][ 2][-2]
789 [data][test_inserts.e][ 7][22.3434]
790 [data][test_inserts.f][ 19][2015-07-06 21:22:23]
791 [data][test_inserts.g][ 10][2014-06-05]
792 [data][test_inserts.h][ 9][356:22:33]
793 [data][test_inserts.i][ 4][-128]
794 [data][test_inserts.k][ 1][0]
795 [data][test_inserts.l][ 6][-32768]
796 [data][test_inserts.m][ 5][32768]
797 [data][test_inserts.n][ 8][-8388608]
798 [data][test_inserts.o][ 7][8388607]
799 [data][test_inserts.p][ 11][-2147483648]
800 [data][test_inserts.q][ 1][0]
801 [data][test_inserts.r][ 20][-9223372036854775808]
802 [data][test_inserts.s][ 20][18446744073709551615]
803 [data][test_inserts.t][ 4][2039]
804 [data][test_inserts.u][ 6][123.45]
805 [data][test_inserts.v][ 7][-543.21]
806
807 [data][test_inserts.a][ 1][3]
808 [data][test_inserts.b][ 5][three]
809 [data][test_inserts.c][ 4][3.45]
810 [data][test_inserts.d][ 2][-3]
811 [data][test_inserts.e][ 7][33.4545]
812 [data][test_inserts.f][ 19][2016-09-12 11:12:13]
813 [data][test_inserts.g][ 10][2013-05-04]
814 [data][test_inserts.h][ 9][821:33:44]
815 [data][test_inserts.i][ 2][-1]
816 [data][test_inserts.k][ 3][128]
817 [data][test_inserts.l][ 2][-1]
818 [data][test_inserts.m][ 5][65534]
819 [data][test_inserts.n][ 2][-1]
820 [data][test_inserts.o][ 8][16777214]
821 [data][test_inserts.p][ 1][1]
822 [data][test_inserts.q][ 1][2]
823 [data][test_inserts.r][ 1][3]
824 [data][test_inserts.s][ 1][4]
825 [data][test_inserts.t][ 4][2155]
826 [data][test_inserts.u][ 6][222.22]
827 [data][test_inserts.v][ 7][-567.89]
828
829 [end] server status: 2
830 [end] server status: AUTOCOMMIT
831 [end] warning count: 0
832 [end] affected rows: 0
833 [end] last insert id: 0
834 [end] message:
835 ------------------------------------------------------------------
836 EXECUTING:[34][DELETE FROM test_inserts WHERE a=2]
837 [CS_TEXT_REPRESENTATION]
838 [meta] rows: 0
839 [meta] cols: 0
840 [meta] server status: 0
841 [meta] server status:
842 [meta] warning count: 0
843
844 [meta] no columns
845
846 [meta] no charset
847
848 [data] no rows
849
850 [end] server status: 2
851 [end] server status: AUTOCOMMIT
852 [end] warning count: 0
853 [end] affected rows: 1
854 [end] last insert id: 0
855 [end] message:
856 ------------------------------------------------------------------
857 EXECUTING:[37][SELECT * FROM test_inserts ORDER BY a]
858 [CS_TEXT_REPRESENTATION]
859 [meta] rows: 2
860 [meta] cols: 21
861 [meta] server status: 2
862 [meta] server status: AUTOCOMMIT
863 [meta] warning count: 0
864
865 [meta][field] db name: test1
866 [meta][field] table name: test_inserts
867 [meta][field] org table name: test_inserts
868 [meta][field] col name: a
869 [meta][field] org col name: a
870 [meta][field] length: 10
871 [meta][field] charsetnr: 8
872 [meta][field] flags: 20515 (NOT_NULL PRI_KEY UNSIGNED NO_DEFAULT_VALUE PART_KEY )
873 [meta][field] decimals: 0
874 [meta][field] type: LONG (3)
875
876 [meta][field] db name: test1
877 [meta][field] table name: test_inserts
878 [meta][field] org table name: test_inserts
879 [meta][field] col name: b
880 [meta][field] org col name: b
881 [meta][field] length: 400
882 [meta][field] charsetnr: 255
883 [meta][field] flags: 0
884 [meta][field] decimals: 0
885 [meta][field] type: VARCHAR (15)
886
887 [meta][field] db name: test1
888 [meta][field] table name: test_inserts
889 [meta][field] org table name: test_inserts
890 [meta][field] col name: c
891 [meta][field] org col name: c
892 [meta][field] length: 22
893 [meta][field] charsetnr: 8
894 [meta][field] flags: 0
895 [meta][field] decimals: 31
896 [meta][field] type: DOUBLE (5)
897
898 [meta][field] db name: test1
899 [meta][field] table name: test_inserts
900 [meta][field] org table name: test_inserts
901 [meta][field] col name: d
902 [meta][field] org col name: d
903 [meta][field] length: 11
904 [meta][field] charsetnr: 8
905 [meta][field] flags: 16392 (MULTIPLE_KEY PART_KEY )
906 [meta][field] decimals: 0
907 [meta][field] type: LONG (3)
908
909 [meta][field] db name: test1
910 [meta][field] table name: test_inserts
911 [meta][field] org table name: test_inserts
912 [meta][field] col name: e
913 [meta][field] org col name: e
914 [meta][field] length: 12
915 [meta][field] charsetnr: 8
916 [meta][field] flags: 0
917 [meta][field] decimals: 31
918 [meta][field] type: FLOAT (4)
919
920 [meta][field] db name: test1
921 [meta][field] table name: test_inserts
922 [meta][field] org table name: test_inserts
923 [meta][field] col name: f
924 [meta][field] org col name: f
925 [meta][field] length: 19
926 [meta][field] charsetnr: 8
927 [meta][field] flags: 128 (BINARY )
928 [meta][field] decimals: 0
929 [meta][field] type: DATETIME (12)
930
931 [meta][field] db name: test1
932 [meta][field] table name: test_inserts
933 [meta][field] org table name: test_inserts
934 [meta][field] col name: g
935 [meta][field] org col name: g
936 [meta][field] length: 10
937 [meta][field] charsetnr: 8
938 [meta][field] flags: 128 (BINARY )
939 [meta][field] decimals: 0
940 [meta][field] type: DATE (10)
941
942 [meta][field] db name: test1
943 [meta][field] table name: test_inserts
944 [meta][field] org table name: test_inserts
945 [meta][field] col name: h
946 [meta][field] org col name: h
947 [meta][field] length: 10
948 [meta][field] charsetnr: 8
949 [meta][field] flags: 128 (BINARY )
950 [meta][field] decimals: 0
951 [meta][field] type: TIME (11)
952
953 [meta][field] db name: test1
954 [meta][field] table name: test_inserts
955 [meta][field] org table name: test_inserts
956 [meta][field] col name: i
957 [meta][field] org col name: i
958 [meta][field] length: 4
959 [meta][field] charsetnr: 8
960 [meta][field] flags: 0
961 [meta][field] decimals: 0
962 [meta][field] type: TINY (1)
963
964 [meta][field] db name: test1
965 [meta][field] table name: test_inserts
966 [meta][field] org table name: test_inserts
967 [meta][field] col name: k
968 [meta][field] org col name: k
969 [meta][field] length: 3
970 [meta][field] charsetnr: 8
971 [meta][field] flags: 32 (UNSIGNED )
972 [meta][field] decimals: 0
973 [meta][field] type: TINY (1)
974
975 [meta][field] db name: test1
976 [meta][field] table name: test_inserts
977 [meta][field] org table name: test_inserts
978 [meta][field] col name: l
979 [meta][field] org col name: l
980 [meta][field] length: 6
981 [meta][field] charsetnr: 8
982 [meta][field] flags: 0
983 [meta][field] decimals: 0
984 [meta][field] type: SHORT (2)
985
986 [meta][field] db name: test1
987 [meta][field] table name: test_inserts
988 [meta][field] org table name: test_inserts
989 [meta][field] col name: m
990 [meta][field] org col name: m
991 [meta][field] length: 5
992 [meta][field] charsetnr: 8
993 [meta][field] flags: 32 (UNSIGNED )
994 [meta][field] decimals: 0
995 [meta][field] type: SHORT (2)
996
997 [meta][field] db name: test1
998 [meta][field] table name: test_inserts
999 [meta][field] org table name: test_inserts
1000 [meta][field] col name: n
1001 [meta][field] org col name: n
1002 [meta][field] length: 9
1003 [meta][field] charsetnr: 8
1004 [meta][field] flags: 0
1005 [meta][field] decimals: 0
1006 [meta][field] type: INT24 (9)
1007
1008 [meta][field] db name: test1
1009 [meta][field] table name: test_inserts
1010 [meta][field] org table name: test_inserts
1011 [meta][field] col name: o
1012 [meta][field] org col name: o
1013 [meta][field] length: 8
1014 [meta][field] charsetnr: 8
1015 [meta][field] flags: 32 (UNSIGNED )
1016 [meta][field] decimals: 0
1017 [meta][field] type: INT24 (9)
1018
1019 [meta][field] db name: test1
1020 [meta][field] table name: test_inserts
1021 [meta][field] org table name: test_inserts
1022 [meta][field] col name: p
1023 [meta][field] org col name: p
1024 [meta][field] length: 11
1025 [meta][field] charsetnr: 8
1026 [meta][field] flags: 0
1027 [meta][field] decimals: 0
1028 [meta][field] type: LONG (3)
1029
1030 [meta][field] db name: test1
1031 [meta][field] table name: test_inserts
1032 [meta][field] org table name: test_inserts
1033 [meta][field] col name: q
1034 [meta][field] org col name: q
1035 [meta][field] length: 10
1036 [meta][field] charsetnr: 8
1037 [meta][field] flags: 32 (UNSIGNED )
1038 [meta][field] decimals: 0
1039 [meta][field] type: LONG (3)
1040
1041 [meta][field] db name: test1
1042 [meta][field] table name: test_inserts
1043 [meta][field] org table name: test_inserts
1044 [meta][field] col name: r
1045 [meta][field] org col name: r
1046 [meta][field] length: 20
1047 [meta][field] charsetnr: 8
1048 [meta][field] flags: 0
1049 [meta][field] decimals: 0
1050 [meta][field] type: LONGLONG (8)
1051
1052 [meta][field] db name: test1
1053 [meta][field] table name: test_inserts
1054 [meta][field] org table name: test_inserts
1055 [meta][field] col name: s
1056 [meta][field] org col name: s
1057 [meta][field] length: 20
1058 [meta][field] charsetnr: 8
1059 [meta][field] flags: 32 (UNSIGNED )
1060 [meta][field] decimals: 0
1061 [meta][field] type: LONGLONG (8)
1062
1063 [meta][field] db name: test1
1064 [meta][field] table name: test_inserts
1065 [meta][field] org table name: test_inserts
1066 [meta][field] col name: t
1067 [meta][field] org col name: t
1068 [meta][field] length: 4
1069 [meta][field] charsetnr: 8
1070 [meta][field] flags: 96 (UNSIGNED ZEROFILL )
1071 [meta][field] decimals: 0
1072 [meta][field] type: YEAR (13)
1073
1074 [meta][field] db name: test1
1075 [meta][field] table name: test_inserts
1076 [meta][field] org table name: test_inserts
1077 [meta][field] col name: u
1078 [meta][field] org col name: u
1079 [meta][field] length: 6
1080 [meta][field] charsetnr: 8
1081 [meta][field] flags: 32 (UNSIGNED )
1082 [meta][field] decimals: 2
1083 [meta][field] type: NEWDECIMAL (246)
1084
1085 [meta][field] db name: test1
1086 [meta][field] table name: test_inserts
1087 [meta][field] org table name: test_inserts
1088 [meta][field] col name: v
1089 [meta][field] org col name: v
1090 [meta][field] length: 7
1091 [meta][field] charsetnr: 8
1092 [meta][field] flags: 0
1093 [meta][field] decimals: 2
1094 [meta][field] type: NEWDECIMAL (246)
1095
1096
1097 [meta][charset result] number: 33
1098 [meta][charset result] name: utf8mb3
1099 [meta][charset result] collation: utf8mb3_general_ci
1100 [meta][charset result] sort order:
1101
1102 [data][test_inserts.a][ 1][1]
1103 [data][test_inserts.b][ 3][one]
1104 [data][test_inserts.c][ 4][1.23]
1105 [data][test_inserts.d][ 2][-1]
1106 [data][test_inserts.e][ 7][11.2323]
1107 [data][test_inserts.f][ 19][2014-07-06 07:06:05]
1108 [data][test_inserts.g][ 10][1980-02-19]
1109 [data][test_inserts.h][ 10][-830:12:23]
1110 [data][test_inserts.i][ 3][127]
1111 [data][test_inserts.k][ 3][255]
1112 [data][test_inserts.l][ 5][32767]
1113 [data][test_inserts.m][ 5][65535]
1114 [data][test_inserts.n][ 7][8388607]
1115 [data][test_inserts.o][ 8][16777215]
1116 [data][test_inserts.p][ 10][2147483647]
1117 [data][test_inserts.q][ 10][4294967295]
1118 [data][test_inserts.r][ 19][9223372036854775807]
1119 [data][test_inserts.s][ 20][18446744073709551615]
1120 [data][test_inserts.t][ 4][1901]
1121 [data][test_inserts.u][ 6][999.99]
1122 [data][test_inserts.v][ 7][-999.99]
1123
1124 [data][test_inserts.a][ 1][3]
1125 [data][test_inserts.b][ 5][three]
1126 [data][test_inserts.c][ 4][3.45]
1127 [data][test_inserts.d][ 2][-3]
1128 [data][test_inserts.e][ 7][33.4545]
1129 [data][test_inserts.f][ 19][2016-09-12 11:12:13]
1130 [data][test_inserts.g][ 10][2013-05-04]
1131 [data][test_inserts.h][ 9][821:33:44]
1132 [data][test_inserts.i][ 2][-1]
1133 [data][test_inserts.k][ 3][128]
1134 [data][test_inserts.l][ 2][-1]
1135 [data][test_inserts.m][ 5][65534]
1136 [data][test_inserts.n][ 2][-1]
1137 [data][test_inserts.o][ 8][16777214]
1138 [data][test_inserts.p][ 1][1]
1139 [data][test_inserts.q][ 1][2]
1140 [data][test_inserts.r][ 1][3]
1141 [data][test_inserts.s][ 1][4]
1142 [data][test_inserts.t][ 4][2155]
1143 [data][test_inserts.u][ 6][222.22]
1144 [data][test_inserts.v][ 7][-567.89]
1145
1146 [end] server status: 2
1147 [end] server status: AUTOCOMMIT
1148 [end] warning count: 0
1149 [end] affected rows: 0
1150 [end] last insert id: 0
1151 [end] message:
1152 [CS_BINARY_REPRESENTATION]
1153 [meta] rows: 2
1154 [meta] cols: 21
1155 [meta] server status: 2
1156 [meta] server status: AUTOCOMMIT
1157 [meta] warning count: 0
1158
1159 [meta][field] db name: test1
1160 [meta][field] table name: test_inserts
1161 [meta][field] org table name: test_inserts
1162 [meta][field] col name: a
1163 [meta][field] org col name: a
1164 [meta][field] length: 10
1165 [meta][field] charsetnr: 8
1166 [meta][field] flags: 20515 (NOT_NULL PRI_KEY UNSIGNED NO_DEFAULT_VALUE PART_KEY )
1167 [meta][field] decimals: 0
1168 [meta][field] type: LONG (3)
1169
1170 [meta][field] db name: test1
1171 [meta][field] table name: test_inserts
1172 [meta][field] org table name: test_inserts
1173 [meta][field] col name: b
1174 [meta][field] org col name: b
1175 [meta][field] length: 400
1176 [meta][field] charsetnr: 255
1177 [meta][field] flags: 0
1178 [meta][field] decimals: 0
1179 [meta][field] type: VARCHAR (15)
1180
1181 [meta][field] db name: test1
1182 [meta][field] table name: test_inserts
1183 [meta][field] org table name: test_inserts
1184 [meta][field] col name: c
1185 [meta][field] org col name: c
1186 [meta][field] length: 22
1187 [meta][field] charsetnr: 8
1188 [meta][field] flags: 0
1189 [meta][field] decimals: 31
1190 [meta][field] type: DOUBLE (5)
1191
1192 [meta][field] db name: test1
1193 [meta][field] table name: test_inserts
1194 [meta][field] org table name: test_inserts
1195 [meta][field] col name: d
1196 [meta][field] org col name: d
1197 [meta][field] length: 11
1198 [meta][field] charsetnr: 8
1199 [meta][field] flags: 16392 (MULTIPLE_KEY PART_KEY )
1200 [meta][field] decimals: 0
1201 [meta][field] type: LONG (3)
1202
1203 [meta][field] db name: test1
1204 [meta][field] table name: test_inserts
1205 [meta][field] org table name: test_inserts
1206 [meta][field] col name: e
1207 [meta][field] org col name: e
1208 [meta][field] length: 12
1209 [meta][field] charsetnr: 8
1210 [meta][field] flags: 0
1211 [meta][field] decimals: 31
1212 [meta][field] type: FLOAT (4)
1213
1214 [meta][field] db name: test1
1215 [meta][field] table name: test_inserts
1216 [meta][field] org table name: test_inserts
1217 [meta][field] col name: f
1218 [meta][field] org col name: f
1219 [meta][field] length: 19
1220 [meta][field] charsetnr: 8
1221 [meta][field] flags: 128 (BINARY )
1222 [meta][field] decimals: 0
1223 [meta][field] type: DATETIME (12)
1224
1225 [meta][field] db name: test1
1226 [meta][field] table name: test_inserts
1227 [meta][field] org table name: test_inserts
1228 [meta][field] col name: g
1229 [meta][field] org col name: g
1230 [meta][field] length: 10
1231 [meta][field] charsetnr: 8
1232 [meta][field] flags: 128 (BINARY )
1233 [meta][field] decimals: 0
1234 [meta][field] type: DATE (10)
1235
1236 [meta][field] db name: test1
1237 [meta][field] table name: test_inserts
1238 [meta][field] org table name: test_inserts
1239 [meta][field] col name: h
1240 [meta][field] org col name: h
1241 [meta][field] length: 10
1242 [meta][field] charsetnr: 8
1243 [meta][field] flags: 128 (BINARY )
1244 [meta][field] decimals: 0
1245 [meta][field] type: TIME (11)
1246
1247 [meta][field] db name: test1
1248 [meta][field] table name: test_inserts
1249 [meta][field] org table name: test_inserts
1250 [meta][field] col name: i
1251 [meta][field] org col name: i
1252 [meta][field] length: 4
1253 [meta][field] charsetnr: 8
1254 [meta][field] flags: 0
1255 [meta][field] decimals: 0
1256 [meta][field] type: TINY (1)
1257
1258 [meta][field] db name: test1
1259 [meta][field] table name: test_inserts
1260 [meta][field] org table name: test_inserts
1261 [meta][field] col name: k
1262 [meta][field] org col name: k
1263 [meta][field] length: 3
1264 [meta][field] charsetnr: 8
1265 [meta][field] flags: 32 (UNSIGNED )
1266 [meta][field] decimals: 0
1267 [meta][field] type: TINY (1)
1268
1269 [meta][field] db name: test1
1270 [meta][field] table name: test_inserts
1271 [meta][field] org table name: test_inserts
1272 [meta][field] col name: l
1273 [meta][field] org col name: l
1274 [meta][field] length: 6
1275 [meta][field] charsetnr: 8
1276 [meta][field] flags: 0
1277 [meta][field] decimals: 0
1278 [meta][field] type: SHORT (2)
1279
1280 [meta][field] db name: test1
1281 [meta][field] table name: test_inserts
1282 [meta][field] org table name: test_inserts
1283 [meta][field] col name: m
1284 [meta][field] org col name: m
1285 [meta][field] length: 5
1286 [meta][field] charsetnr: 8
1287 [meta][field] flags: 32 (UNSIGNED )
1288 [meta][field] decimals: 0
1289 [meta][field] type: SHORT (2)
1290
1291 [meta][field] db name: test1
1292 [meta][field] table name: test_inserts
1293 [meta][field] org table name: test_inserts
1294 [meta][field] col name: n
1295 [meta][field] org col name: n
1296 [meta][field] length: 9
1297 [meta][field] charsetnr: 8
1298 [meta][field] flags: 0
1299 [meta][field] decimals: 0
1300 [meta][field] type: INT24 (9)
1301
1302 [meta][field] db name: test1
1303 [meta][field] table name: test_inserts
1304 [meta][field] org table name: test_inserts
1305 [meta][field] col name: o
1306 [meta][field] org col name: o
1307 [meta][field] length: 8
1308 [meta][field] charsetnr: 8
1309 [meta][field] flags: 32 (UNSIGNED )
1310 [meta][field] decimals: 0
1311 [meta][field] type: INT24 (9)
1312
1313 [meta][field] db name: test1
1314 [meta][field] table name: test_inserts
1315 [meta][field] org table name: test_inserts
1316 [meta][field] col name: p
1317 [meta][field] org col name: p
1318 [meta][field] length: 11
1319 [meta][field] charsetnr: 8
1320 [meta][field] flags: 0
1321 [meta][field] decimals: 0
1322 [meta][field] type: LONG (3)
1323
1324 [meta][field] db name: test1
1325 [meta][field] table name: test_inserts
1326 [meta][field] org table name: test_inserts
1327 [meta][field] col name: q
1328 [meta][field] org col name: q
1329 [meta][field] length: 10
1330 [meta][field] charsetnr: 8
1331 [meta][field] flags: 32 (UNSIGNED )
1332 [meta][field] decimals: 0
1333 [meta][field] type: LONG (3)
1334
1335 [meta][field] db name: test1
1336 [meta][field] table name: test_inserts
1337 [meta][field] org table name: test_inserts
1338 [meta][field] col name: r
1339 [meta][field] org col name: r
1340 [meta][field] length: 20
1341 [meta][field] charsetnr: 8
1342 [meta][field] flags: 0
1343 [meta][field] decimals: 0
1344 [meta][field] type: LONGLONG (8)
1345
1346 [meta][field] db name: test1
1347 [meta][field] table name: test_inserts
1348 [meta][field] org table name: test_inserts
1349 [meta][field] col name: s
1350 [meta][field] org col name: s
1351 [meta][field] length: 20
1352 [meta][field] charsetnr: 8
1353 [meta][field] flags: 32 (UNSIGNED )
1354 [meta][field] decimals: 0
1355 [meta][field] type: LONGLONG (8)
1356
1357 [meta][field] db name: test1
1358 [meta][field] table name: test_inserts
1359 [meta][field] org table name: test_inserts
1360 [meta][field] col name: t
1361 [meta][field] org col name: t
1362 [meta][field] length: 4
1363 [meta][field] charsetnr: 8
1364 [meta][field] flags: 96 (UNSIGNED ZEROFILL )
1365 [meta][field] decimals: 0
1366 [meta][field] type: YEAR (13)
1367
1368 [meta][field] db name: test1
1369 [meta][field] table name: test_inserts
1370 [meta][field] org table name: test_inserts
1371 [meta][field] col name: u
1372 [meta][field] org col name: u
1373 [meta][field] length: 6
1374 [meta][field] charsetnr: 8
1375 [meta][field] flags: 32 (UNSIGNED )
1376 [meta][field] decimals: 2
1377 [meta][field] type: NEWDECIMAL (246)
1378
1379 [meta][field] db name: test1
1380 [meta][field] table name: test_inserts
1381 [meta][field] org table name: test_inserts
1382 [meta][field] col name: v
1383 [meta][field] org col name: v
1384 [meta][field] length: 7
1385 [meta][field] charsetnr: 8
1386 [meta][field] flags: 0
1387 [meta][field] decimals: 2
1388 [meta][field] type: NEWDECIMAL (246)
1389
1390
1391 [meta][charset result] number: 33
1392 [meta][charset result] name: utf8mb3
1393 [meta][charset result] collation: utf8mb3_general_ci
1394 [meta][charset result] sort order:
1395
1396 [data][test_inserts.a][ 1][1]
1397 [data][test_inserts.b][ 3][one]
1398 [data][test_inserts.c][ 4][1.23]
1399 [data][test_inserts.d][ 2][-1]
1400 [data][test_inserts.e][ 7][11.2323]
1401 [data][test_inserts.f][ 19][2014-07-06 07:06:05]
1402 [data][test_inserts.g][ 10][1980-02-19]
1403 [data][test_inserts.h][ 10][-830:12:23]
1404 [data][test_inserts.i][ 3][127]
1405 [data][test_inserts.k][ 3][255]
1406 [data][test_inserts.l][ 5][32767]
1407 [data][test_inserts.m][ 5][65535]
1408 [data][test_inserts.n][ 7][8388607]
1409 [data][test_inserts.o][ 8][16777215]
1410 [data][test_inserts.p][ 10][2147483647]
1411 [data][test_inserts.q][ 10][4294967295]
1412 [data][test_inserts.r][ 19][9223372036854775807]
1413 [data][test_inserts.s][ 20][18446744073709551615]
1414 [data][test_inserts.t][ 4][1901]
1415 [data][test_inserts.u][ 6][999.99]
1416 [data][test_inserts.v][ 7][-999.99]
1417
1418 [data][test_inserts.a][ 1][3]
1419 [data][test_inserts.b][ 5][three]
1420 [data][test_inserts.c][ 4][3.45]
1421 [data][test_inserts.d][ 2][-3]
1422 [data][test_inserts.e][ 7][33.4545]
1423 [data][test_inserts.f][ 19][2016-09-12 11:12:13]
1424 [data][test_inserts.g][ 10][2013-05-04]
1425 [data][test_inserts.h][ 9][821:33:44]
1426 [data][test_inserts.i][ 2][-1]
1427 [data][test_inserts.k][ 3][128]
1428 [data][test_inserts.l][ 2][-1]
1429 [data][test_inserts.m][ 5][65534]
1430 [data][test_inserts.n][ 2][-1]
1431 [data][test_inserts.o][ 8][16777214]
1432 [data][test_inserts.p][ 1][1]
1433 [data][test_inserts.q][ 1][2]
1434 [data][test_inserts.r][ 1][3]
1435 [data][test_inserts.s][ 1][4]
1436 [data][test_inserts.t][ 4][2155]
1437 [data][test_inserts.u][ 6][222.22]
1438 [data][test_inserts.v][ 7][-567.89]
1439
1440 [end] server status: 2
1441 [end] server status: AUTOCOMMIT
1442 [end] warning count: 0
1443 [end] affected rows: 0
1444 [end] last insert id: 0
1445 [end] message:
1446 ------------------------------------------------------------------
1447 EXECUTING:[21][TRUNCATE test_inserts]
1448 [CS_TEXT_REPRESENTATION]
1449 [meta] rows: 0
1450 [meta] cols: 0
1451 [meta] server status: 0
1452 [meta] server status:
1453 [meta] warning count: 0
1454
1455 [meta] no columns
1456
1457 [meta] no charset
1458
1459 [data] no rows
1460
1461 [end] server status: 2
1462 [end] server status: AUTOCOMMIT
1463 [end] warning count: 0
1464 [end] affected rows: 0
1465 [end] last insert id: 0
1466 [end] message:
1467 ------------------------------------------------------------------
1468 EXECUTING:[37][SELECT * FROM test_inserts ORDER BY a]
1469 [CS_TEXT_REPRESENTATION]
1470 [meta] rows: 0
1471 [meta] cols: 21
1472 [meta] server status: 2
1473 [meta] server status: AUTOCOMMIT
1474 [meta] warning count: 0
1475
1476 [meta][field] db name: test1
1477 [meta][field] table name: test_inserts
1478 [meta][field] org table name: test_inserts
1479 [meta][field] col name: a
1480 [meta][field] org col name: a
1481 [meta][field] length: 10
1482 [meta][field] charsetnr: 8
1483 [meta][field] flags: 20515 (NOT_NULL PRI_KEY UNSIGNED NO_DEFAULT_VALUE PART_KEY )
1484 [meta][field] decimals: 0
1485 [meta][field] type: LONG (3)
1486
1487 [meta][field] db name: test1
1488 [meta][field] table name: test_inserts
1489 [meta][field] org table name: test_inserts
1490 [meta][field] col name: b
1491 [meta][field] org col name: b
1492 [meta][field] length: 400
1493 [meta][field] charsetnr: 255
1494 [meta][field] flags: 0
1495 [meta][field] decimals: 0
1496 [meta][field] type: VARCHAR (15)
1497
1498 [meta][field] db name: test1
1499 [meta][field] table name: test_inserts
1500 [meta][field] org table name: test_inserts
1501 [meta][field] col name: c
1502 [meta][field] org col name: c
1503 [meta][field] length: 22
1504 [meta][field] charsetnr: 8
1505 [meta][field] flags: 0
1506 [meta][field] decimals: 31
1507 [meta][field] type: DOUBLE (5)
1508
1509 [meta][field] db name: test1
1510 [meta][field] table name: test_inserts
1511 [meta][field] org table name: test_inserts
1512 [meta][field] col name: d
1513 [meta][field] org col name: d
1514 [meta][field] length: 11
1515 [meta][field] charsetnr: 8
1516 [meta][field] flags: 16392 (MULTIPLE_KEY PART_KEY )
1517 [meta][field] decimals: 0
1518 [meta][field] type: LONG (3)
1519
1520 [meta][field] db name: test1
1521 [meta][field] table name: test_inserts
1522 [meta][field] org table name: test_inserts
1523 [meta][field] col name: e
1524 [meta][field] org col name: e
1525 [meta][field] length: 12
1526 [meta][field] charsetnr: 8
1527 [meta][field] flags: 0
1528 [meta][field] decimals: 31
1529 [meta][field] type: FLOAT (4)
1530
1531 [meta][field] db name: test1
1532 [meta][field] table name: test_inserts
1533 [meta][field] org table name: test_inserts
1534 [meta][field] col name: f
1535 [meta][field] org col name: f
1536 [meta][field] length: 19
1537 [meta][field] charsetnr: 8
1538 [meta][field] flags: 128 (BINARY )
1539 [meta][field] decimals: 0
1540 [meta][field] type: DATETIME (12)
1541
1542 [meta][field] db name: test1
1543 [meta][field] table name: test_inserts
1544 [meta][field] org table name: test_inserts
1545 [meta][field] col name: g
1546 [meta][field] org col name: g
1547 [meta][field] length: 10
1548 [meta][field] charsetnr: 8
1549 [meta][field] flags: 128 (BINARY )
1550 [meta][field] decimals: 0
1551 [meta][field] type: DATE (10)
1552
1553 [meta][field] db name: test1
1554 [meta][field] table name: test_inserts
1555 [meta][field] org table name: test_inserts
1556 [meta][field] col name: h
1557 [meta][field] org col name: h
1558 [meta][field] length: 10
1559 [meta][field] charsetnr: 8
1560 [meta][field] flags: 128 (BINARY )
1561 [meta][field] decimals: 0
1562 [meta][field] type: TIME (11)
1563
1564 [meta][field] db name: test1
1565 [meta][field] table name: test_inserts
1566 [meta][field] org table name: test_inserts
1567 [meta][field] col name: i
1568 [meta][field] org col name: i
1569 [meta][field] length: 4
1570 [meta][field] charsetnr: 8
1571 [meta][field] flags: 0
1572 [meta][field] decimals: 0
1573 [meta][field] type: TINY (1)
1574
1575 [meta][field] db name: test1
1576 [meta][field] table name: test_inserts
1577 [meta][field] org table name: test_inserts
1578 [meta][field] col name: k
1579 [meta][field] org col name: k
1580 [meta][field] length: 3
1581 [meta][field] charsetnr: 8
1582 [meta][field] flags: 32 (UNSIGNED )
1583 [meta][field] decimals: 0
1584 [meta][field] type: TINY (1)
1585
1586 [meta][field] db name: test1
1587 [meta][field] table name: test_inserts
1588 [meta][field] org table name: test_inserts
1589 [meta][field] col name: l
1590 [meta][field] org col name: l
1591 [meta][field] length: 6
1592 [meta][field] charsetnr: 8
1593 [meta][field] flags: 0
1594 [meta][field] decimals: 0
1595 [meta][field] type: SHORT (2)
1596
1597 [meta][field] db name: test1
1598 [meta][field] table name: test_inserts
1599 [meta][field] org table name: test_inserts
1600 [meta][field] col name: m
1601 [meta][field] org col name: m
1602 [meta][field] length: 5
1603 [meta][field] charsetnr: 8
1604 [meta][field] flags: 32 (UNSIGNED )
1605 [meta][field] decimals: 0
1606 [meta][field] type: SHORT (2)
1607
1608 [meta][field] db name: test1
1609 [meta][field] table name: test_inserts
1610 [meta][field] org table name: test_inserts
1611 [meta][field] col name: n
1612 [meta][field] org col name: n
1613 [meta][field] length: 9
1614 [meta][field] charsetnr: 8
1615 [meta][field] flags: 0
1616 [meta][field] decimals: 0
1617 [meta][field] type: INT24 (9)
1618
1619 [meta][field] db name: test1
1620 [meta][field] table name: test_inserts
1621 [meta][field] org table name: test_inserts
1622 [meta][field] col name: o
1623 [meta][field] org col name: o
1624 [meta][field] length: 8
1625 [meta][field] charsetnr: 8
1626 [meta][field] flags: 32 (UNSIGNED )
1627 [meta][field] decimals: 0
1628 [meta][field] type: INT24 (9)
1629
1630 [meta][field] db name: test1
1631 [meta][field] table name: test_inserts
1632 [meta][field] org table name: test_inserts
1633 [meta][field] col name: p
1634 [meta][field] org col name: p
1635 [meta][field] length: 11
1636 [meta][field] charsetnr: 8
1637 [meta][field] flags: 0
1638 [meta][field] decimals: 0
1639 [meta][field] type: LONG (3)
1640
1641 [meta][field] db name: test1
1642 [meta][field] table name: test_inserts
1643 [meta][field] org table name: test_inserts
1644 [meta][field] col name: q
1645 [meta][field] org col name: q
1646 [meta][field] length: 10
1647 [meta][field] charsetnr: 8
1648 [meta][field] flags: 32 (UNSIGNED )
1649 [meta][field] decimals: 0
1650 [meta][field] type: LONG (3)
1651
1652 [meta][field] db name: test1
1653 [meta][field] table name: test_inserts
1654 [meta][field] org table name: test_inserts
1655 [meta][field] col name: r
1656 [meta][field] org col name: r
1657 [meta][field] length: 20
1658 [meta][field] charsetnr: 8
1659 [meta][field] flags: 0
1660 [meta][field] decimals: 0
1661 [meta][field] type: LONGLONG (8)
1662
1663 [meta][field] db name: test1
1664 [meta][field] table name: test_inserts
1665 [meta][field] org table name: test_inserts
1666 [meta][field] col name: s
1667 [meta][field] org col name: s
1668 [meta][field] length: 20
1669 [meta][field] charsetnr: 8
1670 [meta][field] flags: 32 (UNSIGNED )
1671 [meta][field] decimals: 0
1672 [meta][field] type: LONGLONG (8)
1673
1674 [meta][field] db name: test1
1675 [meta][field] table name: test_inserts
1676 [meta][field] org table name: test_inserts
1677 [meta][field] col name: t
1678 [meta][field] org col name: t
1679 [meta][field] length: 4
1680 [meta][field] charsetnr: 8
1681 [meta][field] flags: 96 (UNSIGNED ZEROFILL )
1682 [meta][field] decimals: 0
1683 [meta][field] type: YEAR (13)
1684
1685 [meta][field] db name: test1
1686 [meta][field] table name: test_inserts
1687 [meta][field] org table name: test_inserts
1688 [meta][field] col name: u
1689 [meta][field] org col name: u
1690 [meta][field] length: 6
1691 [meta][field] charsetnr: 8
1692 [meta][field] flags: 32 (UNSIGNED )
1693 [meta][field] decimals: 2
1694 [meta][field] type: NEWDECIMAL (246)
1695
1696 [meta][field] db name: test1
1697 [meta][field] table name: test_inserts
1698 [meta][field] org table name: test_inserts
1699 [meta][field] col name: v
1700 [meta][field] org col name: v
1701 [meta][field] length: 7
1702 [meta][field] charsetnr: 8
1703 [meta][field] flags: 0
1704 [meta][field] decimals: 2
1705 [meta][field] type: NEWDECIMAL (246)
1706
1707
1708 [meta][charset result] number: 33
1709 [meta][charset result] name: utf8mb3
1710 [meta][charset result] collation: utf8mb3_general_ci
1711 [meta][charset result] sort order:
1712
1713 [data] no rows
1714
1715 [end] server status: 2
1716 [end] server status: AUTOCOMMIT
1717 [end] warning count: 0
1718 [end] affected rows: 0
1719 [end] last insert id: 0
1720 [end] message:
1721 [CS_BINARY_REPRESENTATION]
1722 [meta] rows: 0
1723 [meta] cols: 21
1724 [meta] server status: 2
1725 [meta] server status: AUTOCOMMIT
1726 [meta] warning count: 0
1727
1728 [meta][field] db name: test1
1729 [meta][field] table name: test_inserts
1730 [meta][field] org table name: test_inserts
1731 [meta][field] col name: a
1732 [meta][field] org col name: a
1733 [meta][field] length: 10
1734 [meta][field] charsetnr: 8
1735 [meta][field] flags: 20515 (NOT_NULL PRI_KEY UNSIGNED NO_DEFAULT_VALUE PART_KEY )
1736 [meta][field] decimals: 0
1737 [meta][field] type: LONG (3)
1738
1739 [meta][field] db name: test1
1740 [meta][field] table name: test_inserts
1741 [meta][field] org table name: test_inserts
1742 [meta][field] col name: b
1743 [meta][field] org col name: b
1744 [meta][field] length: 400
1745 [meta][field] charsetnr: 255
1746 [meta][field] flags: 0
1747 [meta][field] decimals: 0
1748 [meta][field] type: VARCHAR (15)
1749
1750 [meta][field] db name: test1
1751 [meta][field] table name: test_inserts
1752 [meta][field] org table name: test_inserts
1753 [meta][field] col name: c
1754 [meta][field] org col name: c
1755 [meta][field] length: 22
1756 [meta][field] charsetnr: 8
1757 [meta][field] flags: 0
1758 [meta][field] decimals: 31
1759 [meta][field] type: DOUBLE (5)
1760
1761 [meta][field] db name: test1
1762 [meta][field] table name: test_inserts
1763 [meta][field] org table name: test_inserts
1764 [meta][field] col name: d
1765 [meta][field] org col name: d
1766 [meta][field] length: 11
1767 [meta][field] charsetnr: 8
1768 [meta][field] flags: 16392 (MULTIPLE_KEY PART_KEY )
1769 [meta][field] decimals: 0
1770 [meta][field] type: LONG (3)
1771
1772 [meta][field] db name: test1
1773 [meta][field] table name: test_inserts
1774 [meta][field] org table name: test_inserts
1775 [meta][field] col name: e
1776 [meta][field] org col name: e
1777 [meta][field] length: 12
1778 [meta][field] charsetnr: 8
1779 [meta][field] flags: 0
1780 [meta][field] decimals: 31
1781 [meta][field] type: FLOAT (4)
1782
1783 [meta][field] db name: test1
1784 [meta][field] table name: test_inserts
1785 [meta][field] org table name: test_inserts
1786 [meta][field] col name: f
1787 [meta][field] org col name: f
1788 [meta][field] length: 19
1789 [meta][field] charsetnr: 8
1790 [meta][field] flags: 128 (BINARY )
1791 [meta][field] decimals: 0
1792 [meta][field] type: DATETIME (12)
1793
1794 [meta][field] db name: test1
1795 [meta][field] table name: test_inserts
1796 [meta][field] org table name: test_inserts
1797 [meta][field] col name: g
1798 [meta][field] org col name: g
1799 [meta][field] length: 10
1800 [meta][field] charsetnr: 8
1801 [meta][field] flags: 128 (BINARY )
1802 [meta][field] decimals: 0
1803 [meta][field] type: DATE (10)
1804
1805 [meta][field] db name: test1
1806 [meta][field] table name: test_inserts
1807 [meta][field] org table name: test_inserts
1808 [meta][field] col name: h
1809 [meta][field] org col name: h
1810 [meta][field] length: 10
1811 [meta][field] charsetnr: 8
1812 [meta][field] flags: 128 (BINARY )
1813 [meta][field] decimals: 0
1814 [meta][field] type: TIME (11)
1815
1816 [meta][field] db name: test1
1817 [meta][field] table name: test_inserts
1818 [meta][field] org table name: test_inserts
1819 [meta][field] col name: i
1820 [meta][field] org col name: i
1821 [meta][field] length: 4
1822 [meta][field] charsetnr: 8
1823 [meta][field] flags: 0
1824 [meta][field] decimals: 0
1825 [meta][field] type: TINY (1)
1826
1827 [meta][field] db name: test1
1828 [meta][field] table name: test_inserts
1829 [meta][field] org table name: test_inserts
1830 [meta][field] col name: k
1831 [meta][field] org col name: k
1832 [meta][field] length: 3
1833 [meta][field] charsetnr: 8
1834 [meta][field] flags: 32 (UNSIGNED )
1835 [meta][field] decimals: 0
1836 [meta][field] type: TINY (1)
1837
1838 [meta][field] db name: test1
1839 [meta][field] table name: test_inserts
1840 [meta][field] org table name: test_inserts
1841 [meta][field] col name: l
1842 [meta][field] org col name: l
1843 [meta][field] length: 6
1844 [meta][field] charsetnr: 8
1845 [meta][field] flags: 0
1846 [meta][field] decimals: 0
1847 [meta][field] type: SHORT (2)
1848
1849 [meta][field] db name: test1
1850 [meta][field] table name: test_inserts
1851 [meta][field] org table name: test_inserts
1852 [meta][field] col name: m
1853 [meta][field] org col name: m
1854 [meta][field] length: 5
1855 [meta][field] charsetnr: 8
1856 [meta][field] flags: 32 (UNSIGNED )
1857 [meta][field] decimals: 0
1858 [meta][field] type: SHORT (2)
1859
1860 [meta][field] db name: test1
1861 [meta][field] table name: test_inserts
1862 [meta][field] org table name: test_inserts
1863 [meta][field] col name: n
1864 [meta][field] org col name: n
1865 [meta][field] length: 9
1866 [meta][field] charsetnr: 8
1867 [meta][field] flags: 0
1868 [meta][field] decimals: 0
1869 [meta][field] type: INT24 (9)
1870
1871 [meta][field] db name: test1
1872 [meta][field] table name: test_inserts
1873 [meta][field] org table name: test_inserts
1874 [meta][field] col name: o
1875 [meta][field] org col name: o
1876 [meta][field] length: 8
1877 [meta][field] charsetnr: 8
1878 [meta][field] flags: 32 (UNSIGNED )
1879 [meta][field] decimals: 0
1880 [meta][field] type: INT24 (9)
1881
1882 [meta][field] db name: test1
1883 [meta][field] table name: test_inserts
1884 [meta][field] org table name: test_inserts
1885 [meta][field] col name: p
1886 [meta][field] org col name: p
1887 [meta][field] length: 11
1888 [meta][field] charsetnr: 8
1889 [meta][field] flags: 0
1890 [meta][field] decimals: 0
1891 [meta][field] type: LONG (3)
1892
1893 [meta][field] db name: test1
1894 [meta][field] table name: test_inserts
1895 [meta][field] org table name: test_inserts
1896 [meta][field] col name: q
1897 [meta][field] org col name: q
1898 [meta][field] length: 10
1899 [meta][field] charsetnr: 8
1900 [meta][field] flags: 32 (UNSIGNED )
1901 [meta][field] decimals: 0
1902 [meta][field] type: LONG (3)
1903
1904 [meta][field] db name: test1
1905 [meta][field] table name: test_inserts
1906 [meta][field] org table name: test_inserts
1907 [meta][field] col name: r
1908 [meta][field] org col name: r
1909 [meta][field] length: 20
1910 [meta][field] charsetnr: 8
1911 [meta][field] flags: 0
1912 [meta][field] decimals: 0
1913 [meta][field] type: LONGLONG (8)
1914
1915 [meta][field] db name: test1
1916 [meta][field] table name: test_inserts
1917 [meta][field] org table name: test_inserts
1918 [meta][field] col name: s
1919 [meta][field] org col name: s
1920 [meta][field] length: 20
1921 [meta][field] charsetnr: 8
1922 [meta][field] flags: 32 (UNSIGNED )
1923 [meta][field] decimals: 0
1924 [meta][field] type: LONGLONG (8)
1925
1926 [meta][field] db name: test1
1927 [meta][field] table name: test_inserts
1928 [meta][field] org table name: test_inserts
1929 [meta][field] col name: t
1930 [meta][field] org col name: t
1931 [meta][field] length: 4
1932 [meta][field] charsetnr: 8
1933 [meta][field] flags: 96 (UNSIGNED ZEROFILL )
1934 [meta][field] decimals: 0
1935 [meta][field] type: YEAR (13)
1936
1937 [meta][field] db name: test1
1938 [meta][field] table name: test_inserts
1939 [meta][field] org table name: test_inserts
1940 [meta][field] col name: u
1941 [meta][field] org col name: u
1942 [meta][field] length: 6
1943 [meta][field] charsetnr: 8
1944 [meta][field] flags: 32 (UNSIGNED )
1945 [meta][field] decimals: 2
1946 [meta][field] type: NEWDECIMAL (246)
1947
1948 [meta][field] db name: test1
1949 [meta][field] table name: test_inserts
1950 [meta][field] org table name: test_inserts
1951 [meta][field] col name: v
1952 [meta][field] org col name: v
1953 [meta][field] length: 7
1954 [meta][field] charsetnr: 8
1955 [meta][field] flags: 0
1956 [meta][field] decimals: 2
1957 [meta][field] type: NEWDECIMAL (246)
1958
1959
1960 [meta][charset result] number: 33
1961 [meta][charset result] name: utf8mb3
1962 [meta][charset result] collation: utf8mb3_general_ci
1963 [meta][charset result] sort order:
1964
1965 [data] no rows
1966
1967 [end] server status: 2
1968 [end] server status: AUTOCOMMIT
1969 [end] warning count: 0
1970 [end] affected rows: 0
1971 [end] last insert id: 0
1972 [end] message:
1973 ------------------------------------------------------------------
1974 EXECUTING:[27][PREPARE ps1 FROM 'select 1']
1975 [CS_TEXT_REPRESENTATION]
1976 [meta] rows: 0
1977 [meta] cols: 0
1978 [meta] server status: 0
1979 [meta] server status:
1980 [meta] warning count: 0
1981
1982 [meta] no columns
1983
1984 [meta] no charset
1985
1986 [data] no rows
1987
1988 [end] server status: 2
1989 [end] server status: AUTOCOMMIT
1990 [end] warning count: 0
1991 [end] affected rows: 0
1992 [end] last insert id: 0
1993 [end] message: Statement prepared
1994 ------------------------------------------------------------------
1995 EXECUTING:[11][EXECUTE ps1]
1996 [CS_TEXT_REPRESENTATION]
1997 [meta] rows: 1
1998 [meta] cols: 1
1999 [meta] server status: 2
2000 [meta] server status: AUTOCOMMIT
2001 [meta] warning count: 0
2002
2003 [meta][field] db name:
2004 [meta][field] table name:
2005 [meta][field] org table name:
2006 [meta][field] col name: 1
2007 [meta][field] org col name:
2008 [meta][field] length: 2
2009 [meta][field] charsetnr: 8
2010 [meta][field] flags: 129 (NOT_NULL BINARY )
2011 [meta][field] decimals: 0
2012 [meta][field] type: LONGLONG (8)
2013
2014
2015 [meta][charset result] number: 33
2016 [meta][charset result] name: utf8mb3
2017 [meta][charset result] collation: utf8mb3_general_ci
2018 [meta][charset result] sort order:
2019
2020 [data][.1][ 1][1]
2021
2022 [end] server status: 2
2023 [end] server status: AUTOCOMMIT
2024 [end] warning count: 0
2025 [end] affected rows: 0
2026 [end] last insert id: 0
2027 [end] message:
2028 ------------------------------------------------------------------
2029 EXECUTING:[22][DEALLOCATE PREPARE ps1]
2030 [CS_TEXT_REPRESENTATION]
2031 [meta] rows: 0
2032 [meta] cols: 0
2033 [meta] server status: 0
2034 [meta] server status:
2035 [meta] warning count: 0
2036
2037 [meta] no columns
2038
2039 [meta] no charset
2040
2041 [data] no rows
2042
2043 [end] server status: 2
2044 [end] server status: AUTOCOMMIT
2045 [end] warning count: 0
2046 [end] affected rows: 0
2047 [end] last insert id: 0
2048 [end] message:
2049 ------------------------------------------------------------------
2050 EXECUTING:[24][CREATE TABLE tbl (a INT)]
2051 [CS_TEXT_REPRESENTATION]
2052 [meta] rows: 0
2053 [meta] cols: 0
2054 [meta] server status: 0
2055 [meta] server status:
2056 [meta] warning count: 0
2057
2058 [meta] no columns
2059
2060 [meta] no charset
2061
2062 [data] no rows
2063
2064 [end] server status: 2
2065 [end] server status: AUTOCOMMIT
2066 [end] warning count: 0
2067 [end] affected rows: 0
2068 [end] last insert id: 0
2069 [end] message:
2070 ------------------------------------------------------------------
2071 EXECUTING:[55][PREPARE ps1 FROM 'INSERT INTO tbl VALUES (1), (2), (3)']
2072 [CS_TEXT_REPRESENTATION]
2073 [meta] rows: 0
2074 [meta] cols: 0
2075 [meta] server status: 0
2076 [meta] server status:
2077 [meta] warning count: 0
2078
2079 [meta] no columns
2080
2081 [meta] no charset
2082
2083 [data] no rows
2084
2085 [end] server status: 2
2086 [end] server status: AUTOCOMMIT
2087 [end] warning count: 0
2088 [end] affected rows: 0
2089 [end] last insert id: 0
2090 [end] message: Statement prepared
2091 ------------------------------------------------------------------
2092 EXECUTING:[11][EXECUTE ps1]
2093 [CS_TEXT_REPRESENTATION]
2094 [meta] rows: 0
2095 [meta] cols: 0
2096 [meta] server status: 0
2097 [meta] server status:
2098 [meta] warning count: 0
2099
2100 [meta] no columns
2101
2102 [meta] no charset
2103
2104 [data] no rows
2105
2106 [end] server status: 2
2107 [end] server status: AUTOCOMMIT
2108 [end] warning count: 0
2109 [end] affected rows: 3
2110 [end] last insert id: 0
2111 [end] message: Records: 3 Duplicates: 0 Warnings: 0
2112 ------------------------------------------------------------------
2113 EXECUTING:[22][DEALLOCATE PREPARE ps1]
2114 [CS_TEXT_REPRESENTATION]
2115 [meta] rows: 0
2116 [meta] cols: 0
2117 [meta] server status: 0
2118 [meta] server status:
2119 [meta] warning count: 0
2120
2121 [meta] no columns
2122
2123 [meta] no charset
2124
2125 [data] no rows
2126
2127 [end] server status: 2
2128 [end] server status: AUTOCOMMIT
2129 [end] warning count: 0
2130 [end] affected rows: 0
2131 [end] last insert id: 0
2132 [end] message:
2133 ------------------------------------------------------------------
2134 EXECUTING:[46][SELECT IF(SUM(a)=6, 'OK:)', 'FAIL:(') FROM tbl]
2135 [CS_TEXT_REPRESENTATION]
2136 [meta] rows: 1
2137 [meta] cols: 1
2138 [meta] server status: 34
2139 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2140 [meta] warning count: 0
2141
2142 [meta][field] db name:
2143 [meta][field] table name:
2144 [meta][field] org table name:
2145 [meta][field] col name: IF(SUM(a)=6, 'OK:)', 'FAIL:(')
2146 [meta][field] org col name:
2147 [meta][field] length: 18
2148 [meta][field] charsetnr: 33
2149 [meta][field] flags: 1 (NOT_NULL )
2150 [meta][field] decimals: 31
2151 [meta][field] type: VARCHAR (15)
2152
2153
2154 [meta][charset result] number: 33
2155 [meta][charset result] name: utf8mb3
2156 [meta][charset result] collation: utf8mb3_general_ci
2157 [meta][charset result] sort order:
2158
2159 [data][.IF(SUM(a)=6, 'OK:)', 'FAIL:(')][ 4][OK:)]
2160
2161 [end] server status: 34
2162 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2163 [end] warning count: 0
2164 [end] affected rows: 0
2165 [end] last insert id: 0
2166 [end] message:
2167 ------------------------------------------------------------------
2168 EXECUTING:[22][DEALLOCATE PREPARE ps1]
2169 [CS_TEXT_REPRESENTATION]
2170 [1243][HY000][Unknown prepared statement handler (ps1) given to DEALLOCATE PREPARE] [meta] rows: 0
2171 [meta] cols: 0
2172 [meta] server status: 0
2173 [meta] server status:
2174 [meta] warning count: 0
2175
2176 [meta] no columns
2177
2178 [meta] no charset
2179
2180 [data] no rows
2181
2182 [end] server status: 0
2183 [end] server status:
2184 [end] warning count: 0
2185 [end] affected rows: 0
2186 [end] last insert id: 0
2187 [end] message:
2188 [CS_BINARY_REPRESENTATION]
2189 [1243][HY000][Unknown prepared statement handler (ps1) given to DEALLOCATE PREPARE] [meta] rows: 0
2190 [meta] cols: 0
2191 [meta] server status: 0
2192 [meta] server status:
2193 [meta] warning count: 0
2194
2195 [meta] no columns
2196
2197 [meta] no charset
2198
2199 [data] no rows
2200
2201 [end] server status: 0
2202 [end] server status:
2203 [end] warning count: 0
2204 [end] affected rows: 0
2205 [end] last insert id: 0
2206 [end] message:
2207 ------------------------------------------------------------------
2208 EXECUTING:[7][garbage]
2209 [CS_TEXT_REPRESENTATION]
2210 [1064][42000][You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1] [meta] rows: 0
2211 [meta] cols: 0
2212 [meta] server status: 0
2213 [meta] server status:
2214 [meta] warning count: 0
2215
2216 [meta] no columns
2217
2218 [meta] no charset
2219
2220 [data] no rows
2221
2222 [end] server status: 0
2223 [end] server status:
2224 [end] warning count: 0
2225 [end] affected rows: 0
2226 [end] last insert id: 0
2227 [end] message:
2228 [CS_BINARY_REPRESENTATION]
2229 [1064][42000][You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1] [meta] rows: 0
2230 [meta] cols: 0
2231 [meta] server status: 0
2232 [meta] server status:
2233 [meta] warning count: 0
2234
2235 [meta] no columns
2236
2237 [meta] no charset
2238
2239 [data] no rows
2240
2241 [end] server status: 0
2242 [end] server status:
2243 [end] warning count: 0
2244 [end] affected rows: 0
2245 [end] last insert id: 0
2246 [end] message:
2247 ------------------------------------------------------------------
2248 EXECUTING:[17][SELECT b FROM tbl]
2249 [CS_TEXT_REPRESENTATION]
2250 [1054][42S22][Unknown column 'b' in 'field list'] [meta] rows: 0
2251 [meta] cols: 0
2252 [meta] server status: 0
2253 [meta] server status:
2254 [meta] warning count: 0
2255
2256 [meta] no columns
2257
2258 [meta] no charset
2259
2260 [data] no rows
2261
2262 [end] server status: 0
2263 [end] server status:
2264 [end] warning count: 0
2265 [end] affected rows: 0
2266 [end] last insert id: 0
2267 [end] message:
2268 [CS_BINARY_REPRESENTATION]
2269 [1054][42S22][Unknown column 'b' in 'field list'] [meta] rows: 0
2270 [meta] cols: 0
2271 [meta] server status: 0
2272 [meta] server status:
2273 [meta] warning count: 0
2274
2275 [meta] no columns
2276
2277 [meta] no charset
2278
2279 [data] no rows
2280
2281 [end] server status: 0
2282 [end] server status:
2283 [end] warning count: 0
2284 [end] affected rows: 0
2285 [end] last insert id: 0
2286 [end] message:
2287 ------------------------------------------------------------------
2288 EXECUTING:[43][ALTER USER bogus@remotehost PASSWORD EXPIRE]
2289 [CS_TEXT_REPRESENTATION]
2290 [1396][HY000][Operation ALTER USER failed for 'bogus'@'remotehost'] [meta] rows: 0
2291 [meta] cols: 0
2292 [meta] server status: 0
2293 [meta] server status:
2294 [meta] warning count: 0
2295
2296 [meta] no columns
2297
2298 [meta] no charset
2299
2300 [data] no rows
2301
2302 [end] server status: 0
2303 [end] server status:
2304 [end] warning count: 0
2305 [end] affected rows: 0
2306 [end] last insert id: 0
2307 [end] message:
2308 [CS_BINARY_REPRESENTATION]
2309 [1396][HY000][Operation ALTER USER failed for 'bogus'@'remotehost'] [meta] rows: 0
2310 [meta] cols: 0
2311 [meta] server status: 0
2312 [meta] server status:
2313 [meta] warning count: 0
2314
2315 [meta] no columns
2316
2317 [meta] no charset
2318
2319 [data] no rows
2320
2321 [end] server status: 0
2322 [end] server status:
2323 [end] warning count: 0
2324 [end] affected rows: 0
2325 [end] last insert id: 0
2326 [end] message:
2327 ------------------------------------------------------------------
2328 EXECUTING:[26][CREATE TABLE tbld (d TIME)]
2329 [CS_TEXT_REPRESENTATION]
2330 [meta] rows: 0
2331 [meta] cols: 0
2332 [meta] server status: 0
2333 [meta] server status:
2334 [meta] warning count: 0
2335
2336 [meta] no columns
2337
2338 [meta] no charset
2339
2340 [data] no rows
2341
2342 [end] server status: 2
2343 [end] server status: AUTOCOMMIT
2344 [end] warning count: 0
2345 [end] affected rows: 0
2346 [end] last insert id: 0
2347 [end] message:
2348 ------------------------------------------------------------------
2349 EXECUTING:[36][INSERT INTO tbld VALUES ('43141231')]
2350 [CS_TEXT_REPRESENTATION]
2351 [1292][22007][Incorrect time value: '43141231' for column 'd' at row 1] [meta] rows: 0
2352 [meta] cols: 0
2353 [meta] server status: 0
2354 [meta] server status:
2355 [meta] warning count: 0
2356
2357 [meta] no columns
2358
2359 [meta] no charset
2360
2361 [data] no rows
2362
2363 [end] server status: 0
2364 [end] server status:
2365 [end] warning count: 0
2366 [end] affected rows: 0
2367 [end] last insert id: 0
2368 [end] message:
2369 [CS_BINARY_REPRESENTATION]
2370 [1292][22007][Incorrect time value: '43141231' for column 'd' at row 1] [meta] rows: 0
2371 [meta] cols: 0
2372 [meta] server status: 0
2373 [meta] server status:
2374 [meta] warning count: 0
2375
2376 [meta] no columns
2377
2378 [meta] no charset
2379
2380 [data] no rows
2381
2382 [end] server status: 0
2383 [end] server status:
2384 [end] warning count: 0
2385 [end] affected rows: 0
2386 [end] last insert id: 0
2387 [end] message:
2388 ------------------------------------------------------------------
2389 EXECUTING:[10][SELECT 1/0]
2390 [CS_TEXT_REPRESENTATION]
2391 [meta] rows: 1
2392 [meta] cols: 1
2393 [meta] server status: 2
2394 [meta] server status: AUTOCOMMIT
2395 [meta] warning count: 0
2396
2397 [meta][field] db name:
2398 [meta][field] table name:
2399 [meta][field] org table name:
2400 [meta][field] col name: 1/0
2401 [meta][field] org col name:
2402 [meta][field] length: 7
2403 [meta][field] charsetnr: 8
2404 [meta][field] flags: 128 (BINARY )
2405 [meta][field] decimals: 4
2406 [meta][field] type: NEWDECIMAL (246)
2407
2408
2409 [meta][charset result] number: 33
2410 [meta][charset result] name: utf8mb3
2411 [meta][charset result] collation: utf8mb3_general_ci
2412 [meta][charset result] sort order:
2413
2414 [data][.1/0][ 6][[NULL]]
2415
2416 [end] server status: 2
2417 [end] server status: AUTOCOMMIT
2418 [end] warning count: 1
2419 [end] affected rows: 0
2420 [end] last insert id: 0
2421 [end] message:
2422 ------------------------------------------------------------------
2423 EXECUTING:[18][UPDATE tbl SET a=5]
2424 [CS_TEXT_REPRESENTATION]
2425 [meta] rows: 0
2426 [meta] cols: 0
2427 [meta] server status: 0
2428 [meta] server status:
2429 [meta] warning count: 0
2430
2431 [meta] no columns
2432
2433 [meta] no charset
2434
2435 [data] no rows
2436
2437 [end] server status: 34
2438 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2439 [end] warning count: 0
2440 [end] affected rows: 3
2441 [end] last insert id: 0
2442 [end] message: Rows matched: 3 Changed: 3 Warnings: 0
2443 ------------------------------------------------------------------
2444 EXECUTING:[17][START TRANSACTION]
2445 [CS_TEXT_REPRESENTATION]
2446 [meta] rows: 0
2447 [meta] cols: 0
2448 [meta] server status: 0
2449 [meta] server status:
2450 [meta] warning count: 0
2451
2452 [meta] no columns
2453
2454 [meta] no charset
2455
2456 [data] no rows
2457
2458 [end] server status: 3
2459 [end] server status: IN_TRANS AUTOCOMMIT
2460 [end] warning count: 0
2461 [end] affected rows: 0
2462 [end] last insert id: 0
2463 [end] message:
2464 ------------------------------------------------------------------
2465 EXECUTING:[18][UPDATE tbl SET a=4]
2466 [CS_TEXT_REPRESENTATION]
2467 [meta] rows: 0
2468 [meta] cols: 0
2469 [meta] server status: 0
2470 [meta] server status:
2471 [meta] warning count: 0
2472
2473 [meta] no columns
2474
2475 [meta] no charset
2476
2477 [data] no rows
2478
2479 [end] server status: 35
2480 [end] server status: IN_TRANS AUTOCOMMIT QUERY_NO_INDEX_USED
2481 [end] warning count: 0
2482 [end] affected rows: 3
2483 [end] last insert id: 0
2484 [end] message: Rows matched: 3 Changed: 3 Warnings: 0
2485 ------------------------------------------------------------------
2486 EXECUTING:[8][ROLLBACK]
2487 [CS_TEXT_REPRESENTATION]
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: 2
2501 [end] server status: AUTOCOMMIT
2502 [end] warning count: 0
2503 [end] affected rows: 0
2504 [end] last insert id: 0
2505 [end] message:
2506 ------------------------------------------------------------------
2507 EXECUTING:[45][SELECT IF(SUM(a) = 15, 'OK', 'FAIL') FROM tbl]
2508 [CS_TEXT_REPRESENTATION]
2509 [meta] rows: 1
2510 [meta] cols: 1
2511 [meta] server status: 34
2512 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2513 [meta] warning count: 0
2514
2515 [meta][field] db name:
2516 [meta][field] table name:
2517 [meta][field] org table name:
2518 [meta][field] col name: IF(SUM(a) = 15, 'OK', 'FAIL')
2519 [meta][field] org col name:
2520 [meta][field] length: 12
2521 [meta][field] charsetnr: 33
2522 [meta][field] flags: 1 (NOT_NULL )
2523 [meta][field] decimals: 31
2524 [meta][field] type: VARCHAR (15)
2525
2526
2527 [meta][charset result] number: 33
2528 [meta][charset result] name: utf8mb3
2529 [meta][charset result] collation: utf8mb3_general_ci
2530 [meta][charset result] sort order:
2531
2532 [data][.IF(SUM(a) = 15, 'OK', 'FAIL')][ 2][OK]
2533
2534 [end] server status: 34
2535 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2536 [end] warning count: 0
2537 [end] affected rows: 0
2538 [end] last insert id: 0
2539 [end] message:
2540 ------------------------------------------------------------------
2541 EXECUTING:[17][START TRANSACTION]
2542 [CS_TEXT_REPRESENTATION]
2543 [meta] rows: 0
2544 [meta] cols: 0
2545 [meta] server status: 0
2546 [meta] server status:
2547 [meta] warning count: 0
2548
2549 [meta] no columns
2550
2551 [meta] no charset
2552
2553 [data] no rows
2554
2555 [end] server status: 3
2556 [end] server status: IN_TRANS AUTOCOMMIT
2557 [end] warning count: 0
2558 [end] affected rows: 0
2559 [end] last insert id: 0
2560 [end] message:
2561 ------------------------------------------------------------------
2562 EXECUTING:[18][UPDATE tbl SET a=4]
2563 [CS_TEXT_REPRESENTATION]
2564 [meta] rows: 0
2565 [meta] cols: 0
2566 [meta] server status: 0
2567 [meta] server status:
2568 [meta] warning count: 0
2569
2570 [meta] no columns
2571
2572 [meta] no charset
2573
2574 [data] no rows
2575
2576 [end] server status: 35
2577 [end] server status: IN_TRANS AUTOCOMMIT QUERY_NO_INDEX_USED
2578 [end] warning count: 0
2579 [end] affected rows: 3
2580 [end] last insert id: 0
2581 [end] message: Rows matched: 3 Changed: 3 Warnings: 0
2582 ------------------------------------------------------------------
2583 EXECUTING:[6][COMMIT]
2584 [CS_TEXT_REPRESENTATION]
2585 [meta] rows: 0
2586 [meta] cols: 0
2587 [meta] server status: 0
2588 [meta] server status:
2589 [meta] warning count: 0
2590
2591 [meta] no columns
2592
2593 [meta] no charset
2594
2595 [data] no rows
2596
2597 [end] server status: 2
2598 [end] server status: AUTOCOMMIT
2599 [end] warning count: 0
2600 [end] affected rows: 0
2601 [end] last insert id: 0
2602 [end] message:
2603 ------------------------------------------------------------------
2604 EXECUTING:[45][SELECT IF(SUM(a) = 12, 'OK', 'FAIL') FROM tbl]
2605 [CS_TEXT_REPRESENTATION]
2606 [meta] rows: 1
2607 [meta] cols: 1
2608 [meta] server status: 34
2609 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2610 [meta] warning count: 0
2611
2612 [meta][field] db name:
2613 [meta][field] table name:
2614 [meta][field] org table name:
2615 [meta][field] col name: IF(SUM(a) = 12, 'OK', 'FAIL')
2616 [meta][field] org col name:
2617 [meta][field] length: 12
2618 [meta][field] charsetnr: 33
2619 [meta][field] flags: 1 (NOT_NULL )
2620 [meta][field] decimals: 31
2621 [meta][field] type: VARCHAR (15)
2622
2623
2624 [meta][charset result] number: 33
2625 [meta][charset result] name: utf8mb3
2626 [meta][charset result] collation: utf8mb3_general_ci
2627 [meta][charset result] sort order:
2628
2629 [data][.IF(SUM(a) = 12, 'OK', 'FAIL')][ 2][OK]
2630
2631 [end] server status: 34
2632 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2633 [end] warning count: 0
2634 [end] affected rows: 0
2635 [end] last insert id: 0
2636 [end] message:
2637 ------------------------------------------------------------------
2638 EXECUTING:[27][START TRANSACTION READ ONLY]
2639 [CS_TEXT_REPRESENTATION]
2640 [meta] rows: 0
2641 [meta] cols: 0
2642 [meta] server status: 0
2643 [meta] server status:
2644 [meta] warning count: 0
2645
2646 [meta] no columns
2647
2648 [meta] no charset
2649
2650 [data] no rows
2651
2652 [end] server status: 8195
2653 [end] server status: IN_TRANS AUTOCOMMIT IN_TRANS_READONLY
2654 [end] warning count: 0
2655 [end] affected rows: 0
2656 [end] last insert id: 0
2657 [end] message:
2658 ------------------------------------------------------------------
2659 EXECUTING:[18][UPDATE tbl SET a=2]
2660 [CS_TEXT_REPRESENTATION]
2661 [1792][25006][Cannot execute statement in a READ ONLY transaction.] [meta] rows: 0
2662 [meta] cols: 0
2663 [meta] server status: 0
2664 [meta] server status:
2665 [meta] warning count: 0
2666
2667 [meta] no columns
2668
2669 [meta] no charset
2670
2671 [data] no rows
2672
2673 [end] server status: 0
2674 [end] server status:
2675 [end] warning count: 0
2676 [end] affected rows: 0
2677 [end] last insert id: 0
2678 [end] message:
2679 ------------------------------------------------------------------
2680 EXECUTING:[6][COMMIT]
2681 [CS_TEXT_REPRESENTATION]
2682 [meta] rows: 0
2683 [meta] cols: 0
2684 [meta] server status: 0
2685 [meta] server status:
2686 [meta] warning count: 0
2687
2688 [meta] no columns
2689
2690 [meta] no charset
2691
2692 [data] no rows
2693
2694 [end] server status: 2
2695 [end] server status: AUTOCOMMIT
2696 [end] warning count: 0
2697 [end] affected rows: 0
2698 [end] last insert id: 0
2699 [end] message:
2700 ------------------------------------------------------------------
2701 EXECUTING:[45][SELECT IF(SUM(4) = 12, 'OK', 'FAIL') FROM tbl]
2702 [CS_TEXT_REPRESENTATION]
2703 [meta] rows: 1
2704 [meta] cols: 1
2705 [meta] server status: 34
2706 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2707 [meta] warning count: 0
2708
2709 [meta][field] db name:
2710 [meta][field] table name:
2711 [meta][field] org table name:
2712 [meta][field] col name: IF(SUM(4) = 12, 'OK', 'FAIL')
2713 [meta][field] org col name:
2714 [meta][field] length: 12
2715 [meta][field] charsetnr: 33
2716 [meta][field] flags: 1 (NOT_NULL )
2717 [meta][field] decimals: 31
2718 [meta][field] type: VARCHAR (15)
2719
2720
2721 [meta][charset result] number: 33
2722 [meta][charset result] name: utf8mb3
2723 [meta][charset result] collation: utf8mb3_general_ci
2724 [meta][charset result] sort order:
2725
2726 [data][.IF(SUM(4) = 12, 'OK', 'FAIL')][ 2][OK]
2727
2728 [end] server status: 34
2729 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
2730 [end] warning count: 0
2731 [end] affected rows: 0
2732 [end] last insert id: 0
2733 [end] message:
2734 ------------------------------------------------------------------
2735 EXECUTING:[16][SET autocommit=0]
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: 0
2750 [end] server status:
2751 [end] warning count: 0
2752 [end] affected rows: 0
2753 [end] last insert id: 0
2754 [end] message:
2755 ------------------------------------------------------------------
2756 EXECUTING:[18][UPDATE tbl SET a=2]
2757 [CS_TEXT_REPRESENTATION]
2758 [meta] rows: 0
2759 [meta] cols: 0
2760 [meta] server status: 0
2761 [meta] server status:
2762 [meta] warning count: 0
2763
2764 [meta] no columns
2765
2766 [meta] no charset
2767
2768 [data] no rows
2769
2770 [end] server status: 33
2771 [end] server status: IN_TRANS QUERY_NO_INDEX_USED
2772 [end] warning count: 0
2773 [end] affected rows: 3
2774 [end] last insert id: 0
2775 [end] message: Rows matched: 3 Changed: 3 Warnings: 0
2776 ------------------------------------------------------------------
2777 EXECUTING:[8][ROLLBACK]
2778 [CS_TEXT_REPRESENTATION]
2779 [meta] rows: 0
2780 [meta] cols: 0
2781 [meta] server status: 0
2782 [meta] server status:
2783 [meta] warning count: 0
2784
2785 [meta] no columns
2786
2787 [meta] no charset
2788
2789 [data] no rows
2790
2791 [end] server status: 0
2792 [end] server status:
2793 [end] warning count: 0
2794 [end] affected rows: 0
2795 [end] last insert id: 0
2796 [end] message:
2797 ------------------------------------------------------------------
2798 EXECUTING:[45][SELECT IF(SUM(4) = 12, 'OK', 'FAIL') FROM tbl]
2799 [CS_TEXT_REPRESENTATION]
2800 [meta] rows: 1
2801 [meta] cols: 1
2802 [meta] server status: 33
2803 [meta] server status: IN_TRANS QUERY_NO_INDEX_USED
2804 [meta] warning count: 0
2805
2806 [meta][field] db name:
2807 [meta][field] table name:
2808 [meta][field] org table name:
2809 [meta][field] col name: IF(SUM(4) = 12, 'OK', 'FAIL')
2810 [meta][field] org col name:
2811 [meta][field] length: 12
2812 [meta][field] charsetnr: 33
2813 [meta][field] flags: 1 (NOT_NULL )
2814 [meta][field] decimals: 31
2815 [meta][field] type: VARCHAR (15)
2816
2817
2818 [meta][charset result] number: 33
2819 [meta][charset result] name: utf8mb3
2820 [meta][charset result] collation: utf8mb3_general_ci
2821 [meta][charset result] sort order:
2822
2823 [data][.IF(SUM(4) = 12, 'OK', 'FAIL')][ 2][OK]
2824
2825 [end] server status: 33
2826 [end] server status: IN_TRANS QUERY_NO_INDEX_USED
2827 [end] warning count: 0
2828 [end] affected rows: 0
2829 [end] last insert id: 0
2830 [end] message:
2831 ------------------------------------------------------------------
2832 EXECUTING:[35][set @a=((2) in (select a from tbl))]
2833 [CS_TEXT_REPRESENTATION]
2834 [meta] rows: 0
2835 [meta] cols: 0
2836 [meta] server status: 0
2837 [meta] server status:
2838 [meta] warning count: 0
2839
2840 [meta] no columns
2841
2842 [meta] no charset
2843
2844 [data] no rows
2845
2846 [end] server status: 33
2847 [end] server status: IN_TRANS QUERY_NO_INDEX_USED
2848 [end] warning count: 0
2849 [end] affected rows: 0
2850 [end] last insert id: 0
2851 [end] message:
2852 [CS_BINARY_REPRESENTATION]
2853 [meta] rows: 0
2854 [meta] cols: 0
2855 [meta] server status: 0
2856 [meta] server status:
2857 [meta] warning count: 0
2858
2859 [meta] no columns
2860
2861 [meta] no charset
2862
2863 [data] no rows
2864
2865 [end] server status: 33
2866 [end] server status: IN_TRANS QUERY_NO_INDEX_USED
2867 [end] warning count: 0
2868 [end] affected rows: 0
2869 [end] last insert id: 0
2870 [end] message:
2871 ------------------------------------------------------------------
2872 EXECUTING:[9][SELECT @a]
2873 [CS_TEXT_REPRESENTATION]
2874 [meta] rows: 1
2875 [meta] cols: 1
2876 [meta] server status: 1
2877 [meta] server status: IN_TRANS
2878 [meta] warning count: 0
2879
2880 [meta][field] db name:
2881 [meta][field] table name:
2882 [meta][field] org table name:
2883 [meta][field] col name: @a
2884 [meta][field] org col name:
2885 [meta][field] length: 21
2886 [meta][field] charsetnr: 33
2887 [meta][field] flags: 128 (BINARY )
2888 [meta][field] decimals: 0
2889 [meta][field] type: LONGLONG (8)
2890
2891
2892 [meta][charset result] number: 33
2893 [meta][charset result] name: utf8mb3
2894 [meta][charset result] collation: utf8mb3_general_ci
2895 [meta][charset result] sort order:
2896
2897 [data][.@a][ 1][0]
2898
2899 [end] server status: 1
2900 [end] server status: IN_TRANS
2901 [end] warning count: 0
2902 [end] affected rows: 0
2903 [end] last insert id: 0
2904 [end] message:
2905 [CS_BINARY_REPRESENTATION]
2906 [meta] rows: 1
2907 [meta] cols: 1
2908 [meta] server status: 1
2909 [meta] server status: IN_TRANS
2910 [meta] warning count: 0
2911
2912 [meta][field] db name:
2913 [meta][field] table name:
2914 [meta][field] org table name:
2915 [meta][field] col name: @a
2916 [meta][field] org col name:
2917 [meta][field] length: 21
2918 [meta][field] charsetnr: 33
2919 [meta][field] flags: 128 (BINARY )
2920 [meta][field] decimals: 0
2921 [meta][field] type: LONGLONG (8)
2922
2923
2924 [meta][charset result] number: 33
2925 [meta][charset result] name: utf8mb3
2926 [meta][charset result] collation: utf8mb3_general_ci
2927 [meta][charset result] sort order:
2928
2929 [data][.@a][ 1][0]
2930
2931 [end] server status: 1
2932 [end] server status: IN_TRANS
2933 [end] warning count: 0
2934 [end] affected rows: 0
2935 [end] last insert id: 0
2936 [end] message:
2937 ------------------------------------------------------------------
2938 EXECUTING:[9][set @b=42]
2939 [CS_TEXT_REPRESENTATION]
2940 [meta] rows: 0
2941 [meta] cols: 0
2942 [meta] server status: 0
2943 [meta] server status:
2944 [meta] warning count: 0
2945
2946 [meta] no columns
2947
2948 [meta] no charset
2949
2950 [data] no rows
2951
2952 [end] server status: 1
2953 [end] server status: IN_TRANS
2954 [end] warning count: 0
2955 [end] affected rows: 0
2956 [end] last insert id: 0
2957 [end] message:
2958 [CS_BINARY_REPRESENTATION]
2959 [meta] rows: 0
2960 [meta] cols: 0
2961 [meta] server status: 0
2962 [meta] server status:
2963 [meta] warning count: 0
2964
2965 [meta] no columns
2966
2967 [meta] no charset
2968
2969 [data] no rows
2970
2971 [end] server status: 1
2972 [end] server status: IN_TRANS
2973 [end] warning count: 0
2974 [end] affected rows: 0
2975 [end] last insert id: 0
2976 [end] message:
2977 ------------------------------------------------------------------
2978 EXECUTING:[9][SELECT @b]
2979 [CS_TEXT_REPRESENTATION]
2980 [meta] rows: 1
2981 [meta] cols: 1
2982 [meta] server status: 1
2983 [meta] server status: IN_TRANS
2984 [meta] warning count: 0
2985
2986 [meta][field] db name:
2987 [meta][field] table name:
2988 [meta][field] org table name:
2989 [meta][field] col name: @b
2990 [meta][field] org col name:
2991 [meta][field] length: 21
2992 [meta][field] charsetnr: 33
2993 [meta][field] flags: 128 (BINARY )
2994 [meta][field] decimals: 0
2995 [meta][field] type: LONGLONG (8)
2996
2997
2998 [meta][charset result] number: 33
2999 [meta][charset result] name: utf8mb3
3000 [meta][charset result] collation: utf8mb3_general_ci
3001 [meta][charset result] sort order:
3002
3003 [data][.@b][ 2][42]
3004
3005 [end] server status: 1
3006 [end] server status: IN_TRANS
3007 [end] warning count: 0
3008 [end] affected rows: 0
3009 [end] last insert id: 0
3010 [end] message:
3011 [CS_BINARY_REPRESENTATION]
3012 [meta] rows: 1
3013 [meta] cols: 1
3014 [meta] server status: 1
3015 [meta] server status: IN_TRANS
3016 [meta] warning count: 0
3017
3018 [meta][field] db name:
3019 [meta][field] table name:
3020 [meta][field] org table name:
3021 [meta][field] col name: @b
3022 [meta][field] org col name:
3023 [meta][field] length: 21
3024 [meta][field] charsetnr: 33
3025 [meta][field] flags: 128 (BINARY )
3026 [meta][field] decimals: 0
3027 [meta][field] type: LONGLONG (8)
3028
3029
3030 [meta][charset result] number: 33
3031 [meta][charset result] name: utf8mb3
3032 [meta][charset result] collation: utf8mb3_general_ci
3033 [meta][charset result] sort order:
3034
3035 [data][.@b][ 2][42]
3036
3037 [end] server status: 1
3038 [end] server status: IN_TRANS
3039 [end] warning count: 0
3040 [end] affected rows: 0
3041 [end] last insert id: 0
3042 [end] message:
3043 ------------------------------------------------------------------
3044 EXECUTING:[20][SELECT @non_existing]
3045 [CS_TEXT_REPRESENTATION]
3046 [meta] rows: 1
3047 [meta] cols: 1
3048 [meta] server status: 1
3049 [meta] server status: IN_TRANS
3050 [meta] warning count: 0
3051
3052 [meta][field] db name:
3053 [meta][field] table name:
3054 [meta][field] org table name:
3055 [meta][field] col name: @non_existing
3056 [meta][field] org col name:
3057 [meta][field] length: 65535
3058 [meta][field] charsetnr: 33
3059 [meta][field] flags: 128 (BINARY )
3060 [meta][field] decimals: 31
3061 [meta][field] type: VARCHAR (15)
3062
3063
3064 [meta][charset result] number: 33
3065 [meta][charset result] name: utf8mb3
3066 [meta][charset result] collation: utf8mb3_general_ci
3067 [meta][charset result] sort order:
3068
3069 [data][.@non_existing][ 6][[NULL]]
3070
3071 [end] server status: 1
3072 [end] server status: IN_TRANS
3073 [end] warning count: 0
3074 [end] affected rows: 0
3075 [end] last insert id: 0
3076 [end] message:
3077 [CS_BINARY_REPRESENTATION]
3078 [meta] rows: 1
3079 [meta] cols: 1
3080 [meta] server status: 1
3081 [meta] server status: IN_TRANS
3082 [meta] warning count: 0
3083
3084 [meta][field] db name:
3085 [meta][field] table name:
3086 [meta][field] org table name:
3087 [meta][field] col name: @non_existing
3088 [meta][field] org col name:
3089 [meta][field] length: 65535
3090 [meta][field] charsetnr: 33
3091 [meta][field] flags: 128 (BINARY )
3092 [meta][field] decimals: 31
3093 [meta][field] type: VARCHAR (15)
3094
3095
3096 [meta][charset result] number: 33
3097 [meta][charset result] name: utf8mb3
3098 [meta][charset result] collation: utf8mb3_general_ci
3099 [meta][charset result] sort order:
3100
3101 [data][.@non_existing][ 6][[NULL]]
3102
3103 [end] server status: 1
3104 [end] server status: IN_TRANS
3105 [end] warning count: 0
3106 [end] affected rows: 0
3107 [end] last insert id: 0
3108 [end] message:
3109 ------------------------------------------------------------------
3110 EXECUTING:[0][]
3111 [CS_TEXT_REPRESENTATION]
3112 [1065][42000][Query was empty] [meta] rows: 0
3113 [meta] cols: 0
3114 [meta] server status: 0
3115 [meta] server status:
3116 [meta] warning count: 0
3117
3118 [meta] no columns
3119
3120 [meta] no charset
3121
3122 [data] no rows
3123
3124 [end] server status: 0
3125 [end] server status:
3126 [end] warning count: 0
3127 [end] affected rows: 0
3128 [end] last insert id: 0
3129 [end] message:
3130 [CS_BINARY_REPRESENTATION]
3131 [1065][42000][Query was empty] [meta] rows: 0
3132 [meta] cols: 0
3133 [meta] server status: 0
3134 [meta] server status:
3135 [meta] warning count: 0
3136
3137 [meta] no columns
3138
3139 [meta] no charset
3140
3141 [data] no rows
3142
3143 [end] server status: 0
3144 [end] server status:
3145 [end] warning count: 0
3146 [end] affected rows: 0
3147 [end] last insert id: 0
3148 [end] message:
3149 ------------------------------------------------------------------
3150 EXECUTING:[14][DROP TABLE tbl]
3151 [CS_TEXT_REPRESENTATION]
3152 [meta] rows: 0
3153 [meta] cols: 0
3154 [meta] server status: 0
3155 [meta] server status:
3156 [meta] warning count: 0
3157
3158 [meta] no columns
3159
3160 [meta] no charset
3161
3162 [data] no rows
3163
3164 [end] server status: 0
3165 [end] server status:
3166 [end] warning count: 0
3167 [end] affected rows: 0
3168 [end] last insert id: 0
3169 [end] message:
3170 ------------------------------------------------------------------
3171 EXECUTING:[15][DROP TABLE tbld]
3172 [CS_TEXT_REPRESENTATION]
3173 [meta] rows: 0
3174 [meta] cols: 0
3175 [meta] server status: 0
3176 [meta] server status:
3177 [meta] warning count: 0
3178
3179 [meta] no columns
3180
3181 [meta] no charset
3182
3183 [data] no rows
3184
3185 [end] server status: 0
3186 [end] server status:
3187 [end] warning count: 0
3188 [end] affected rows: 0
3189 [end] last insert id: 0
3190 [end] message:
3191 ------------------------------------------------------------------
3192 EXECUTING:[19][DROP DATABASE test1]
3193 [CS_TEXT_REPRESENTATION]
3194 [meta] rows: 0
3195 [meta] cols: 0
3196 [meta] server status: 0
3197 [meta] server status:
3198 [meta] warning count: 0
3199
3200 [meta] no columns
3201
3202 [meta] no charset
3203
3204 [data] no rows
3205
3206 [end] server status: 256
3207 [end] server status: DB_DROPPED
3208 [end] warning count: 0
3209 [end] affected rows: 1
3210 [end] last insert id: 0
3211 [end] message:
3212 ------------------------------------------------------------------
3213 [srv_session_close]
3214 Follows threaded run
3215 ========================================================================
3216 init thread
3217 [srv_session_open]
3218 ------------------------------------------------------------------
3219 EXECUTING:[35][SELECT 'first complex command' as a]
3220 [CS_TEXT_REPRESENTATION]
3221 [meta] rows: 1
3222 [meta] cols: 1
3223 [meta] server status: 2
3224 [meta] server status: AUTOCOMMIT
3225 [meta] warning count: 0
3226
3227 [meta][field] db name:
3228 [meta][field] table name:
3229 [meta][field] org table name:
3230 [meta][field] col name: a
3231 [meta][field] org col name:
3232 [meta][field] length: 63
3233 [meta][field] charsetnr: 33
3234 [meta][field] flags: 1 (NOT_NULL )
3235 [meta][field] decimals: 31
3236 [meta][field] type: VARCHAR (15)
3237
3238
3239 [meta][charset result] number: 33
3240 [meta][charset result] name: utf8mb3
3241 [meta][charset result] collation: utf8mb3_general_ci
3242 [meta][charset result] sort order:
3243
3244 [data][.a][ 21][first complex command]
3245
3246 [end] server status: 2
3247 [end] server status: AUTOCOMMIT
3248 [end] warning count: 0
3249 [end] affected rows: 0
3250 [end] last insert id: 0
3251 [end] message:
3252 [CS_BINARY_REPRESENTATION]
3253 [meta] rows: 1
3254 [meta] cols: 1
3255 [meta] server status: 2
3256 [meta] server status: AUTOCOMMIT
3257 [meta] warning count: 0
3258
3259 [meta][field] db name:
3260 [meta][field] table name:
3261 [meta][field] org table name:
3262 [meta][field] col name: a
3263 [meta][field] org col name:
3264 [meta][field] length: 63
3265 [meta][field] charsetnr: 33
3266 [meta][field] flags: 1 (NOT_NULL )
3267 [meta][field] decimals: 31
3268 [meta][field] type: VARCHAR (15)
3269
3270
3271 [meta][charset result] number: 33
3272 [meta][charset result] name: utf8mb3
3273 [meta][charset result] collation: utf8mb3_general_ci
3274 [meta][charset result] sort order:
3275
3276 [data][.a][ 21][first complex command]
3277
3278 [end] server status: 2
3279 [end] server status: AUTOCOMMIT
3280 [end] warning count: 0
3281 [end] affected rows: 0
3282 [end] last insert id: 0
3283 [end] message:
3284 ------------------------------------------------------------------
3285 EXECUTING:[21][CREATE DATABASE test1]
3286 [CS_TEXT_REPRESENTATION]
3287 [meta] rows: 0
3288 [meta] cols: 0
3289 [meta] server status: 0
3290 [meta] server status:
3291 [meta] warning count: 0
3292
3293 [meta] no columns
3294
3295 [meta] no charset
3296
3297 [data] no rows
3298
3299 [end] server status: 2
3300 [end] server status: AUTOCOMMIT
3301 [end] warning count: 0
3302 [end] affected rows: 1
3303 [end] last insert id: 0
3304 [end] message:
3305 ------------------------------------------------------------------
3306 EXECUTING:[8][USE test]
3307 [CS_TEXT_REPRESENTATION]
3308 [meta] rows: 0
3309 [meta] cols: 0
3310 [meta] server status: 0
3311 [meta] server status:
3312 [meta] warning count: 0
3313
3314 [meta] no columns
3315
3316 [meta] no charset
3317
3318 [data] no rows
3319
3320 [end] server status: 2
3321 [end] server status: AUTOCOMMIT
3322 [end] warning count: 0
3323 [end] affected rows: 0
3324 [end] last insert id: 0
3325 [end] message:
3326 ------------------------------------------------------------------
3327 EXECUTING:[343][CREATE TABLE test_inserts( a INT UNSIGNED, b VARCHAR(100), c DOUBLE, d INT, e FLOAT,f DATETIME, g DATE, h TIME, i TINYINT, k TINYINT UNSIGNED,l SMALLINT, m SMALLINT UNSIGNED, n MEDIUMINT, o MEDIUMINT UNSIGNED,p INTEGER, q INTEGER UNSIGNED, r BIGINT, s BIGINT UNSIGNED,t YEAR, u DECIMAL(5,2) UNSIGNED, v DECIMAL(5,2), PRIMARY KEY(a), INDEX(d));]
3328 [CS_TEXT_REPRESENTATION]
3329 [meta] rows: 0
3330 [meta] cols: 0
3331 [meta] server status: 0
3332 [meta] server status:
3333 [meta] warning count: 0
3334
3335 [meta] no columns
3336
3337 [meta] no charset
3338
3339 [data] no rows
3340
3341 [end] server status: 2
3342 [end] server status: AUTOCOMMIT
3343 [end] warning count: 1
3344 [end] affected rows: 0
3345 [end] last insert id: 0
3346 [end] message:
3347 ------------------------------------------------------------------
3348 EXECUTING:[244][INSERT INTO test_inserts VALUES (1, 'one', 1.23, -1, 11.2323, '2014-07-06 07:06:05', '1980-02-19', '-830:12:23', 127, 255, 32767, 65535, 8388607, 16777215, 2147483647, 4294967295, 9223372036854775807, 18446744073709551615,1901, 999.99, -999.99)]
3349 [CS_TEXT_REPRESENTATION]
3350 [meta] rows: 0
3351 [meta] cols: 0
3352 [meta] server status: 0
3353 [meta] server status:
3354 [meta] warning count: 0
3355
3356 [meta] no columns
3357
3358 [meta] no charset
3359
3360 [data] no rows
3361
3362 [end] server status: 2
3363 [end] server status: AUTOCOMMIT
3364 [end] warning count: 0
3365 [end] affected rows: 1
3366 [end] last insert id: 0
3367 [end] message:
3368 ------------------------------------------------------------------
3369 EXECUTING:[236][INSERT INTO test_inserts VALUES (2, 'two', 2.34, -2, 22.3434, '2015-07-06 21:22:23', '2014-06-05', '356:22:33', -128, 0, -32768, 32768, -8388608, 8388607, -2147483648, 0, -9223372036854775808, 18446744073709551615,2039, 123.45, -543.21)]
3370 [CS_TEXT_REPRESENTATION]
3371 [meta] rows: 0
3372 [meta] cols: 0
3373 [meta] server status: 0
3374 [meta] server status:
3375 [meta] warning count: 0
3376
3377 [meta] no columns
3378
3379 [meta] no charset
3380
3381 [data] no rows
3382
3383 [end] server status: 2
3384 [end] server status: AUTOCOMMIT
3385 [end] warning count: 0
3386 [end] affected rows: 1
3387 [end] last insert id: 0
3388 [end] message:
3389 ------------------------------------------------------------------
3390 EXECUTING:[179][INSERT INTO test_inserts VALUES (3, 'three',3.45,-3, 33.4545, '2016-09-12 11:12:13', '2013-05-04', '821:33:44', -1, 128, -1, 65534, -1, 16777214, 1, 2, 3, 4,2155, 222.22, -567.89)]
3391 [CS_TEXT_REPRESENTATION]
3392 [meta] rows: 0
3393 [meta] cols: 0
3394 [meta] server status: 0
3395 [meta] server status:
3396 [meta] warning count: 0
3397
3398 [meta] no columns
3399
3400 [meta] no charset
3401
3402 [data] no rows
3403
3404 [end] server status: 2
3405 [end] server status: AUTOCOMMIT
3406 [end] warning count: 0
3407 [end] affected rows: 1
3408 [end] last insert id: 0
3409 [end] message:
3410 ------------------------------------------------------------------
3411 EXECUTING:[43][SELECT * FROM test1.test_inserts ORDER BY a]
3412 [CS_TEXT_REPRESENTATION]
3413 [meta] rows: 3
3414 [meta] cols: 21
3415 [meta] server status: 2
3416 [meta] server status: AUTOCOMMIT
3417 [meta] warning count: 0
3418
3419 [meta][field] db name: test1
3420 [meta][field] table name: test_inserts
3421 [meta][field] org table name: test_inserts
3422 [meta][field] col name: a
3423 [meta][field] org col name: a
3424 [meta][field] length: 10
3425 [meta][field] charsetnr: 8
3426 [meta][field] flags: 20515 (NOT_NULL PRI_KEY UNSIGNED NO_DEFAULT_VALUE PART_KEY )
3427 [meta][field] decimals: 0
3428 [meta][field] type: LONG (3)
3429
3430 [meta][field] db name: test1
3431 [meta][field] table name: test_inserts
3432 [meta][field] org table name: test_inserts
3433 [meta][field] col name: b
3434 [meta][field] org col name: b
3435 [meta][field] length: 400
3436 [meta][field] charsetnr: 255
3437 [meta][field] flags: 0
3438 [meta][field] decimals: 0
3439 [meta][field] type: VARCHAR (15)
3440
3441 [meta][field] db name: test1
3442 [meta][field] table name: test_inserts
3443 [meta][field] org table name: test_inserts
3444 [meta][field] col name: c
3445 [meta][field] org col name: c
3446 [meta][field] length: 22
3447 [meta][field] charsetnr: 8
3448 [meta][field] flags: 0
3449 [meta][field] decimals: 31
3450 [meta][field] type: DOUBLE (5)
3451
3452 [meta][field] db name: test1
3453 [meta][field] table name: test_inserts
3454 [meta][field] org table name: test_inserts
3455 [meta][field] col name: d
3456 [meta][field] org col name: d
3457 [meta][field] length: 11
3458 [meta][field] charsetnr: 8
3459 [meta][field] flags: 16392 (MULTIPLE_KEY PART_KEY )
3460 [meta][field] decimals: 0
3461 [meta][field] type: LONG (3)
3462
3463 [meta][field] db name: test1
3464 [meta][field] table name: test_inserts
3465 [meta][field] org table name: test_inserts
3466 [meta][field] col name: e
3467 [meta][field] org col name: e
3468 [meta][field] length: 12
3469 [meta][field] charsetnr: 8
3470 [meta][field] flags: 0
3471 [meta][field] decimals: 31
3472 [meta][field] type: FLOAT (4)
3473
3474 [meta][field] db name: test1
3475 [meta][field] table name: test_inserts
3476 [meta][field] org table name: test_inserts
3477 [meta][field] col name: f
3478 [meta][field] org col name: f
3479 [meta][field] length: 19
3480 [meta][field] charsetnr: 8
3481 [meta][field] flags: 128 (BINARY )
3482 [meta][field] decimals: 0
3483 [meta][field] type: DATETIME (12)
3484
3485 [meta][field] db name: test1
3486 [meta][field] table name: test_inserts
3487 [meta][field] org table name: test_inserts
3488 [meta][field] col name: g
3489 [meta][field] org col name: g
3490 [meta][field] length: 10
3491 [meta][field] charsetnr: 8
3492 [meta][field] flags: 128 (BINARY )
3493 [meta][field] decimals: 0
3494 [meta][field] type: DATE (10)
3495
3496 [meta][field] db name: test1
3497 [meta][field] table name: test_inserts
3498 [meta][field] org table name: test_inserts
3499 [meta][field] col name: h
3500 [meta][field] org col name: h
3501 [meta][field] length: 10
3502 [meta][field] charsetnr: 8
3503 [meta][field] flags: 128 (BINARY )
3504 [meta][field] decimals: 0
3505 [meta][field] type: TIME (11)
3506
3507 [meta][field] db name: test1
3508 [meta][field] table name: test_inserts
3509 [meta][field] org table name: test_inserts
3510 [meta][field] col name: i
3511 [meta][field] org col name: i
3512 [meta][field] length: 4
3513 [meta][field] charsetnr: 8
3514 [meta][field] flags: 0
3515 [meta][field] decimals: 0
3516 [meta][field] type: TINY (1)
3517
3518 [meta][field] db name: test1
3519 [meta][field] table name: test_inserts
3520 [meta][field] org table name: test_inserts
3521 [meta][field] col name: k
3522 [meta][field] org col name: k
3523 [meta][field] length: 3
3524 [meta][field] charsetnr: 8
3525 [meta][field] flags: 32 (UNSIGNED )
3526 [meta][field] decimals: 0
3527 [meta][field] type: TINY (1)
3528
3529 [meta][field] db name: test1
3530 [meta][field] table name: test_inserts
3531 [meta][field] org table name: test_inserts
3532 [meta][field] col name: l
3533 [meta][field] org col name: l
3534 [meta][field] length: 6
3535 [meta][field] charsetnr: 8
3536 [meta][field] flags: 0
3537 [meta][field] decimals: 0
3538 [meta][field] type: SHORT (2)
3539
3540 [meta][field] db name: test1
3541 [meta][field] table name: test_inserts
3542 [meta][field] org table name: test_inserts
3543 [meta][field] col name: m
3544 [meta][field] org col name: m
3545 [meta][field] length: 5
3546 [meta][field] charsetnr: 8
3547 [meta][field] flags: 32 (UNSIGNED )
3548 [meta][field] decimals: 0
3549 [meta][field] type: SHORT (2)
3550
3551 [meta][field] db name: test1
3552 [meta][field] table name: test_inserts
3553 [meta][field] org table name: test_inserts
3554 [meta][field] col name: n
3555 [meta][field] org col name: n
3556 [meta][field] length: 9
3557 [meta][field] charsetnr: 8
3558 [meta][field] flags: 0
3559 [meta][field] decimals: 0
3560 [meta][field] type: INT24 (9)
3561
3562 [meta][field] db name: test1
3563 [meta][field] table name: test_inserts
3564 [meta][field] org table name: test_inserts
3565 [meta][field] col name: o
3566 [meta][field] org col name: o
3567 [meta][field] length: 8
3568 [meta][field] charsetnr: 8
3569 [meta][field] flags: 32 (UNSIGNED )
3570 [meta][field] decimals: 0
3571 [meta][field] type: INT24 (9)
3572
3573 [meta][field] db name: test1
3574 [meta][field] table name: test_inserts
3575 [meta][field] org table name: test_inserts
3576 [meta][field] col name: p
3577 [meta][field] org col name: p
3578 [meta][field] length: 11
3579 [meta][field] charsetnr: 8
3580 [meta][field] flags: 0
3581 [meta][field] decimals: 0
3582 [meta][field] type: LONG (3)
3583
3584 [meta][field] db name: test1
3585 [meta][field] table name: test_inserts
3586 [meta][field] org table name: test_inserts
3587 [meta][field] col name: q
3588 [meta][field] org col name: q
3589 [meta][field] length: 10
3590 [meta][field] charsetnr: 8
3591 [meta][field] flags: 32 (UNSIGNED )
3592 [meta][field] decimals: 0
3593 [meta][field] type: LONG (3)
3594
3595 [meta][field] db name: test1
3596 [meta][field] table name: test_inserts
3597 [meta][field] org table name: test_inserts
3598 [meta][field] col name: r
3599 [meta][field] org col name: r
3600 [meta][field] length: 20
3601 [meta][field] charsetnr: 8
3602 [meta][field] flags: 0
3603 [meta][field] decimals: 0
3604 [meta][field] type: LONGLONG (8)
3605
3606 [meta][field] db name: test1
3607 [meta][field] table name: test_inserts
3608 [meta][field] org table name: test_inserts
3609 [meta][field] col name: s
3610 [meta][field] org col name: s
3611 [meta][field] length: 20
3612 [meta][field] charsetnr: 8
3613 [meta][field] flags: 32 (UNSIGNED )
3614 [meta][field] decimals: 0
3615 [meta][field] type: LONGLONG (8)
3616
3617 [meta][field] db name: test1
3618 [meta][field] table name: test_inserts
3619 [meta][field] org table name: test_inserts
3620 [meta][field] col name: t
3621 [meta][field] org col name: t
3622 [meta][field] length: 4
3623 [meta][field] charsetnr: 8
3624 [meta][field] flags: 96 (UNSIGNED ZEROFILL )
3625 [meta][field] decimals: 0
3626 [meta][field] type: YEAR (13)
3627
3628 [meta][field] db name: test1
3629 [meta][field] table name: test_inserts
3630 [meta][field] org table name: test_inserts
3631 [meta][field] col name: u
3632 [meta][field] org col name: u
3633 [meta][field] length: 6
3634 [meta][field] charsetnr: 8
3635 [meta][field] flags: 32 (UNSIGNED )
3636 [meta][field] decimals: 2
3637 [meta][field] type: NEWDECIMAL (246)
3638
3639 [meta][field] db name: test1
3640 [meta][field] table name: test_inserts
3641 [meta][field] org table name: test_inserts
3642 [meta][field] col name: v
3643 [meta][field] org col name: v
3644 [meta][field] length: 7
3645 [meta][field] charsetnr: 8
3646 [meta][field] flags: 0
3647 [meta][field] decimals: 2
3648 [meta][field] type: NEWDECIMAL (246)
3649
3650
3651 [meta][charset result] number: 33
3652 [meta][charset result] name: utf8mb3
3653 [meta][charset result] collation: utf8mb3_general_ci
3654 [meta][charset result] sort order:
3655
3656 [data][test_inserts.a][ 1][1]
3657 [data][test_inserts.b][ 3][one]
3658 [data][test_inserts.c][ 4][1.23]
3659 [data][test_inserts.d][ 2][-1]
3660 [data][test_inserts.e][ 7][11.2323]
3661 [data][test_inserts.f][ 19][2014-07-06 07:06:05]
3662 [data][test_inserts.g][ 10][1980-02-19]
3663 [data][test_inserts.h][ 10][-830:12:23]
3664 [data][test_inserts.i][ 3][127]
3665 [data][test_inserts.k][ 3][255]
3666 [data][test_inserts.l][ 5][32767]
3667 [data][test_inserts.m][ 5][65535]
3668 [data][test_inserts.n][ 7][8388607]
3669 [data][test_inserts.o][ 8][16777215]
3670 [data][test_inserts.p][ 10][2147483647]
3671 [data][test_inserts.q][ 10][4294967295]
3672 [data][test_inserts.r][ 19][9223372036854775807]
3673 [data][test_inserts.s][ 20][18446744073709551615]
3674 [data][test_inserts.t][ 4][1901]
3675 [data][test_inserts.u][ 6][999.99]
3676 [data][test_inserts.v][ 7][-999.99]
3677
3678 [data][test_inserts.a][ 1][2]
3679 [data][test_inserts.b][ 3][two]
3680 [data][test_inserts.c][ 4][2.34]
3681 [data][test_inserts.d][ 2][-2]
3682 [data][test_inserts.e][ 7][22.3434]
3683 [data][test_inserts.f][ 19][2015-07-06 21:22:23]
3684 [data][test_inserts.g][ 10][2014-06-05]
3685 [data][test_inserts.h][ 9][356:22:33]
3686 [data][test_inserts.i][ 4][-128]
3687 [data][test_inserts.k][ 1][0]
3688 [data][test_inserts.l][ 6][-32768]
3689 [data][test_inserts.m][ 5][32768]
3690 [data][test_inserts.n][ 8][-8388608]
3691 [data][test_inserts.o][ 7][8388607]
3692 [data][test_inserts.p][ 11][-2147483648]
3693 [data][test_inserts.q][ 1][0]
3694 [data][test_inserts.r][ 20][-9223372036854775808]
3695 [data][test_inserts.s][ 20][18446744073709551615]
3696 [data][test_inserts.t][ 4][2039]
3697 [data][test_inserts.u][ 6][123.45]
3698 [data][test_inserts.v][ 7][-543.21]
3699
3700 [data][test_inserts.a][ 1][3]
3701 [data][test_inserts.b][ 5][three]
3702 [data][test_inserts.c][ 4][3.45]
3703 [data][test_inserts.d][ 2][-3]
3704 [data][test_inserts.e][ 7][33.4545]
3705 [data][test_inserts.f][ 19][2016-09-12 11:12:13]
3706 [data][test_inserts.g][ 10][2013-05-04]
3707 [data][test_inserts.h][ 9][821:33:44]
3708 [data][test_inserts.i][ 2][-1]
3709 [data][test_inserts.k][ 3][128]
3710 [data][test_inserts.l][ 2][-1]
3711 [data][test_inserts.m][ 5][65534]
3712 [data][test_inserts.n][ 2][-1]
3713 [data][test_inserts.o][ 8][16777214]
3714 [data][test_inserts.p][ 1][1]
3715 [data][test_inserts.q][ 1][2]
3716 [data][test_inserts.r][ 1][3]
3717 [data][test_inserts.s][ 1][4]
3718 [data][test_inserts.t][ 4][2155]
3719 [data][test_inserts.u][ 6][222.22]
3720 [data][test_inserts.v][ 7][-567.89]
3721
3722 [end] server status: 2
3723 [end] server status: AUTOCOMMIT
3724 [end] warning count: 0
3725 [end] affected rows: 0
3726 [end] last insert id: 0
3727 [end] message:
3728 [CS_BINARY_REPRESENTATION]
3729 [meta] rows: 3
3730 [meta] cols: 21
3731 [meta] server status: 2
3732 [meta] server status: AUTOCOMMIT
3733 [meta] warning count: 0
3734
3735 [meta][field] db name: test1
3736 [meta][field] table name: test_inserts
3737 [meta][field] org table name: test_inserts
3738 [meta][field] col name: a
3739 [meta][field] org col name: a
3740 [meta][field] length: 10
3741 [meta][field] charsetnr: 8
3742 [meta][field] flags: 20515 (NOT_NULL PRI_KEY UNSIGNED NO_DEFAULT_VALUE PART_KEY )
3743 [meta][field] decimals: 0
3744 [meta][field] type: LONG (3)
3745
3746 [meta][field] db name: test1
3747 [meta][field] table name: test_inserts
3748 [meta][field] org table name: test_inserts
3749 [meta][field] col name: b
3750 [meta][field] org col name: b
3751 [meta][field] length: 400
3752 [meta][field] charsetnr: 255
3753 [meta][field] flags: 0
3754 [meta][field] decimals: 0
3755 [meta][field] type: VARCHAR (15)
3756
3757 [meta][field] db name: test1
3758 [meta][field] table name: test_inserts
3759 [meta][field] org table name: test_inserts
3760 [meta][field] col name: c
3761 [meta][field] org col name: c
3762 [meta][field] length: 22
3763 [meta][field] charsetnr: 8
3764 [meta][field] flags: 0
3765 [meta][field] decimals: 31
3766 [meta][field] type: DOUBLE (5)
3767
3768 [meta][field] db name: test1
3769 [meta][field] table name: test_inserts
3770 [meta][field] org table name: test_inserts
3771 [meta][field] col name: d
3772 [meta][field] org col name: d
3773 [meta][field] length: 11
3774 [meta][field] charsetnr: 8
3775 [meta][field] flags: 16392 (MULTIPLE_KEY PART_KEY )
3776 [meta][field] decimals: 0
3777 [meta][field] type: LONG (3)
3778
3779 [meta][field] db name: test1
3780 [meta][field] table name: test_inserts
3781 [meta][field] org table name: test_inserts
3782 [meta][field] col name: e
3783 [meta][field] org col name: e
3784 [meta][field] length: 12
3785 [meta][field] charsetnr: 8
3786 [meta][field] flags: 0
3787 [meta][field] decimals: 31
3788 [meta][field] type: FLOAT (4)
3789
3790 [meta][field] db name: test1
3791 [meta][field] table name: test_inserts
3792 [meta][field] org table name: test_inserts
3793 [meta][field] col name: f
3794 [meta][field] org col name: f
3795 [meta][field] length: 19
3796 [meta][field] charsetnr: 8
3797 [meta][field] flags: 128 (BINARY )
3798 [meta][field] decimals: 0
3799 [meta][field] type: DATETIME (12)
3800
3801 [meta][field] db name: test1
3802 [meta][field] table name: test_inserts
3803 [meta][field] org table name: test_inserts
3804 [meta][field] col name: g
3805 [meta][field] org col name: g
3806 [meta][field] length: 10
3807 [meta][field] charsetnr: 8
3808 [meta][field] flags: 128 (BINARY )
3809 [meta][field] decimals: 0
3810 [meta][field] type: DATE (10)
3811
3812 [meta][field] db name: test1
3813 [meta][field] table name: test_inserts
3814 [meta][field] org table name: test_inserts
3815 [meta][field] col name: h
3816 [meta][field] org col name: h
3817 [meta][field] length: 10
3818 [meta][field] charsetnr: 8
3819 [meta][field] flags: 128 (BINARY )
3820 [meta][field] decimals: 0
3821 [meta][field] type: TIME (11)
3822
3823 [meta][field] db name: test1
3824 [meta][field] table name: test_inserts
3825 [meta][field] org table name: test_inserts
3826 [meta][field] col name: i
3827 [meta][field] org col name: i
3828 [meta][field] length: 4
3829 [meta][field] charsetnr: 8
3830 [meta][field] flags: 0
3831 [meta][field] decimals: 0
3832 [meta][field] type: TINY (1)
3833
3834 [meta][field] db name: test1
3835 [meta][field] table name: test_inserts
3836 [meta][field] org table name: test_inserts
3837 [meta][field] col name: k
3838 [meta][field] org col name: k
3839 [meta][field] length: 3
3840 [meta][field] charsetnr: 8
3841 [meta][field] flags: 32 (UNSIGNED )
3842 [meta][field] decimals: 0
3843 [meta][field] type: TINY (1)
3844
3845 [meta][field] db name: test1
3846 [meta][field] table name: test_inserts
3847 [meta][field] org table name: test_inserts
3848 [meta][field] col name: l
3849 [meta][field] org col name: l
3850 [meta][field] length: 6
3851 [meta][field] charsetnr: 8
3852 [meta][field] flags: 0
3853 [meta][field] decimals: 0
3854 [meta][field] type: SHORT (2)
3855
3856 [meta][field] db name: test1
3857 [meta][field] table name: test_inserts
3858 [meta][field] org table name: test_inserts
3859 [meta][field] col name: m
3860 [meta][field] org col name: m
3861 [meta][field] length: 5
3862 [meta][field] charsetnr: 8
3863 [meta][field] flags: 32 (UNSIGNED )
3864 [meta][field] decimals: 0
3865 [meta][field] type: SHORT (2)
3866
3867 [meta][field] db name: test1
3868 [meta][field] table name: test_inserts
3869 [meta][field] org table name: test_inserts
3870 [meta][field] col name: n
3871 [meta][field] org col name: n
3872 [meta][field] length: 9
3873 [meta][field] charsetnr: 8
3874 [meta][field] flags: 0
3875 [meta][field] decimals: 0
3876 [meta][field] type: INT24 (9)
3877
3878 [meta][field] db name: test1
3879 [meta][field] table name: test_inserts
3880 [meta][field] org table name: test_inserts
3881 [meta][field] col name: o
3882 [meta][field] org col name: o
3883 [meta][field] length: 8
3884 [meta][field] charsetnr: 8
3885 [meta][field] flags: 32 (UNSIGNED )
3886 [meta][field] decimals: 0
3887 [meta][field] type: INT24 (9)
3888
3889 [meta][field] db name: test1
3890 [meta][field] table name: test_inserts
3891 [meta][field] org table name: test_inserts
3892 [meta][field] col name: p
3893 [meta][field] org col name: p
3894 [meta][field] length: 11
3895 [meta][field] charsetnr: 8
3896 [meta][field] flags: 0
3897 [meta][field] decimals: 0
3898 [meta][field] type: LONG (3)
3899
3900 [meta][field] db name: test1
3901 [meta][field] table name: test_inserts
3902 [meta][field] org table name: test_inserts
3903 [meta][field] col name: q
3904 [meta][field] org col name: q
3905 [meta][field] length: 10
3906 [meta][field] charsetnr: 8
3907 [meta][field] flags: 32 (UNSIGNED )
3908 [meta][field] decimals: 0
3909 [meta][field] type: LONG (3)
3910
3911 [meta][field] db name: test1
3912 [meta][field] table name: test_inserts
3913 [meta][field] org table name: test_inserts
3914 [meta][field] col name: r
3915 [meta][field] org col name: r
3916 [meta][field] length: 20
3917 [meta][field] charsetnr: 8
3918 [meta][field] flags: 0
3919 [meta][field] decimals: 0
3920 [meta][field] type: LONGLONG (8)
3921
3922 [meta][field] db name: test1
3923 [meta][field] table name: test_inserts
3924 [meta][field] org table name: test_inserts
3925 [meta][field] col name: s
3926 [meta][field] org col name: s
3927 [meta][field] length: 20
3928 [meta][field] charsetnr: 8
3929 [meta][field] flags: 32 (UNSIGNED )
3930 [meta][field] decimals: 0
3931 [meta][field] type: LONGLONG (8)
3932
3933 [meta][field] db name: test1
3934 [meta][field] table name: test_inserts
3935 [meta][field] org table name: test_inserts
3936 [meta][field] col name: t
3937 [meta][field] org col name: t
3938 [meta][field] length: 4
3939 [meta][field] charsetnr: 8
3940 [meta][field] flags: 96 (UNSIGNED ZEROFILL )
3941 [meta][field] decimals: 0
3942 [meta][field] type: YEAR (13)
3943
3944 [meta][field] db name: test1
3945 [meta][field] table name: test_inserts
3946 [meta][field] org table name: test_inserts
3947 [meta][field] col name: u
3948 [meta][field] org col name: u
3949 [meta][field] length: 6
3950 [meta][field] charsetnr: 8
3951 [meta][field] flags: 32 (UNSIGNED )
3952 [meta][field] decimals: 2
3953 [meta][field] type: NEWDECIMAL (246)
3954
3955 [meta][field] db name: test1
3956 [meta][field] table name: test_inserts
3957 [meta][field] org table name: test_inserts
3958 [meta][field] col name: v
3959 [meta][field] org col name: v
3960 [meta][field] length: 7
3961 [meta][field] charsetnr: 8
3962 [meta][field] flags: 0
3963 [meta][field] decimals: 2
3964 [meta][field] type: NEWDECIMAL (246)
3965
3966
3967 [meta][charset result] number: 33
3968 [meta][charset result] name: utf8mb3
3969 [meta][charset result] collation: utf8mb3_general_ci
3970 [meta][charset result] sort order:
3971
3972 [data][test_inserts.a][ 1][1]
3973 [data][test_inserts.b][ 3][one]
3974 [data][test_inserts.c][ 4][1.23]
3975 [data][test_inserts.d][ 2][-1]
3976 [data][test_inserts.e][ 7][11.2323]
3977 [data][test_inserts.f][ 19][2014-07-06 07:06:05]
3978 [data][test_inserts.g][ 10][1980-02-19]
3979 [data][test_inserts.h][ 10][-830:12:23]
3980 [data][test_inserts.i][ 3][127]
3981 [data][test_inserts.k][ 3][255]
3982 [data][test_inserts.l][ 5][32767]
3983 [data][test_inserts.m][ 5][65535]
3984 [data][test_inserts.n][ 7][8388607]
3985 [data][test_inserts.o][ 8][16777215]
3986 [data][test_inserts.p][ 10][2147483647]
3987 [data][test_inserts.q][ 10][4294967295]
3988 [data][test_inserts.r][ 19][9223372036854775807]
3989 [data][test_inserts.s][ 20][18446744073709551615]
3990 [data][test_inserts.t][ 4][1901]
3991 [data][test_inserts.u][ 6][999.99]
3992 [data][test_inserts.v][ 7][-999.99]
3993
3994 [data][test_inserts.a][ 1][2]
3995 [data][test_inserts.b][ 3][two]
3996 [data][test_inserts.c][ 4][2.34]
3997 [data][test_inserts.d][ 2][-2]
3998 [data][test_inserts.e][ 7][22.3434]
3999 [data][test_inserts.f][ 19][2015-07-06 21:22:23]
4000 [data][test_inserts.g][ 10][2014-06-05]
4001 [data][test_inserts.h][ 9][356:22:33]
4002 [data][test_inserts.i][ 4][-128]
4003 [data][test_inserts.k][ 1][0]
4004 [data][test_inserts.l][ 6][-32768]
4005 [data][test_inserts.m][ 5][32768]
4006 [data][test_inserts.n][ 8][-8388608]
4007 [data][test_inserts.o][ 7][8388607]
4008 [data][test_inserts.p][ 11][-2147483648]
4009 [data][test_inserts.q][ 1][0]
4010 [data][test_inserts.r][ 20][-9223372036854775808]
4011 [data][test_inserts.s][ 20][18446744073709551615]
4012 [data][test_inserts.t][ 4][2039]
4013 [data][test_inserts.u][ 6][123.45]
4014 [data][test_inserts.v][ 7][-543.21]
4015
4016 [data][test_inserts.a][ 1][3]
4017 [data][test_inserts.b][ 5][three]
4018 [data][test_inserts.c][ 4][3.45]
4019 [data][test_inserts.d][ 2][-3]
4020 [data][test_inserts.e][ 7][33.4545]
4021 [data][test_inserts.f][ 19][2016-09-12 11:12:13]
4022 [data][test_inserts.g][ 10][2013-05-04]
4023 [data][test_inserts.h][ 9][821:33:44]
4024 [data][test_inserts.i][ 2][-1]
4025 [data][test_inserts.k][ 3][128]
4026 [data][test_inserts.l][ 2][-1]
4027 [data][test_inserts.m][ 5][65534]
4028 [data][test_inserts.n][ 2][-1]
4029 [data][test_inserts.o][ 8][16777214]
4030 [data][test_inserts.p][ 1][1]
4031 [data][test_inserts.q][ 1][2]
4032 [data][test_inserts.r][ 1][3]
4033 [data][test_inserts.s][ 1][4]
4034 [data][test_inserts.t][ 4][2155]
4035 [data][test_inserts.u][ 6][222.22]
4036 [data][test_inserts.v][ 7][-567.89]
4037
4038 [end] server status: 2
4039 [end] server status: AUTOCOMMIT
4040 [end] warning count: 0
4041 [end] affected rows: 0
4042 [end] last insert id: 0
4043 [end] message:
4044 ------------------------------------------------------------------
4045 EXECUTING:[34][DELETE FROM test_inserts WHERE a=2]
4046 [CS_TEXT_REPRESENTATION]
4047 [meta] rows: 0
4048 [meta] cols: 0
4049 [meta] server status: 0
4050 [meta] server status:
4051 [meta] warning count: 0
4052
4053 [meta] no columns
4054
4055 [meta] no charset
4056
4057 [data] no rows
4058
4059 [end] server status: 2
4060 [end] server status: AUTOCOMMIT
4061 [end] warning count: 0
4062 [end] affected rows: 1
4063 [end] last insert id: 0
4064 [end] message:
4065 ------------------------------------------------------------------
4066 EXECUTING:[37][SELECT * FROM test_inserts ORDER BY a]
4067 [CS_TEXT_REPRESENTATION]
4068 [meta] rows: 2
4069 [meta] cols: 21
4070 [meta] server status: 2
4071 [meta] server status: AUTOCOMMIT
4072 [meta] warning count: 0
4073
4074 [meta][field] db name: test1
4075 [meta][field] table name: test_inserts
4076 [meta][field] org table name: test_inserts
4077 [meta][field] col name: a
4078 [meta][field] org col name: a
4079 [meta][field] length: 10
4080 [meta][field] charsetnr: 8
4081 [meta][field] flags: 20515 (NOT_NULL PRI_KEY UNSIGNED NO_DEFAULT_VALUE PART_KEY )
4082 [meta][field] decimals: 0
4083 [meta][field] type: LONG (3)
4084
4085 [meta][field] db name: test1
4086 [meta][field] table name: test_inserts
4087 [meta][field] org table name: test_inserts
4088 [meta][field] col name: b
4089 [meta][field] org col name: b
4090 [meta][field] length: 400
4091 [meta][field] charsetnr: 255
4092 [meta][field] flags: 0
4093 [meta][field] decimals: 0
4094 [meta][field] type: VARCHAR (15)
4095
4096 [meta][field] db name: test1
4097 [meta][field] table name: test_inserts
4098 [meta][field] org table name: test_inserts
4099 [meta][field] col name: c
4100 [meta][field] org col name: c
4101 [meta][field] length: 22
4102 [meta][field] charsetnr: 8
4103 [meta][field] flags: 0
4104 [meta][field] decimals: 31
4105 [meta][field] type: DOUBLE (5)
4106
4107 [meta][field] db name: test1
4108 [meta][field] table name: test_inserts
4109 [meta][field] org table name: test_inserts
4110 [meta][field] col name: d
4111 [meta][field] org col name: d
4112 [meta][field] length: 11
4113 [meta][field] charsetnr: 8
4114 [meta][field] flags: 16392 (MULTIPLE_KEY PART_KEY )
4115 [meta][field] decimals: 0
4116 [meta][field] type: LONG (3)
4117
4118 [meta][field] db name: test1
4119 [meta][field] table name: test_inserts
4120 [meta][field] org table name: test_inserts
4121 [meta][field] col name: e
4122 [meta][field] org col name: e
4123 [meta][field] length: 12
4124 [meta][field] charsetnr: 8
4125 [meta][field] flags: 0
4126 [meta][field] decimals: 31
4127 [meta][field] type: FLOAT (4)
4128
4129 [meta][field] db name: test1
4130 [meta][field] table name: test_inserts
4131 [meta][field] org table name: test_inserts
4132 [meta][field] col name: f
4133 [meta][field] org col name: f
4134 [meta][field] length: 19
4135 [meta][field] charsetnr: 8
4136 [meta][field] flags: 128 (BINARY )
4137 [meta][field] decimals: 0
4138 [meta][field] type: DATETIME (12)
4139
4140 [meta][field] db name: test1
4141 [meta][field] table name: test_inserts
4142 [meta][field] org table name: test_inserts
4143 [meta][field] col name: g
4144 [meta][field] org col name: g
4145 [meta][field] length: 10
4146 [meta][field] charsetnr: 8
4147 [meta][field] flags: 128 (BINARY )
4148 [meta][field] decimals: 0
4149 [meta][field] type: DATE (10)
4150
4151 [meta][field] db name: test1
4152 [meta][field] table name: test_inserts
4153 [meta][field] org table name: test_inserts
4154 [meta][field] col name: h
4155 [meta][field] org col name: h
4156 [meta][field] length: 10
4157 [meta][field] charsetnr: 8
4158 [meta][field] flags: 128 (BINARY )
4159 [meta][field] decimals: 0
4160 [meta][field] type: TIME (11)
4161
4162 [meta][field] db name: test1
4163 [meta][field] table name: test_inserts
4164 [meta][field] org table name: test_inserts
4165 [meta][field] col name: i
4166 [meta][field] org col name: i
4167 [meta][field] length: 4
4168 [meta][field] charsetnr: 8
4169 [meta][field] flags: 0
4170 [meta][field] decimals: 0
4171 [meta][field] type: TINY (1)
4172
4173 [meta][field] db name: test1
4174 [meta][field] table name: test_inserts
4175 [meta][field] org table name: test_inserts
4176 [meta][field] col name: k
4177 [meta][field] org col name: k
4178 [meta][field] length: 3
4179 [meta][field] charsetnr: 8
4180 [meta][field] flags: 32 (UNSIGNED )
4181 [meta][field] decimals: 0
4182 [meta][field] type: TINY (1)
4183
4184 [meta][field] db name: test1
4185 [meta][field] table name: test_inserts
4186 [meta][field] org table name: test_inserts
4187 [meta][field] col name: l
4188 [meta][field] org col name: l
4189 [meta][field] length: 6
4190 [meta][field] charsetnr: 8
4191 [meta][field] flags: 0
4192 [meta][field] decimals: 0
4193 [meta][field] type: SHORT (2)
4194
4195 [meta][field] db name: test1
4196 [meta][field] table name: test_inserts
4197 [meta][field] org table name: test_inserts
4198 [meta][field] col name: m
4199 [meta][field] org col name: m
4200 [meta][field] length: 5
4201 [meta][field] charsetnr: 8
4202 [meta][field] flags: 32 (UNSIGNED )
4203 [meta][field] decimals: 0
4204 [meta][field] type: SHORT (2)
4205
4206 [meta][field] db name: test1
4207 [meta][field] table name: test_inserts
4208 [meta][field] org table name: test_inserts
4209 [meta][field] col name: n
4210 [meta][field] org col name: n
4211 [meta][field] length: 9
4212 [meta][field] charsetnr: 8
4213 [meta][field] flags: 0
4214 [meta][field] decimals: 0
4215 [meta][field] type: INT24 (9)
4216
4217 [meta][field] db name: test1
4218 [meta][field] table name: test_inserts
4219 [meta][field] org table name: test_inserts
4220 [meta][field] col name: o
4221 [meta][field] org col name: o
4222 [meta][field] length: 8
4223 [meta][field] charsetnr: 8
4224 [meta][field] flags: 32 (UNSIGNED )
4225 [meta][field] decimals: 0
4226 [meta][field] type: INT24 (9)
4227
4228 [meta][field] db name: test1
4229 [meta][field] table name: test_inserts
4230 [meta][field] org table name: test_inserts
4231 [meta][field] col name: p
4232 [meta][field] org col name: p
4233 [meta][field] length: 11
4234 [meta][field] charsetnr: 8
4235 [meta][field] flags: 0
4236 [meta][field] decimals: 0
4237 [meta][field] type: LONG (3)
4238
4239 [meta][field] db name: test1
4240 [meta][field] table name: test_inserts
4241 [meta][field] org table name: test_inserts
4242 [meta][field] col name: q
4243 [meta][field] org col name: q
4244 [meta][field] length: 10
4245 [meta][field] charsetnr: 8
4246 [meta][field] flags: 32 (UNSIGNED )
4247 [meta][field] decimals: 0
4248 [meta][field] type: LONG (3)
4249
4250 [meta][field] db name: test1
4251 [meta][field] table name: test_inserts
4252 [meta][field] org table name: test_inserts
4253 [meta][field] col name: r
4254 [meta][field] org col name: r
4255 [meta][field] length: 20
4256 [meta][field] charsetnr: 8
4257 [meta][field] flags: 0
4258 [meta][field] decimals: 0
4259 [meta][field] type: LONGLONG (8)
4260
4261 [meta][field] db name: test1
4262 [meta][field] table name: test_inserts
4263 [meta][field] org table name: test_inserts
4264 [meta][field] col name: s
4265 [meta][field] org col name: s
4266 [meta][field] length: 20
4267 [meta][field] charsetnr: 8
4268 [meta][field] flags: 32 (UNSIGNED )
4269 [meta][field] decimals: 0
4270 [meta][field] type: LONGLONG (8)
4271
4272 [meta][field] db name: test1
4273 [meta][field] table name: test_inserts
4274 [meta][field] org table name: test_inserts
4275 [meta][field] col name: t
4276 [meta][field] org col name: t
4277 [meta][field] length: 4
4278 [meta][field] charsetnr: 8
4279 [meta][field] flags: 96 (UNSIGNED ZEROFILL )
4280 [meta][field] decimals: 0
4281 [meta][field] type: YEAR (13)
4282
4283 [meta][field] db name: test1
4284 [meta][field] table name: test_inserts
4285 [meta][field] org table name: test_inserts
4286 [meta][field] col name: u
4287 [meta][field] org col name: u
4288 [meta][field] length: 6
4289 [meta][field] charsetnr: 8
4290 [meta][field] flags: 32 (UNSIGNED )
4291 [meta][field] decimals: 2
4292 [meta][field] type: NEWDECIMAL (246)
4293
4294 [meta][field] db name: test1
4295 [meta][field] table name: test_inserts
4296 [meta][field] org table name: test_inserts
4297 [meta][field] col name: v
4298 [meta][field] org col name: v
4299 [meta][field] length: 7
4300 [meta][field] charsetnr: 8
4301 [meta][field] flags: 0
4302 [meta][field] decimals: 2
4303 [meta][field] type: NEWDECIMAL (246)
4304
4305
4306 [meta][charset result] number: 33
4307 [meta][charset result] name: utf8mb3
4308 [meta][charset result] collation: utf8mb3_general_ci
4309 [meta][charset result] sort order:
4310
4311 [data][test_inserts.a][ 1][1]
4312 [data][test_inserts.b][ 3][one]
4313 [data][test_inserts.c][ 4][1.23]
4314 [data][test_inserts.d][ 2][-1]
4315 [data][test_inserts.e][ 7][11.2323]
4316 [data][test_inserts.f][ 19][2014-07-06 07:06:05]
4317 [data][test_inserts.g][ 10][1980-02-19]
4318 [data][test_inserts.h][ 10][-830:12:23]
4319 [data][test_inserts.i][ 3][127]
4320 [data][test_inserts.k][ 3][255]
4321 [data][test_inserts.l][ 5][32767]
4322 [data][test_inserts.m][ 5][65535]
4323 [data][test_inserts.n][ 7][8388607]
4324 [data][test_inserts.o][ 8][16777215]
4325 [data][test_inserts.p][ 10][2147483647]
4326 [data][test_inserts.q][ 10][4294967295]
4327 [data][test_inserts.r][ 19][9223372036854775807]
4328 [data][test_inserts.s][ 20][18446744073709551615]
4329 [data][test_inserts.t][ 4][1901]
4330 [data][test_inserts.u][ 6][999.99]
4331 [data][test_inserts.v][ 7][-999.99]
4332
4333 [data][test_inserts.a][ 1][3]
4334 [data][test_inserts.b][ 5][three]
4335 [data][test_inserts.c][ 4][3.45]
4336 [data][test_inserts.d][ 2][-3]
4337 [data][test_inserts.e][ 7][33.4545]
4338 [data][test_inserts.f][ 19][2016-09-12 11:12:13]
4339 [data][test_inserts.g][ 10][2013-05-04]
4340 [data][test_inserts.h][ 9][821:33:44]
4341 [data][test_inserts.i][ 2][-1]
4342 [data][test_inserts.k][ 3][128]
4343 [data][test_inserts.l][ 2][-1]
4344 [data][test_inserts.m][ 5][65534]
4345 [data][test_inserts.n][ 2][-1]
4346 [data][test_inserts.o][ 8][16777214]
4347 [data][test_inserts.p][ 1][1]
4348 [data][test_inserts.q][ 1][2]
4349 [data][test_inserts.r][ 1][3]
4350 [data][test_inserts.s][ 1][4]
4351 [data][test_inserts.t][ 4][2155]
4352 [data][test_inserts.u][ 6][222.22]
4353 [data][test_inserts.v][ 7][-567.89]
4354
4355 [end] server status: 2
4356 [end] server status: AUTOCOMMIT
4357 [end] warning count: 0
4358 [end] affected rows: 0
4359 [end] last insert id: 0
4360 [end] message:
4361 [CS_BINARY_REPRESENTATION]
4362 [meta] rows: 2
4363 [meta] cols: 21
4364 [meta] server status: 2
4365 [meta] server status: AUTOCOMMIT
4366 [meta] warning count: 0
4367
4368 [meta][field] db name: test1
4369 [meta][field] table name: test_inserts
4370 [meta][field] org table name: test_inserts
4371 [meta][field] col name: a
4372 [meta][field] org col name: a
4373 [meta][field] length: 10
4374 [meta][field] charsetnr: 8
4375 [meta][field] flags: 20515 (NOT_NULL PRI_KEY UNSIGNED NO_DEFAULT_VALUE PART_KEY )
4376 [meta][field] decimals: 0
4377 [meta][field] type: LONG (3)
4378
4379 [meta][field] db name: test1
4380 [meta][field] table name: test_inserts
4381 [meta][field] org table name: test_inserts
4382 [meta][field] col name: b
4383 [meta][field] org col name: b
4384 [meta][field] length: 400
4385 [meta][field] charsetnr: 255
4386 [meta][field] flags: 0
4387 [meta][field] decimals: 0
4388 [meta][field] type: VARCHAR (15)
4389
4390 [meta][field] db name: test1
4391 [meta][field] table name: test_inserts
4392 [meta][field] org table name: test_inserts
4393 [meta][field] col name: c
4394 [meta][field] org col name: c
4395 [meta][field] length: 22
4396 [meta][field] charsetnr: 8
4397 [meta][field] flags: 0
4398 [meta][field] decimals: 31
4399 [meta][field] type: DOUBLE (5)
4400
4401 [meta][field] db name: test1
4402 [meta][field] table name: test_inserts
4403 [meta][field] org table name: test_inserts
4404 [meta][field] col name: d
4405 [meta][field] org col name: d
4406 [meta][field] length: 11
4407 [meta][field] charsetnr: 8
4408 [meta][field] flags: 16392 (MULTIPLE_KEY PART_KEY )
4409 [meta][field] decimals: 0
4410 [meta][field] type: LONG (3)
4411
4412 [meta][field] db name: test1
4413 [meta][field] table name: test_inserts
4414 [meta][field] org table name: test_inserts
4415 [meta][field] col name: e
4416 [meta][field] org col name: e
4417 [meta][field] length: 12
4418 [meta][field] charsetnr: 8
4419 [meta][field] flags: 0
4420 [meta][field] decimals: 31
4421 [meta][field] type: FLOAT (4)
4422
4423 [meta][field] db name: test1
4424 [meta][field] table name: test_inserts
4425 [meta][field] org table name: test_inserts
4426 [meta][field] col name: f
4427 [meta][field] org col name: f
4428 [meta][field] length: 19
4429 [meta][field] charsetnr: 8
4430 [meta][field] flags: 128 (BINARY )
4431 [meta][field] decimals: 0
4432 [meta][field] type: DATETIME (12)
4433
4434 [meta][field] db name: test1
4435 [meta][field] table name: test_inserts
4436 [meta][field] org table name: test_inserts
4437 [meta][field] col name: g
4438 [meta][field] org col name: g
4439 [meta][field] length: 10
4440 [meta][field] charsetnr: 8
4441 [meta][field] flags: 128 (BINARY )
4442 [meta][field] decimals: 0
4443 [meta][field] type: DATE (10)
4444
4445 [meta][field] db name: test1
4446 [meta][field] table name: test_inserts
4447 [meta][field] org table name: test_inserts
4448 [meta][field] col name: h
4449 [meta][field] org col name: h
4450 [meta][field] length: 10
4451 [meta][field] charsetnr: 8
4452 [meta][field] flags: 128 (BINARY )
4453 [meta][field] decimals: 0
4454 [meta][field] type: TIME (11)
4455
4456 [meta][field] db name: test1
4457 [meta][field] table name: test_inserts
4458 [meta][field] org table name: test_inserts
4459 [meta][field] col name: i
4460 [meta][field] org col name: i
4461 [meta][field] length: 4
4462 [meta][field] charsetnr: 8
4463 [meta][field] flags: 0
4464 [meta][field] decimals: 0
4465 [meta][field] type: TINY (1)
4466
4467 [meta][field] db name: test1
4468 [meta][field] table name: test_inserts
4469 [meta][field] org table name: test_inserts
4470 [meta][field] col name: k
4471 [meta][field] org col name: k
4472 [meta][field] length: 3
4473 [meta][field] charsetnr: 8
4474 [meta][field] flags: 32 (UNSIGNED )
4475 [meta][field] decimals: 0
4476 [meta][field] type: TINY (1)
4477
4478 [meta][field] db name: test1
4479 [meta][field] table name: test_inserts
4480 [meta][field] org table name: test_inserts
4481 [meta][field] col name: l
4482 [meta][field] org col name: l
4483 [meta][field] length: 6
4484 [meta][field] charsetnr: 8
4485 [meta][field] flags: 0
4486 [meta][field] decimals: 0
4487 [meta][field] type: SHORT (2)
4488
4489 [meta][field] db name: test1
4490 [meta][field] table name: test_inserts
4491 [meta][field] org table name: test_inserts
4492 [meta][field] col name: m
4493 [meta][field] org col name: m
4494 [meta][field] length: 5
4495 [meta][field] charsetnr: 8
4496 [meta][field] flags: 32 (UNSIGNED )
4497 [meta][field] decimals: 0
4498 [meta][field] type: SHORT (2)
4499
4500 [meta][field] db name: test1
4501 [meta][field] table name: test_inserts
4502 [meta][field] org table name: test_inserts
4503 [meta][field] col name: n
4504 [meta][field] org col name: n
4505 [meta][field] length: 9
4506 [meta][field] charsetnr: 8
4507 [meta][field] flags: 0
4508 [meta][field] decimals: 0
4509 [meta][field] type: INT24 (9)
4510
4511 [meta][field] db name: test1
4512 [meta][field] table name: test_inserts
4513 [meta][field] org table name: test_inserts
4514 [meta][field] col name: o
4515 [meta][field] org col name: o
4516 [meta][field] length: 8
4517 [meta][field] charsetnr: 8
4518 [meta][field] flags: 32 (UNSIGNED )
4519 [meta][field] decimals: 0
4520 [meta][field] type: INT24 (9)
4521
4522 [meta][field] db name: test1
4523 [meta][field] table name: test_inserts
4524 [meta][field] org table name: test_inserts
4525 [meta][field] col name: p
4526 [meta][field] org col name: p
4527 [meta][field] length: 11
4528 [meta][field] charsetnr: 8
4529 [meta][field] flags: 0
4530 [meta][field] decimals: 0
4531 [meta][field] type: LONG (3)
4532
4533 [meta][field] db name: test1
4534 [meta][field] table name: test_inserts
4535 [meta][field] org table name: test_inserts
4536 [meta][field] col name: q
4537 [meta][field] org col name: q
4538 [meta][field] length: 10
4539 [meta][field] charsetnr: 8
4540 [meta][field] flags: 32 (UNSIGNED )
4541 [meta][field] decimals: 0
4542 [meta][field] type: LONG (3)
4543
4544 [meta][field] db name: test1
4545 [meta][field] table name: test_inserts
4546 [meta][field] org table name: test_inserts
4547 [meta][field] col name: r
4548 [meta][field] org col name: r
4549 [meta][field] length: 20
4550 [meta][field] charsetnr: 8
4551 [meta][field] flags: 0
4552 [meta][field] decimals: 0
4553 [meta][field] type: LONGLONG (8)
4554
4555 [meta][field] db name: test1
4556 [meta][field] table name: test_inserts
4557 [meta][field] org table name: test_inserts
4558 [meta][field] col name: s
4559 [meta][field] org col name: s
4560 [meta][field] length: 20
4561 [meta][field] charsetnr: 8
4562 [meta][field] flags: 32 (UNSIGNED )
4563 [meta][field] decimals: 0
4564 [meta][field] type: LONGLONG (8)
4565
4566 [meta][field] db name: test1
4567 [meta][field] table name: test_inserts
4568 [meta][field] org table name: test_inserts
4569 [meta][field] col name: t
4570 [meta][field] org col name: t
4571 [meta][field] length: 4
4572 [meta][field] charsetnr: 8
4573 [meta][field] flags: 96 (UNSIGNED ZEROFILL )
4574 [meta][field] decimals: 0
4575 [meta][field] type: YEAR (13)
4576
4577 [meta][field] db name: test1
4578 [meta][field] table name: test_inserts
4579 [meta][field] org table name: test_inserts
4580 [meta][field] col name: u
4581 [meta][field] org col name: u
4582 [meta][field] length: 6
4583 [meta][field] charsetnr: 8
4584 [meta][field] flags: 32 (UNSIGNED )
4585 [meta][field] decimals: 2
4586 [meta][field] type: NEWDECIMAL (246)
4587
4588 [meta][field] db name: test1
4589 [meta][field] table name: test_inserts
4590 [meta][field] org table name: test_inserts
4591 [meta][field] col name: v
4592 [meta][field] org col name: v
4593 [meta][field] length: 7
4594 [meta][field] charsetnr: 8
4595 [meta][field] flags: 0
4596 [meta][field] decimals: 2
4597 [meta][field] type: NEWDECIMAL (246)
4598
4599
4600 [meta][charset result] number: 33
4601 [meta][charset result] name: utf8mb3
4602 [meta][charset result] collation: utf8mb3_general_ci
4603 [meta][charset result] sort order:
4604
4605 [data][test_inserts.a][ 1][1]
4606 [data][test_inserts.b][ 3][one]
4607 [data][test_inserts.c][ 4][1.23]
4608 [data][test_inserts.d][ 2][-1]
4609 [data][test_inserts.e][ 7][11.2323]
4610 [data][test_inserts.f][ 19][2014-07-06 07:06:05]
4611 [data][test_inserts.g][ 10][1980-02-19]
4612 [data][test_inserts.h][ 10][-830:12:23]
4613 [data][test_inserts.i][ 3][127]
4614 [data][test_inserts.k][ 3][255]
4615 [data][test_inserts.l][ 5][32767]
4616 [data][test_inserts.m][ 5][65535]
4617 [data][test_inserts.n][ 7][8388607]
4618 [data][test_inserts.o][ 8][16777215]
4619 [data][test_inserts.p][ 10][2147483647]
4620 [data][test_inserts.q][ 10][4294967295]
4621 [data][test_inserts.r][ 19][9223372036854775807]
4622 [data][test_inserts.s][ 20][18446744073709551615]
4623 [data][test_inserts.t][ 4][1901]
4624 [data][test_inserts.u][ 6][999.99]
4625 [data][test_inserts.v][ 7][-999.99]
4626
4627 [data][test_inserts.a][ 1][3]
4628 [data][test_inserts.b][ 5][three]
4629 [data][test_inserts.c][ 4][3.45]
4630 [data][test_inserts.d][ 2][-3]
4631 [data][test_inserts.e][ 7][33.4545]
4632 [data][test_inserts.f][ 19][2016-09-12 11:12:13]
4633 [data][test_inserts.g][ 10][2013-05-04]
4634 [data][test_inserts.h][ 9][821:33:44]
4635 [data][test_inserts.i][ 2][-1]
4636 [data][test_inserts.k][ 3][128]
4637 [data][test_inserts.l][ 2][-1]
4638 [data][test_inserts.m][ 5][65534]
4639 [data][test_inserts.n][ 2][-1]
4640 [data][test_inserts.o][ 8][16777214]
4641 [data][test_inserts.p][ 1][1]
4642 [data][test_inserts.q][ 1][2]
4643 [data][test_inserts.r][ 1][3]
4644 [data][test_inserts.s][ 1][4]
4645 [data][test_inserts.t][ 4][2155]
4646 [data][test_inserts.u][ 6][222.22]
4647 [data][test_inserts.v][ 7][-567.89]
4648
4649 [end] server status: 2
4650 [end] server status: AUTOCOMMIT
4651 [end] warning count: 0
4652 [end] affected rows: 0
4653 [end] last insert id: 0
4654 [end] message:
4655 ------------------------------------------------------------------
4656 EXECUTING:[21][TRUNCATE test_inserts]
4657 [CS_TEXT_REPRESENTATION]
4658 [meta] rows: 0
4659 [meta] cols: 0
4660 [meta] server status: 0
4661 [meta] server status:
4662 [meta] warning count: 0
4663
4664 [meta] no columns
4665
4666 [meta] no charset
4667
4668 [data] no rows
4669
4670 [end] server status: 2
4671 [end] server status: AUTOCOMMIT
4672 [end] warning count: 0
4673 [end] affected rows: 0
4674 [end] last insert id: 0
4675 [end] message:
4676 ------------------------------------------------------------------
4677 EXECUTING:[37][SELECT * FROM test_inserts ORDER BY a]
4678 [CS_TEXT_REPRESENTATION]
4679 [meta] rows: 0
4680 [meta] cols: 21
4681 [meta] server status: 2
4682 [meta] server status: AUTOCOMMIT
4683 [meta] warning count: 0
4684
4685 [meta][field] db name: test1
4686 [meta][field] table name: test_inserts
4687 [meta][field] org table name: test_inserts
4688 [meta][field] col name: a
4689 [meta][field] org col name: a
4690 [meta][field] length: 10
4691 [meta][field] charsetnr: 8
4692 [meta][field] flags: 20515 (NOT_NULL PRI_KEY UNSIGNED NO_DEFAULT_VALUE PART_KEY )
4693 [meta][field] decimals: 0
4694 [meta][field] type: LONG (3)
4695
4696 [meta][field] db name: test1
4697 [meta][field] table name: test_inserts
4698 [meta][field] org table name: test_inserts
4699 [meta][field] col name: b
4700 [meta][field] org col name: b
4701 [meta][field] length: 400
4702 [meta][field] charsetnr: 255
4703 [meta][field] flags: 0
4704 [meta][field] decimals: 0
4705 [meta][field] type: VARCHAR (15)
4706
4707 [meta][field] db name: test1
4708 [meta][field] table name: test_inserts
4709 [meta][field] org table name: test_inserts
4710 [meta][field] col name: c
4711 [meta][field] org col name: c
4712 [meta][field] length: 22
4713 [meta][field] charsetnr: 8
4714 [meta][field] flags: 0
4715 [meta][field] decimals: 31
4716 [meta][field] type: DOUBLE (5)
4717
4718 [meta][field] db name: test1
4719 [meta][field] table name: test_inserts
4720 [meta][field] org table name: test_inserts
4721 [meta][field] col name: d
4722 [meta][field] org col name: d
4723 [meta][field] length: 11
4724 [meta][field] charsetnr: 8
4725 [meta][field] flags: 16392 (MULTIPLE_KEY PART_KEY )
4726 [meta][field] decimals: 0
4727 [meta][field] type: LONG (3)
4728
4729 [meta][field] db name: test1
4730 [meta][field] table name: test_inserts
4731 [meta][field] org table name: test_inserts
4732 [meta][field] col name: e
4733 [meta][field] org col name: e
4734 [meta][field] length: 12
4735 [meta][field] charsetnr: 8
4736 [meta][field] flags: 0
4737 [meta][field] decimals: 31
4738 [meta][field] type: FLOAT (4)
4739
4740 [meta][field] db name: test1
4741 [meta][field] table name: test_inserts
4742 [meta][field] org table name: test_inserts
4743 [meta][field] col name: f
4744 [meta][field] org col name: f
4745 [meta][field] length: 19
4746 [meta][field] charsetnr: 8
4747 [meta][field] flags: 128 (BINARY )
4748 [meta][field] decimals: 0
4749 [meta][field] type: DATETIME (12)
4750
4751 [meta][field] db name: test1
4752 [meta][field] table name: test_inserts
4753 [meta][field] org table name: test_inserts
4754 [meta][field] col name: g
4755 [meta][field] org col name: g
4756 [meta][field] length: 10
4757 [meta][field] charsetnr: 8
4758 [meta][field] flags: 128 (BINARY )
4759 [meta][field] decimals: 0
4760 [meta][field] type: DATE (10)
4761
4762 [meta][field] db name: test1
4763 [meta][field] table name: test_inserts
4764 [meta][field] org table name: test_inserts
4765 [meta][field] col name: h
4766 [meta][field] org col name: h
4767 [meta][field] length: 10
4768 [meta][field] charsetnr: 8
4769 [meta][field] flags: 128 (BINARY )
4770 [meta][field] decimals: 0
4771 [meta][field] type: TIME (11)
4772
4773 [meta][field] db name: test1
4774 [meta][field] table name: test_inserts
4775 [meta][field] org table name: test_inserts
4776 [meta][field] col name: i
4777 [meta][field] org col name: i
4778 [meta][field] length: 4
4779 [meta][field] charsetnr: 8
4780 [meta][field] flags: 0
4781 [meta][field] decimals: 0
4782 [meta][field] type: TINY (1)
4783
4784 [meta][field] db name: test1
4785 [meta][field] table name: test_inserts
4786 [meta][field] org table name: test_inserts
4787 [meta][field] col name: k
4788 [meta][field] org col name: k
4789 [meta][field] length: 3
4790 [meta][field] charsetnr: 8
4791 [meta][field] flags: 32 (UNSIGNED )
4792 [meta][field] decimals: 0
4793 [meta][field] type: TINY (1)
4794
4795 [meta][field] db name: test1
4796 [meta][field] table name: test_inserts
4797 [meta][field] org table name: test_inserts
4798 [meta][field] col name: l
4799 [meta][field] org col name: l
4800 [meta][field] length: 6
4801 [meta][field] charsetnr: 8
4802 [meta][field] flags: 0
4803 [meta][field] decimals: 0
4804 [meta][field] type: SHORT (2)
4805
4806 [meta][field] db name: test1
4807 [meta][field] table name: test_inserts
4808 [meta][field] org table name: test_inserts
4809 [meta][field] col name: m
4810 [meta][field] org col name: m
4811 [meta][field] length: 5
4812 [meta][field] charsetnr: 8
4813 [meta][field] flags: 32 (UNSIGNED )
4814 [meta][field] decimals: 0
4815 [meta][field] type: SHORT (2)
4816
4817 [meta][field] db name: test1
4818 [meta][field] table name: test_inserts
4819 [meta][field] org table name: test_inserts
4820 [meta][field] col name: n
4821 [meta][field] org col name: n
4822 [meta][field] length: 9
4823 [meta][field] charsetnr: 8
4824 [meta][field] flags: 0
4825 [meta][field] decimals: 0
4826 [meta][field] type: INT24 (9)
4827
4828 [meta][field] db name: test1
4829 [meta][field] table name: test_inserts
4830 [meta][field] org table name: test_inserts
4831 [meta][field] col name: o
4832 [meta][field] org col name: o
4833 [meta][field] length: 8
4834 [meta][field] charsetnr: 8
4835 [meta][field] flags: 32 (UNSIGNED )
4836 [meta][field] decimals: 0
4837 [meta][field] type: INT24 (9)
4838
4839 [meta][field] db name: test1
4840 [meta][field] table name: test_inserts
4841 [meta][field] org table name: test_inserts
4842 [meta][field] col name: p
4843 [meta][field] org col name: p
4844 [meta][field] length: 11
4845 [meta][field] charsetnr: 8
4846 [meta][field] flags: 0
4847 [meta][field] decimals: 0
4848 [meta][field] type: LONG (3)
4849
4850 [meta][field] db name: test1
4851 [meta][field] table name: test_inserts
4852 [meta][field] org table name: test_inserts
4853 [meta][field] col name: q
4854 [meta][field] org col name: q
4855 [meta][field] length: 10
4856 [meta][field] charsetnr: 8
4857 [meta][field] flags: 32 (UNSIGNED )
4858 [meta][field] decimals: 0
4859 [meta][field] type: LONG (3)
4860
4861 [meta][field] db name: test1
4862 [meta][field] table name: test_inserts
4863 [meta][field] org table name: test_inserts
4864 [meta][field] col name: r
4865 [meta][field] org col name: r
4866 [meta][field] length: 20
4867 [meta][field] charsetnr: 8
4868 [meta][field] flags: 0
4869 [meta][field] decimals: 0
4870 [meta][field] type: LONGLONG (8)
4871
4872 [meta][field] db name: test1
4873 [meta][field] table name: test_inserts
4874 [meta][field] org table name: test_inserts
4875 [meta][field] col name: s
4876 [meta][field] org col name: s
4877 [meta][field] length: 20
4878 [meta][field] charsetnr: 8
4879 [meta][field] flags: 32 (UNSIGNED )
4880 [meta][field] decimals: 0
4881 [meta][field] type: LONGLONG (8)
4882
4883 [meta][field] db name: test1
4884 [meta][field] table name: test_inserts
4885 [meta][field] org table name: test_inserts
4886 [meta][field] col name: t
4887 [meta][field] org col name: t
4888 [meta][field] length: 4
4889 [meta][field] charsetnr: 8
4890 [meta][field] flags: 96 (UNSIGNED ZEROFILL )
4891 [meta][field] decimals: 0
4892 [meta][field] type: YEAR (13)
4893
4894 [meta][field] db name: test1
4895 [meta][field] table name: test_inserts
4896 [meta][field] org table name: test_inserts
4897 [meta][field] col name: u
4898 [meta][field] org col name: u
4899 [meta][field] length: 6
4900 [meta][field] charsetnr: 8
4901 [meta][field] flags: 32 (UNSIGNED )
4902 [meta][field] decimals: 2
4903 [meta][field] type: NEWDECIMAL (246)
4904
4905 [meta][field] db name: test1
4906 [meta][field] table name: test_inserts
4907 [meta][field] org table name: test_inserts
4908 [meta][field] col name: v
4909 [meta][field] org col name: v
4910 [meta][field] length: 7
4911 [meta][field] charsetnr: 8
4912 [meta][field] flags: 0
4913 [meta][field] decimals: 2
4914 [meta][field] type: NEWDECIMAL (246)
4915
4916
4917 [meta][charset result] number: 33
4918 [meta][charset result] name: utf8mb3
4919 [meta][charset result] collation: utf8mb3_general_ci
4920 [meta][charset result] sort order:
4921
4922 [data] no rows
4923
4924 [end] server status: 2
4925 [end] server status: AUTOCOMMIT
4926 [end] warning count: 0
4927 [end] affected rows: 0
4928 [end] last insert id: 0
4929 [end] message:
4930 [CS_BINARY_REPRESENTATION]
4931 [meta] rows: 0
4932 [meta] cols: 21
4933 [meta] server status: 2
4934 [meta] server status: AUTOCOMMIT
4935 [meta] warning count: 0
4936
4937 [meta][field] db name: test1
4938 [meta][field] table name: test_inserts
4939 [meta][field] org table name: test_inserts
4940 [meta][field] col name: a
4941 [meta][field] org col name: a
4942 [meta][field] length: 10
4943 [meta][field] charsetnr: 8
4944 [meta][field] flags: 20515 (NOT_NULL PRI_KEY UNSIGNED NO_DEFAULT_VALUE PART_KEY )
4945 [meta][field] decimals: 0
4946 [meta][field] type: LONG (3)
4947
4948 [meta][field] db name: test1
4949 [meta][field] table name: test_inserts
4950 [meta][field] org table name: test_inserts
4951 [meta][field] col name: b
4952 [meta][field] org col name: b
4953 [meta][field] length: 400
4954 [meta][field] charsetnr: 255
4955 [meta][field] flags: 0
4956 [meta][field] decimals: 0
4957 [meta][field] type: VARCHAR (15)
4958
4959 [meta][field] db name: test1
4960 [meta][field] table name: test_inserts
4961 [meta][field] org table name: test_inserts
4962 [meta][field] col name: c
4963 [meta][field] org col name: c
4964 [meta][field] length: 22
4965 [meta][field] charsetnr: 8
4966 [meta][field] flags: 0
4967 [meta][field] decimals: 31
4968 [meta][field] type: DOUBLE (5)
4969
4970 [meta][field] db name: test1
4971 [meta][field] table name: test_inserts
4972 [meta][field] org table name: test_inserts
4973 [meta][field] col name: d
4974 [meta][field] org col name: d
4975 [meta][field] length: 11
4976 [meta][field] charsetnr: 8
4977 [meta][field] flags: 16392 (MULTIPLE_KEY PART_KEY )
4978 [meta][field] decimals: 0
4979 [meta][field] type: LONG (3)
4980
4981 [meta][field] db name: test1
4982 [meta][field] table name: test_inserts
4983 [meta][field] org table name: test_inserts
4984 [meta][field] col name: e
4985 [meta][field] org col name: e
4986 [meta][field] length: 12
4987 [meta][field] charsetnr: 8
4988 [meta][field] flags: 0
4989 [meta][field] decimals: 31
4990 [meta][field] type: FLOAT (4)
4991
4992 [meta][field] db name: test1
4993 [meta][field] table name: test_inserts
4994 [meta][field] org table name: test_inserts
4995 [meta][field] col name: f
4996 [meta][field] org col name: f
4997 [meta][field] length: 19
4998 [meta][field] charsetnr: 8
4999 [meta][field] flags: 128 (BINARY )
5000 [meta][field] decimals: 0
5001 [meta][field] type: DATETIME (12)
5002
5003 [meta][field] db name: test1
5004 [meta][field] table name: test_inserts
5005 [meta][field] org table name: test_inserts
5006 [meta][field] col name: g
5007 [meta][field] org col name: g
5008 [meta][field] length: 10
5009 [meta][field] charsetnr: 8
5010 [meta][field] flags: 128 (BINARY )
5011 [meta][field] decimals: 0
5012 [meta][field] type: DATE (10)
5013
5014 [meta][field] db name: test1
5015 [meta][field] table name: test_inserts
5016 [meta][field] org table name: test_inserts
5017 [meta][field] col name: h
5018 [meta][field] org col name: h
5019 [meta][field] length: 10
5020 [meta][field] charsetnr: 8
5021 [meta][field] flags: 128 (BINARY )
5022 [meta][field] decimals: 0
5023 [meta][field] type: TIME (11)
5024
5025 [meta][field] db name: test1
5026 [meta][field] table name: test_inserts
5027 [meta][field] org table name: test_inserts
5028 [meta][field] col name: i
5029 [meta][field] org col name: i
5030 [meta][field] length: 4
5031 [meta][field] charsetnr: 8
5032 [meta][field] flags: 0
5033 [meta][field] decimals: 0
5034 [meta][field] type: TINY (1)
5035
5036 [meta][field] db name: test1
5037 [meta][field] table name: test_inserts
5038 [meta][field] org table name: test_inserts
5039 [meta][field] col name: k
5040 [meta][field] org col name: k
5041 [meta][field] length: 3
5042 [meta][field] charsetnr: 8
5043 [meta][field] flags: 32 (UNSIGNED )
5044 [meta][field] decimals: 0
5045 [meta][field] type: TINY (1)
5046
5047 [meta][field] db name: test1
5048 [meta][field] table name: test_inserts
5049 [meta][field] org table name: test_inserts
5050 [meta][field] col name: l
5051 [meta][field] org col name: l
5052 [meta][field] length: 6
5053 [meta][field] charsetnr: 8
5054 [meta][field] flags: 0
5055 [meta][field] decimals: 0
5056 [meta][field] type: SHORT (2)
5057
5058 [meta][field] db name: test1
5059 [meta][field] table name: test_inserts
5060 [meta][field] org table name: test_inserts
5061 [meta][field] col name: m
5062 [meta][field] org col name: m
5063 [meta][field] length: 5
5064 [meta][field] charsetnr: 8
5065 [meta][field] flags: 32 (UNSIGNED )
5066 [meta][field] decimals: 0
5067 [meta][field] type: SHORT (2)
5068
5069 [meta][field] db name: test1
5070 [meta][field] table name: test_inserts
5071 [meta][field] org table name: test_inserts
5072 [meta][field] col name: n
5073 [meta][field] org col name: n
5074 [meta][field] length: 9
5075 [meta][field] charsetnr: 8
5076 [meta][field] flags: 0
5077 [meta][field] decimals: 0
5078 [meta][field] type: INT24 (9)
5079
5080 [meta][field] db name: test1
5081 [meta][field] table name: test_inserts
5082 [meta][field] org table name: test_inserts
5083 [meta][field] col name: o
5084 [meta][field] org col name: o
5085 [meta][field] length: 8
5086 [meta][field] charsetnr: 8
5087 [meta][field] flags: 32 (UNSIGNED )
5088 [meta][field] decimals: 0
5089 [meta][field] type: INT24 (9)
5090
5091 [meta][field] db name: test1
5092 [meta][field] table name: test_inserts
5093 [meta][field] org table name: test_inserts
5094 [meta][field] col name: p
5095 [meta][field] org col name: p
5096 [meta][field] length: 11
5097 [meta][field] charsetnr: 8
5098 [meta][field] flags: 0
5099 [meta][field] decimals: 0
5100 [meta][field] type: LONG (3)
5101
5102 [meta][field] db name: test1
5103 [meta][field] table name: test_inserts
5104 [meta][field] org table name: test_inserts
5105 [meta][field] col name: q
5106 [meta][field] org col name: q
5107 [meta][field] length: 10
5108 [meta][field] charsetnr: 8
5109 [meta][field] flags: 32 (UNSIGNED )
5110 [meta][field] decimals: 0
5111 [meta][field] type: LONG (3)
5112
5113 [meta][field] db name: test1
5114 [meta][field] table name: test_inserts
5115 [meta][field] org table name: test_inserts
5116 [meta][field] col name: r
5117 [meta][field] org col name: r
5118 [meta][field] length: 20
5119 [meta][field] charsetnr: 8
5120 [meta][field] flags: 0
5121 [meta][field] decimals: 0
5122 [meta][field] type: LONGLONG (8)
5123
5124 [meta][field] db name: test1
5125 [meta][field] table name: test_inserts
5126 [meta][field] org table name: test_inserts
5127 [meta][field] col name: s
5128 [meta][field] org col name: s
5129 [meta][field] length: 20
5130 [meta][field] charsetnr: 8
5131 [meta][field] flags: 32 (UNSIGNED )
5132 [meta][field] decimals: 0
5133 [meta][field] type: LONGLONG (8)
5134
5135 [meta][field] db name: test1
5136 [meta][field] table name: test_inserts
5137 [meta][field] org table name: test_inserts
5138 [meta][field] col name: t
5139 [meta][field] org col name: t
5140 [meta][field] length: 4
5141 [meta][field] charsetnr: 8
5142 [meta][field] flags: 96 (UNSIGNED ZEROFILL )
5143 [meta][field] decimals: 0
5144 [meta][field] type: YEAR (13)
5145
5146 [meta][field] db name: test1
5147 [meta][field] table name: test_inserts
5148 [meta][field] org table name: test_inserts
5149 [meta][field] col name: u
5150 [meta][field] org col name: u
5151 [meta][field] length: 6
5152 [meta][field] charsetnr: 8
5153 [meta][field] flags: 32 (UNSIGNED )
5154 [meta][field] decimals: 2
5155 [meta][field] type: NEWDECIMAL (246)
5156
5157 [meta][field] db name: test1
5158 [meta][field] table name: test_inserts
5159 [meta][field] org table name: test_inserts
5160 [meta][field] col name: v
5161 [meta][field] org col name: v
5162 [meta][field] length: 7
5163 [meta][field] charsetnr: 8
5164 [meta][field] flags: 0
5165 [meta][field] decimals: 2
5166 [meta][field] type: NEWDECIMAL (246)
5167
5168
5169 [meta][charset result] number: 33
5170 [meta][charset result] name: utf8mb3
5171 [meta][charset result] collation: utf8mb3_general_ci
5172 [meta][charset result] sort order:
5173
5174 [data] no rows
5175
5176 [end] server status: 2
5177 [end] server status: AUTOCOMMIT
5178 [end] warning count: 0
5179 [end] affected rows: 0
5180 [end] last insert id: 0
5181 [end] message:
5182 ------------------------------------------------------------------
5183 EXECUTING:[27][PREPARE ps1 FROM 'select 1']
5184 [CS_TEXT_REPRESENTATION]
5185 [meta] rows: 0
5186 [meta] cols: 0
5187 [meta] server status: 0
5188 [meta] server status:
5189 [meta] warning count: 0
5190
5191 [meta] no columns
5192
5193 [meta] no charset
5194
5195 [data] no rows
5196
5197 [end] server status: 2
5198 [end] server status: AUTOCOMMIT
5199 [end] warning count: 0
5200 [end] affected rows: 0
5201 [end] last insert id: 0
5202 [end] message: Statement prepared
5203 ------------------------------------------------------------------
5204 EXECUTING:[11][EXECUTE ps1]
5205 [CS_TEXT_REPRESENTATION]
5206 [meta] rows: 1
5207 [meta] cols: 1
5208 [meta] server status: 2
5209 [meta] server status: AUTOCOMMIT
5210 [meta] warning count: 0
5211
5212 [meta][field] db name:
5213 [meta][field] table name:
5214 [meta][field] org table name:
5215 [meta][field] col name: 1
5216 [meta][field] org col name:
5217 [meta][field] length: 2
5218 [meta][field] charsetnr: 8
5219 [meta][field] flags: 129 (NOT_NULL BINARY )
5220 [meta][field] decimals: 0
5221 [meta][field] type: LONGLONG (8)
5222
5223
5224 [meta][charset result] number: 33
5225 [meta][charset result] name: utf8mb3
5226 [meta][charset result] collation: utf8mb3_general_ci
5227 [meta][charset result] sort order:
5228
5229 [data][.1][ 1][1]
5230
5231 [end] server status: 2
5232 [end] server status: AUTOCOMMIT
5233 [end] warning count: 0
5234 [end] affected rows: 0
5235 [end] last insert id: 0
5236 [end] message:
5237 ------------------------------------------------------------------
5238 EXECUTING:[22][DEALLOCATE PREPARE ps1]
5239 [CS_TEXT_REPRESENTATION]
5240 [meta] rows: 0
5241 [meta] cols: 0
5242 [meta] server status: 0
5243 [meta] server status:
5244 [meta] warning count: 0
5245
5246 [meta] no columns
5247
5248 [meta] no charset
5249
5250 [data] no rows
5251
5252 [end] server status: 2
5253 [end] server status: AUTOCOMMIT
5254 [end] warning count: 0
5255 [end] affected rows: 0
5256 [end] last insert id: 0
5257 [end] message:
5258 ------------------------------------------------------------------
5259 EXECUTING:[24][CREATE TABLE tbl (a INT)]
5260 [CS_TEXT_REPRESENTATION]
5261 [meta] rows: 0
5262 [meta] cols: 0
5263 [meta] server status: 0
5264 [meta] server status:
5265 [meta] warning count: 0
5266
5267 [meta] no columns
5268
5269 [meta] no charset
5270
5271 [data] no rows
5272
5273 [end] server status: 2
5274 [end] server status: AUTOCOMMIT
5275 [end] warning count: 0
5276 [end] affected rows: 0
5277 [end] last insert id: 0
5278 [end] message:
5279 ------------------------------------------------------------------
5280 EXECUTING:[55][PREPARE ps1 FROM 'INSERT INTO tbl VALUES (1), (2), (3)']
5281 [CS_TEXT_REPRESENTATION]
5282 [meta] rows: 0
5283 [meta] cols: 0
5284 [meta] server status: 0
5285 [meta] server status:
5286 [meta] warning count: 0
5287
5288 [meta] no columns
5289
5290 [meta] no charset
5291
5292 [data] no rows
5293
5294 [end] server status: 2
5295 [end] server status: AUTOCOMMIT
5296 [end] warning count: 0
5297 [end] affected rows: 0
5298 [end] last insert id: 0
5299 [end] message: Statement prepared
5300 ------------------------------------------------------------------
5301 EXECUTING:[11][EXECUTE ps1]
5302 [CS_TEXT_REPRESENTATION]
5303 [meta] rows: 0
5304 [meta] cols: 0
5305 [meta] server status: 0
5306 [meta] server status:
5307 [meta] warning count: 0
5308
5309 [meta] no columns
5310
5311 [meta] no charset
5312
5313 [data] no rows
5314
5315 [end] server status: 2
5316 [end] server status: AUTOCOMMIT
5317 [end] warning count: 0
5318 [end] affected rows: 3
5319 [end] last insert id: 0
5320 [end] message: Records: 3 Duplicates: 0 Warnings: 0
5321 ------------------------------------------------------------------
5322 EXECUTING:[22][DEALLOCATE PREPARE ps1]
5323 [CS_TEXT_REPRESENTATION]
5324 [meta] rows: 0
5325 [meta] cols: 0
5326 [meta] server status: 0
5327 [meta] server status:
5328 [meta] warning count: 0
5329
5330 [meta] no columns
5331
5332 [meta] no charset
5333
5334 [data] no rows
5335
5336 [end] server status: 2
5337 [end] server status: AUTOCOMMIT
5338 [end] warning count: 0
5339 [end] affected rows: 0
5340 [end] last insert id: 0
5341 [end] message:
5342 ------------------------------------------------------------------
5343 EXECUTING:[46][SELECT IF(SUM(a)=6, 'OK:)', 'FAIL:(') FROM tbl]
5344 [CS_TEXT_REPRESENTATION]
5345 [meta] rows: 1
5346 [meta] cols: 1
5347 [meta] server status: 34
5348 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
5349 [meta] warning count: 0
5350
5351 [meta][field] db name:
5352 [meta][field] table name:
5353 [meta][field] org table name:
5354 [meta][field] col name: IF(SUM(a)=6, 'OK:)', 'FAIL:(')
5355 [meta][field] org col name:
5356 [meta][field] length: 18
5357 [meta][field] charsetnr: 33
5358 [meta][field] flags: 1 (NOT_NULL )
5359 [meta][field] decimals: 31
5360 [meta][field] type: VARCHAR (15)
5361
5362
5363 [meta][charset result] number: 33
5364 [meta][charset result] name: utf8mb3
5365 [meta][charset result] collation: utf8mb3_general_ci
5366 [meta][charset result] sort order:
5367
5368 [data][.IF(SUM(a)=6, 'OK:)', 'FAIL:(')][ 4][OK:)]
5369
5370 [end] server status: 34
5371 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
5372 [end] warning count: 0
5373 [end] affected rows: 0
5374 [end] last insert id: 0
5375 [end] message:
5376 ------------------------------------------------------------------
5377 EXECUTING:[22][DEALLOCATE PREPARE ps1]
5378 [CS_TEXT_REPRESENTATION]
5379 [1243][HY000][Unknown prepared statement handler (ps1) given to DEALLOCATE PREPARE] [meta] rows: 0
5380 [meta] cols: 0
5381 [meta] server status: 0
5382 [meta] server status:
5383 [meta] warning count: 0
5384
5385 [meta] no columns
5386
5387 [meta] no charset
5388
5389 [data] no rows
5390
5391 [end] server status: 0
5392 [end] server status:
5393 [end] warning count: 0
5394 [end] affected rows: 0
5395 [end] last insert id: 0
5396 [end] message:
5397 [CS_BINARY_REPRESENTATION]
5398 [1243][HY000][Unknown prepared statement handler (ps1) given to DEALLOCATE PREPARE] [meta] rows: 0
5399 [meta] cols: 0
5400 [meta] server status: 0
5401 [meta] server status:
5402 [meta] warning count: 0
5403
5404 [meta] no columns
5405
5406 [meta] no charset
5407
5408 [data] no rows
5409
5410 [end] server status: 0
5411 [end] server status:
5412 [end] warning count: 0
5413 [end] affected rows: 0
5414 [end] last insert id: 0
5415 [end] message:
5416 ------------------------------------------------------------------
5417 EXECUTING:[7][garbage]
5418 [CS_TEXT_REPRESENTATION]
5419 [1064][42000][You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1] [meta] rows: 0
5420 [meta] cols: 0
5421 [meta] server status: 0
5422 [meta] server status:
5423 [meta] warning count: 0
5424
5425 [meta] no columns
5426
5427 [meta] no charset
5428
5429 [data] no rows
5430
5431 [end] server status: 0
5432 [end] server status:
5433 [end] warning count: 0
5434 [end] affected rows: 0
5435 [end] last insert id: 0
5436 [end] message:
5437 [CS_BINARY_REPRESENTATION]
5438 [1064][42000][You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1] [meta] rows: 0
5439 [meta] cols: 0
5440 [meta] server status: 0
5441 [meta] server status:
5442 [meta] warning count: 0
5443
5444 [meta] no columns
5445
5446 [meta] no charset
5447
5448 [data] no rows
5449
5450 [end] server status: 0
5451 [end] server status:
5452 [end] warning count: 0
5453 [end] affected rows: 0
5454 [end] last insert id: 0
5455 [end] message:
5456 ------------------------------------------------------------------
5457 EXECUTING:[17][SELECT b FROM tbl]
5458 [CS_TEXT_REPRESENTATION]
5459 [1054][42S22][Unknown column 'b' in 'field list'] [meta] rows: 0
5460 [meta] cols: 0
5461 [meta] server status: 0
5462 [meta] server status:
5463 [meta] warning count: 0
5464
5465 [meta] no columns
5466
5467 [meta] no charset
5468
5469 [data] no rows
5470
5471 [end] server status: 0
5472 [end] server status:
5473 [end] warning count: 0
5474 [end] affected rows: 0
5475 [end] last insert id: 0
5476 [end] message:
5477 [CS_BINARY_REPRESENTATION]
5478 [1054][42S22][Unknown column 'b' in 'field list'] [meta] rows: 0
5479 [meta] cols: 0
5480 [meta] server status: 0
5481 [meta] server status:
5482 [meta] warning count: 0
5483
5484 [meta] no columns
5485
5486 [meta] no charset
5487
5488 [data] no rows
5489
5490 [end] server status: 0
5491 [end] server status:
5492 [end] warning count: 0
5493 [end] affected rows: 0
5494 [end] last insert id: 0
5495 [end] message:
5496 ------------------------------------------------------------------
5497 EXECUTING:[43][ALTER USER bogus@remotehost PASSWORD EXPIRE]
5498 [CS_TEXT_REPRESENTATION]
5499 [1396][HY000][Operation ALTER USER failed for 'bogus'@'remotehost'] [meta] rows: 0
5500 [meta] cols: 0
5501 [meta] server status: 0
5502 [meta] server status:
5503 [meta] warning count: 0
5504
5505 [meta] no columns
5506
5507 [meta] no charset
5508
5509 [data] no rows
5510
5511 [end] server status: 0
5512 [end] server status:
5513 [end] warning count: 0
5514 [end] affected rows: 0
5515 [end] last insert id: 0
5516 [end] message:
5517 [CS_BINARY_REPRESENTATION]
5518 [1396][HY000][Operation ALTER USER failed for 'bogus'@'remotehost'] [meta] rows: 0
5519 [meta] cols: 0
5520 [meta] server status: 0
5521 [meta] server status:
5522 [meta] warning count: 0
5523
5524 [meta] no columns
5525
5526 [meta] no charset
5527
5528 [data] no rows
5529
5530 [end] server status: 0
5531 [end] server status:
5532 [end] warning count: 0
5533 [end] affected rows: 0
5534 [end] last insert id: 0
5535 [end] message:
5536 ------------------------------------------------------------------
5537 EXECUTING:[26][CREATE TABLE tbld (d TIME)]
5538 [CS_TEXT_REPRESENTATION]
5539 [meta] rows: 0
5540 [meta] cols: 0
5541 [meta] server status: 0
5542 [meta] server status:
5543 [meta] warning count: 0
5544
5545 [meta] no columns
5546
5547 [meta] no charset
5548
5549 [data] no rows
5550
5551 [end] server status: 2
5552 [end] server status: AUTOCOMMIT
5553 [end] warning count: 0
5554 [end] affected rows: 0
5555 [end] last insert id: 0
5556 [end] message:
5557 ------------------------------------------------------------------
5558 EXECUTING:[36][INSERT INTO tbld VALUES ('43141231')]
5559 [CS_TEXT_REPRESENTATION]
5560 [1292][22007][Incorrect time value: '43141231' for column 'd' at row 1] [meta] rows: 0
5561 [meta] cols: 0
5562 [meta] server status: 0
5563 [meta] server status:
5564 [meta] warning count: 0
5565
5566 [meta] no columns
5567
5568 [meta] no charset
5569
5570 [data] no rows
5571
5572 [end] server status: 0
5573 [end] server status:
5574 [end] warning count: 0
5575 [end] affected rows: 0
5576 [end] last insert id: 0
5577 [end] message:
5578 [CS_BINARY_REPRESENTATION]
5579 [1292][22007][Incorrect time value: '43141231' for column 'd' at row 1] [meta] rows: 0
5580 [meta] cols: 0
5581 [meta] server status: 0
5582 [meta] server status:
5583 [meta] warning count: 0
5584
5585 [meta] no columns
5586
5587 [meta] no charset
5588
5589 [data] no rows
5590
5591 [end] server status: 0
5592 [end] server status:
5593 [end] warning count: 0
5594 [end] affected rows: 0
5595 [end] last insert id: 0
5596 [end] message:
5597 ------------------------------------------------------------------
5598 EXECUTING:[10][SELECT 1/0]
5599 [CS_TEXT_REPRESENTATION]
5600 [meta] rows: 1
5601 [meta] cols: 1
5602 [meta] server status: 2
5603 [meta] server status: AUTOCOMMIT
5604 [meta] warning count: 0
5605
5606 [meta][field] db name:
5607 [meta][field] table name:
5608 [meta][field] org table name:
5609 [meta][field] col name: 1/0
5610 [meta][field] org col name:
5611 [meta][field] length: 7
5612 [meta][field] charsetnr: 8
5613 [meta][field] flags: 128 (BINARY )
5614 [meta][field] decimals: 4
5615 [meta][field] type: NEWDECIMAL (246)
5616
5617
5618 [meta][charset result] number: 33
5619 [meta][charset result] name: utf8mb3
5620 [meta][charset result] collation: utf8mb3_general_ci
5621 [meta][charset result] sort order:
5622
5623 [data][.1/0][ 6][[NULL]]
5624
5625 [end] server status: 2
5626 [end] server status: AUTOCOMMIT
5627 [end] warning count: 1
5628 [end] affected rows: 0
5629 [end] last insert id: 0
5630 [end] message:
5631 ------------------------------------------------------------------
5632 EXECUTING:[18][UPDATE tbl SET a=5]
5633 [CS_TEXT_REPRESENTATION]
5634 [meta] rows: 0
5635 [meta] cols: 0
5636 [meta] server status: 0
5637 [meta] server status:
5638 [meta] warning count: 0
5639
5640 [meta] no columns
5641
5642 [meta] no charset
5643
5644 [data] no rows
5645
5646 [end] server status: 34
5647 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
5648 [end] warning count: 0
5649 [end] affected rows: 3
5650 [end] last insert id: 0
5651 [end] message: Rows matched: 3 Changed: 3 Warnings: 0
5652 ------------------------------------------------------------------
5653 EXECUTING:[17][START TRANSACTION]
5654 [CS_TEXT_REPRESENTATION]
5655 [meta] rows: 0
5656 [meta] cols: 0
5657 [meta] server status: 0
5658 [meta] server status:
5659 [meta] warning count: 0
5660
5661 [meta] no columns
5662
5663 [meta] no charset
5664
5665 [data] no rows
5666
5667 [end] server status: 3
5668 [end] server status: IN_TRANS AUTOCOMMIT
5669 [end] warning count: 0
5670 [end] affected rows: 0
5671 [end] last insert id: 0
5672 [end] message:
5673 ------------------------------------------------------------------
5674 EXECUTING:[18][UPDATE tbl SET a=4]
5675 [CS_TEXT_REPRESENTATION]
5676 [meta] rows: 0
5677 [meta] cols: 0
5678 [meta] server status: 0
5679 [meta] server status:
5680 [meta] warning count: 0
5681
5682 [meta] no columns
5683
5684 [meta] no charset
5685
5686 [data] no rows
5687
5688 [end] server status: 35
5689 [end] server status: IN_TRANS AUTOCOMMIT QUERY_NO_INDEX_USED
5690 [end] warning count: 0
5691 [end] affected rows: 3
5692 [end] last insert id: 0
5693 [end] message: Rows matched: 3 Changed: 3 Warnings: 0
5694 ------------------------------------------------------------------
5695 EXECUTING:[8][ROLLBACK]
5696 [CS_TEXT_REPRESENTATION]
5697 [meta] rows: 0
5698 [meta] cols: 0
5699 [meta] server status: 0
5700 [meta] server status:
5701 [meta] warning count: 0
5702
5703 [meta] no columns
5704
5705 [meta] no charset
5706
5707 [data] no rows
5708
5709 [end] server status: 2
5710 [end] server status: AUTOCOMMIT
5711 [end] warning count: 0
5712 [end] affected rows: 0
5713 [end] last insert id: 0
5714 [end] message:
5715 ------------------------------------------------------------------
5716 EXECUTING:[45][SELECT IF(SUM(a) = 15, 'OK', 'FAIL') FROM tbl]
5717 [CS_TEXT_REPRESENTATION]
5718 [meta] rows: 1
5719 [meta] cols: 1
5720 [meta] server status: 34
5721 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
5722 [meta] warning count: 0
5723
5724 [meta][field] db name:
5725 [meta][field] table name:
5726 [meta][field] org table name:
5727 [meta][field] col name: IF(SUM(a) = 15, 'OK', 'FAIL')
5728 [meta][field] org col name:
5729 [meta][field] length: 12
5730 [meta][field] charsetnr: 33
5731 [meta][field] flags: 1 (NOT_NULL )
5732 [meta][field] decimals: 31
5733 [meta][field] type: VARCHAR (15)
5734
5735
5736 [meta][charset result] number: 33
5737 [meta][charset result] name: utf8mb3
5738 [meta][charset result] collation: utf8mb3_general_ci
5739 [meta][charset result] sort order:
5740
5741 [data][.IF(SUM(a) = 15, 'OK', 'FAIL')][ 2][OK]
5742
5743 [end] server status: 34
5744 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
5745 [end] warning count: 0
5746 [end] affected rows: 0
5747 [end] last insert id: 0
5748 [end] message:
5749 ------------------------------------------------------------------
5750 EXECUTING:[17][START TRANSACTION]
5751 [CS_TEXT_REPRESENTATION]
5752 [meta] rows: 0
5753 [meta] cols: 0
5754 [meta] server status: 0
5755 [meta] server status:
5756 [meta] warning count: 0
5757
5758 [meta] no columns
5759
5760 [meta] no charset
5761
5762 [data] no rows
5763
5764 [end] server status: 3
5765 [end] server status: IN_TRANS AUTOCOMMIT
5766 [end] warning count: 0
5767 [end] affected rows: 0
5768 [end] last insert id: 0
5769 [end] message:
5770 ------------------------------------------------------------------
5771 EXECUTING:[18][UPDATE tbl SET a=4]
5772 [CS_TEXT_REPRESENTATION]
5773 [meta] rows: 0
5774 [meta] cols: 0
5775 [meta] server status: 0
5776 [meta] server status:
5777 [meta] warning count: 0
5778
5779 [meta] no columns
5780
5781 [meta] no charset
5782
5783 [data] no rows
5784
5785 [end] server status: 35
5786 [end] server status: IN_TRANS AUTOCOMMIT QUERY_NO_INDEX_USED
5787 [end] warning count: 0
5788 [end] affected rows: 3
5789 [end] last insert id: 0
5790 [end] message: Rows matched: 3 Changed: 3 Warnings: 0
5791 ------------------------------------------------------------------
5792 EXECUTING:[6][COMMIT]
5793 [CS_TEXT_REPRESENTATION]
5794 [meta] rows: 0
5795 [meta] cols: 0
5796 [meta] server status: 0
5797 [meta] server status:
5798 [meta] warning count: 0
5799
5800 [meta] no columns
5801
5802 [meta] no charset
5803
5804 [data] no rows
5805
5806 [end] server status: 2
5807 [end] server status: AUTOCOMMIT
5808 [end] warning count: 0
5809 [end] affected rows: 0
5810 [end] last insert id: 0
5811 [end] message:
5812 ------------------------------------------------------------------
5813 EXECUTING:[45][SELECT IF(SUM(a) = 12, 'OK', 'FAIL') FROM tbl]
5814 [CS_TEXT_REPRESENTATION]
5815 [meta] rows: 1
5816 [meta] cols: 1
5817 [meta] server status: 34
5818 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
5819 [meta] warning count: 0
5820
5821 [meta][field] db name:
5822 [meta][field] table name:
5823 [meta][field] org table name:
5824 [meta][field] col name: IF(SUM(a) = 12, 'OK', 'FAIL')
5825 [meta][field] org col name:
5826 [meta][field] length: 12
5827 [meta][field] charsetnr: 33
5828 [meta][field] flags: 1 (NOT_NULL )
5829 [meta][field] decimals: 31
5830 [meta][field] type: VARCHAR (15)
5831
5832
5833 [meta][charset result] number: 33
5834 [meta][charset result] name: utf8mb3
5835 [meta][charset result] collation: utf8mb3_general_ci
5836 [meta][charset result] sort order:
5837
5838 [data][.IF(SUM(a) = 12, 'OK', 'FAIL')][ 2][OK]
5839
5840 [end] server status: 34
5841 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
5842 [end] warning count: 0
5843 [end] affected rows: 0
5844 [end] last insert id: 0
5845 [end] message:
5846 ------------------------------------------------------------------
5847 EXECUTING:[27][START TRANSACTION READ ONLY]
5848 [CS_TEXT_REPRESENTATION]
5849 [meta] rows: 0
5850 [meta] cols: 0
5851 [meta] server status: 0
5852 [meta] server status:
5853 [meta] warning count: 0
5854
5855 [meta] no columns
5856
5857 [meta] no charset
5858
5859 [data] no rows
5860
5861 [end] server status: 8195
5862 [end] server status: IN_TRANS AUTOCOMMIT IN_TRANS_READONLY
5863 [end] warning count: 0
5864 [end] affected rows: 0
5865 [end] last insert id: 0
5866 [end] message:
5867 ------------------------------------------------------------------
5868 EXECUTING:[18][UPDATE tbl SET a=2]
5869 [CS_TEXT_REPRESENTATION]
5870 [1792][25006][Cannot execute statement in a READ ONLY transaction.] [meta] rows: 0
5871 [meta] cols: 0
5872 [meta] server status: 0
5873 [meta] server status:
5874 [meta] warning count: 0
5875
5876 [meta] no columns
5877
5878 [meta] no charset
5879
5880 [data] no rows
5881
5882 [end] server status: 0
5883 [end] server status:
5884 [end] warning count: 0
5885 [end] affected rows: 0
5886 [end] last insert id: 0
5887 [end] message:
5888 ------------------------------------------------------------------
5889 EXECUTING:[6][COMMIT]
5890 [CS_TEXT_REPRESENTATION]
5891 [meta] rows: 0
5892 [meta] cols: 0
5893 [meta] server status: 0
5894 [meta] server status:
5895 [meta] warning count: 0
5896
5897 [meta] no columns
5898
5899 [meta] no charset
5900
5901 [data] no rows
5902
5903 [end] server status: 2
5904 [end] server status: AUTOCOMMIT
5905 [end] warning count: 0
5906 [end] affected rows: 0
5907 [end] last insert id: 0
5908 [end] message:
5909 ------------------------------------------------------------------
5910 EXECUTING:[45][SELECT IF(SUM(4) = 12, 'OK', 'FAIL') FROM tbl]
5911 [CS_TEXT_REPRESENTATION]
5912 [meta] rows: 1
5913 [meta] cols: 1
5914 [meta] server status: 34
5915 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
5916 [meta] warning count: 0
5917
5918 [meta][field] db name:
5919 [meta][field] table name:
5920 [meta][field] org table name:
5921 [meta][field] col name: IF(SUM(4) = 12, 'OK', 'FAIL')
5922 [meta][field] org col name:
5923 [meta][field] length: 12
5924 [meta][field] charsetnr: 33
5925 [meta][field] flags: 1 (NOT_NULL )
5926 [meta][field] decimals: 31
5927 [meta][field] type: VARCHAR (15)
5928
5929
5930 [meta][charset result] number: 33
5931 [meta][charset result] name: utf8mb3
5932 [meta][charset result] collation: utf8mb3_general_ci
5933 [meta][charset result] sort order:
5934
5935 [data][.IF(SUM(4) = 12, 'OK', 'FAIL')][ 2][OK]
5936
5937 [end] server status: 34
5938 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
5939 [end] warning count: 0
5940 [end] affected rows: 0
5941 [end] last insert id: 0
5942 [end] message:
5943 ------------------------------------------------------------------
5944 EXECUTING:[16][SET autocommit=0]
5945 [CS_TEXT_REPRESENTATION]
5946 [meta] rows: 0
5947 [meta] cols: 0
5948 [meta] server status: 0
5949 [meta] server status:
5950 [meta] warning count: 0
5951
5952 [meta] no columns
5953
5954 [meta] no charset
5955
5956 [data] no rows
5957
5958 [end] server status: 0
5959 [end] server status:
5960 [end] warning count: 0
5961 [end] affected rows: 0
5962 [end] last insert id: 0
5963 [end] message:
5964 ------------------------------------------------------------------
5965 EXECUTING:[18][UPDATE tbl SET a=2]
5966 [CS_TEXT_REPRESENTATION]
5967 [meta] rows: 0
5968 [meta] cols: 0
5969 [meta] server status: 0
5970 [meta] server status:
5971 [meta] warning count: 0
5972
5973 [meta] no columns
5974
5975 [meta] no charset
5976
5977 [data] no rows
5978
5979 [end] server status: 33
5980 [end] server status: IN_TRANS QUERY_NO_INDEX_USED
5981 [end] warning count: 0
5982 [end] affected rows: 3
5983 [end] last insert id: 0
5984 [end] message: Rows matched: 3 Changed: 3 Warnings: 0
5985 ------------------------------------------------------------------
5986 EXECUTING:[8][ROLLBACK]
5987 [CS_TEXT_REPRESENTATION]
5988 [meta] rows: 0
5989 [meta] cols: 0
5990 [meta] server status: 0
5991 [meta] server status:
5992 [meta] warning count: 0
5993
5994 [meta] no columns
5995
5996 [meta] no charset
5997
5998 [data] no rows
5999
6000 [end] server status: 0
6001 [end] server status:
6002 [end] warning count: 0
6003 [end] affected rows: 0
6004 [end] last insert id: 0
6005 [end] message:
6006 ------------------------------------------------------------------
6007 EXECUTING:[45][SELECT IF(SUM(4) = 12, 'OK', 'FAIL') FROM tbl]
6008 [CS_TEXT_REPRESENTATION]
6009 [meta] rows: 1
6010 [meta] cols: 1
6011 [meta] server status: 33
6012 [meta] server status: IN_TRANS QUERY_NO_INDEX_USED
6013 [meta] warning count: 0
6014
6015 [meta][field] db name:
6016 [meta][field] table name:
6017 [meta][field] org table name:
6018 [meta][field] col name: IF(SUM(4) = 12, 'OK', 'FAIL')
6019 [meta][field] org col name:
6020 [meta][field] length: 12
6021 [meta][field] charsetnr: 33
6022 [meta][field] flags: 1 (NOT_NULL )
6023 [meta][field] decimals: 31
6024 [meta][field] type: VARCHAR (15)
6025
6026
6027 [meta][charset result] number: 33
6028 [meta][charset result] name: utf8mb3
6029 [meta][charset result] collation: utf8mb3_general_ci
6030 [meta][charset result] sort order:
6031
6032 [data][.IF(SUM(4) = 12, 'OK', 'FAIL')][ 2][OK]
6033
6034 [end] server status: 33
6035 [end] server status: IN_TRANS QUERY_NO_INDEX_USED
6036 [end] warning count: 0
6037 [end] affected rows: 0
6038 [end] last insert id: 0
6039 [end] message:
6040 ------------------------------------------------------------------
6041 EXECUTING:[35][set @a=((2) in (select a from tbl))]
6042 [CS_TEXT_REPRESENTATION]
6043 [meta] rows: 0
6044 [meta] cols: 0
6045 [meta] server status: 0
6046 [meta] server status:
6047 [meta] warning count: 0
6048
6049 [meta] no columns
6050
6051 [meta] no charset
6052
6053 [data] no rows
6054
6055 [end] server status: 33
6056 [end] server status: IN_TRANS QUERY_NO_INDEX_USED
6057 [end] warning count: 0
6058 [end] affected rows: 0
6059 [end] last insert id: 0
6060 [end] message:
6061 [CS_BINARY_REPRESENTATION]
6062 [meta] rows: 0
6063 [meta] cols: 0
6064 [meta] server status: 0
6065 [meta] server status:
6066 [meta] warning count: 0
6067
6068 [meta] no columns
6069
6070 [meta] no charset
6071
6072 [data] no rows
6073
6074 [end] server status: 33
6075 [end] server status: IN_TRANS QUERY_NO_INDEX_USED
6076 [end] warning count: 0
6077 [end] affected rows: 0
6078 [end] last insert id: 0
6079 [end] message:
6080 ------------------------------------------------------------------
6081 EXECUTING:[9][SELECT @a]
6082 [CS_TEXT_REPRESENTATION]
6083 [meta] rows: 1
6084 [meta] cols: 1
6085 [meta] server status: 1
6086 [meta] server status: IN_TRANS
6087 [meta] warning count: 0
6088
6089 [meta][field] db name:
6090 [meta][field] table name:
6091 [meta][field] org table name:
6092 [meta][field] col name: @a
6093 [meta][field] org col name:
6094 [meta][field] length: 21
6095 [meta][field] charsetnr: 33
6096 [meta][field] flags: 128 (BINARY )
6097 [meta][field] decimals: 0
6098 [meta][field] type: LONGLONG (8)
6099
6100
6101 [meta][charset result] number: 33
6102 [meta][charset result] name: utf8mb3
6103 [meta][charset result] collation: utf8mb3_general_ci
6104 [meta][charset result] sort order:
6105
6106 [data][.@a][ 1][0]
6107
6108 [end] server status: 1
6109 [end] server status: IN_TRANS
6110 [end] warning count: 0
6111 [end] affected rows: 0
6112 [end] last insert id: 0
6113 [end] message:
6114 [CS_BINARY_REPRESENTATION]
6115 [meta] rows: 1
6116 [meta] cols: 1
6117 [meta] server status: 1
6118 [meta] server status: IN_TRANS
6119 [meta] warning count: 0
6120
6121 [meta][field] db name:
6122 [meta][field] table name:
6123 [meta][field] org table name:
6124 [meta][field] col name: @a
6125 [meta][field] org col name:
6126 [meta][field] length: 21
6127 [meta][field] charsetnr: 33
6128 [meta][field] flags: 128 (BINARY )
6129 [meta][field] decimals: 0
6130 [meta][field] type: LONGLONG (8)
6131
6132
6133 [meta][charset result] number: 33
6134 [meta][charset result] name: utf8mb3
6135 [meta][charset result] collation: utf8mb3_general_ci
6136 [meta][charset result] sort order:
6137
6138 [data][.@a][ 1][0]
6139
6140 [end] server status: 1
6141 [end] server status: IN_TRANS
6142 [end] warning count: 0
6143 [end] affected rows: 0
6144 [end] last insert id: 0
6145 [end] message:
6146 ------------------------------------------------------------------
6147 EXECUTING:[9][set @b=42]
6148 [CS_TEXT_REPRESENTATION]
6149 [meta] rows: 0
6150 [meta] cols: 0
6151 [meta] server status: 0
6152 [meta] server status:
6153 [meta] warning count: 0
6154
6155 [meta] no columns
6156
6157 [meta] no charset
6158
6159 [data] no rows
6160
6161 [end] server status: 1
6162 [end] server status: IN_TRANS
6163 [end] warning count: 0
6164 [end] affected rows: 0
6165 [end] last insert id: 0
6166 [end] message:
6167 [CS_BINARY_REPRESENTATION]
6168 [meta] rows: 0
6169 [meta] cols: 0
6170 [meta] server status: 0
6171 [meta] server status:
6172 [meta] warning count: 0
6173
6174 [meta] no columns
6175
6176 [meta] no charset
6177
6178 [data] no rows
6179
6180 [end] server status: 1
6181 [end] server status: IN_TRANS
6182 [end] warning count: 0
6183 [end] affected rows: 0
6184 [end] last insert id: 0
6185 [end] message:
6186 ------------------------------------------------------------------
6187 EXECUTING:[9][SELECT @b]
6188 [CS_TEXT_REPRESENTATION]
6189 [meta] rows: 1
6190 [meta] cols: 1
6191 [meta] server status: 1
6192 [meta] server status: IN_TRANS
6193 [meta] warning count: 0
6194
6195 [meta][field] db name:
6196 [meta][field] table name:
6197 [meta][field] org table name:
6198 [meta][field] col name: @b
6199 [meta][field] org col name:
6200 [meta][field] length: 21
6201 [meta][field] charsetnr: 33
6202 [meta][field] flags: 128 (BINARY )
6203 [meta][field] decimals: 0
6204 [meta][field] type: LONGLONG (8)
6205
6206
6207 [meta][charset result] number: 33
6208 [meta][charset result] name: utf8mb3
6209 [meta][charset result] collation: utf8mb3_general_ci
6210 [meta][charset result] sort order:
6211
6212 [data][.@b][ 2][42]
6213
6214 [end] server status: 1
6215 [end] server status: IN_TRANS
6216 [end] warning count: 0
6217 [end] affected rows: 0
6218 [end] last insert id: 0
6219 [end] message:
6220 [CS_BINARY_REPRESENTATION]
6221 [meta] rows: 1
6222 [meta] cols: 1
6223 [meta] server status: 1
6224 [meta] server status: IN_TRANS
6225 [meta] warning count: 0
6226
6227 [meta][field] db name:
6228 [meta][field] table name:
6229 [meta][field] org table name:
6230 [meta][field] col name: @b
6231 [meta][field] org col name:
6232 [meta][field] length: 21
6233 [meta][field] charsetnr: 33
6234 [meta][field] flags: 128 (BINARY )
6235 [meta][field] decimals: 0
6236 [meta][field] type: LONGLONG (8)
6237
6238
6239 [meta][charset result] number: 33
6240 [meta][charset result] name: utf8mb3
6241 [meta][charset result] collation: utf8mb3_general_ci
6242 [meta][charset result] sort order:
6243
6244 [data][.@b][ 2][42]
6245
6246 [end] server status: 1
6247 [end] server status: IN_TRANS
6248 [end] warning count: 0
6249 [end] affected rows: 0
6250 [end] last insert id: 0
6251 [end] message:
6252 ------------------------------------------------------------------
6253 EXECUTING:[20][SELECT @non_existing]
6254 [CS_TEXT_REPRESENTATION]
6255 [meta] rows: 1
6256 [meta] cols: 1
6257 [meta] server status: 1
6258 [meta] server status: IN_TRANS
6259 [meta] warning count: 0
6260
6261 [meta][field] db name:
6262 [meta][field] table name:
6263 [meta][field] org table name:
6264 [meta][field] col name: @non_existing
6265 [meta][field] org col name:
6266 [meta][field] length: 65535
6267 [meta][field] charsetnr: 33
6268 [meta][field] flags: 128 (BINARY )
6269 [meta][field] decimals: 31
6270 [meta][field] type: VARCHAR (15)
6271
6272
6273 [meta][charset result] number: 33
6274 [meta][charset result] name: utf8mb3
6275 [meta][charset result] collation: utf8mb3_general_ci
6276 [meta][charset result] sort order:
6277
6278 [data][.@non_existing][ 6][[NULL]]
6279
6280 [end] server status: 1
6281 [end] server status: IN_TRANS
6282 [end] warning count: 0
6283 [end] affected rows: 0
6284 [end] last insert id: 0
6285 [end] message:
6286 [CS_BINARY_REPRESENTATION]
6287 [meta] rows: 1
6288 [meta] cols: 1
6289 [meta] server status: 1
6290 [meta] server status: IN_TRANS
6291 [meta] warning count: 0
6292
6293 [meta][field] db name:
6294 [meta][field] table name:
6295 [meta][field] org table name:
6296 [meta][field] col name: @non_existing
6297 [meta][field] org col name:
6298 [meta][field] length: 65535
6299 [meta][field] charsetnr: 33
6300 [meta][field] flags: 128 (BINARY )
6301 [meta][field] decimals: 31
6302 [meta][field] type: VARCHAR (15)
6303
6304
6305 [meta][charset result] number: 33
6306 [meta][charset result] name: utf8mb3
6307 [meta][charset result] collation: utf8mb3_general_ci
6308 [meta][charset result] sort order:
6309
6310 [data][.@non_existing][ 6][[NULL]]
6311
6312 [end] server status: 1
6313 [end] server status: IN_TRANS
6314 [end] warning count: 0
6315 [end] affected rows: 0
6316 [end] last insert id: 0
6317 [end] message:
6318 ------------------------------------------------------------------
6319 EXECUTING:[0][]
6320 [CS_TEXT_REPRESENTATION]
6321 [1065][42000][Query was empty] [meta] rows: 0
6322 [meta] cols: 0
6323 [meta] server status: 0
6324 [meta] server status:
6325 [meta] warning count: 0
6326
6327 [meta] no columns
6328
6329 [meta] no charset
6330
6331 [data] no rows
6332
6333 [end] server status: 0
6334 [end] server status:
6335 [end] warning count: 0
6336 [end] affected rows: 0
6337 [end] last insert id: 0
6338 [end] message:
6339 [CS_BINARY_REPRESENTATION]
6340 [1065][42000][Query was empty] [meta] rows: 0
6341 [meta] cols: 0
6342 [meta] server status: 0
6343 [meta] server status:
6344 [meta] warning count: 0
6345
6346 [meta] no columns
6347
6348 [meta] no charset
6349
6350 [data] no rows
6351
6352 [end] server status: 0
6353 [end] server status:
6354 [end] warning count: 0
6355 [end] affected rows: 0
6356 [end] last insert id: 0
6357 [end] message:
6358 ------------------------------------------------------------------
6359 EXECUTING:[14][DROP TABLE tbl]
6360 [CS_TEXT_REPRESENTATION]
6361 [meta] rows: 0
6362 [meta] cols: 0
6363 [meta] server status: 0
6364 [meta] server status:
6365 [meta] warning count: 0
6366
6367 [meta] no columns
6368
6369 [meta] no charset
6370
6371 [data] no rows
6372
6373 [end] server status: 0
6374 [end] server status:
6375 [end] warning count: 0
6376 [end] affected rows: 0
6377 [end] last insert id: 0
6378 [end] message:
6379 ------------------------------------------------------------------
6380 EXECUTING:[15][DROP TABLE tbld]
6381 [CS_TEXT_REPRESENTATION]
6382 [meta] rows: 0
6383 [meta] cols: 0
6384 [meta] server status: 0
6385 [meta] server status:
6386 [meta] warning count: 0
6387
6388 [meta] no columns
6389
6390 [meta] no charset
6391
6392 [data] no rows
6393
6394 [end] server status: 0
6395 [end] server status:
6396 [end] warning count: 0
6397 [end] affected rows: 0
6398 [end] last insert id: 0
6399 [end] message:
6400 ------------------------------------------------------------------
6401 EXECUTING:[19][DROP DATABASE test1]
6402 [CS_TEXT_REPRESENTATION]
6403 [meta] rows: 0
6404 [meta] cols: 0
6405 [meta] server status: 0
6406 [meta] server status:
6407 [meta] warning count: 0
6408
6409 [meta] no columns
6410
6411 [meta] no charset
6412
6413 [data] no rows
6414
6415 [end] server status: 256
6416 [end] server status: DB_DROPPED
6417 [end] warning count: 0
6418 [end] affected rows: 1
6419 [end] last insert id: 0
6420 [end] message:
6421 ------------------------------------------------------------------
6422 [srv_session_close]
6423 deinit thread
6424 ------ cleanup ---------------------------------------------------