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: 0 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: 100 227 [meta][field] charsetnr: 8 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: 100 543 [meta][field] charsetnr: 8 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: 100 882 [meta][field] charsetnr: 8 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: 100 1176 [meta][field] charsetnr: 8 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: 100 1493 [meta][field] charsetnr: 8 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: 100 1745 [meta][field] charsetnr: 8 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:[55][INSTALL PLUGIN plugin_name SONAME 'shared_library_name'] 2833[CS_TEXT_REPRESENTATION] 2834[3130][HY000][Command not supported by pluggable protocols] [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: 0 2847 [end] server status: 2848 [end] warning count: 0 2849 [end] affected rows: 0 2850 [end] last insert id: 0 2851 [end] message: 2852------------------------------------------------------------------ 2853EXECUTING:[28][UNINSTALL PLUGIN plugin_name] 2854[CS_TEXT_REPRESENTATION] 2855[3130][HY000][Command not supported by pluggable protocols] [meta] rows: 0 2856 [meta] cols: 0 2857 [meta] server status: 0 2858 [meta] server status: 2859 [meta] warning count: 0 2860 2861 [meta] no columns 2862 2863 [meta] no charset 2864 2865 [data] no rows 2866 2867 [end] server status: 0 2868 [end] server status: 2869 [end] warning count: 0 2870 [end] affected rows: 0 2871 [end] last insert id: 0 2872 [end] message: 2873------------------------------------------------------------------ 2874EXECUTING:[23][START GROUP_REPLICATION] 2875[CS_TEXT_REPRESENTATION] 2876[3130][HY000][Command not supported by pluggable protocols] [meta] rows: 0 2877 [meta] cols: 0 2878 [meta] server status: 0 2879 [meta] server status: 2880 [meta] warning count: 0 2881 2882 [meta] no columns 2883 2884 [meta] no charset 2885 2886 [data] no rows 2887 2888 [end] server status: 0 2889 [end] server status: 2890 [end] warning count: 0 2891 [end] affected rows: 0 2892 [end] last insert id: 0 2893 [end] message: 2894------------------------------------------------------------------ 2895EXECUTING:[22][STOP GROUP_REPLICATION] 2896[CS_TEXT_REPRESENTATION] 2897[3130][HY000][Command not supported by pluggable protocols] [meta] rows: 0 2898 [meta] cols: 0 2899 [meta] server status: 0 2900 [meta] server status: 2901 [meta] warning count: 0 2902 2903 [meta] no columns 2904 2905 [meta] no charset 2906 2907 [data] no rows 2908 2909 [end] server status: 0 2910 [end] server status: 2911 [end] warning count: 0 2912 [end] affected rows: 0 2913 [end] last insert id: 0 2914 [end] message: 2915------------------------------------------------------------------ 2916EXECUTING:[0][] 2917[CS_TEXT_REPRESENTATION] 2918[1065][42000][Query was empty] [meta] rows: 0 2919 [meta] cols: 0 2920 [meta] server status: 0 2921 [meta] server status: 2922 [meta] warning count: 0 2923 2924 [meta] no columns 2925 2926 [meta] no charset 2927 2928 [data] no rows 2929 2930 [end] server status: 0 2931 [end] server status: 2932 [end] warning count: 0 2933 [end] affected rows: 0 2934 [end] last insert id: 0 2935 [end] message: 2936[CS_BINARY_REPRESENTATION] 2937[1065][42000][Query was empty] [meta] rows: 0 2938 [meta] cols: 0 2939 [meta] server status: 0 2940 [meta] server status: 2941 [meta] warning count: 0 2942 2943 [meta] no columns 2944 2945 [meta] no charset 2946 2947 [data] no rows 2948 2949 [end] server status: 0 2950 [end] server status: 2951 [end] warning count: 0 2952 [end] affected rows: 0 2953 [end] last insert id: 0 2954 [end] message: 2955------------------------------------------------------------------ 2956EXECUTING:[14][DROP TABLE tbl] 2957[CS_TEXT_REPRESENTATION] 2958 [meta] rows: 0 2959 [meta] cols: 0 2960 [meta] server status: 0 2961 [meta] server status: 2962 [meta] warning count: 0 2963 2964 [meta] no columns 2965 2966 [meta] no charset 2967 2968 [data] no rows 2969 2970 [end] server status: 0 2971 [end] server status: 2972 [end] warning count: 0 2973 [end] affected rows: 0 2974 [end] last insert id: 0 2975 [end] message: 2976------------------------------------------------------------------ 2977EXECUTING:[15][DROP TABLE tbld] 2978[CS_TEXT_REPRESENTATION] 2979 [meta] rows: 0 2980 [meta] cols: 0 2981 [meta] server status: 0 2982 [meta] server status: 2983 [meta] warning count: 0 2984 2985 [meta] no columns 2986 2987 [meta] no charset 2988 2989 [data] no rows 2990 2991 [end] server status: 0 2992 [end] server status: 2993 [end] warning count: 0 2994 [end] affected rows: 0 2995 [end] last insert id: 0 2996 [end] message: 2997------------------------------------------------------------------ 2998EXECUTING:[19][DROP DATABASE test1] 2999[CS_TEXT_REPRESENTATION] 3000 [meta] rows: 0 3001 [meta] cols: 0 3002 [meta] server status: 0 3003 [meta] server status: 3004 [meta] warning count: 0 3005 3006 [meta] no columns 3007 3008 [meta] no charset 3009 3010 [data] no rows 3011 3012 [end] server status: 256 3013 [end] server status: DB_DROPPED 3014 [end] warning count: 0 3015 [end] affected rows: 1 3016 [end] last insert id: 0 3017 [end] message: 3018------------------------------------------------------------------ 3019[srv_session_close] 3020Follows threaded run 3021======================================================================== 3022init thread 3023[srv_session_open] 3024------------------------------------------------------------------ 3025EXECUTING:[35][SELECT 'first complex command' as a] 3026[CS_TEXT_REPRESENTATION] 3027 [meta] rows: 1 3028 [meta] cols: 1 3029 [meta] server status: 2 3030 [meta] server status: AUTOCOMMIT 3031 [meta] warning count: 0 3032 3033 [meta][field] db name: 3034 [meta][field] table name: 3035 [meta][field] org table name: 3036 [meta][field] col name: a 3037 [meta][field] org col name: 3038 [meta][field] length: 63 3039 [meta][field] charsetnr: 33 3040 [meta][field] flags: 1 (NOT_NULL ) 3041 [meta][field] decimals: 31 3042 [meta][field] type: VARCHAR (15) 3043 3044 3045 [meta][charset result] number: 33 3046 [meta][charset result] name: utf8 3047 [meta][charset result] collation: utf8_general_ci 3048 [meta][charset result] sort order: 3049 3050 [data][.a][ 21][first complex command] 3051 3052 [end] server status: 2 3053 [end] server status: AUTOCOMMIT 3054 [end] warning count: 0 3055 [end] affected rows: 0 3056 [end] last insert id: 0 3057 [end] message: 3058[CS_BINARY_REPRESENTATION] 3059 [meta] rows: 1 3060 [meta] cols: 1 3061 [meta] server status: 2 3062 [meta] server status: AUTOCOMMIT 3063 [meta] warning count: 0 3064 3065 [meta][field] db name: 3066 [meta][field] table name: 3067 [meta][field] org table name: 3068 [meta][field] col name: a 3069 [meta][field] org col name: 3070 [meta][field] length: 63 3071 [meta][field] charsetnr: 33 3072 [meta][field] flags: 1 (NOT_NULL ) 3073 [meta][field] decimals: 31 3074 [meta][field] type: VARCHAR (15) 3075 3076 3077 [meta][charset result] number: 33 3078 [meta][charset result] name: utf8 3079 [meta][charset result] collation: utf8_general_ci 3080 [meta][charset result] sort order: 3081 3082 [data][.a][ 21][first complex command] 3083 3084 [end] server status: 2 3085 [end] server status: AUTOCOMMIT 3086 [end] warning count: 0 3087 [end] affected rows: 0 3088 [end] last insert id: 0 3089 [end] message: 3090------------------------------------------------------------------ 3091EXECUTING:[21][CREATE DATABASE test1] 3092[CS_TEXT_REPRESENTATION] 3093 [meta] rows: 0 3094 [meta] cols: 0 3095 [meta] server status: 0 3096 [meta] server status: 3097 [meta] warning count: 0 3098 3099 [meta] no columns 3100 3101 [meta] no charset 3102 3103 [data] no rows 3104 3105 [end] server status: 2 3106 [end] server status: AUTOCOMMIT 3107 [end] warning count: 0 3108 [end] affected rows: 1 3109 [end] last insert id: 0 3110 [end] message: 3111------------------------------------------------------------------ 3112EXECUTING:[8][USE test] 3113[CS_TEXT_REPRESENTATION] 3114 [meta] rows: 0 3115 [meta] cols: 0 3116 [meta] server status: 0 3117 [meta] server status: 3118 [meta] warning count: 0 3119 3120 [meta] no columns 3121 3122 [meta] no charset 3123 3124 [data] no rows 3125 3126 [end] server status: 2 3127 [end] server status: AUTOCOMMIT 3128 [end] warning count: 0 3129 [end] affected rows: 0 3130 [end] last insert id: 0 3131 [end] message: 3132------------------------------------------------------------------ 3133EXECUTING:[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));] 3134[CS_TEXT_REPRESENTATION] 3135 [meta] rows: 0 3136 [meta] cols: 0 3137 [meta] server status: 0 3138 [meta] server status: 3139 [meta] warning count: 0 3140 3141 [meta] no columns 3142 3143 [meta] no charset 3144 3145 [data] no rows 3146 3147 [end] server status: 2 3148 [end] server status: AUTOCOMMIT 3149 [end] warning count: 0 3150 [end] affected rows: 0 3151 [end] last insert id: 0 3152 [end] message: 3153------------------------------------------------------------------ 3154EXECUTING:[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)] 3155[CS_TEXT_REPRESENTATION] 3156 [meta] rows: 0 3157 [meta] cols: 0 3158 [meta] server status: 0 3159 [meta] server status: 3160 [meta] warning count: 0 3161 3162 [meta] no columns 3163 3164 [meta] no charset 3165 3166 [data] no rows 3167 3168 [end] server status: 2 3169 [end] server status: AUTOCOMMIT 3170 [end] warning count: 0 3171 [end] affected rows: 1 3172 [end] last insert id: 0 3173 [end] message: 3174------------------------------------------------------------------ 3175EXECUTING:[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)] 3176[CS_TEXT_REPRESENTATION] 3177 [meta] rows: 0 3178 [meta] cols: 0 3179 [meta] server status: 0 3180 [meta] server status: 3181 [meta] warning count: 0 3182 3183 [meta] no columns 3184 3185 [meta] no charset 3186 3187 [data] no rows 3188 3189 [end] server status: 2 3190 [end] server status: AUTOCOMMIT 3191 [end] warning count: 0 3192 [end] affected rows: 1 3193 [end] last insert id: 0 3194 [end] message: 3195------------------------------------------------------------------ 3196EXECUTING:[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)] 3197[CS_TEXT_REPRESENTATION] 3198 [meta] rows: 0 3199 [meta] cols: 0 3200 [meta] server status: 0 3201 [meta] server status: 3202 [meta] warning count: 0 3203 3204 [meta] no columns 3205 3206 [meta] no charset 3207 3208 [data] no rows 3209 3210 [end] server status: 2 3211 [end] server status: AUTOCOMMIT 3212 [end] warning count: 0 3213 [end] affected rows: 1 3214 [end] last insert id: 0 3215 [end] message: 3216------------------------------------------------------------------ 3217EXECUTING:[43][SELECT * FROM test1.test_inserts ORDER BY a] 3218[CS_TEXT_REPRESENTATION] 3219 [meta] rows: 3 3220 [meta] cols: 21 3221 [meta] server status: 2 3222 [meta] server status: AUTOCOMMIT 3223 [meta] warning count: 0 3224 3225 [meta][field] db name: test1 3226 [meta][field] table name: test_inserts 3227 [meta][field] org table name: test_inserts 3228 [meta][field] col name: a 3229 [meta][field] org col name: a 3230 [meta][field] length: 10 3231 [meta][field] charsetnr: 8 3232 [meta][field] flags: 20515 (NOT_NULL PRI_KEY UNSIGNED NO_DEFAULT_VALUE PART_KEY ) 3233 [meta][field] decimals: 0 3234 [meta][field] type: LONG (3) 3235 3236 [meta][field] db name: test1 3237 [meta][field] table name: test_inserts 3238 [meta][field] org table name: test_inserts 3239 [meta][field] col name: b 3240 [meta][field] org col name: b 3241 [meta][field] length: 100 3242 [meta][field] charsetnr: 8 3243 [meta][field] flags: 0 3244 [meta][field] decimals: 0 3245 [meta][field] type: VARCHAR (15) 3246 3247 [meta][field] db name: test1 3248 [meta][field] table name: test_inserts 3249 [meta][field] org table name: test_inserts 3250 [meta][field] col name: c 3251 [meta][field] org col name: c 3252 [meta][field] length: 22 3253 [meta][field] charsetnr: 8 3254 [meta][field] flags: 0 3255 [meta][field] decimals: 31 3256 [meta][field] type: DOUBLE (5) 3257 3258 [meta][field] db name: test1 3259 [meta][field] table name: test_inserts 3260 [meta][field] org table name: test_inserts 3261 [meta][field] col name: d 3262 [meta][field] org col name: d 3263 [meta][field] length: 11 3264 [meta][field] charsetnr: 8 3265 [meta][field] flags: 16392 (MULTIPLE_KEY PART_KEY ) 3266 [meta][field] decimals: 0 3267 [meta][field] type: LONG (3) 3268 3269 [meta][field] db name: test1 3270 [meta][field] table name: test_inserts 3271 [meta][field] org table name: test_inserts 3272 [meta][field] col name: e 3273 [meta][field] org col name: e 3274 [meta][field] length: 12 3275 [meta][field] charsetnr: 8 3276 [meta][field] flags: 0 3277 [meta][field] decimals: 31 3278 [meta][field] type: FLOAT (4) 3279 3280 [meta][field] db name: test1 3281 [meta][field] table name: test_inserts 3282 [meta][field] org table name: test_inserts 3283 [meta][field] col name: f 3284 [meta][field] org col name: f 3285 [meta][field] length: 19 3286 [meta][field] charsetnr: 8 3287 [meta][field] flags: 128 (BINARY ) 3288 [meta][field] decimals: 0 3289 [meta][field] type: DATETIME (12) 3290 3291 [meta][field] db name: test1 3292 [meta][field] table name: test_inserts 3293 [meta][field] org table name: test_inserts 3294 [meta][field] col name: g 3295 [meta][field] org col name: g 3296 [meta][field] length: 10 3297 [meta][field] charsetnr: 8 3298 [meta][field] flags: 128 (BINARY ) 3299 [meta][field] decimals: 0 3300 [meta][field] type: DATE (10) 3301 3302 [meta][field] db name: test1 3303 [meta][field] table name: test_inserts 3304 [meta][field] org table name: test_inserts 3305 [meta][field] col name: h 3306 [meta][field] org col name: h 3307 [meta][field] length: 10 3308 [meta][field] charsetnr: 8 3309 [meta][field] flags: 128 (BINARY ) 3310 [meta][field] decimals: 0 3311 [meta][field] type: TIME (11) 3312 3313 [meta][field] db name: test1 3314 [meta][field] table name: test_inserts 3315 [meta][field] org table name: test_inserts 3316 [meta][field] col name: i 3317 [meta][field] org col name: i 3318 [meta][field] length: 4 3319 [meta][field] charsetnr: 8 3320 [meta][field] flags: 0 3321 [meta][field] decimals: 0 3322 [meta][field] type: TINY (1) 3323 3324 [meta][field] db name: test1 3325 [meta][field] table name: test_inserts 3326 [meta][field] org table name: test_inserts 3327 [meta][field] col name: k 3328 [meta][field] org col name: k 3329 [meta][field] length: 3 3330 [meta][field] charsetnr: 8 3331 [meta][field] flags: 32 (UNSIGNED ) 3332 [meta][field] decimals: 0 3333 [meta][field] type: TINY (1) 3334 3335 [meta][field] db name: test1 3336 [meta][field] table name: test_inserts 3337 [meta][field] org table name: test_inserts 3338 [meta][field] col name: l 3339 [meta][field] org col name: l 3340 [meta][field] length: 6 3341 [meta][field] charsetnr: 8 3342 [meta][field] flags: 0 3343 [meta][field] decimals: 0 3344 [meta][field] type: SHORT (2) 3345 3346 [meta][field] db name: test1 3347 [meta][field] table name: test_inserts 3348 [meta][field] org table name: test_inserts 3349 [meta][field] col name: m 3350 [meta][field] org col name: m 3351 [meta][field] length: 5 3352 [meta][field] charsetnr: 8 3353 [meta][field] flags: 32 (UNSIGNED ) 3354 [meta][field] decimals: 0 3355 [meta][field] type: SHORT (2) 3356 3357 [meta][field] db name: test1 3358 [meta][field] table name: test_inserts 3359 [meta][field] org table name: test_inserts 3360 [meta][field] col name: n 3361 [meta][field] org col name: n 3362 [meta][field] length: 9 3363 [meta][field] charsetnr: 8 3364 [meta][field] flags: 0 3365 [meta][field] decimals: 0 3366 [meta][field] type: INT24 (9) 3367 3368 [meta][field] db name: test1 3369 [meta][field] table name: test_inserts 3370 [meta][field] org table name: test_inserts 3371 [meta][field] col name: o 3372 [meta][field] org col name: o 3373 [meta][field] length: 8 3374 [meta][field] charsetnr: 8 3375 [meta][field] flags: 32 (UNSIGNED ) 3376 [meta][field] decimals: 0 3377 [meta][field] type: INT24 (9) 3378 3379 [meta][field] db name: test1 3380 [meta][field] table name: test_inserts 3381 [meta][field] org table name: test_inserts 3382 [meta][field] col name: p 3383 [meta][field] org col name: p 3384 [meta][field] length: 11 3385 [meta][field] charsetnr: 8 3386 [meta][field] flags: 0 3387 [meta][field] decimals: 0 3388 [meta][field] type: LONG (3) 3389 3390 [meta][field] db name: test1 3391 [meta][field] table name: test_inserts 3392 [meta][field] org table name: test_inserts 3393 [meta][field] col name: q 3394 [meta][field] org col name: q 3395 [meta][field] length: 10 3396 [meta][field] charsetnr: 8 3397 [meta][field] flags: 32 (UNSIGNED ) 3398 [meta][field] decimals: 0 3399 [meta][field] type: LONG (3) 3400 3401 [meta][field] db name: test1 3402 [meta][field] table name: test_inserts 3403 [meta][field] org table name: test_inserts 3404 [meta][field] col name: r 3405 [meta][field] org col name: r 3406 [meta][field] length: 20 3407 [meta][field] charsetnr: 8 3408 [meta][field] flags: 0 3409 [meta][field] decimals: 0 3410 [meta][field] type: LONGLONG (8) 3411 3412 [meta][field] db name: test1 3413 [meta][field] table name: test_inserts 3414 [meta][field] org table name: test_inserts 3415 [meta][field] col name: s 3416 [meta][field] org col name: s 3417 [meta][field] length: 20 3418 [meta][field] charsetnr: 8 3419 [meta][field] flags: 32 (UNSIGNED ) 3420 [meta][field] decimals: 0 3421 [meta][field] type: LONGLONG (8) 3422 3423 [meta][field] db name: test1 3424 [meta][field] table name: test_inserts 3425 [meta][field] org table name: test_inserts 3426 [meta][field] col name: t 3427 [meta][field] org col name: t 3428 [meta][field] length: 4 3429 [meta][field] charsetnr: 8 3430 [meta][field] flags: 96 (UNSIGNED ZEROFILL ) 3431 [meta][field] decimals: 0 3432 [meta][field] type: YEAR (13) 3433 3434 [meta][field] db name: test1 3435 [meta][field] table name: test_inserts 3436 [meta][field] org table name: test_inserts 3437 [meta][field] col name: u 3438 [meta][field] org col name: u 3439 [meta][field] length: 6 3440 [meta][field] charsetnr: 8 3441 [meta][field] flags: 32 (UNSIGNED ) 3442 [meta][field] decimals: 2 3443 [meta][field] type: NEWDECIMAL (246) 3444 3445 [meta][field] db name: test1 3446 [meta][field] table name: test_inserts 3447 [meta][field] org table name: test_inserts 3448 [meta][field] col name: v 3449 [meta][field] org col name: v 3450 [meta][field] length: 7 3451 [meta][field] charsetnr: 8 3452 [meta][field] flags: 0 3453 [meta][field] decimals: 2 3454 [meta][field] type: NEWDECIMAL (246) 3455 3456 3457 [meta][charset result] number: 33 3458 [meta][charset result] name: utf8 3459 [meta][charset result] collation: utf8_general_ci 3460 [meta][charset result] sort order: 3461 3462 [data][test_inserts.a][ 1][1] 3463 [data][test_inserts.b][ 3][one] 3464 [data][test_inserts.c][ 4][1.23] 3465 [data][test_inserts.d][ 2][-1] 3466 [data][test_inserts.e][ 7][11.2323] 3467 [data][test_inserts.f][ 19][2014-07-06 07:06:05] 3468 [data][test_inserts.g][ 10][1980-02-19] 3469 [data][test_inserts.h][ 10][-830:12:23] 3470 [data][test_inserts.i][ 3][127] 3471 [data][test_inserts.k][ 3][255] 3472 [data][test_inserts.l][ 5][32767] 3473 [data][test_inserts.m][ 5][65535] 3474 [data][test_inserts.n][ 7][8388607] 3475 [data][test_inserts.o][ 8][16777215] 3476 [data][test_inserts.p][ 10][2147483647] 3477 [data][test_inserts.q][ 10][4294967295] 3478 [data][test_inserts.r][ 19][9223372036854775807] 3479 [data][test_inserts.s][ 20][18446744073709551615] 3480 [data][test_inserts.t][ 4][1901] 3481 [data][test_inserts.u][ 6][999.99] 3482 [data][test_inserts.v][ 7][-999.99] 3483 3484 [data][test_inserts.a][ 1][2] 3485 [data][test_inserts.b][ 3][two] 3486 [data][test_inserts.c][ 4][2.34] 3487 [data][test_inserts.d][ 2][-2] 3488 [data][test_inserts.e][ 7][22.3434] 3489 [data][test_inserts.f][ 19][2015-07-06 21:22:23] 3490 [data][test_inserts.g][ 10][2014-06-05] 3491 [data][test_inserts.h][ 9][356:22:33] 3492 [data][test_inserts.i][ 4][-128] 3493 [data][test_inserts.k][ 1][0] 3494 [data][test_inserts.l][ 6][-32768] 3495 [data][test_inserts.m][ 5][32768] 3496 [data][test_inserts.n][ 8][-8388608] 3497 [data][test_inserts.o][ 7][8388607] 3498 [data][test_inserts.p][ 11][-2147483648] 3499 [data][test_inserts.q][ 1][0] 3500 [data][test_inserts.r][ 20][-9223372036854775808] 3501 [data][test_inserts.s][ 20][18446744073709551615] 3502 [data][test_inserts.t][ 4][2039] 3503 [data][test_inserts.u][ 6][123.45] 3504 [data][test_inserts.v][ 7][-543.21] 3505 3506 [data][test_inserts.a][ 1][3] 3507 [data][test_inserts.b][ 5][three] 3508 [data][test_inserts.c][ 4][3.45] 3509 [data][test_inserts.d][ 2][-3] 3510 [data][test_inserts.e][ 7][33.4545] 3511 [data][test_inserts.f][ 19][2016-09-12 11:12:13] 3512 [data][test_inserts.g][ 10][2013-05-04] 3513 [data][test_inserts.h][ 9][821:33:44] 3514 [data][test_inserts.i][ 2][-1] 3515 [data][test_inserts.k][ 3][128] 3516 [data][test_inserts.l][ 2][-1] 3517 [data][test_inserts.m][ 5][65534] 3518 [data][test_inserts.n][ 2][-1] 3519 [data][test_inserts.o][ 8][16777214] 3520 [data][test_inserts.p][ 1][1] 3521 [data][test_inserts.q][ 1][2] 3522 [data][test_inserts.r][ 1][3] 3523 [data][test_inserts.s][ 1][4] 3524 [data][test_inserts.t][ 4][2155] 3525 [data][test_inserts.u][ 6][222.22] 3526 [data][test_inserts.v][ 7][-567.89] 3527 3528 [end] server status: 2 3529 [end] server status: AUTOCOMMIT 3530 [end] warning count: 0 3531 [end] affected rows: 0 3532 [end] last insert id: 0 3533 [end] message: 3534[CS_BINARY_REPRESENTATION] 3535 [meta] rows: 3 3536 [meta] cols: 21 3537 [meta] server status: 2 3538 [meta] server status: AUTOCOMMIT 3539 [meta] warning count: 0 3540 3541 [meta][field] db name: test1 3542 [meta][field] table name: test_inserts 3543 [meta][field] org table name: test_inserts 3544 [meta][field] col name: a 3545 [meta][field] org col name: a 3546 [meta][field] length: 10 3547 [meta][field] charsetnr: 8 3548 [meta][field] flags: 20515 (NOT_NULL PRI_KEY UNSIGNED NO_DEFAULT_VALUE PART_KEY ) 3549 [meta][field] decimals: 0 3550 [meta][field] type: LONG (3) 3551 3552 [meta][field] db name: test1 3553 [meta][field] table name: test_inserts 3554 [meta][field] org table name: test_inserts 3555 [meta][field] col name: b 3556 [meta][field] org col name: b 3557 [meta][field] length: 100 3558 [meta][field] charsetnr: 8 3559 [meta][field] flags: 0 3560 [meta][field] decimals: 0 3561 [meta][field] type: VARCHAR (15) 3562 3563 [meta][field] db name: test1 3564 [meta][field] table name: test_inserts 3565 [meta][field] org table name: test_inserts 3566 [meta][field] col name: c 3567 [meta][field] org col name: c 3568 [meta][field] length: 22 3569 [meta][field] charsetnr: 8 3570 [meta][field] flags: 0 3571 [meta][field] decimals: 31 3572 [meta][field] type: DOUBLE (5) 3573 3574 [meta][field] db name: test1 3575 [meta][field] table name: test_inserts 3576 [meta][field] org table name: test_inserts 3577 [meta][field] col name: d 3578 [meta][field] org col name: d 3579 [meta][field] length: 11 3580 [meta][field] charsetnr: 8 3581 [meta][field] flags: 16392 (MULTIPLE_KEY PART_KEY ) 3582 [meta][field] decimals: 0 3583 [meta][field] type: LONG (3) 3584 3585 [meta][field] db name: test1 3586 [meta][field] table name: test_inserts 3587 [meta][field] org table name: test_inserts 3588 [meta][field] col name: e 3589 [meta][field] org col name: e 3590 [meta][field] length: 12 3591 [meta][field] charsetnr: 8 3592 [meta][field] flags: 0 3593 [meta][field] decimals: 31 3594 [meta][field] type: FLOAT (4) 3595 3596 [meta][field] db name: test1 3597 [meta][field] table name: test_inserts 3598 [meta][field] org table name: test_inserts 3599 [meta][field] col name: f 3600 [meta][field] org col name: f 3601 [meta][field] length: 19 3602 [meta][field] charsetnr: 8 3603 [meta][field] flags: 128 (BINARY ) 3604 [meta][field] decimals: 0 3605 [meta][field] type: DATETIME (12) 3606 3607 [meta][field] db name: test1 3608 [meta][field] table name: test_inserts 3609 [meta][field] org table name: test_inserts 3610 [meta][field] col name: g 3611 [meta][field] org col name: g 3612 [meta][field] length: 10 3613 [meta][field] charsetnr: 8 3614 [meta][field] flags: 128 (BINARY ) 3615 [meta][field] decimals: 0 3616 [meta][field] type: DATE (10) 3617 3618 [meta][field] db name: test1 3619 [meta][field] table name: test_inserts 3620 [meta][field] org table name: test_inserts 3621 [meta][field] col name: h 3622 [meta][field] org col name: h 3623 [meta][field] length: 10 3624 [meta][field] charsetnr: 8 3625 [meta][field] flags: 128 (BINARY ) 3626 [meta][field] decimals: 0 3627 [meta][field] type: TIME (11) 3628 3629 [meta][field] db name: test1 3630 [meta][field] table name: test_inserts 3631 [meta][field] org table name: test_inserts 3632 [meta][field] col name: i 3633 [meta][field] org col name: i 3634 [meta][field] length: 4 3635 [meta][field] charsetnr: 8 3636 [meta][field] flags: 0 3637 [meta][field] decimals: 0 3638 [meta][field] type: TINY (1) 3639 3640 [meta][field] db name: test1 3641 [meta][field] table name: test_inserts 3642 [meta][field] org table name: test_inserts 3643 [meta][field] col name: k 3644 [meta][field] org col name: k 3645 [meta][field] length: 3 3646 [meta][field] charsetnr: 8 3647 [meta][field] flags: 32 (UNSIGNED ) 3648 [meta][field] decimals: 0 3649 [meta][field] type: TINY (1) 3650 3651 [meta][field] db name: test1 3652 [meta][field] table name: test_inserts 3653 [meta][field] org table name: test_inserts 3654 [meta][field] col name: l 3655 [meta][field] org col name: l 3656 [meta][field] length: 6 3657 [meta][field] charsetnr: 8 3658 [meta][field] flags: 0 3659 [meta][field] decimals: 0 3660 [meta][field] type: SHORT (2) 3661 3662 [meta][field] db name: test1 3663 [meta][field] table name: test_inserts 3664 [meta][field] org table name: test_inserts 3665 [meta][field] col name: m 3666 [meta][field] org col name: m 3667 [meta][field] length: 5 3668 [meta][field] charsetnr: 8 3669 [meta][field] flags: 32 (UNSIGNED ) 3670 [meta][field] decimals: 0 3671 [meta][field] type: SHORT (2) 3672 3673 [meta][field] db name: test1 3674 [meta][field] table name: test_inserts 3675 [meta][field] org table name: test_inserts 3676 [meta][field] col name: n 3677 [meta][field] org col name: n 3678 [meta][field] length: 9 3679 [meta][field] charsetnr: 8 3680 [meta][field] flags: 0 3681 [meta][field] decimals: 0 3682 [meta][field] type: INT24 (9) 3683 3684 [meta][field] db name: test1 3685 [meta][field] table name: test_inserts 3686 [meta][field] org table name: test_inserts 3687 [meta][field] col name: o 3688 [meta][field] org col name: o 3689 [meta][field] length: 8 3690 [meta][field] charsetnr: 8 3691 [meta][field] flags: 32 (UNSIGNED ) 3692 [meta][field] decimals: 0 3693 [meta][field] type: INT24 (9) 3694 3695 [meta][field] db name: test1 3696 [meta][field] table name: test_inserts 3697 [meta][field] org table name: test_inserts 3698 [meta][field] col name: p 3699 [meta][field] org col name: p 3700 [meta][field] length: 11 3701 [meta][field] charsetnr: 8 3702 [meta][field] flags: 0 3703 [meta][field] decimals: 0 3704 [meta][field] type: LONG (3) 3705 3706 [meta][field] db name: test1 3707 [meta][field] table name: test_inserts 3708 [meta][field] org table name: test_inserts 3709 [meta][field] col name: q 3710 [meta][field] org col name: q 3711 [meta][field] length: 10 3712 [meta][field] charsetnr: 8 3713 [meta][field] flags: 32 (UNSIGNED ) 3714 [meta][field] decimals: 0 3715 [meta][field] type: LONG (3) 3716 3717 [meta][field] db name: test1 3718 [meta][field] table name: test_inserts 3719 [meta][field] org table name: test_inserts 3720 [meta][field] col name: r 3721 [meta][field] org col name: r 3722 [meta][field] length: 20 3723 [meta][field] charsetnr: 8 3724 [meta][field] flags: 0 3725 [meta][field] decimals: 0 3726 [meta][field] type: LONGLONG (8) 3727 3728 [meta][field] db name: test1 3729 [meta][field] table name: test_inserts 3730 [meta][field] org table name: test_inserts 3731 [meta][field] col name: s 3732 [meta][field] org col name: s 3733 [meta][field] length: 20 3734 [meta][field] charsetnr: 8 3735 [meta][field] flags: 32 (UNSIGNED ) 3736 [meta][field] decimals: 0 3737 [meta][field] type: LONGLONG (8) 3738 3739 [meta][field] db name: test1 3740 [meta][field] table name: test_inserts 3741 [meta][field] org table name: test_inserts 3742 [meta][field] col name: t 3743 [meta][field] org col name: t 3744 [meta][field] length: 4 3745 [meta][field] charsetnr: 8 3746 [meta][field] flags: 96 (UNSIGNED ZEROFILL ) 3747 [meta][field] decimals: 0 3748 [meta][field] type: YEAR (13) 3749 3750 [meta][field] db name: test1 3751 [meta][field] table name: test_inserts 3752 [meta][field] org table name: test_inserts 3753 [meta][field] col name: u 3754 [meta][field] org col name: u 3755 [meta][field] length: 6 3756 [meta][field] charsetnr: 8 3757 [meta][field] flags: 32 (UNSIGNED ) 3758 [meta][field] decimals: 2 3759 [meta][field] type: NEWDECIMAL (246) 3760 3761 [meta][field] db name: test1 3762 [meta][field] table name: test_inserts 3763 [meta][field] org table name: test_inserts 3764 [meta][field] col name: v 3765 [meta][field] org col name: v 3766 [meta][field] length: 7 3767 [meta][field] charsetnr: 8 3768 [meta][field] flags: 0 3769 [meta][field] decimals: 2 3770 [meta][field] type: NEWDECIMAL (246) 3771 3772 3773 [meta][charset result] number: 33 3774 [meta][charset result] name: utf8 3775 [meta][charset result] collation: utf8_general_ci 3776 [meta][charset result] sort order: 3777 3778 [data][test_inserts.a][ 1][1] 3779 [data][test_inserts.b][ 3][one] 3780 [data][test_inserts.c][ 4][1.23] 3781 [data][test_inserts.d][ 2][-1] 3782 [data][test_inserts.e][ 7][11.2323] 3783 [data][test_inserts.f][ 19][2014-07-06 07:06:05] 3784 [data][test_inserts.g][ 10][1980-02-19] 3785 [data][test_inserts.h][ 10][-830:12:23] 3786 [data][test_inserts.i][ 3][127] 3787 [data][test_inserts.k][ 3][255] 3788 [data][test_inserts.l][ 5][32767] 3789 [data][test_inserts.m][ 5][65535] 3790 [data][test_inserts.n][ 7][8388607] 3791 [data][test_inserts.o][ 8][16777215] 3792 [data][test_inserts.p][ 10][2147483647] 3793 [data][test_inserts.q][ 10][4294967295] 3794 [data][test_inserts.r][ 19][9223372036854775807] 3795 [data][test_inserts.s][ 20][18446744073709551615] 3796 [data][test_inserts.t][ 4][1901] 3797 [data][test_inserts.u][ 6][999.99] 3798 [data][test_inserts.v][ 7][-999.99] 3799 3800 [data][test_inserts.a][ 1][2] 3801 [data][test_inserts.b][ 3][two] 3802 [data][test_inserts.c][ 4][2.34] 3803 [data][test_inserts.d][ 2][-2] 3804 [data][test_inserts.e][ 7][22.3434] 3805 [data][test_inserts.f][ 19][2015-07-06 21:22:23] 3806 [data][test_inserts.g][ 10][2014-06-05] 3807 [data][test_inserts.h][ 9][356:22:33] 3808 [data][test_inserts.i][ 4][-128] 3809 [data][test_inserts.k][ 1][0] 3810 [data][test_inserts.l][ 6][-32768] 3811 [data][test_inserts.m][ 5][32768] 3812 [data][test_inserts.n][ 8][-8388608] 3813 [data][test_inserts.o][ 7][8388607] 3814 [data][test_inserts.p][ 11][-2147483648] 3815 [data][test_inserts.q][ 1][0] 3816 [data][test_inserts.r][ 20][-9223372036854775808] 3817 [data][test_inserts.s][ 20][18446744073709551615] 3818 [data][test_inserts.t][ 4][2039] 3819 [data][test_inserts.u][ 6][123.45] 3820 [data][test_inserts.v][ 7][-543.21] 3821 3822 [data][test_inserts.a][ 1][3] 3823 [data][test_inserts.b][ 5][three] 3824 [data][test_inserts.c][ 4][3.45] 3825 [data][test_inserts.d][ 2][-3] 3826 [data][test_inserts.e][ 7][33.4545] 3827 [data][test_inserts.f][ 19][2016-09-12 11:12:13] 3828 [data][test_inserts.g][ 10][2013-05-04] 3829 [data][test_inserts.h][ 9][821:33:44] 3830 [data][test_inserts.i][ 2][-1] 3831 [data][test_inserts.k][ 3][128] 3832 [data][test_inserts.l][ 2][-1] 3833 [data][test_inserts.m][ 5][65534] 3834 [data][test_inserts.n][ 2][-1] 3835 [data][test_inserts.o][ 8][16777214] 3836 [data][test_inserts.p][ 1][1] 3837 [data][test_inserts.q][ 1][2] 3838 [data][test_inserts.r][ 1][3] 3839 [data][test_inserts.s][ 1][4] 3840 [data][test_inserts.t][ 4][2155] 3841 [data][test_inserts.u][ 6][222.22] 3842 [data][test_inserts.v][ 7][-567.89] 3843 3844 [end] server status: 2 3845 [end] server status: AUTOCOMMIT 3846 [end] warning count: 0 3847 [end] affected rows: 0 3848 [end] last insert id: 0 3849 [end] message: 3850------------------------------------------------------------------ 3851EXECUTING:[34][DELETE FROM test_inserts WHERE a=2] 3852[CS_TEXT_REPRESENTATION] 3853 [meta] rows: 0 3854 [meta] cols: 0 3855 [meta] server status: 0 3856 [meta] server status: 3857 [meta] warning count: 0 3858 3859 [meta] no columns 3860 3861 [meta] no charset 3862 3863 [data] no rows 3864 3865 [end] server status: 2 3866 [end] server status: AUTOCOMMIT 3867 [end] warning count: 0 3868 [end] affected rows: 1 3869 [end] last insert id: 0 3870 [end] message: 3871------------------------------------------------------------------ 3872EXECUTING:[37][SELECT * FROM test_inserts ORDER BY a] 3873[CS_TEXT_REPRESENTATION] 3874 [meta] rows: 2 3875 [meta] cols: 21 3876 [meta] server status: 2 3877 [meta] server status: AUTOCOMMIT 3878 [meta] warning count: 0 3879 3880 [meta][field] db name: test1 3881 [meta][field] table name: test_inserts 3882 [meta][field] org table name: test_inserts 3883 [meta][field] col name: a 3884 [meta][field] org col name: a 3885 [meta][field] length: 10 3886 [meta][field] charsetnr: 8 3887 [meta][field] flags: 20515 (NOT_NULL PRI_KEY UNSIGNED NO_DEFAULT_VALUE PART_KEY ) 3888 [meta][field] decimals: 0 3889 [meta][field] type: LONG (3) 3890 3891 [meta][field] db name: test1 3892 [meta][field] table name: test_inserts 3893 [meta][field] org table name: test_inserts 3894 [meta][field] col name: b 3895 [meta][field] org col name: b 3896 [meta][field] length: 100 3897 [meta][field] charsetnr: 8 3898 [meta][field] flags: 0 3899 [meta][field] decimals: 0 3900 [meta][field] type: VARCHAR (15) 3901 3902 [meta][field] db name: test1 3903 [meta][field] table name: test_inserts 3904 [meta][field] org table name: test_inserts 3905 [meta][field] col name: c 3906 [meta][field] org col name: c 3907 [meta][field] length: 22 3908 [meta][field] charsetnr: 8 3909 [meta][field] flags: 0 3910 [meta][field] decimals: 31 3911 [meta][field] type: DOUBLE (5) 3912 3913 [meta][field] db name: test1 3914 [meta][field] table name: test_inserts 3915 [meta][field] org table name: test_inserts 3916 [meta][field] col name: d 3917 [meta][field] org col name: d 3918 [meta][field] length: 11 3919 [meta][field] charsetnr: 8 3920 [meta][field] flags: 16392 (MULTIPLE_KEY PART_KEY ) 3921 [meta][field] decimals: 0 3922 [meta][field] type: LONG (3) 3923 3924 [meta][field] db name: test1 3925 [meta][field] table name: test_inserts 3926 [meta][field] org table name: test_inserts 3927 [meta][field] col name: e 3928 [meta][field] org col name: e 3929 [meta][field] length: 12 3930 [meta][field] charsetnr: 8 3931 [meta][field] flags: 0 3932 [meta][field] decimals: 31 3933 [meta][field] type: FLOAT (4) 3934 3935 [meta][field] db name: test1 3936 [meta][field] table name: test_inserts 3937 [meta][field] org table name: test_inserts 3938 [meta][field] col name: f 3939 [meta][field] org col name: f 3940 [meta][field] length: 19 3941 [meta][field] charsetnr: 8 3942 [meta][field] flags: 128 (BINARY ) 3943 [meta][field] decimals: 0 3944 [meta][field] type: DATETIME (12) 3945 3946 [meta][field] db name: test1 3947 [meta][field] table name: test_inserts 3948 [meta][field] org table name: test_inserts 3949 [meta][field] col name: g 3950 [meta][field] org col name: g 3951 [meta][field] length: 10 3952 [meta][field] charsetnr: 8 3953 [meta][field] flags: 128 (BINARY ) 3954 [meta][field] decimals: 0 3955 [meta][field] type: DATE (10) 3956 3957 [meta][field] db name: test1 3958 [meta][field] table name: test_inserts 3959 [meta][field] org table name: test_inserts 3960 [meta][field] col name: h 3961 [meta][field] org col name: h 3962 [meta][field] length: 10 3963 [meta][field] charsetnr: 8 3964 [meta][field] flags: 128 (BINARY ) 3965 [meta][field] decimals: 0 3966 [meta][field] type: TIME (11) 3967 3968 [meta][field] db name: test1 3969 [meta][field] table name: test_inserts 3970 [meta][field] org table name: test_inserts 3971 [meta][field] col name: i 3972 [meta][field] org col name: i 3973 [meta][field] length: 4 3974 [meta][field] charsetnr: 8 3975 [meta][field] flags: 0 3976 [meta][field] decimals: 0 3977 [meta][field] type: TINY (1) 3978 3979 [meta][field] db name: test1 3980 [meta][field] table name: test_inserts 3981 [meta][field] org table name: test_inserts 3982 [meta][field] col name: k 3983 [meta][field] org col name: k 3984 [meta][field] length: 3 3985 [meta][field] charsetnr: 8 3986 [meta][field] flags: 32 (UNSIGNED ) 3987 [meta][field] decimals: 0 3988 [meta][field] type: TINY (1) 3989 3990 [meta][field] db name: test1 3991 [meta][field] table name: test_inserts 3992 [meta][field] org table name: test_inserts 3993 [meta][field] col name: l 3994 [meta][field] org col name: l 3995 [meta][field] length: 6 3996 [meta][field] charsetnr: 8 3997 [meta][field] flags: 0 3998 [meta][field] decimals: 0 3999 [meta][field] type: SHORT (2) 4000 4001 [meta][field] db name: test1 4002 [meta][field] table name: test_inserts 4003 [meta][field] org table name: test_inserts 4004 [meta][field] col name: m 4005 [meta][field] org col name: m 4006 [meta][field] length: 5 4007 [meta][field] charsetnr: 8 4008 [meta][field] flags: 32 (UNSIGNED ) 4009 [meta][field] decimals: 0 4010 [meta][field] type: SHORT (2) 4011 4012 [meta][field] db name: test1 4013 [meta][field] table name: test_inserts 4014 [meta][field] org table name: test_inserts 4015 [meta][field] col name: n 4016 [meta][field] org col name: n 4017 [meta][field] length: 9 4018 [meta][field] charsetnr: 8 4019 [meta][field] flags: 0 4020 [meta][field] decimals: 0 4021 [meta][field] type: INT24 (9) 4022 4023 [meta][field] db name: test1 4024 [meta][field] table name: test_inserts 4025 [meta][field] org table name: test_inserts 4026 [meta][field] col name: o 4027 [meta][field] org col name: o 4028 [meta][field] length: 8 4029 [meta][field] charsetnr: 8 4030 [meta][field] flags: 32 (UNSIGNED ) 4031 [meta][field] decimals: 0 4032 [meta][field] type: INT24 (9) 4033 4034 [meta][field] db name: test1 4035 [meta][field] table name: test_inserts 4036 [meta][field] org table name: test_inserts 4037 [meta][field] col name: p 4038 [meta][field] org col name: p 4039 [meta][field] length: 11 4040 [meta][field] charsetnr: 8 4041 [meta][field] flags: 0 4042 [meta][field] decimals: 0 4043 [meta][field] type: LONG (3) 4044 4045 [meta][field] db name: test1 4046 [meta][field] table name: test_inserts 4047 [meta][field] org table name: test_inserts 4048 [meta][field] col name: q 4049 [meta][field] org col name: q 4050 [meta][field] length: 10 4051 [meta][field] charsetnr: 8 4052 [meta][field] flags: 32 (UNSIGNED ) 4053 [meta][field] decimals: 0 4054 [meta][field] type: LONG (3) 4055 4056 [meta][field] db name: test1 4057 [meta][field] table name: test_inserts 4058 [meta][field] org table name: test_inserts 4059 [meta][field] col name: r 4060 [meta][field] org col name: r 4061 [meta][field] length: 20 4062 [meta][field] charsetnr: 8 4063 [meta][field] flags: 0 4064 [meta][field] decimals: 0 4065 [meta][field] type: LONGLONG (8) 4066 4067 [meta][field] db name: test1 4068 [meta][field] table name: test_inserts 4069 [meta][field] org table name: test_inserts 4070 [meta][field] col name: s 4071 [meta][field] org col name: s 4072 [meta][field] length: 20 4073 [meta][field] charsetnr: 8 4074 [meta][field] flags: 32 (UNSIGNED ) 4075 [meta][field] decimals: 0 4076 [meta][field] type: LONGLONG (8) 4077 4078 [meta][field] db name: test1 4079 [meta][field] table name: test_inserts 4080 [meta][field] org table name: test_inserts 4081 [meta][field] col name: t 4082 [meta][field] org col name: t 4083 [meta][field] length: 4 4084 [meta][field] charsetnr: 8 4085 [meta][field] flags: 96 (UNSIGNED ZEROFILL ) 4086 [meta][field] decimals: 0 4087 [meta][field] type: YEAR (13) 4088 4089 [meta][field] db name: test1 4090 [meta][field] table name: test_inserts 4091 [meta][field] org table name: test_inserts 4092 [meta][field] col name: u 4093 [meta][field] org col name: u 4094 [meta][field] length: 6 4095 [meta][field] charsetnr: 8 4096 [meta][field] flags: 32 (UNSIGNED ) 4097 [meta][field] decimals: 2 4098 [meta][field] type: NEWDECIMAL (246) 4099 4100 [meta][field] db name: test1 4101 [meta][field] table name: test_inserts 4102 [meta][field] org table name: test_inserts 4103 [meta][field] col name: v 4104 [meta][field] org col name: v 4105 [meta][field] length: 7 4106 [meta][field] charsetnr: 8 4107 [meta][field] flags: 0 4108 [meta][field] decimals: 2 4109 [meta][field] type: NEWDECIMAL (246) 4110 4111 4112 [meta][charset result] number: 33 4113 [meta][charset result] name: utf8 4114 [meta][charset result] collation: utf8_general_ci 4115 [meta][charset result] sort order: 4116 4117 [data][test_inserts.a][ 1][1] 4118 [data][test_inserts.b][ 3][one] 4119 [data][test_inserts.c][ 4][1.23] 4120 [data][test_inserts.d][ 2][-1] 4121 [data][test_inserts.e][ 7][11.2323] 4122 [data][test_inserts.f][ 19][2014-07-06 07:06:05] 4123 [data][test_inserts.g][ 10][1980-02-19] 4124 [data][test_inserts.h][ 10][-830:12:23] 4125 [data][test_inserts.i][ 3][127] 4126 [data][test_inserts.k][ 3][255] 4127 [data][test_inserts.l][ 5][32767] 4128 [data][test_inserts.m][ 5][65535] 4129 [data][test_inserts.n][ 7][8388607] 4130 [data][test_inserts.o][ 8][16777215] 4131 [data][test_inserts.p][ 10][2147483647] 4132 [data][test_inserts.q][ 10][4294967295] 4133 [data][test_inserts.r][ 19][9223372036854775807] 4134 [data][test_inserts.s][ 20][18446744073709551615] 4135 [data][test_inserts.t][ 4][1901] 4136 [data][test_inserts.u][ 6][999.99] 4137 [data][test_inserts.v][ 7][-999.99] 4138 4139 [data][test_inserts.a][ 1][3] 4140 [data][test_inserts.b][ 5][three] 4141 [data][test_inserts.c][ 4][3.45] 4142 [data][test_inserts.d][ 2][-3] 4143 [data][test_inserts.e][ 7][33.4545] 4144 [data][test_inserts.f][ 19][2016-09-12 11:12:13] 4145 [data][test_inserts.g][ 10][2013-05-04] 4146 [data][test_inserts.h][ 9][821:33:44] 4147 [data][test_inserts.i][ 2][-1] 4148 [data][test_inserts.k][ 3][128] 4149 [data][test_inserts.l][ 2][-1] 4150 [data][test_inserts.m][ 5][65534] 4151 [data][test_inserts.n][ 2][-1] 4152 [data][test_inserts.o][ 8][16777214] 4153 [data][test_inserts.p][ 1][1] 4154 [data][test_inserts.q][ 1][2] 4155 [data][test_inserts.r][ 1][3] 4156 [data][test_inserts.s][ 1][4] 4157 [data][test_inserts.t][ 4][2155] 4158 [data][test_inserts.u][ 6][222.22] 4159 [data][test_inserts.v][ 7][-567.89] 4160 4161 [end] server status: 2 4162 [end] server status: AUTOCOMMIT 4163 [end] warning count: 0 4164 [end] affected rows: 0 4165 [end] last insert id: 0 4166 [end] message: 4167[CS_BINARY_REPRESENTATION] 4168 [meta] rows: 2 4169 [meta] cols: 21 4170 [meta] server status: 2 4171 [meta] server status: AUTOCOMMIT 4172 [meta] warning count: 0 4173 4174 [meta][field] db name: test1 4175 [meta][field] table name: test_inserts 4176 [meta][field] org table name: test_inserts 4177 [meta][field] col name: a 4178 [meta][field] org col name: a 4179 [meta][field] length: 10 4180 [meta][field] charsetnr: 8 4181 [meta][field] flags: 20515 (NOT_NULL PRI_KEY UNSIGNED NO_DEFAULT_VALUE PART_KEY ) 4182 [meta][field] decimals: 0 4183 [meta][field] type: LONG (3) 4184 4185 [meta][field] db name: test1 4186 [meta][field] table name: test_inserts 4187 [meta][field] org table name: test_inserts 4188 [meta][field] col name: b 4189 [meta][field] org col name: b 4190 [meta][field] length: 100 4191 [meta][field] charsetnr: 8 4192 [meta][field] flags: 0 4193 [meta][field] decimals: 0 4194 [meta][field] type: VARCHAR (15) 4195 4196 [meta][field] db name: test1 4197 [meta][field] table name: test_inserts 4198 [meta][field] org table name: test_inserts 4199 [meta][field] col name: c 4200 [meta][field] org col name: c 4201 [meta][field] length: 22 4202 [meta][field] charsetnr: 8 4203 [meta][field] flags: 0 4204 [meta][field] decimals: 31 4205 [meta][field] type: DOUBLE (5) 4206 4207 [meta][field] db name: test1 4208 [meta][field] table name: test_inserts 4209 [meta][field] org table name: test_inserts 4210 [meta][field] col name: d 4211 [meta][field] org col name: d 4212 [meta][field] length: 11 4213 [meta][field] charsetnr: 8 4214 [meta][field] flags: 16392 (MULTIPLE_KEY PART_KEY ) 4215 [meta][field] decimals: 0 4216 [meta][field] type: LONG (3) 4217 4218 [meta][field] db name: test1 4219 [meta][field] table name: test_inserts 4220 [meta][field] org table name: test_inserts 4221 [meta][field] col name: e 4222 [meta][field] org col name: e 4223 [meta][field] length: 12 4224 [meta][field] charsetnr: 8 4225 [meta][field] flags: 0 4226 [meta][field] decimals: 31 4227 [meta][field] type: FLOAT (4) 4228 4229 [meta][field] db name: test1 4230 [meta][field] table name: test_inserts 4231 [meta][field] org table name: test_inserts 4232 [meta][field] col name: f 4233 [meta][field] org col name: f 4234 [meta][field] length: 19 4235 [meta][field] charsetnr: 8 4236 [meta][field] flags: 128 (BINARY ) 4237 [meta][field] decimals: 0 4238 [meta][field] type: DATETIME (12) 4239 4240 [meta][field] db name: test1 4241 [meta][field] table name: test_inserts 4242 [meta][field] org table name: test_inserts 4243 [meta][field] col name: g 4244 [meta][field] org col name: g 4245 [meta][field] length: 10 4246 [meta][field] charsetnr: 8 4247 [meta][field] flags: 128 (BINARY ) 4248 [meta][field] decimals: 0 4249 [meta][field] type: DATE (10) 4250 4251 [meta][field] db name: test1 4252 [meta][field] table name: test_inserts 4253 [meta][field] org table name: test_inserts 4254 [meta][field] col name: h 4255 [meta][field] org col name: h 4256 [meta][field] length: 10 4257 [meta][field] charsetnr: 8 4258 [meta][field] flags: 128 (BINARY ) 4259 [meta][field] decimals: 0 4260 [meta][field] type: TIME (11) 4261 4262 [meta][field] db name: test1 4263 [meta][field] table name: test_inserts 4264 [meta][field] org table name: test_inserts 4265 [meta][field] col name: i 4266 [meta][field] org col name: i 4267 [meta][field] length: 4 4268 [meta][field] charsetnr: 8 4269 [meta][field] flags: 0 4270 [meta][field] decimals: 0 4271 [meta][field] type: TINY (1) 4272 4273 [meta][field] db name: test1 4274 [meta][field] table name: test_inserts 4275 [meta][field] org table name: test_inserts 4276 [meta][field] col name: k 4277 [meta][field] org col name: k 4278 [meta][field] length: 3 4279 [meta][field] charsetnr: 8 4280 [meta][field] flags: 32 (UNSIGNED ) 4281 [meta][field] decimals: 0 4282 [meta][field] type: TINY (1) 4283 4284 [meta][field] db name: test1 4285 [meta][field] table name: test_inserts 4286 [meta][field] org table name: test_inserts 4287 [meta][field] col name: l 4288 [meta][field] org col name: l 4289 [meta][field] length: 6 4290 [meta][field] charsetnr: 8 4291 [meta][field] flags: 0 4292 [meta][field] decimals: 0 4293 [meta][field] type: SHORT (2) 4294 4295 [meta][field] db name: test1 4296 [meta][field] table name: test_inserts 4297 [meta][field] org table name: test_inserts 4298 [meta][field] col name: m 4299 [meta][field] org col name: m 4300 [meta][field] length: 5 4301 [meta][field] charsetnr: 8 4302 [meta][field] flags: 32 (UNSIGNED ) 4303 [meta][field] decimals: 0 4304 [meta][field] type: SHORT (2) 4305 4306 [meta][field] db name: test1 4307 [meta][field] table name: test_inserts 4308 [meta][field] org table name: test_inserts 4309 [meta][field] col name: n 4310 [meta][field] org col name: n 4311 [meta][field] length: 9 4312 [meta][field] charsetnr: 8 4313 [meta][field] flags: 0 4314 [meta][field] decimals: 0 4315 [meta][field] type: INT24 (9) 4316 4317 [meta][field] db name: test1 4318 [meta][field] table name: test_inserts 4319 [meta][field] org table name: test_inserts 4320 [meta][field] col name: o 4321 [meta][field] org col name: o 4322 [meta][field] length: 8 4323 [meta][field] charsetnr: 8 4324 [meta][field] flags: 32 (UNSIGNED ) 4325 [meta][field] decimals: 0 4326 [meta][field] type: INT24 (9) 4327 4328 [meta][field] db name: test1 4329 [meta][field] table name: test_inserts 4330 [meta][field] org table name: test_inserts 4331 [meta][field] col name: p 4332 [meta][field] org col name: p 4333 [meta][field] length: 11 4334 [meta][field] charsetnr: 8 4335 [meta][field] flags: 0 4336 [meta][field] decimals: 0 4337 [meta][field] type: LONG (3) 4338 4339 [meta][field] db name: test1 4340 [meta][field] table name: test_inserts 4341 [meta][field] org table name: test_inserts 4342 [meta][field] col name: q 4343 [meta][field] org col name: q 4344 [meta][field] length: 10 4345 [meta][field] charsetnr: 8 4346 [meta][field] flags: 32 (UNSIGNED ) 4347 [meta][field] decimals: 0 4348 [meta][field] type: LONG (3) 4349 4350 [meta][field] db name: test1 4351 [meta][field] table name: test_inserts 4352 [meta][field] org table name: test_inserts 4353 [meta][field] col name: r 4354 [meta][field] org col name: r 4355 [meta][field] length: 20 4356 [meta][field] charsetnr: 8 4357 [meta][field] flags: 0 4358 [meta][field] decimals: 0 4359 [meta][field] type: LONGLONG (8) 4360 4361 [meta][field] db name: test1 4362 [meta][field] table name: test_inserts 4363 [meta][field] org table name: test_inserts 4364 [meta][field] col name: s 4365 [meta][field] org col name: s 4366 [meta][field] length: 20 4367 [meta][field] charsetnr: 8 4368 [meta][field] flags: 32 (UNSIGNED ) 4369 [meta][field] decimals: 0 4370 [meta][field] type: LONGLONG (8) 4371 4372 [meta][field] db name: test1 4373 [meta][field] table name: test_inserts 4374 [meta][field] org table name: test_inserts 4375 [meta][field] col name: t 4376 [meta][field] org col name: t 4377 [meta][field] length: 4 4378 [meta][field] charsetnr: 8 4379 [meta][field] flags: 96 (UNSIGNED ZEROFILL ) 4380 [meta][field] decimals: 0 4381 [meta][field] type: YEAR (13) 4382 4383 [meta][field] db name: test1 4384 [meta][field] table name: test_inserts 4385 [meta][field] org table name: test_inserts 4386 [meta][field] col name: u 4387 [meta][field] org col name: u 4388 [meta][field] length: 6 4389 [meta][field] charsetnr: 8 4390 [meta][field] flags: 32 (UNSIGNED ) 4391 [meta][field] decimals: 2 4392 [meta][field] type: NEWDECIMAL (246) 4393 4394 [meta][field] db name: test1 4395 [meta][field] table name: test_inserts 4396 [meta][field] org table name: test_inserts 4397 [meta][field] col name: v 4398 [meta][field] org col name: v 4399 [meta][field] length: 7 4400 [meta][field] charsetnr: 8 4401 [meta][field] flags: 0 4402 [meta][field] decimals: 2 4403 [meta][field] type: NEWDECIMAL (246) 4404 4405 4406 [meta][charset result] number: 33 4407 [meta][charset result] name: utf8 4408 [meta][charset result] collation: utf8_general_ci 4409 [meta][charset result] sort order: 4410 4411 [data][test_inserts.a][ 1][1] 4412 [data][test_inserts.b][ 3][one] 4413 [data][test_inserts.c][ 4][1.23] 4414 [data][test_inserts.d][ 2][-1] 4415 [data][test_inserts.e][ 7][11.2323] 4416 [data][test_inserts.f][ 19][2014-07-06 07:06:05] 4417 [data][test_inserts.g][ 10][1980-02-19] 4418 [data][test_inserts.h][ 10][-830:12:23] 4419 [data][test_inserts.i][ 3][127] 4420 [data][test_inserts.k][ 3][255] 4421 [data][test_inserts.l][ 5][32767] 4422 [data][test_inserts.m][ 5][65535] 4423 [data][test_inserts.n][ 7][8388607] 4424 [data][test_inserts.o][ 8][16777215] 4425 [data][test_inserts.p][ 10][2147483647] 4426 [data][test_inserts.q][ 10][4294967295] 4427 [data][test_inserts.r][ 19][9223372036854775807] 4428 [data][test_inserts.s][ 20][18446744073709551615] 4429 [data][test_inserts.t][ 4][1901] 4430 [data][test_inserts.u][ 6][999.99] 4431 [data][test_inserts.v][ 7][-999.99] 4432 4433 [data][test_inserts.a][ 1][3] 4434 [data][test_inserts.b][ 5][three] 4435 [data][test_inserts.c][ 4][3.45] 4436 [data][test_inserts.d][ 2][-3] 4437 [data][test_inserts.e][ 7][33.4545] 4438 [data][test_inserts.f][ 19][2016-09-12 11:12:13] 4439 [data][test_inserts.g][ 10][2013-05-04] 4440 [data][test_inserts.h][ 9][821:33:44] 4441 [data][test_inserts.i][ 2][-1] 4442 [data][test_inserts.k][ 3][128] 4443 [data][test_inserts.l][ 2][-1] 4444 [data][test_inserts.m][ 5][65534] 4445 [data][test_inserts.n][ 2][-1] 4446 [data][test_inserts.o][ 8][16777214] 4447 [data][test_inserts.p][ 1][1] 4448 [data][test_inserts.q][ 1][2] 4449 [data][test_inserts.r][ 1][3] 4450 [data][test_inserts.s][ 1][4] 4451 [data][test_inserts.t][ 4][2155] 4452 [data][test_inserts.u][ 6][222.22] 4453 [data][test_inserts.v][ 7][-567.89] 4454 4455 [end] server status: 2 4456 [end] server status: AUTOCOMMIT 4457 [end] warning count: 0 4458 [end] affected rows: 0 4459 [end] last insert id: 0 4460 [end] message: 4461------------------------------------------------------------------ 4462EXECUTING:[21][TRUNCATE test_inserts] 4463[CS_TEXT_REPRESENTATION] 4464 [meta] rows: 0 4465 [meta] cols: 0 4466 [meta] server status: 0 4467 [meta] server status: 4468 [meta] warning count: 0 4469 4470 [meta] no columns 4471 4472 [meta] no charset 4473 4474 [data] no rows 4475 4476 [end] server status: 2 4477 [end] server status: AUTOCOMMIT 4478 [end] warning count: 0 4479 [end] affected rows: 0 4480 [end] last insert id: 0 4481 [end] message: 4482------------------------------------------------------------------ 4483EXECUTING:[37][SELECT * FROM test_inserts ORDER BY a] 4484[CS_TEXT_REPRESENTATION] 4485 [meta] rows: 0 4486 [meta] cols: 21 4487 [meta] server status: 2 4488 [meta] server status: AUTOCOMMIT 4489 [meta] warning count: 0 4490 4491 [meta][field] db name: test1 4492 [meta][field] table name: test_inserts 4493 [meta][field] org table name: test_inserts 4494 [meta][field] col name: a 4495 [meta][field] org col name: a 4496 [meta][field] length: 10 4497 [meta][field] charsetnr: 8 4498 [meta][field] flags: 20515 (NOT_NULL PRI_KEY UNSIGNED NO_DEFAULT_VALUE PART_KEY ) 4499 [meta][field] decimals: 0 4500 [meta][field] type: LONG (3) 4501 4502 [meta][field] db name: test1 4503 [meta][field] table name: test_inserts 4504 [meta][field] org table name: test_inserts 4505 [meta][field] col name: b 4506 [meta][field] org col name: b 4507 [meta][field] length: 100 4508 [meta][field] charsetnr: 8 4509 [meta][field] flags: 0 4510 [meta][field] decimals: 0 4511 [meta][field] type: VARCHAR (15) 4512 4513 [meta][field] db name: test1 4514 [meta][field] table name: test_inserts 4515 [meta][field] org table name: test_inserts 4516 [meta][field] col name: c 4517 [meta][field] org col name: c 4518 [meta][field] length: 22 4519 [meta][field] charsetnr: 8 4520 [meta][field] flags: 0 4521 [meta][field] decimals: 31 4522 [meta][field] type: DOUBLE (5) 4523 4524 [meta][field] db name: test1 4525 [meta][field] table name: test_inserts 4526 [meta][field] org table name: test_inserts 4527 [meta][field] col name: d 4528 [meta][field] org col name: d 4529 [meta][field] length: 11 4530 [meta][field] charsetnr: 8 4531 [meta][field] flags: 16392 (MULTIPLE_KEY PART_KEY ) 4532 [meta][field] decimals: 0 4533 [meta][field] type: LONG (3) 4534 4535 [meta][field] db name: test1 4536 [meta][field] table name: test_inserts 4537 [meta][field] org table name: test_inserts 4538 [meta][field] col name: e 4539 [meta][field] org col name: e 4540 [meta][field] length: 12 4541 [meta][field] charsetnr: 8 4542 [meta][field] flags: 0 4543 [meta][field] decimals: 31 4544 [meta][field] type: FLOAT (4) 4545 4546 [meta][field] db name: test1 4547 [meta][field] table name: test_inserts 4548 [meta][field] org table name: test_inserts 4549 [meta][field] col name: f 4550 [meta][field] org col name: f 4551 [meta][field] length: 19 4552 [meta][field] charsetnr: 8 4553 [meta][field] flags: 128 (BINARY ) 4554 [meta][field] decimals: 0 4555 [meta][field] type: DATETIME (12) 4556 4557 [meta][field] db name: test1 4558 [meta][field] table name: test_inserts 4559 [meta][field] org table name: test_inserts 4560 [meta][field] col name: g 4561 [meta][field] org col name: g 4562 [meta][field] length: 10 4563 [meta][field] charsetnr: 8 4564 [meta][field] flags: 128 (BINARY ) 4565 [meta][field] decimals: 0 4566 [meta][field] type: DATE (10) 4567 4568 [meta][field] db name: test1 4569 [meta][field] table name: test_inserts 4570 [meta][field] org table name: test_inserts 4571 [meta][field] col name: h 4572 [meta][field] org col name: h 4573 [meta][field] length: 10 4574 [meta][field] charsetnr: 8 4575 [meta][field] flags: 128 (BINARY ) 4576 [meta][field] decimals: 0 4577 [meta][field] type: TIME (11) 4578 4579 [meta][field] db name: test1 4580 [meta][field] table name: test_inserts 4581 [meta][field] org table name: test_inserts 4582 [meta][field] col name: i 4583 [meta][field] org col name: i 4584 [meta][field] length: 4 4585 [meta][field] charsetnr: 8 4586 [meta][field] flags: 0 4587 [meta][field] decimals: 0 4588 [meta][field] type: TINY (1) 4589 4590 [meta][field] db name: test1 4591 [meta][field] table name: test_inserts 4592 [meta][field] org table name: test_inserts 4593 [meta][field] col name: k 4594 [meta][field] org col name: k 4595 [meta][field] length: 3 4596 [meta][field] charsetnr: 8 4597 [meta][field] flags: 32 (UNSIGNED ) 4598 [meta][field] decimals: 0 4599 [meta][field] type: TINY (1) 4600 4601 [meta][field] db name: test1 4602 [meta][field] table name: test_inserts 4603 [meta][field] org table name: test_inserts 4604 [meta][field] col name: l 4605 [meta][field] org col name: l 4606 [meta][field] length: 6 4607 [meta][field] charsetnr: 8 4608 [meta][field] flags: 0 4609 [meta][field] decimals: 0 4610 [meta][field] type: SHORT (2) 4611 4612 [meta][field] db name: test1 4613 [meta][field] table name: test_inserts 4614 [meta][field] org table name: test_inserts 4615 [meta][field] col name: m 4616 [meta][field] org col name: m 4617 [meta][field] length: 5 4618 [meta][field] charsetnr: 8 4619 [meta][field] flags: 32 (UNSIGNED ) 4620 [meta][field] decimals: 0 4621 [meta][field] type: SHORT (2) 4622 4623 [meta][field] db name: test1 4624 [meta][field] table name: test_inserts 4625 [meta][field] org table name: test_inserts 4626 [meta][field] col name: n 4627 [meta][field] org col name: n 4628 [meta][field] length: 9 4629 [meta][field] charsetnr: 8 4630 [meta][field] flags: 0 4631 [meta][field] decimals: 0 4632 [meta][field] type: INT24 (9) 4633 4634 [meta][field] db name: test1 4635 [meta][field] table name: test_inserts 4636 [meta][field] org table name: test_inserts 4637 [meta][field] col name: o 4638 [meta][field] org col name: o 4639 [meta][field] length: 8 4640 [meta][field] charsetnr: 8 4641 [meta][field] flags: 32 (UNSIGNED ) 4642 [meta][field] decimals: 0 4643 [meta][field] type: INT24 (9) 4644 4645 [meta][field] db name: test1 4646 [meta][field] table name: test_inserts 4647 [meta][field] org table name: test_inserts 4648 [meta][field] col name: p 4649 [meta][field] org col name: p 4650 [meta][field] length: 11 4651 [meta][field] charsetnr: 8 4652 [meta][field] flags: 0 4653 [meta][field] decimals: 0 4654 [meta][field] type: LONG (3) 4655 4656 [meta][field] db name: test1 4657 [meta][field] table name: test_inserts 4658 [meta][field] org table name: test_inserts 4659 [meta][field] col name: q 4660 [meta][field] org col name: q 4661 [meta][field] length: 10 4662 [meta][field] charsetnr: 8 4663 [meta][field] flags: 32 (UNSIGNED ) 4664 [meta][field] decimals: 0 4665 [meta][field] type: LONG (3) 4666 4667 [meta][field] db name: test1 4668 [meta][field] table name: test_inserts 4669 [meta][field] org table name: test_inserts 4670 [meta][field] col name: r 4671 [meta][field] org col name: r 4672 [meta][field] length: 20 4673 [meta][field] charsetnr: 8 4674 [meta][field] flags: 0 4675 [meta][field] decimals: 0 4676 [meta][field] type: LONGLONG (8) 4677 4678 [meta][field] db name: test1 4679 [meta][field] table name: test_inserts 4680 [meta][field] org table name: test_inserts 4681 [meta][field] col name: s 4682 [meta][field] org col name: s 4683 [meta][field] length: 20 4684 [meta][field] charsetnr: 8 4685 [meta][field] flags: 32 (UNSIGNED ) 4686 [meta][field] decimals: 0 4687 [meta][field] type: LONGLONG (8) 4688 4689 [meta][field] db name: test1 4690 [meta][field] table name: test_inserts 4691 [meta][field] org table name: test_inserts 4692 [meta][field] col name: t 4693 [meta][field] org col name: t 4694 [meta][field] length: 4 4695 [meta][field] charsetnr: 8 4696 [meta][field] flags: 96 (UNSIGNED ZEROFILL ) 4697 [meta][field] decimals: 0 4698 [meta][field] type: YEAR (13) 4699 4700 [meta][field] db name: test1 4701 [meta][field] table name: test_inserts 4702 [meta][field] org table name: test_inserts 4703 [meta][field] col name: u 4704 [meta][field] org col name: u 4705 [meta][field] length: 6 4706 [meta][field] charsetnr: 8 4707 [meta][field] flags: 32 (UNSIGNED ) 4708 [meta][field] decimals: 2 4709 [meta][field] type: NEWDECIMAL (246) 4710 4711 [meta][field] db name: test1 4712 [meta][field] table name: test_inserts 4713 [meta][field] org table name: test_inserts 4714 [meta][field] col name: v 4715 [meta][field] org col name: v 4716 [meta][field] length: 7 4717 [meta][field] charsetnr: 8 4718 [meta][field] flags: 0 4719 [meta][field] decimals: 2 4720 [meta][field] type: NEWDECIMAL (246) 4721 4722 4723 [meta][charset result] number: 33 4724 [meta][charset result] name: utf8 4725 [meta][charset result] collation: utf8_general_ci 4726 [meta][charset result] sort order: 4727 4728 [data] no rows 4729 4730 [end] server status: 2 4731 [end] server status: AUTOCOMMIT 4732 [end] warning count: 0 4733 [end] affected rows: 0 4734 [end] last insert id: 0 4735 [end] message: 4736[CS_BINARY_REPRESENTATION] 4737 [meta] rows: 0 4738 [meta] cols: 21 4739 [meta] server status: 2 4740 [meta] server status: AUTOCOMMIT 4741 [meta] warning count: 0 4742 4743 [meta][field] db name: test1 4744 [meta][field] table name: test_inserts 4745 [meta][field] org table name: test_inserts 4746 [meta][field] col name: a 4747 [meta][field] org col name: a 4748 [meta][field] length: 10 4749 [meta][field] charsetnr: 8 4750 [meta][field] flags: 20515 (NOT_NULL PRI_KEY UNSIGNED NO_DEFAULT_VALUE PART_KEY ) 4751 [meta][field] decimals: 0 4752 [meta][field] type: LONG (3) 4753 4754 [meta][field] db name: test1 4755 [meta][field] table name: test_inserts 4756 [meta][field] org table name: test_inserts 4757 [meta][field] col name: b 4758 [meta][field] org col name: b 4759 [meta][field] length: 100 4760 [meta][field] charsetnr: 8 4761 [meta][field] flags: 0 4762 [meta][field] decimals: 0 4763 [meta][field] type: VARCHAR (15) 4764 4765 [meta][field] db name: test1 4766 [meta][field] table name: test_inserts 4767 [meta][field] org table name: test_inserts 4768 [meta][field] col name: c 4769 [meta][field] org col name: c 4770 [meta][field] length: 22 4771 [meta][field] charsetnr: 8 4772 [meta][field] flags: 0 4773 [meta][field] decimals: 31 4774 [meta][field] type: DOUBLE (5) 4775 4776 [meta][field] db name: test1 4777 [meta][field] table name: test_inserts 4778 [meta][field] org table name: test_inserts 4779 [meta][field] col name: d 4780 [meta][field] org col name: d 4781 [meta][field] length: 11 4782 [meta][field] charsetnr: 8 4783 [meta][field] flags: 16392 (MULTIPLE_KEY PART_KEY ) 4784 [meta][field] decimals: 0 4785 [meta][field] type: LONG (3) 4786 4787 [meta][field] db name: test1 4788 [meta][field] table name: test_inserts 4789 [meta][field] org table name: test_inserts 4790 [meta][field] col name: e 4791 [meta][field] org col name: e 4792 [meta][field] length: 12 4793 [meta][field] charsetnr: 8 4794 [meta][field] flags: 0 4795 [meta][field] decimals: 31 4796 [meta][field] type: FLOAT (4) 4797 4798 [meta][field] db name: test1 4799 [meta][field] table name: test_inserts 4800 [meta][field] org table name: test_inserts 4801 [meta][field] col name: f 4802 [meta][field] org col name: f 4803 [meta][field] length: 19 4804 [meta][field] charsetnr: 8 4805 [meta][field] flags: 128 (BINARY ) 4806 [meta][field] decimals: 0 4807 [meta][field] type: DATETIME (12) 4808 4809 [meta][field] db name: test1 4810 [meta][field] table name: test_inserts 4811 [meta][field] org table name: test_inserts 4812 [meta][field] col name: g 4813 [meta][field] org col name: g 4814 [meta][field] length: 10 4815 [meta][field] charsetnr: 8 4816 [meta][field] flags: 128 (BINARY ) 4817 [meta][field] decimals: 0 4818 [meta][field] type: DATE (10) 4819 4820 [meta][field] db name: test1 4821 [meta][field] table name: test_inserts 4822 [meta][field] org table name: test_inserts 4823 [meta][field] col name: h 4824 [meta][field] org col name: h 4825 [meta][field] length: 10 4826 [meta][field] charsetnr: 8 4827 [meta][field] flags: 128 (BINARY ) 4828 [meta][field] decimals: 0 4829 [meta][field] type: TIME (11) 4830 4831 [meta][field] db name: test1 4832 [meta][field] table name: test_inserts 4833 [meta][field] org table name: test_inserts 4834 [meta][field] col name: i 4835 [meta][field] org col name: i 4836 [meta][field] length: 4 4837 [meta][field] charsetnr: 8 4838 [meta][field] flags: 0 4839 [meta][field] decimals: 0 4840 [meta][field] type: TINY (1) 4841 4842 [meta][field] db name: test1 4843 [meta][field] table name: test_inserts 4844 [meta][field] org table name: test_inserts 4845 [meta][field] col name: k 4846 [meta][field] org col name: k 4847 [meta][field] length: 3 4848 [meta][field] charsetnr: 8 4849 [meta][field] flags: 32 (UNSIGNED ) 4850 [meta][field] decimals: 0 4851 [meta][field] type: TINY (1) 4852 4853 [meta][field] db name: test1 4854 [meta][field] table name: test_inserts 4855 [meta][field] org table name: test_inserts 4856 [meta][field] col name: l 4857 [meta][field] org col name: l 4858 [meta][field] length: 6 4859 [meta][field] charsetnr: 8 4860 [meta][field] flags: 0 4861 [meta][field] decimals: 0 4862 [meta][field] type: SHORT (2) 4863 4864 [meta][field] db name: test1 4865 [meta][field] table name: test_inserts 4866 [meta][field] org table name: test_inserts 4867 [meta][field] col name: m 4868 [meta][field] org col name: m 4869 [meta][field] length: 5 4870 [meta][field] charsetnr: 8 4871 [meta][field] flags: 32 (UNSIGNED ) 4872 [meta][field] decimals: 0 4873 [meta][field] type: SHORT (2) 4874 4875 [meta][field] db name: test1 4876 [meta][field] table name: test_inserts 4877 [meta][field] org table name: test_inserts 4878 [meta][field] col name: n 4879 [meta][field] org col name: n 4880 [meta][field] length: 9 4881 [meta][field] charsetnr: 8 4882 [meta][field] flags: 0 4883 [meta][field] decimals: 0 4884 [meta][field] type: INT24 (9) 4885 4886 [meta][field] db name: test1 4887 [meta][field] table name: test_inserts 4888 [meta][field] org table name: test_inserts 4889 [meta][field] col name: o 4890 [meta][field] org col name: o 4891 [meta][field] length: 8 4892 [meta][field] charsetnr: 8 4893 [meta][field] flags: 32 (UNSIGNED ) 4894 [meta][field] decimals: 0 4895 [meta][field] type: INT24 (9) 4896 4897 [meta][field] db name: test1 4898 [meta][field] table name: test_inserts 4899 [meta][field] org table name: test_inserts 4900 [meta][field] col name: p 4901 [meta][field] org col name: p 4902 [meta][field] length: 11 4903 [meta][field] charsetnr: 8 4904 [meta][field] flags: 0 4905 [meta][field] decimals: 0 4906 [meta][field] type: LONG (3) 4907 4908 [meta][field] db name: test1 4909 [meta][field] table name: test_inserts 4910 [meta][field] org table name: test_inserts 4911 [meta][field] col name: q 4912 [meta][field] org col name: q 4913 [meta][field] length: 10 4914 [meta][field] charsetnr: 8 4915 [meta][field] flags: 32 (UNSIGNED ) 4916 [meta][field] decimals: 0 4917 [meta][field] type: LONG (3) 4918 4919 [meta][field] db name: test1 4920 [meta][field] table name: test_inserts 4921 [meta][field] org table name: test_inserts 4922 [meta][field] col name: r 4923 [meta][field] org col name: r 4924 [meta][field] length: 20 4925 [meta][field] charsetnr: 8 4926 [meta][field] flags: 0 4927 [meta][field] decimals: 0 4928 [meta][field] type: LONGLONG (8) 4929 4930 [meta][field] db name: test1 4931 [meta][field] table name: test_inserts 4932 [meta][field] org table name: test_inserts 4933 [meta][field] col name: s 4934 [meta][field] org col name: s 4935 [meta][field] length: 20 4936 [meta][field] charsetnr: 8 4937 [meta][field] flags: 32 (UNSIGNED ) 4938 [meta][field] decimals: 0 4939 [meta][field] type: LONGLONG (8) 4940 4941 [meta][field] db name: test1 4942 [meta][field] table name: test_inserts 4943 [meta][field] org table name: test_inserts 4944 [meta][field] col name: t 4945 [meta][field] org col name: t 4946 [meta][field] length: 4 4947 [meta][field] charsetnr: 8 4948 [meta][field] flags: 96 (UNSIGNED ZEROFILL ) 4949 [meta][field] decimals: 0 4950 [meta][field] type: YEAR (13) 4951 4952 [meta][field] db name: test1 4953 [meta][field] table name: test_inserts 4954 [meta][field] org table name: test_inserts 4955 [meta][field] col name: u 4956 [meta][field] org col name: u 4957 [meta][field] length: 6 4958 [meta][field] charsetnr: 8 4959 [meta][field] flags: 32 (UNSIGNED ) 4960 [meta][field] decimals: 2 4961 [meta][field] type: NEWDECIMAL (246) 4962 4963 [meta][field] db name: test1 4964 [meta][field] table name: test_inserts 4965 [meta][field] org table name: test_inserts 4966 [meta][field] col name: v 4967 [meta][field] org col name: v 4968 [meta][field] length: 7 4969 [meta][field] charsetnr: 8 4970 [meta][field] flags: 0 4971 [meta][field] decimals: 2 4972 [meta][field] type: NEWDECIMAL (246) 4973 4974 4975 [meta][charset result] number: 33 4976 [meta][charset result] name: utf8 4977 [meta][charset result] collation: utf8_general_ci 4978 [meta][charset result] sort order: 4979 4980 [data] no rows 4981 4982 [end] server status: 2 4983 [end] server status: AUTOCOMMIT 4984 [end] warning count: 0 4985 [end] affected rows: 0 4986 [end] last insert id: 0 4987 [end] message: 4988------------------------------------------------------------------ 4989EXECUTING:[27][PREPARE ps1 FROM 'select 1'] 4990[CS_TEXT_REPRESENTATION] 4991 [meta] rows: 0 4992 [meta] cols: 0 4993 [meta] server status: 0 4994 [meta] server status: 4995 [meta] warning count: 0 4996 4997 [meta] no columns 4998 4999 [meta] no charset 5000 5001 [data] no rows 5002 5003 [end] server status: 2 5004 [end] server status: AUTOCOMMIT 5005 [end] warning count: 0 5006 [end] affected rows: 0 5007 [end] last insert id: 0 5008 [end] message: Statement prepared 5009------------------------------------------------------------------ 5010EXECUTING:[11][EXECUTE ps1] 5011[CS_TEXT_REPRESENTATION] 5012 [meta] rows: 1 5013 [meta] cols: 1 5014 [meta] server status: 2 5015 [meta] server status: AUTOCOMMIT 5016 [meta] warning count: 0 5017 5018 [meta][field] db name: 5019 [meta][field] table name: 5020 [meta][field] org table name: 5021 [meta][field] col name: 1 5022 [meta][field] org col name: 5023 [meta][field] length: 1 5024 [meta][field] charsetnr: 8 5025 [meta][field] flags: 129 (NOT_NULL BINARY ) 5026 [meta][field] decimals: 0 5027 [meta][field] type: LONGLONG (8) 5028 5029 5030 [meta][charset result] number: 33 5031 [meta][charset result] name: utf8 5032 [meta][charset result] collation: utf8_general_ci 5033 [meta][charset result] sort order: 5034 5035 [data][.1][ 1][1] 5036 5037 [end] server status: 2 5038 [end] server status: AUTOCOMMIT 5039 [end] warning count: 0 5040 [end] affected rows: 0 5041 [end] last insert id: 0 5042 [end] message: 5043------------------------------------------------------------------ 5044EXECUTING:[22][DEALLOCATE PREPARE ps1] 5045[CS_TEXT_REPRESENTATION] 5046 [meta] rows: 0 5047 [meta] cols: 0 5048 [meta] server status: 0 5049 [meta] server status: 5050 [meta] warning count: 0 5051 5052 [meta] no columns 5053 5054 [meta] no charset 5055 5056 [data] no rows 5057 5058 [end] server status: 2 5059 [end] server status: AUTOCOMMIT 5060 [end] warning count: 0 5061 [end] affected rows: 0 5062 [end] last insert id: 0 5063 [end] message: 5064------------------------------------------------------------------ 5065EXECUTING:[24][CREATE TABLE tbl (a INT)] 5066[CS_TEXT_REPRESENTATION] 5067 [meta] rows: 0 5068 [meta] cols: 0 5069 [meta] server status: 0 5070 [meta] server status: 5071 [meta] warning count: 0 5072 5073 [meta] no columns 5074 5075 [meta] no charset 5076 5077 [data] no rows 5078 5079 [end] server status: 2 5080 [end] server status: AUTOCOMMIT 5081 [end] warning count: 0 5082 [end] affected rows: 0 5083 [end] last insert id: 0 5084 [end] message: 5085------------------------------------------------------------------ 5086EXECUTING:[55][PREPARE ps1 FROM 'INSERT INTO tbl VALUES (1), (2), (3)'] 5087[CS_TEXT_REPRESENTATION] 5088 [meta] rows: 0 5089 [meta] cols: 0 5090 [meta] server status: 0 5091 [meta] server status: 5092 [meta] warning count: 0 5093 5094 [meta] no columns 5095 5096 [meta] no charset 5097 5098 [data] no rows 5099 5100 [end] server status: 2 5101 [end] server status: AUTOCOMMIT 5102 [end] warning count: 0 5103 [end] affected rows: 0 5104 [end] last insert id: 0 5105 [end] message: Statement prepared 5106------------------------------------------------------------------ 5107EXECUTING:[11][EXECUTE ps1] 5108[CS_TEXT_REPRESENTATION] 5109 [meta] rows: 0 5110 [meta] cols: 0 5111 [meta] server status: 0 5112 [meta] server status: 5113 [meta] warning count: 0 5114 5115 [meta] no columns 5116 5117 [meta] no charset 5118 5119 [data] no rows 5120 5121 [end] server status: 2 5122 [end] server status: AUTOCOMMIT 5123 [end] warning count: 0 5124 [end] affected rows: 3 5125 [end] last insert id: 0 5126 [end] message: Records: 3 Duplicates: 0 Warnings: 0 5127------------------------------------------------------------------ 5128EXECUTING:[22][DEALLOCATE PREPARE ps1] 5129[CS_TEXT_REPRESENTATION] 5130 [meta] rows: 0 5131 [meta] cols: 0 5132 [meta] server status: 0 5133 [meta] server status: 5134 [meta] warning count: 0 5135 5136 [meta] no columns 5137 5138 [meta] no charset 5139 5140 [data] no rows 5141 5142 [end] server status: 2 5143 [end] server status: AUTOCOMMIT 5144 [end] warning count: 0 5145 [end] affected rows: 0 5146 [end] last insert id: 0 5147 [end] message: 5148------------------------------------------------------------------ 5149EXECUTING:[46][SELECT IF(SUM(a)=6, 'OK:)', 'FAIL:(') FROM tbl] 5150[CS_TEXT_REPRESENTATION] 5151 [meta] rows: 1 5152 [meta] cols: 1 5153 [meta] server status: 34 5154 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 5155 [meta] warning count: 0 5156 5157 [meta][field] db name: 5158 [meta][field] table name: 5159 [meta][field] org table name: 5160 [meta][field] col name: IF(SUM(a)=6, 'OK:)', 'FAIL:(') 5161 [meta][field] org col name: 5162 [meta][field] length: 18 5163 [meta][field] charsetnr: 33 5164 [meta][field] flags: 1 (NOT_NULL ) 5165 [meta][field] decimals: 31 5166 [meta][field] type: VARCHAR (15) 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][.IF(SUM(a)=6, 'OK:)', 'FAIL:(')][ 4][OK:)] 5175 5176 [end] server status: 34 5177 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 5178 [end] warning count: 0 5179 [end] affected rows: 0 5180 [end] last insert id: 0 5181 [end] message: 5182------------------------------------------------------------------ 5183EXECUTING:[22][DEALLOCATE PREPARE ps1] 5184[CS_TEXT_REPRESENTATION] 5185[1243][HY000][Unknown prepared statement handler (ps1) given to DEALLOCATE PREPARE] [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: 0 5198 [end] server status: 5199 [end] warning count: 0 5200 [end] affected rows: 0 5201 [end] last insert id: 0 5202 [end] message: 5203[CS_BINARY_REPRESENTATION] 5204[1243][HY000][Unknown prepared statement handler (ps1) given to DEALLOCATE PREPARE] [meta] rows: 0 5205 [meta] cols: 0 5206 [meta] server status: 0 5207 [meta] server status: 5208 [meta] warning count: 0 5209 5210 [meta] no columns 5211 5212 [meta] no charset 5213 5214 [data] no rows 5215 5216 [end] server status: 0 5217 [end] server status: 5218 [end] warning count: 0 5219 [end] affected rows: 0 5220 [end] last insert id: 0 5221 [end] message: 5222------------------------------------------------------------------ 5223EXECUTING:[7][garbage] 5224[CS_TEXT_REPRESENTATION] 5225[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 5226 [meta] cols: 0 5227 [meta] server status: 0 5228 [meta] server status: 5229 [meta] warning count: 0 5230 5231 [meta] no columns 5232 5233 [meta] no charset 5234 5235 [data] no rows 5236 5237 [end] server status: 0 5238 [end] server status: 5239 [end] warning count: 0 5240 [end] affected rows: 0 5241 [end] last insert id: 0 5242 [end] message: 5243[CS_BINARY_REPRESENTATION] 5244[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 5245 [meta] cols: 0 5246 [meta] server status: 0 5247 [meta] server status: 5248 [meta] warning count: 0 5249 5250 [meta] no columns 5251 5252 [meta] no charset 5253 5254 [data] no rows 5255 5256 [end] server status: 0 5257 [end] server status: 5258 [end] warning count: 0 5259 [end] affected rows: 0 5260 [end] last insert id: 0 5261 [end] message: 5262------------------------------------------------------------------ 5263EXECUTING:[17][SELECT b FROM tbl] 5264[CS_TEXT_REPRESENTATION] 5265[1054][42S22][Unknown column 'b' in 'field list'] [meta] rows: 0 5266 [meta] cols: 0 5267 [meta] server status: 0 5268 [meta] server status: 5269 [meta] warning count: 0 5270 5271 [meta] no columns 5272 5273 [meta] no charset 5274 5275 [data] no rows 5276 5277 [end] server status: 0 5278 [end] server status: 5279 [end] warning count: 0 5280 [end] affected rows: 0 5281 [end] last insert id: 0 5282 [end] message: 5283[CS_BINARY_REPRESENTATION] 5284[1054][42S22][Unknown column 'b' in 'field list'] [meta] rows: 0 5285 [meta] cols: 0 5286 [meta] server status: 0 5287 [meta] server status: 5288 [meta] warning count: 0 5289 5290 [meta] no columns 5291 5292 [meta] no charset 5293 5294 [data] no rows 5295 5296 [end] server status: 0 5297 [end] server status: 5298 [end] warning count: 0 5299 [end] affected rows: 0 5300 [end] last insert id: 0 5301 [end] message: 5302------------------------------------------------------------------ 5303EXECUTING:[43][ALTER USER bogus@remotehost PASSWORD EXPIRE] 5304[CS_TEXT_REPRESENTATION] 5305[1396][HY000][Operation ALTER USER failed for 'bogus'@'remotehost'] [meta] rows: 0 5306 [meta] cols: 0 5307 [meta] server status: 0 5308 [meta] server status: 5309 [meta] warning count: 0 5310 5311 [meta] no columns 5312 5313 [meta] no charset 5314 5315 [data] no rows 5316 5317 [end] server status: 0 5318 [end] server status: 5319 [end] warning count: 0 5320 [end] affected rows: 0 5321 [end] last insert id: 0 5322 [end] message: 5323[CS_BINARY_REPRESENTATION] 5324[1396][HY000][Operation ALTER USER failed for 'bogus'@'remotehost'] [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: 0 5337 [end] server status: 5338 [end] warning count: 0 5339 [end] affected rows: 0 5340 [end] last insert id: 0 5341 [end] message: 5342------------------------------------------------------------------ 5343EXECUTING:[26][CREATE TABLE tbld (d TIME)] 5344[CS_TEXT_REPRESENTATION] 5345 [meta] rows: 0 5346 [meta] cols: 0 5347 [meta] server status: 0 5348 [meta] server status: 5349 [meta] warning count: 0 5350 5351 [meta] no columns 5352 5353 [meta] no charset 5354 5355 [data] no rows 5356 5357 [end] server status: 2 5358 [end] server status: AUTOCOMMIT 5359 [end] warning count: 0 5360 [end] affected rows: 0 5361 [end] last insert id: 0 5362 [end] message: 5363------------------------------------------------------------------ 5364EXECUTING:[36][INSERT INTO tbld VALUES ('43141231')] 5365[CS_TEXT_REPRESENTATION] 5366[1292][22007][Incorrect time value: '43141231' for column 'd' at row 1] [meta] rows: 0 5367 [meta] cols: 0 5368 [meta] server status: 0 5369 [meta] server status: 5370 [meta] warning count: 0 5371 5372 [meta] no columns 5373 5374 [meta] no charset 5375 5376 [data] no rows 5377 5378 [end] server status: 0 5379 [end] server status: 5380 [end] warning count: 0 5381 [end] affected rows: 0 5382 [end] last insert id: 0 5383 [end] message: 5384[CS_BINARY_REPRESENTATION] 5385[1292][22007][Incorrect time value: '43141231' for column 'd' at row 1] [meta] rows: 0 5386 [meta] cols: 0 5387 [meta] server status: 0 5388 [meta] server status: 5389 [meta] warning count: 0 5390 5391 [meta] no columns 5392 5393 [meta] no charset 5394 5395 [data] no rows 5396 5397 [end] server status: 0 5398 [end] server status: 5399 [end] warning count: 0 5400 [end] affected rows: 0 5401 [end] last insert id: 0 5402 [end] message: 5403------------------------------------------------------------------ 5404EXECUTING:[10][SELECT 1/0] 5405[CS_TEXT_REPRESENTATION] 5406 [meta] rows: 1 5407 [meta] cols: 1 5408 [meta] server status: 2 5409 [meta] server status: AUTOCOMMIT 5410 [meta] warning count: 0 5411 5412 [meta][field] db name: 5413 [meta][field] table name: 5414 [meta][field] org table name: 5415 [meta][field] col name: 1/0 5416 [meta][field] org col name: 5417 [meta][field] length: 7 5418 [meta][field] charsetnr: 8 5419 [meta][field] flags: 128 (BINARY ) 5420 [meta][field] decimals: 4 5421 [meta][field] type: NEWDECIMAL (246) 5422 5423 5424 [meta][charset result] number: 33 5425 [meta][charset result] name: utf8 5426 [meta][charset result] collation: utf8_general_ci 5427 [meta][charset result] sort order: 5428 5429 [data][.1/0][ 6][[NULL]] 5430 5431 [end] server status: 2 5432 [end] server status: AUTOCOMMIT 5433 [end] warning count: 1 5434 [end] affected rows: 0 5435 [end] last insert id: 0 5436 [end] message: 5437------------------------------------------------------------------ 5438EXECUTING:[18][UPDATE tbl SET a=5] 5439[CS_TEXT_REPRESENTATION] 5440 [meta] rows: 0 5441 [meta] cols: 0 5442 [meta] server status: 0 5443 [meta] server status: 5444 [meta] warning count: 0 5445 5446 [meta] no columns 5447 5448 [meta] no charset 5449 5450 [data] no rows 5451 5452 [end] server status: 34 5453 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 5454 [end] warning count: 0 5455 [end] affected rows: 3 5456 [end] last insert id: 0 5457 [end] message: Rows matched: 3 Changed: 3 Warnings: 0 5458------------------------------------------------------------------ 5459EXECUTING:[17][START TRANSACTION] 5460[CS_TEXT_REPRESENTATION] 5461 [meta] rows: 0 5462 [meta] cols: 0 5463 [meta] server status: 0 5464 [meta] server status: 5465 [meta] warning count: 0 5466 5467 [meta] no columns 5468 5469 [meta] no charset 5470 5471 [data] no rows 5472 5473 [end] server status: 3 5474 [end] server status: IN_TRANS AUTOCOMMIT 5475 [end] warning count: 0 5476 [end] affected rows: 0 5477 [end] last insert id: 0 5478 [end] message: 5479------------------------------------------------------------------ 5480EXECUTING:[18][UPDATE tbl SET a=4] 5481[CS_TEXT_REPRESENTATION] 5482 [meta] rows: 0 5483 [meta] cols: 0 5484 [meta] server status: 0 5485 [meta] server status: 5486 [meta] warning count: 0 5487 5488 [meta] no columns 5489 5490 [meta] no charset 5491 5492 [data] no rows 5493 5494 [end] server status: 35 5495 [end] server status: IN_TRANS AUTOCOMMIT QUERY_NO_INDEX_USED 5496 [end] warning count: 0 5497 [end] affected rows: 3 5498 [end] last insert id: 0 5499 [end] message: Rows matched: 3 Changed: 3 Warnings: 0 5500------------------------------------------------------------------ 5501EXECUTING:[8][ROLLBACK] 5502[CS_TEXT_REPRESENTATION] 5503 [meta] rows: 0 5504 [meta] cols: 0 5505 [meta] server status: 0 5506 [meta] server status: 5507 [meta] warning count: 0 5508 5509 [meta] no columns 5510 5511 [meta] no charset 5512 5513 [data] no rows 5514 5515 [end] server status: 2 5516 [end] server status: AUTOCOMMIT 5517 [end] warning count: 0 5518 [end] affected rows: 0 5519 [end] last insert id: 0 5520 [end] message: 5521------------------------------------------------------------------ 5522EXECUTING:[45][SELECT IF(SUM(a) = 15, 'OK', 'FAIL') FROM tbl] 5523[CS_TEXT_REPRESENTATION] 5524 [meta] rows: 1 5525 [meta] cols: 1 5526 [meta] server status: 34 5527 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 5528 [meta] warning count: 0 5529 5530 [meta][field] db name: 5531 [meta][field] table name: 5532 [meta][field] org table name: 5533 [meta][field] col name: IF(SUM(a) = 15, 'OK', 'FAIL') 5534 [meta][field] org col name: 5535 [meta][field] length: 12 5536 [meta][field] charsetnr: 33 5537 [meta][field] flags: 1 (NOT_NULL ) 5538 [meta][field] decimals: 31 5539 [meta][field] type: VARCHAR (15) 5540 5541 5542 [meta][charset result] number: 33 5543 [meta][charset result] name: utf8 5544 [meta][charset result] collation: utf8_general_ci 5545 [meta][charset result] sort order: 5546 5547 [data][.IF(SUM(a) = 15, 'OK', 'FAIL')][ 2][OK] 5548 5549 [end] server status: 34 5550 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 5551 [end] warning count: 0 5552 [end] affected rows: 0 5553 [end] last insert id: 0 5554 [end] message: 5555------------------------------------------------------------------ 5556EXECUTING:[17][START TRANSACTION] 5557[CS_TEXT_REPRESENTATION] 5558 [meta] rows: 0 5559 [meta] cols: 0 5560 [meta] server status: 0 5561 [meta] server status: 5562 [meta] warning count: 0 5563 5564 [meta] no columns 5565 5566 [meta] no charset 5567 5568 [data] no rows 5569 5570 [end] server status: 3 5571 [end] server status: IN_TRANS AUTOCOMMIT 5572 [end] warning count: 0 5573 [end] affected rows: 0 5574 [end] last insert id: 0 5575 [end] message: 5576------------------------------------------------------------------ 5577EXECUTING:[18][UPDATE tbl SET a=4] 5578[CS_TEXT_REPRESENTATION] 5579 [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: 35 5592 [end] server status: IN_TRANS AUTOCOMMIT QUERY_NO_INDEX_USED 5593 [end] warning count: 0 5594 [end] affected rows: 3 5595 [end] last insert id: 0 5596 [end] message: Rows matched: 3 Changed: 3 Warnings: 0 5597------------------------------------------------------------------ 5598EXECUTING:[6][COMMIT] 5599[CS_TEXT_REPRESENTATION] 5600 [meta] rows: 0 5601 [meta] cols: 0 5602 [meta] server status: 0 5603 [meta] server status: 5604 [meta] warning count: 0 5605 5606 [meta] no columns 5607 5608 [meta] no charset 5609 5610 [data] no rows 5611 5612 [end] server status: 2 5613 [end] server status: AUTOCOMMIT 5614 [end] warning count: 0 5615 [end] affected rows: 0 5616 [end] last insert id: 0 5617 [end] message: 5618------------------------------------------------------------------ 5619EXECUTING:[45][SELECT IF(SUM(a) = 12, 'OK', 'FAIL') FROM tbl] 5620[CS_TEXT_REPRESENTATION] 5621 [meta] rows: 1 5622 [meta] cols: 1 5623 [meta] server status: 34 5624 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 5625 [meta] warning count: 0 5626 5627 [meta][field] db name: 5628 [meta][field] table name: 5629 [meta][field] org table name: 5630 [meta][field] col name: IF(SUM(a) = 12, 'OK', 'FAIL') 5631 [meta][field] org col name: 5632 [meta][field] length: 12 5633 [meta][field] charsetnr: 33 5634 [meta][field] flags: 1 (NOT_NULL ) 5635 [meta][field] decimals: 31 5636 [meta][field] type: VARCHAR (15) 5637 5638 5639 [meta][charset result] number: 33 5640 [meta][charset result] name: utf8 5641 [meta][charset result] collation: utf8_general_ci 5642 [meta][charset result] sort order: 5643 5644 [data][.IF(SUM(a) = 12, 'OK', 'FAIL')][ 2][OK] 5645 5646 [end] server status: 34 5647 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 5648 [end] warning count: 0 5649 [end] affected rows: 0 5650 [end] last insert id: 0 5651 [end] message: 5652------------------------------------------------------------------ 5653EXECUTING:[27][START TRANSACTION READ ONLY] 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: 8195 5668 [end] server status: IN_TRANS AUTOCOMMIT IN_TRANS_READONLY 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=2] 5675[CS_TEXT_REPRESENTATION] 5676[1792][25006][Cannot execute statement in a READ ONLY transaction.] [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: 0 5689 [end] server status: 5690 [end] warning count: 0 5691 [end] affected rows: 0 5692 [end] last insert id: 0 5693 [end] message: 5694------------------------------------------------------------------ 5695EXECUTING:[6][COMMIT] 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(4) = 12, '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(4) = 12, '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(4) = 12, '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:[16][SET autocommit=0] 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: 0 5765 [end] server status: 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=2] 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: 33 5786 [end] server status: IN_TRANS 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:[8][ROLLBACK] 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: 0 5807 [end] server status: 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(4) = 12, 'OK', 'FAIL') FROM tbl] 5814[CS_TEXT_REPRESENTATION] 5815 [meta] rows: 1 5816 [meta] cols: 1 5817 [meta] server status: 33 5818 [meta] server status: IN_TRANS 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(4) = 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(4) = 12, 'OK', 'FAIL')][ 2][OK] 5839 5840 [end] server status: 33 5841 [end] server status: IN_TRANS 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:[55][INSTALL PLUGIN plugin_name SONAME 'shared_library_name'] 5848[CS_TEXT_REPRESENTATION] 5849[3130][HY000][Command not supported by pluggable protocols] [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: 0 5862 [end] server status: 5863 [end] warning count: 0 5864 [end] affected rows: 0 5865 [end] last insert id: 0 5866 [end] message: 5867------------------------------------------------------------------ 5868EXECUTING:[28][UNINSTALL PLUGIN plugin_name] 5869[CS_TEXT_REPRESENTATION] 5870[3130][HY000][Command not supported by pluggable protocols] [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:[23][START GROUP_REPLICATION] 5890[CS_TEXT_REPRESENTATION] 5891[3130][HY000][Command not supported by pluggable protocols] [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: 0 5904 [end] server status: 5905 [end] warning count: 0 5906 [end] affected rows: 0 5907 [end] last insert id: 0 5908 [end] message: 5909------------------------------------------------------------------ 5910EXECUTING:[22][STOP GROUP_REPLICATION] 5911[CS_TEXT_REPRESENTATION] 5912[3130][HY000][Command not supported by pluggable protocols] [meta] rows: 0 5913 [meta] cols: 0 5914 [meta] server status: 0 5915 [meta] server status: 5916 [meta] warning count: 0 5917 5918 [meta] no columns 5919 5920 [meta] no charset 5921 5922 [data] no rows 5923 5924 [end] server status: 0 5925 [end] server status: 5926 [end] warning count: 0 5927 [end] affected rows: 0 5928 [end] last insert id: 0 5929 [end] message: 5930------------------------------------------------------------------ 5931EXECUTING:[0][] 5932[CS_TEXT_REPRESENTATION] 5933[1065][42000][Query was empty] [meta] rows: 0 5934 [meta] cols: 0 5935 [meta] server status: 0 5936 [meta] server status: 5937 [meta] warning count: 0 5938 5939 [meta] no columns 5940 5941 [meta] no charset 5942 5943 [data] no rows 5944 5945 [end] server status: 0 5946 [end] server status: 5947 [end] warning count: 0 5948 [end] affected rows: 0 5949 [end] last insert id: 0 5950 [end] message: 5951[CS_BINARY_REPRESENTATION] 5952[1065][42000][Query was empty] [meta] rows: 0 5953 [meta] cols: 0 5954 [meta] server status: 0 5955 [meta] server status: 5956 [meta] warning count: 0 5957 5958 [meta] no columns 5959 5960 [meta] no charset 5961 5962 [data] no rows 5963 5964 [end] server status: 0 5965 [end] server status: 5966 [end] warning count: 0 5967 [end] affected rows: 0 5968 [end] last insert id: 0 5969 [end] message: 5970------------------------------------------------------------------ 5971EXECUTING:[14][DROP TABLE tbl] 5972[CS_TEXT_REPRESENTATION] 5973 [meta] rows: 0 5974 [meta] cols: 0 5975 [meta] server status: 0 5976 [meta] server status: 5977 [meta] warning count: 0 5978 5979 [meta] no columns 5980 5981 [meta] no charset 5982 5983 [data] no rows 5984 5985 [end] server status: 0 5986 [end] server status: 5987 [end] warning count: 0 5988 [end] affected rows: 0 5989 [end] last insert id: 0 5990 [end] message: 5991------------------------------------------------------------------ 5992EXECUTING:[15][DROP TABLE tbld] 5993[CS_TEXT_REPRESENTATION] 5994 [meta] rows: 0 5995 [meta] cols: 0 5996 [meta] server status: 0 5997 [meta] server status: 5998 [meta] warning count: 0 5999 6000 [meta] no columns 6001 6002 [meta] no charset 6003 6004 [data] no rows 6005 6006 [end] server status: 0 6007 [end] server status: 6008 [end] warning count: 0 6009 [end] affected rows: 0 6010 [end] last insert id: 0 6011 [end] message: 6012------------------------------------------------------------------ 6013EXECUTING:[19][DROP DATABASE test1] 6014[CS_TEXT_REPRESENTATION] 6015 [meta] rows: 0 6016 [meta] cols: 0 6017 [meta] server status: 0 6018 [meta] server status: 6019 [meta] warning count: 0 6020 6021 [meta] no columns 6022 6023 [meta] no charset 6024 6025 [data] no rows 6026 6027 [end] server status: 256 6028 [end] server status: DB_DROPPED 6029 [end] warning count: 0 6030 [end] affected rows: 1 6031 [end] last insert id: 0 6032 [end] message: 6033------------------------------------------------------------------ 6034[srv_session_close] 6035deinit thread 6036------ cleanup --------------------------------------------------- 6037