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