1------ Run plugin ------------------------------------------------ 2INSTALL PLUGIN test_sql_complex SONAME 'TEST_SQL_COMPLEX'; 3------ Stop plugin ----------------------------------------------- 4UNINSTALL PLUGIN test_sql_complex; 5------ plugin log ------------------------------------------------ 6======================================================================== 7Test in a server thread 8[srv_session_open] 9------------------------------------------------------------------ 10EXECUTING:[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: utf8 32 [meta][charset result] collation: utf8_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: utf8 64 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 76EXECUTING:[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------------------------------------------------------------------ 97EXECUTING:[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------------------------------------------------------------------ 118EXECUTING:[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------------------------------------------------------------------ 139EXECUTING:[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------------------------------------------------------------------ 160EXECUTING:[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------------------------------------------------------------------ 181EXECUTING:[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------------------------------------------------------------------ 202EXECUTING:[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: utf8 444 [meta][charset result] collation: utf8_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: utf8 760 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 836EXECUTING:[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------------------------------------------------------------------ 857EXECUTING:[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: utf8 1099 [meta][charset result] collation: utf8_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: utf8 1393 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 1447EXECUTING:[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------------------------------------------------------------------ 1468EXECUTING:[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: utf8 1710 [meta][charset result] collation: utf8_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: utf8 1962 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 1974EXECUTING:[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------------------------------------------------------------------ 1995EXECUTING:[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: 1 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: utf8 2017 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 2029EXECUTING:[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------------------------------------------------------------------ 2050EXECUTING:[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------------------------------------------------------------------ 2071EXECUTING:[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------------------------------------------------------------------ 2092EXECUTING:[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------------------------------------------------------------------ 2113EXECUTING:[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------------------------------------------------------------------ 2134EXECUTING:[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: utf8 2156 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 2168EXECUTING:[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------------------------------------------------------------------ 2208EXECUTING:[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------------------------------------------------------------------ 2248EXECUTING:[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------------------------------------------------------------------ 2288EXECUTING:[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------------------------------------------------------------------ 2328EXECUTING:[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------------------------------------------------------------------ 2349EXECUTING:[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------------------------------------------------------------------ 2389EXECUTING:[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: utf8 2411 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 2423EXECUTING:[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------------------------------------------------------------------ 2444EXECUTING:[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------------------------------------------------------------------ 2465EXECUTING:[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------------------------------------------------------------------ 2486EXECUTING:[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------------------------------------------------------------------ 2507EXECUTING:[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: utf8 2529 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 2541EXECUTING:[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------------------------------------------------------------------ 2562EXECUTING:[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------------------------------------------------------------------ 2583EXECUTING:[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------------------------------------------------------------------ 2604EXECUTING:[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: utf8 2626 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 2638EXECUTING:[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------------------------------------------------------------------ 2659EXECUTING:[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------------------------------------------------------------------ 2680EXECUTING:[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------------------------------------------------------------------ 2701EXECUTING:[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: utf8 2723 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 2735EXECUTING:[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------------------------------------------------------------------ 2756EXECUTING:[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------------------------------------------------------------------ 2777EXECUTING:[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------------------------------------------------------------------ 2798EXECUTING:[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: utf8 2820 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 2832EXECUTING:[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------------------------------------------------------------------ 2872EXECUTING:[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: 20 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: utf8 2894 [meta][charset result] collation: utf8_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: 20 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: utf8 2926 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 2938EXECUTING:[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------------------------------------------------------------------ 2978EXECUTING:[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: 20 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: utf8 3000 [meta][charset result] collation: utf8_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: 20 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: utf8 3032 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 3044EXECUTING:[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: 16777216 3058 [meta][field] charsetnr: 63 3059 [meta][field] flags: 128 (BINARY ) 3060 [meta][field] decimals: 31 3061 [meta][field] type: LONG_BLOB (251) 3062 3063 3064 [meta][charset result] number: 33 3065 [meta][charset result] name: utf8 3066 [meta][charset result] collation: utf8_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: 16777216 3090 [meta][field] charsetnr: 63 3091 [meta][field] flags: 128 (BINARY ) 3092 [meta][field] decimals: 31 3093 [meta][field] type: LONG_BLOB (251) 3094 3095 3096 [meta][charset result] number: 33 3097 [meta][charset result] name: utf8 3098 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 3110EXECUTING:[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------------------------------------------------------------------ 3150EXECUTING:[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------------------------------------------------------------------ 3171EXECUTING:[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------------------------------------------------------------------ 3192EXECUTING:[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] 3214Follows threaded run 3215======================================================================== 3216init thread 3217[srv_session_open] 3218------------------------------------------------------------------ 3219EXECUTING:[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: utf8 3241 [meta][charset result] collation: utf8_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: utf8 3273 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 3285EXECUTING:[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------------------------------------------------------------------ 3306EXECUTING:[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------------------------------------------------------------------ 3327EXECUTING:[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------------------------------------------------------------------ 3348EXECUTING:[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------------------------------------------------------------------ 3369EXECUTING:[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------------------------------------------------------------------ 3390EXECUTING:[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------------------------------------------------------------------ 3411EXECUTING:[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: utf8 3653 [meta][charset result] collation: utf8_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: utf8 3969 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 4045EXECUTING:[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------------------------------------------------------------------ 4066EXECUTING:[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: utf8 4308 [meta][charset result] collation: utf8_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: utf8 4602 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 4656EXECUTING:[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------------------------------------------------------------------ 4677EXECUTING:[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: utf8 4919 [meta][charset result] collation: utf8_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: utf8 5171 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 5183EXECUTING:[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------------------------------------------------------------------ 5204EXECUTING:[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: 1 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: utf8 5226 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 5238EXECUTING:[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------------------------------------------------------------------ 5259EXECUTING:[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------------------------------------------------------------------ 5280EXECUTING:[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------------------------------------------------------------------ 5301EXECUTING:[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------------------------------------------------------------------ 5322EXECUTING:[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------------------------------------------------------------------ 5343EXECUTING:[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: utf8 5365 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 5377EXECUTING:[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------------------------------------------------------------------ 5417EXECUTING:[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------------------------------------------------------------------ 5457EXECUTING:[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------------------------------------------------------------------ 5497EXECUTING:[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------------------------------------------------------------------ 5537EXECUTING:[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------------------------------------------------------------------ 5558EXECUTING:[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------------------------------------------------------------------ 5598EXECUTING:[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: utf8 5620 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 5632EXECUTING:[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------------------------------------------------------------------ 5653EXECUTING:[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------------------------------------------------------------------ 5674EXECUTING:[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------------------------------------------------------------------ 5695EXECUTING:[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------------------------------------------------------------------ 5716EXECUTING:[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: utf8 5738 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 5750EXECUTING:[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------------------------------------------------------------------ 5771EXECUTING:[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------------------------------------------------------------------ 5792EXECUTING:[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------------------------------------------------------------------ 5813EXECUTING:[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: utf8 5835 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 5847EXECUTING:[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------------------------------------------------------------------ 5868EXECUTING:[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------------------------------------------------------------------ 5889EXECUTING:[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------------------------------------------------------------------ 5910EXECUTING:[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: utf8 5932 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 5944EXECUTING:[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------------------------------------------------------------------ 5965EXECUTING:[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------------------------------------------------------------------ 5986EXECUTING:[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------------------------------------------------------------------ 6007EXECUTING:[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: utf8 6029 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 6041EXECUTING:[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------------------------------------------------------------------ 6081EXECUTING:[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: 20 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: utf8 6103 [meta][charset result] collation: utf8_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: 20 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: utf8 6135 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 6147EXECUTING:[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------------------------------------------------------------------ 6187EXECUTING:[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: 20 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: utf8 6209 [meta][charset result] collation: utf8_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: 20 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: utf8 6241 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 6253EXECUTING:[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: 16777216 6267 [meta][field] charsetnr: 63 6268 [meta][field] flags: 128 (BINARY ) 6269 [meta][field] decimals: 31 6270 [meta][field] type: LONG_BLOB (251) 6271 6272 6273 [meta][charset result] number: 33 6274 [meta][charset result] name: utf8 6275 [meta][charset result] collation: utf8_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: 16777216 6299 [meta][field] charsetnr: 63 6300 [meta][field] flags: 128 (BINARY ) 6301 [meta][field] decimals: 31 6302 [meta][field] type: LONG_BLOB (251) 6303 6304 6305 [meta][charset result] number: 33 6306 [meta][charset result] name: utf8 6307 [meta][charset result] collation: utf8_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------------------------------------------------------------------ 6319EXECUTING:[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------------------------------------------------------------------ 6359EXECUTING:[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------------------------------------------------------------------ 6380EXECUTING:[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------------------------------------------------------------------ 6401EXECUTING:[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] 6423deinit thread 6424------ cleanup --------------------------------------------------- 6425