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