1include/master-slave.inc 2Warnings: 3Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. 4Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 5[connection master] 6# Creating table t1 7CREATE TABLE t1(c1 INT NOT NULL, c2 INT); 8################################################################### 9# Run plugin 10################################################################### 11INSTALL PLUGIN test_sql_replication SONAME 'TEST_SQL_REPLICATION'; 12################################################################### 13# Stop plugin 14################################################################### 15UNINSTALL PLUGIN test_sql_replication; 16################################################################### 17# Plugin log 18################################################################### 19======================================================================== 20Test in a server thread 21[srv_session_open] 22======================================================================== 23EXECUTING:[35][SELECT 'first complex command' as a] 24[CS_TEXT_REPRESENTATION] 25 [meta] rows: 1 26 [meta] cols: 1 27 [meta] server status: 2 28 [meta] server status: AUTOCOMMIT 29 [meta] warning count: 0 30 31 [meta][field] db name: 32 [meta][field] table name: 33 [meta][field] org table name: 34 [meta][field] col name: a 35 [meta][field] org col name: 36 [meta][field] length: 63 37 [meta][field] charsetnr: 33 38 [meta][field] flags: 1 (NOT_NULL ) 39 [meta][field] decimals: 31 40 [meta][field] type: VARCHAR (15) 41 42 43 [meta][charset result] number: 33 44 [meta][charset result] name: utf8 45 [meta][charset result] collation: utf8_general_ci 46 [meta][charset result] sort order: 47 48 [data][.a][ 21][first complex command] 49 50 [end] server status: 2 51 [end] server status: AUTOCOMMIT 52 [end] warning count: 0 53 [end] affected rows: 0 54 [end] last insert id: 0 55 [end] message: 56[CS_BINARY_REPRESENTATION] 57 [meta] rows: 1 58 [meta] cols: 1 59 [meta] server status: 2 60 [meta] server status: AUTOCOMMIT 61 [meta] warning count: 0 62 63 [meta][field] db name: 64 [meta][field] table name: 65 [meta][field] org table name: 66 [meta][field] col name: a 67 [meta][field] org col name: 68 [meta][field] length: 63 69 [meta][field] charsetnr: 33 70 [meta][field] flags: 1 (NOT_NULL ) 71 [meta][field] decimals: 31 72 [meta][field] type: VARCHAR (15) 73 74 75 [meta][charset result] number: 33 76 [meta][charset result] name: utf8 77 [meta][charset result] collation: utf8_general_ci 78 [meta][charset result] sort order: 79 80 [data][.a][ 21][first complex command] 81 82 [end] server status: 2 83 [end] server status: AUTOCOMMIT 84 [end] warning count: 0 85 [end] affected rows: 0 86 [end] last insert id: 0 87 [end] message: 88======================================================================== 89EXECUTING:[COM_INIT_DB][test] 90======================================================================== 91EXECUTING:[62][INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,1), (5,2), (6,3)] 92[CS_TEXT_REPRESENTATION] 93 [meta] rows: 0 94 [meta] cols: 0 95 [meta] server status: 0 96 [meta] server status: 97 [meta] warning count: 0 98 99 [meta] no columns 100 101 [meta] no charset 102 103 [data] no rows 104 105 [end] server status: 2 106 [end] server status: AUTOCOMMIT 107 [end] warning count: 0 108 [end] affected rows: 6 109 [end] last insert id: 0 110 [end] message: Records: 6 Duplicates: 0 Warnings: 0 111======================================================================== 112EXECUTING:[COM_INIT_DB][test] 113======================================================================== 114EXECUTING:[16][SELECT * FROM t1] 115[CS_TEXT_REPRESENTATION] 116 [meta] rows: 6 117 [meta] cols: 2 118 [meta] server status: 34 119 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 120 [meta] warning count: 0 121 122 [meta][field] db name: test 123 [meta][field] table name: t1 124 [meta][field] org table name: t1 125 [meta][field] col name: c1 126 [meta][field] org col name: c1 127 [meta][field] length: 11 128 [meta][field] charsetnr: 8 129 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) 130 [meta][field] decimals: 0 131 [meta][field] type: LONG (3) 132 133 [meta][field] db name: test 134 [meta][field] table name: t1 135 [meta][field] org table name: t1 136 [meta][field] col name: c2 137 [meta][field] org col name: c2 138 [meta][field] length: 11 139 [meta][field] charsetnr: 8 140 [meta][field] flags: 0 141 [meta][field] decimals: 0 142 [meta][field] type: LONG (3) 143 144 145 [meta][charset result] number: 33 146 [meta][charset result] name: utf8 147 [meta][charset result] collation: utf8_general_ci 148 [meta][charset result] sort order: 149 150 [data][t1.c1][ 1][1] 151 [data][t1.c2][ 1][1] 152 153 [data][t1.c1][ 1][2] 154 [data][t1.c2][ 1][2] 155 156 [data][t1.c1][ 1][3] 157 [data][t1.c2][ 1][3] 158 159 [data][t1.c1][ 1][4] 160 [data][t1.c2][ 1][1] 161 162 [data][t1.c1][ 1][5] 163 [data][t1.c2][ 1][2] 164 165 [data][t1.c1][ 1][6] 166 [data][t1.c2][ 1][3] 167 168 [end] server status: 34 169 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 170 [end] warning count: 0 171 [end] affected rows: 0 172 [end] last insert id: 0 173 [end] message: 174[CS_BINARY_REPRESENTATION] 175 [meta] rows: 6 176 [meta] cols: 2 177 [meta] server status: 34 178 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 179 [meta] warning count: 0 180 181 [meta][field] db name: test 182 [meta][field] table name: t1 183 [meta][field] org table name: t1 184 [meta][field] col name: c1 185 [meta][field] org col name: c1 186 [meta][field] length: 11 187 [meta][field] charsetnr: 8 188 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) 189 [meta][field] decimals: 0 190 [meta][field] type: LONG (3) 191 192 [meta][field] db name: test 193 [meta][field] table name: t1 194 [meta][field] org table name: t1 195 [meta][field] col name: c2 196 [meta][field] org col name: c2 197 [meta][field] length: 11 198 [meta][field] charsetnr: 8 199 [meta][field] flags: 0 200 [meta][field] decimals: 0 201 [meta][field] type: LONG (3) 202 203 204 [meta][charset result] number: 33 205 [meta][charset result] name: utf8 206 [meta][charset result] collation: utf8_general_ci 207 [meta][charset result] sort order: 208 209 [data][t1.c1][ 1][1] 210 [data][t1.c2][ 1][1] 211 212 [data][t1.c1][ 1][2] 213 [data][t1.c2][ 1][2] 214 215 [data][t1.c1][ 1][3] 216 [data][t1.c2][ 1][3] 217 218 [data][t1.c1][ 1][4] 219 [data][t1.c2][ 1][1] 220 221 [data][t1.c1][ 1][5] 222 [data][t1.c2][ 1][2] 223 224 [data][t1.c1][ 1][6] 225 [data][t1.c2][ 1][3] 226 227 [end] server status: 34 228 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 229 [end] warning count: 0 230 [end] affected rows: 0 231 [end] last insert id: 0 232 [end] message: 233======================================================================== 234EXECUTING:[COM_INIT_DB][test] 235======================================================================== 236EXECUTING:[35][UPDATE t1 SET c1 = 100 WHERE c2 = 2] 237[CS_TEXT_REPRESENTATION] 238 [meta] rows: 0 239 [meta] cols: 0 240 [meta] server status: 0 241 [meta] server status: 242 [meta] warning count: 0 243 244 [meta] no columns 245 246 [meta] no charset 247 248 [data] no rows 249 250 [end] server status: 34 251 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 252 [end] warning count: 0 253 [end] affected rows: 2 254 [end] last insert id: 0 255 [end] message: Rows matched: 2 Changed: 2 Warnings: 0 256======================================================================== 257EXECUTING:[COM_INIT_DB][test] 258======================================================================== 259EXECUTING:[16][SELECT * FROM t1] 260[CS_TEXT_REPRESENTATION] 261 [meta] rows: 6 262 [meta] cols: 2 263 [meta] server status: 34 264 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 265 [meta] warning count: 0 266 267 [meta][field] db name: test 268 [meta][field] table name: t1 269 [meta][field] org table name: t1 270 [meta][field] col name: c1 271 [meta][field] org col name: c1 272 [meta][field] length: 11 273 [meta][field] charsetnr: 8 274 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) 275 [meta][field] decimals: 0 276 [meta][field] type: LONG (3) 277 278 [meta][field] db name: test 279 [meta][field] table name: t1 280 [meta][field] org table name: t1 281 [meta][field] col name: c2 282 [meta][field] org col name: c2 283 [meta][field] length: 11 284 [meta][field] charsetnr: 8 285 [meta][field] flags: 0 286 [meta][field] decimals: 0 287 [meta][field] type: LONG (3) 288 289 290 [meta][charset result] number: 33 291 [meta][charset result] name: utf8 292 [meta][charset result] collation: utf8_general_ci 293 [meta][charset result] sort order: 294 295 [data][t1.c1][ 1][1] 296 [data][t1.c2][ 1][1] 297 298 [data][t1.c1][ 3][100] 299 [data][t1.c2][ 1][2] 300 301 [data][t1.c1][ 1][3] 302 [data][t1.c2][ 1][3] 303 304 [data][t1.c1][ 1][4] 305 [data][t1.c2][ 1][1] 306 307 [data][t1.c1][ 3][100] 308 [data][t1.c2][ 1][2] 309 310 [data][t1.c1][ 1][6] 311 [data][t1.c2][ 1][3] 312 313 [end] server status: 34 314 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 315 [end] warning count: 0 316 [end] affected rows: 0 317 [end] last insert id: 0 318 [end] message: 319[CS_BINARY_REPRESENTATION] 320 [meta] rows: 6 321 [meta] cols: 2 322 [meta] server status: 34 323 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 324 [meta] warning count: 0 325 326 [meta][field] db name: test 327 [meta][field] table name: t1 328 [meta][field] org table name: t1 329 [meta][field] col name: c1 330 [meta][field] org col name: c1 331 [meta][field] length: 11 332 [meta][field] charsetnr: 8 333 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) 334 [meta][field] decimals: 0 335 [meta][field] type: LONG (3) 336 337 [meta][field] db name: test 338 [meta][field] table name: t1 339 [meta][field] org table name: t1 340 [meta][field] col name: c2 341 [meta][field] org col name: c2 342 [meta][field] length: 11 343 [meta][field] charsetnr: 8 344 [meta][field] flags: 0 345 [meta][field] decimals: 0 346 [meta][field] type: LONG (3) 347 348 349 [meta][charset result] number: 33 350 [meta][charset result] name: utf8 351 [meta][charset result] collation: utf8_general_ci 352 [meta][charset result] sort order: 353 354 [data][t1.c1][ 1][1] 355 [data][t1.c2][ 1][1] 356 357 [data][t1.c1][ 3][100] 358 [data][t1.c2][ 1][2] 359 360 [data][t1.c1][ 1][3] 361 [data][t1.c2][ 1][3] 362 363 [data][t1.c1][ 1][4] 364 [data][t1.c2][ 1][1] 365 366 [data][t1.c1][ 3][100] 367 [data][t1.c2][ 1][2] 368 369 [data][t1.c1][ 1][6] 370 [data][t1.c2][ 1][3] 371 372 [end] server status: 34 373 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 374 [end] warning count: 0 375 [end] affected rows: 0 376 [end] last insert id: 0 377 [end] message: 378======================================================================== 379[srv_session_close] 380Follows threaded run 381======================================================================== 382init thread 383[srv_session_open] 384======================================================================== 385EXECUTING:[35][SELECT 'first complex command' as a] 386[CS_TEXT_REPRESENTATION] 387 [meta] rows: 1 388 [meta] cols: 1 389 [meta] server status: 2 390 [meta] server status: AUTOCOMMIT 391 [meta] warning count: 0 392 393 [meta][field] db name: 394 [meta][field] table name: 395 [meta][field] org table name: 396 [meta][field] col name: a 397 [meta][field] org col name: 398 [meta][field] length: 63 399 [meta][field] charsetnr: 33 400 [meta][field] flags: 1 (NOT_NULL ) 401 [meta][field] decimals: 31 402 [meta][field] type: VARCHAR (15) 403 404 405 [meta][charset result] number: 33 406 [meta][charset result] name: utf8 407 [meta][charset result] collation: utf8_general_ci 408 [meta][charset result] sort order: 409 410 [data][.a][ 21][first complex command] 411 412 [end] server status: 2 413 [end] server status: AUTOCOMMIT 414 [end] warning count: 0 415 [end] affected rows: 0 416 [end] last insert id: 0 417 [end] message: 418[CS_BINARY_REPRESENTATION] 419 [meta] rows: 1 420 [meta] cols: 1 421 [meta] server status: 2 422 [meta] server status: AUTOCOMMIT 423 [meta] warning count: 0 424 425 [meta][field] db name: 426 [meta][field] table name: 427 [meta][field] org table name: 428 [meta][field] col name: a 429 [meta][field] org col name: 430 [meta][field] length: 63 431 [meta][field] charsetnr: 33 432 [meta][field] flags: 1 (NOT_NULL ) 433 [meta][field] decimals: 31 434 [meta][field] type: VARCHAR (15) 435 436 437 [meta][charset result] number: 33 438 [meta][charset result] name: utf8 439 [meta][charset result] collation: utf8_general_ci 440 [meta][charset result] sort order: 441 442 [data][.a][ 21][first complex command] 443 444 [end] server status: 2 445 [end] server status: AUTOCOMMIT 446 [end] warning count: 0 447 [end] affected rows: 0 448 [end] last insert id: 0 449 [end] message: 450======================================================================== 451EXECUTING:[COM_INIT_DB][test] 452======================================================================== 453EXECUTING:[62][INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,1), (5,2), (6,3)] 454[CS_TEXT_REPRESENTATION] 455 [meta] rows: 0 456 [meta] cols: 0 457 [meta] server status: 0 458 [meta] server status: 459 [meta] warning count: 0 460 461 [meta] no columns 462 463 [meta] no charset 464 465 [data] no rows 466 467 [end] server status: 2 468 [end] server status: AUTOCOMMIT 469 [end] warning count: 0 470 [end] affected rows: 6 471 [end] last insert id: 0 472 [end] message: Records: 6 Duplicates: 0 Warnings: 0 473======================================================================== 474EXECUTING:[COM_INIT_DB][test] 475======================================================================== 476EXECUTING:[16][SELECT * FROM t1] 477[CS_TEXT_REPRESENTATION] 478 [meta] rows: 12 479 [meta] cols: 2 480 [meta] server status: 34 481 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 482 [meta] warning count: 0 483 484 [meta][field] db name: test 485 [meta][field] table name: t1 486 [meta][field] org table name: t1 487 [meta][field] col name: c1 488 [meta][field] org col name: c1 489 [meta][field] length: 11 490 [meta][field] charsetnr: 8 491 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) 492 [meta][field] decimals: 0 493 [meta][field] type: LONG (3) 494 495 [meta][field] db name: test 496 [meta][field] table name: t1 497 [meta][field] org table name: t1 498 [meta][field] col name: c2 499 [meta][field] org col name: c2 500 [meta][field] length: 11 501 [meta][field] charsetnr: 8 502 [meta][field] flags: 0 503 [meta][field] decimals: 0 504 [meta][field] type: LONG (3) 505 506 507 [meta][charset result] number: 33 508 [meta][charset result] name: utf8 509 [meta][charset result] collation: utf8_general_ci 510 [meta][charset result] sort order: 511 512 [data][t1.c1][ 1][1] 513 [data][t1.c2][ 1][1] 514 515 [data][t1.c1][ 3][100] 516 [data][t1.c2][ 1][2] 517 518 [data][t1.c1][ 1][3] 519 [data][t1.c2][ 1][3] 520 521 [data][t1.c1][ 1][4] 522 [data][t1.c2][ 1][1] 523 524 [data][t1.c1][ 3][100] 525 [data][t1.c2][ 1][2] 526 527 [data][t1.c1][ 1][6] 528 [data][t1.c2][ 1][3] 529 530 [data][t1.c1][ 1][1] 531 [data][t1.c2][ 1][1] 532 533 [data][t1.c1][ 1][2] 534 [data][t1.c2][ 1][2] 535 536 [data][t1.c1][ 1][3] 537 [data][t1.c2][ 1][3] 538 539 [data][t1.c1][ 1][4] 540 [data][t1.c2][ 1][1] 541 542 [data][t1.c1][ 1][5] 543 [data][t1.c2][ 1][2] 544 545 [data][t1.c1][ 1][6] 546 [data][t1.c2][ 1][3] 547 548 [end] server status: 34 549 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 550 [end] warning count: 0 551 [end] affected rows: 0 552 [end] last insert id: 0 553 [end] message: 554[CS_BINARY_REPRESENTATION] 555 [meta] rows: 12 556 [meta] cols: 2 557 [meta] server status: 34 558 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 559 [meta] warning count: 0 560 561 [meta][field] db name: test 562 [meta][field] table name: t1 563 [meta][field] org table name: t1 564 [meta][field] col name: c1 565 [meta][field] org col name: c1 566 [meta][field] length: 11 567 [meta][field] charsetnr: 8 568 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) 569 [meta][field] decimals: 0 570 [meta][field] type: LONG (3) 571 572 [meta][field] db name: test 573 [meta][field] table name: t1 574 [meta][field] org table name: t1 575 [meta][field] col name: c2 576 [meta][field] org col name: c2 577 [meta][field] length: 11 578 [meta][field] charsetnr: 8 579 [meta][field] flags: 0 580 [meta][field] decimals: 0 581 [meta][field] type: LONG (3) 582 583 584 [meta][charset result] number: 33 585 [meta][charset result] name: utf8 586 [meta][charset result] collation: utf8_general_ci 587 [meta][charset result] sort order: 588 589 [data][t1.c1][ 1][1] 590 [data][t1.c2][ 1][1] 591 592 [data][t1.c1][ 3][100] 593 [data][t1.c2][ 1][2] 594 595 [data][t1.c1][ 1][3] 596 [data][t1.c2][ 1][3] 597 598 [data][t1.c1][ 1][4] 599 [data][t1.c2][ 1][1] 600 601 [data][t1.c1][ 3][100] 602 [data][t1.c2][ 1][2] 603 604 [data][t1.c1][ 1][6] 605 [data][t1.c2][ 1][3] 606 607 [data][t1.c1][ 1][1] 608 [data][t1.c2][ 1][1] 609 610 [data][t1.c1][ 1][2] 611 [data][t1.c2][ 1][2] 612 613 [data][t1.c1][ 1][3] 614 [data][t1.c2][ 1][3] 615 616 [data][t1.c1][ 1][4] 617 [data][t1.c2][ 1][1] 618 619 [data][t1.c1][ 1][5] 620 [data][t1.c2][ 1][2] 621 622 [data][t1.c1][ 1][6] 623 [data][t1.c2][ 1][3] 624 625 [end] server status: 34 626 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 627 [end] warning count: 0 628 [end] affected rows: 0 629 [end] last insert id: 0 630 [end] message: 631======================================================================== 632EXECUTING:[COM_INIT_DB][test] 633======================================================================== 634EXECUTING:[35][UPDATE t1 SET c1 = 100 WHERE c2 = 2] 635[CS_TEXT_REPRESENTATION] 636 [meta] rows: 0 637 [meta] cols: 0 638 [meta] server status: 0 639 [meta] server status: 640 [meta] warning count: 0 641 642 [meta] no columns 643 644 [meta] no charset 645 646 [data] no rows 647 648 [end] server status: 34 649 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 650 [end] warning count: 0 651 [end] affected rows: 2 652 [end] last insert id: 0 653 [end] message: Rows matched: 4 Changed: 2 Warnings: 0 654======================================================================== 655EXECUTING:[COM_INIT_DB][test] 656======================================================================== 657EXECUTING:[16][SELECT * FROM t1] 658[CS_TEXT_REPRESENTATION] 659 [meta] rows: 12 660 [meta] cols: 2 661 [meta] server status: 34 662 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 663 [meta] warning count: 0 664 665 [meta][field] db name: test 666 [meta][field] table name: t1 667 [meta][field] org table name: t1 668 [meta][field] col name: c1 669 [meta][field] org col name: c1 670 [meta][field] length: 11 671 [meta][field] charsetnr: 8 672 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) 673 [meta][field] decimals: 0 674 [meta][field] type: LONG (3) 675 676 [meta][field] db name: test 677 [meta][field] table name: t1 678 [meta][field] org table name: t1 679 [meta][field] col name: c2 680 [meta][field] org col name: c2 681 [meta][field] length: 11 682 [meta][field] charsetnr: 8 683 [meta][field] flags: 0 684 [meta][field] decimals: 0 685 [meta][field] type: LONG (3) 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][t1.c1][ 1][1] 694 [data][t1.c2][ 1][1] 695 696 [data][t1.c1][ 3][100] 697 [data][t1.c2][ 1][2] 698 699 [data][t1.c1][ 1][3] 700 [data][t1.c2][ 1][3] 701 702 [data][t1.c1][ 1][4] 703 [data][t1.c2][ 1][1] 704 705 [data][t1.c1][ 3][100] 706 [data][t1.c2][ 1][2] 707 708 [data][t1.c1][ 1][6] 709 [data][t1.c2][ 1][3] 710 711 [data][t1.c1][ 1][1] 712 [data][t1.c2][ 1][1] 713 714 [data][t1.c1][ 3][100] 715 [data][t1.c2][ 1][2] 716 717 [data][t1.c1][ 1][3] 718 [data][t1.c2][ 1][3] 719 720 [data][t1.c1][ 1][4] 721 [data][t1.c2][ 1][1] 722 723 [data][t1.c1][ 3][100] 724 [data][t1.c2][ 1][2] 725 726 [data][t1.c1][ 1][6] 727 [data][t1.c2][ 1][3] 728 729 [end] server status: 34 730 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 731 [end] warning count: 0 732 [end] affected rows: 0 733 [end] last insert id: 0 734 [end] message: 735[CS_BINARY_REPRESENTATION] 736 [meta] rows: 12 737 [meta] cols: 2 738 [meta] server status: 34 739 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 740 [meta] warning count: 0 741 742 [meta][field] db name: test 743 [meta][field] table name: t1 744 [meta][field] org table name: t1 745 [meta][field] col name: c1 746 [meta][field] org col name: c1 747 [meta][field] length: 11 748 [meta][field] charsetnr: 8 749 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) 750 [meta][field] decimals: 0 751 [meta][field] type: LONG (3) 752 753 [meta][field] db name: test 754 [meta][field] table name: t1 755 [meta][field] org table name: t1 756 [meta][field] col name: c2 757 [meta][field] org col name: c2 758 [meta][field] length: 11 759 [meta][field] charsetnr: 8 760 [meta][field] flags: 0 761 [meta][field] decimals: 0 762 [meta][field] type: LONG (3) 763 764 765 [meta][charset result] number: 33 766 [meta][charset result] name: utf8 767 [meta][charset result] collation: utf8_general_ci 768 [meta][charset result] sort order: 769 770 [data][t1.c1][ 1][1] 771 [data][t1.c2][ 1][1] 772 773 [data][t1.c1][ 3][100] 774 [data][t1.c2][ 1][2] 775 776 [data][t1.c1][ 1][3] 777 [data][t1.c2][ 1][3] 778 779 [data][t1.c1][ 1][4] 780 [data][t1.c2][ 1][1] 781 782 [data][t1.c1][ 3][100] 783 [data][t1.c2][ 1][2] 784 785 [data][t1.c1][ 1][6] 786 [data][t1.c2][ 1][3] 787 788 [data][t1.c1][ 1][1] 789 [data][t1.c2][ 1][1] 790 791 [data][t1.c1][ 3][100] 792 [data][t1.c2][ 1][2] 793 794 [data][t1.c1][ 1][3] 795 [data][t1.c2][ 1][3] 796 797 [data][t1.c1][ 1][4] 798 [data][t1.c2][ 1][1] 799 800 [data][t1.c1][ 3][100] 801 [data][t1.c2][ 1][2] 802 803 [data][t1.c1][ 1][6] 804 [data][t1.c2][ 1][3] 805 806 [end] server status: 34 807 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 808 [end] warning count: 0 809 [end] affected rows: 0 810 [end] last insert id: 0 811 [end] message: 812======================================================================== 813[srv_session_close] 814deinit thread 815SELECT * FROM t1; 816c1 c2 8171 1 818100 2 8193 3 8204 1 821100 2 8226 3 8231 1 824100 2 8253 3 8264 1 827100 2 8286 3 829include/sync_slave_sql_with_master.inc 830[Connection Slave] 831SELECT * FROM t1; 832c1 c2 8331 1 834100 2 8353 3 8364 1 837100 2 8386 3 8391 1 840100 2 8413 3 8424 1 843100 2 8446 3 845[Connection Master] 846################################################################### 847# Run plugin 848################################################################### 849INSTALL PLUGIN test_sql_replication SONAME 'TEST_SQL_REPLICATION'; 850################################################################### 851# Stop plugin 852################################################################### 853UNINSTALL PLUGIN test_sql_replication; 854################################################################### 855# Plugin log 856################################################################### 857======================================================================== 858Test in a server thread 859[srv_session_open] 860======================================================================== 861EXECUTING:[35][SELECT 'first complex command' as a] 862[CS_TEXT_REPRESENTATION] 863 [meta] rows: 1 864 [meta] cols: 1 865 [meta] server status: 2 866 [meta] server status: AUTOCOMMIT 867 [meta] warning count: 0 868 869 [meta][field] db name: 870 [meta][field] table name: 871 [meta][field] org table name: 872 [meta][field] col name: a 873 [meta][field] org col name: 874 [meta][field] length: 63 875 [meta][field] charsetnr: 33 876 [meta][field] flags: 1 (NOT_NULL ) 877 [meta][field] decimals: 31 878 [meta][field] type: VARCHAR (15) 879 880 881 [meta][charset result] number: 33 882 [meta][charset result] name: utf8 883 [meta][charset result] collation: utf8_general_ci 884 [meta][charset result] sort order: 885 886 [data][.a][ 21][first complex command] 887 888 [end] server status: 2 889 [end] server status: AUTOCOMMIT 890 [end] warning count: 0 891 [end] affected rows: 0 892 [end] last insert id: 0 893 [end] message: 894[CS_BINARY_REPRESENTATION] 895 [meta] rows: 1 896 [meta] cols: 1 897 [meta] server status: 2 898 [meta] server status: AUTOCOMMIT 899 [meta] warning count: 0 900 901 [meta][field] db name: 902 [meta][field] table name: 903 [meta][field] org table name: 904 [meta][field] col name: a 905 [meta][field] org col name: 906 [meta][field] length: 63 907 [meta][field] charsetnr: 33 908 [meta][field] flags: 1 (NOT_NULL ) 909 [meta][field] decimals: 31 910 [meta][field] type: VARCHAR (15) 911 912 913 [meta][charset result] number: 33 914 [meta][charset result] name: utf8 915 [meta][charset result] collation: utf8_general_ci 916 [meta][charset result] sort order: 917 918 [data][.a][ 21][first complex command] 919 920 [end] server status: 2 921 [end] server status: AUTOCOMMIT 922 [end] warning count: 0 923 [end] affected rows: 0 924 [end] last insert id: 0 925 [end] message: 926======================================================================== 927EXECUTING:[COM_INIT_DB][test] 928======================================================================== 929EXECUTING:[62][INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,1), (5,2), (6,3)] 930[CS_TEXT_REPRESENTATION] 931 [meta] rows: 0 932 [meta] cols: 0 933 [meta] server status: 0 934 [meta] server status: 935 [meta] warning count: 0 936 937 [meta] no columns 938 939 [meta] no charset 940 941 [data] no rows 942 943 [end] server status: 2 944 [end] server status: AUTOCOMMIT 945 [end] warning count: 0 946 [end] affected rows: 6 947 [end] last insert id: 0 948 [end] message: Records: 6 Duplicates: 0 Warnings: 0 949======================================================================== 950EXECUTING:[COM_INIT_DB][test] 951======================================================================== 952EXECUTING:[16][SELECT * FROM t1] 953[CS_TEXT_REPRESENTATION] 954 [meta] rows: 18 955 [meta] cols: 2 956 [meta] server status: 34 957 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 958 [meta] warning count: 0 959 960 [meta][field] db name: test 961 [meta][field] table name: t1 962 [meta][field] org table name: t1 963 [meta][field] col name: c1 964 [meta][field] org col name: c1 965 [meta][field] length: 11 966 [meta][field] charsetnr: 8 967 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) 968 [meta][field] decimals: 0 969 [meta][field] type: LONG (3) 970 971 [meta][field] db name: test 972 [meta][field] table name: t1 973 [meta][field] org table name: t1 974 [meta][field] col name: c2 975 [meta][field] org col name: c2 976 [meta][field] length: 11 977 [meta][field] charsetnr: 8 978 [meta][field] flags: 0 979 [meta][field] decimals: 0 980 [meta][field] type: LONG (3) 981 982 983 [meta][charset result] number: 33 984 [meta][charset result] name: utf8 985 [meta][charset result] collation: utf8_general_ci 986 [meta][charset result] sort order: 987 988 [data][t1.c1][ 1][1] 989 [data][t1.c2][ 1][1] 990 991 [data][t1.c1][ 3][100] 992 [data][t1.c2][ 1][2] 993 994 [data][t1.c1][ 1][3] 995 [data][t1.c2][ 1][3] 996 997 [data][t1.c1][ 1][4] 998 [data][t1.c2][ 1][1] 999 1000 [data][t1.c1][ 3][100] 1001 [data][t1.c2][ 1][2] 1002 1003 [data][t1.c1][ 1][6] 1004 [data][t1.c2][ 1][3] 1005 1006 [data][t1.c1][ 1][1] 1007 [data][t1.c2][ 1][1] 1008 1009 [data][t1.c1][ 3][100] 1010 [data][t1.c2][ 1][2] 1011 1012 [data][t1.c1][ 1][3] 1013 [data][t1.c2][ 1][3] 1014 1015 [data][t1.c1][ 1][4] 1016 [data][t1.c2][ 1][1] 1017 1018 [data][t1.c1][ 3][100] 1019 [data][t1.c2][ 1][2] 1020 1021 [data][t1.c1][ 1][6] 1022 [data][t1.c2][ 1][3] 1023 1024 [data][t1.c1][ 1][1] 1025 [data][t1.c2][ 1][1] 1026 1027 [data][t1.c1][ 1][2] 1028 [data][t1.c2][ 1][2] 1029 1030 [data][t1.c1][ 1][3] 1031 [data][t1.c2][ 1][3] 1032 1033 [data][t1.c1][ 1][4] 1034 [data][t1.c2][ 1][1] 1035 1036 [data][t1.c1][ 1][5] 1037 [data][t1.c2][ 1][2] 1038 1039 [data][t1.c1][ 1][6] 1040 [data][t1.c2][ 1][3] 1041 1042 [end] server status: 34 1043 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 1044 [end] warning count: 0 1045 [end] affected rows: 0 1046 [end] last insert id: 0 1047 [end] message: 1048[CS_BINARY_REPRESENTATION] 1049 [meta] rows: 18 1050 [meta] cols: 2 1051 [meta] server status: 34 1052 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 1053 [meta] warning count: 0 1054 1055 [meta][field] db name: test 1056 [meta][field] table name: t1 1057 [meta][field] org table name: t1 1058 [meta][field] col name: c1 1059 [meta][field] org col name: c1 1060 [meta][field] length: 11 1061 [meta][field] charsetnr: 8 1062 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) 1063 [meta][field] decimals: 0 1064 [meta][field] type: LONG (3) 1065 1066 [meta][field] db name: test 1067 [meta][field] table name: t1 1068 [meta][field] org table name: t1 1069 [meta][field] col name: c2 1070 [meta][field] org col name: c2 1071 [meta][field] length: 11 1072 [meta][field] charsetnr: 8 1073 [meta][field] flags: 0 1074 [meta][field] decimals: 0 1075 [meta][field] type: LONG (3) 1076 1077 1078 [meta][charset result] number: 33 1079 [meta][charset result] name: utf8 1080 [meta][charset result] collation: utf8_general_ci 1081 [meta][charset result] sort order: 1082 1083 [data][t1.c1][ 1][1] 1084 [data][t1.c2][ 1][1] 1085 1086 [data][t1.c1][ 3][100] 1087 [data][t1.c2][ 1][2] 1088 1089 [data][t1.c1][ 1][3] 1090 [data][t1.c2][ 1][3] 1091 1092 [data][t1.c1][ 1][4] 1093 [data][t1.c2][ 1][1] 1094 1095 [data][t1.c1][ 3][100] 1096 [data][t1.c2][ 1][2] 1097 1098 [data][t1.c1][ 1][6] 1099 [data][t1.c2][ 1][3] 1100 1101 [data][t1.c1][ 1][1] 1102 [data][t1.c2][ 1][1] 1103 1104 [data][t1.c1][ 3][100] 1105 [data][t1.c2][ 1][2] 1106 1107 [data][t1.c1][ 1][3] 1108 [data][t1.c2][ 1][3] 1109 1110 [data][t1.c1][ 1][4] 1111 [data][t1.c2][ 1][1] 1112 1113 [data][t1.c1][ 3][100] 1114 [data][t1.c2][ 1][2] 1115 1116 [data][t1.c1][ 1][6] 1117 [data][t1.c2][ 1][3] 1118 1119 [data][t1.c1][ 1][1] 1120 [data][t1.c2][ 1][1] 1121 1122 [data][t1.c1][ 1][2] 1123 [data][t1.c2][ 1][2] 1124 1125 [data][t1.c1][ 1][3] 1126 [data][t1.c2][ 1][3] 1127 1128 [data][t1.c1][ 1][4] 1129 [data][t1.c2][ 1][1] 1130 1131 [data][t1.c1][ 1][5] 1132 [data][t1.c2][ 1][2] 1133 1134 [data][t1.c1][ 1][6] 1135 [data][t1.c2][ 1][3] 1136 1137 [end] server status: 34 1138 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 1139 [end] warning count: 0 1140 [end] affected rows: 0 1141 [end] last insert id: 0 1142 [end] message: 1143======================================================================== 1144EXECUTING:[COM_INIT_DB][test] 1145======================================================================== 1146EXECUTING:[35][UPDATE t1 SET c1 = 100 WHERE c2 = 2] 1147[CS_TEXT_REPRESENTATION] 1148 [meta] rows: 0 1149 [meta] cols: 0 1150 [meta] server status: 0 1151 [meta] server status: 1152 [meta] warning count: 0 1153 1154 [meta] no columns 1155 1156 [meta] no charset 1157 1158 [data] no rows 1159 1160 [end] server status: 34 1161 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 1162 [end] warning count: 0 1163 [end] affected rows: 2 1164 [end] last insert id: 0 1165 [end] message: Rows matched: 6 Changed: 2 Warnings: 0 1166======================================================================== 1167EXECUTING:[COM_INIT_DB][test] 1168======================================================================== 1169EXECUTING:[16][SELECT * FROM t1] 1170[CS_TEXT_REPRESENTATION] 1171 [meta] rows: 18 1172 [meta] cols: 2 1173 [meta] server status: 34 1174 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 1175 [meta] warning count: 0 1176 1177 [meta][field] db name: test 1178 [meta][field] table name: t1 1179 [meta][field] org table name: t1 1180 [meta][field] col name: c1 1181 [meta][field] org col name: c1 1182 [meta][field] length: 11 1183 [meta][field] charsetnr: 8 1184 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) 1185 [meta][field] decimals: 0 1186 [meta][field] type: LONG (3) 1187 1188 [meta][field] db name: test 1189 [meta][field] table name: t1 1190 [meta][field] org table name: t1 1191 [meta][field] col name: c2 1192 [meta][field] org col name: c2 1193 [meta][field] length: 11 1194 [meta][field] charsetnr: 8 1195 [meta][field] flags: 0 1196 [meta][field] decimals: 0 1197 [meta][field] type: LONG (3) 1198 1199 1200 [meta][charset result] number: 33 1201 [meta][charset result] name: utf8 1202 [meta][charset result] collation: utf8_general_ci 1203 [meta][charset result] sort order: 1204 1205 [data][t1.c1][ 1][1] 1206 [data][t1.c2][ 1][1] 1207 1208 [data][t1.c1][ 3][100] 1209 [data][t1.c2][ 1][2] 1210 1211 [data][t1.c1][ 1][3] 1212 [data][t1.c2][ 1][3] 1213 1214 [data][t1.c1][ 1][4] 1215 [data][t1.c2][ 1][1] 1216 1217 [data][t1.c1][ 3][100] 1218 [data][t1.c2][ 1][2] 1219 1220 [data][t1.c1][ 1][6] 1221 [data][t1.c2][ 1][3] 1222 1223 [data][t1.c1][ 1][1] 1224 [data][t1.c2][ 1][1] 1225 1226 [data][t1.c1][ 3][100] 1227 [data][t1.c2][ 1][2] 1228 1229 [data][t1.c1][ 1][3] 1230 [data][t1.c2][ 1][3] 1231 1232 [data][t1.c1][ 1][4] 1233 [data][t1.c2][ 1][1] 1234 1235 [data][t1.c1][ 3][100] 1236 [data][t1.c2][ 1][2] 1237 1238 [data][t1.c1][ 1][6] 1239 [data][t1.c2][ 1][3] 1240 1241 [data][t1.c1][ 1][1] 1242 [data][t1.c2][ 1][1] 1243 1244 [data][t1.c1][ 3][100] 1245 [data][t1.c2][ 1][2] 1246 1247 [data][t1.c1][ 1][3] 1248 [data][t1.c2][ 1][3] 1249 1250 [data][t1.c1][ 1][4] 1251 [data][t1.c2][ 1][1] 1252 1253 [data][t1.c1][ 3][100] 1254 [data][t1.c2][ 1][2] 1255 1256 [data][t1.c1][ 1][6] 1257 [data][t1.c2][ 1][3] 1258 1259 [end] server status: 34 1260 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 1261 [end] warning count: 0 1262 [end] affected rows: 0 1263 [end] last insert id: 0 1264 [end] message: 1265[CS_BINARY_REPRESENTATION] 1266 [meta] rows: 18 1267 [meta] cols: 2 1268 [meta] server status: 34 1269 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 1270 [meta] warning count: 0 1271 1272 [meta][field] db name: test 1273 [meta][field] table name: t1 1274 [meta][field] org table name: t1 1275 [meta][field] col name: c1 1276 [meta][field] org col name: c1 1277 [meta][field] length: 11 1278 [meta][field] charsetnr: 8 1279 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) 1280 [meta][field] decimals: 0 1281 [meta][field] type: LONG (3) 1282 1283 [meta][field] db name: test 1284 [meta][field] table name: t1 1285 [meta][field] org table name: t1 1286 [meta][field] col name: c2 1287 [meta][field] org col name: c2 1288 [meta][field] length: 11 1289 [meta][field] charsetnr: 8 1290 [meta][field] flags: 0 1291 [meta][field] decimals: 0 1292 [meta][field] type: LONG (3) 1293 1294 1295 [meta][charset result] number: 33 1296 [meta][charset result] name: utf8 1297 [meta][charset result] collation: utf8_general_ci 1298 [meta][charset result] sort order: 1299 1300 [data][t1.c1][ 1][1] 1301 [data][t1.c2][ 1][1] 1302 1303 [data][t1.c1][ 3][100] 1304 [data][t1.c2][ 1][2] 1305 1306 [data][t1.c1][ 1][3] 1307 [data][t1.c2][ 1][3] 1308 1309 [data][t1.c1][ 1][4] 1310 [data][t1.c2][ 1][1] 1311 1312 [data][t1.c1][ 3][100] 1313 [data][t1.c2][ 1][2] 1314 1315 [data][t1.c1][ 1][6] 1316 [data][t1.c2][ 1][3] 1317 1318 [data][t1.c1][ 1][1] 1319 [data][t1.c2][ 1][1] 1320 1321 [data][t1.c1][ 3][100] 1322 [data][t1.c2][ 1][2] 1323 1324 [data][t1.c1][ 1][3] 1325 [data][t1.c2][ 1][3] 1326 1327 [data][t1.c1][ 1][4] 1328 [data][t1.c2][ 1][1] 1329 1330 [data][t1.c1][ 3][100] 1331 [data][t1.c2][ 1][2] 1332 1333 [data][t1.c1][ 1][6] 1334 [data][t1.c2][ 1][3] 1335 1336 [data][t1.c1][ 1][1] 1337 [data][t1.c2][ 1][1] 1338 1339 [data][t1.c1][ 3][100] 1340 [data][t1.c2][ 1][2] 1341 1342 [data][t1.c1][ 1][3] 1343 [data][t1.c2][ 1][3] 1344 1345 [data][t1.c1][ 1][4] 1346 [data][t1.c2][ 1][1] 1347 1348 [data][t1.c1][ 3][100] 1349 [data][t1.c2][ 1][2] 1350 1351 [data][t1.c1][ 1][6] 1352 [data][t1.c2][ 1][3] 1353 1354 [end] server status: 34 1355 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 1356 [end] warning count: 0 1357 [end] affected rows: 0 1358 [end] last insert id: 0 1359 [end] message: 1360======================================================================== 1361[srv_session_close] 1362Follows threaded run 1363======================================================================== 1364init thread 1365[srv_session_open] 1366======================================================================== 1367EXECUTING:[35][SELECT 'first complex command' as a] 1368[CS_TEXT_REPRESENTATION] 1369 [meta] rows: 1 1370 [meta] cols: 1 1371 [meta] server status: 2 1372 [meta] server status: AUTOCOMMIT 1373 [meta] warning count: 0 1374 1375 [meta][field] db name: 1376 [meta][field] table name: 1377 [meta][field] org table name: 1378 [meta][field] col name: a 1379 [meta][field] org col name: 1380 [meta][field] length: 63 1381 [meta][field] charsetnr: 33 1382 [meta][field] flags: 1 (NOT_NULL ) 1383 [meta][field] decimals: 31 1384 [meta][field] type: VARCHAR (15) 1385 1386 1387 [meta][charset result] number: 33 1388 [meta][charset result] name: utf8 1389 [meta][charset result] collation: utf8_general_ci 1390 [meta][charset result] sort order: 1391 1392 [data][.a][ 21][first complex command] 1393 1394 [end] server status: 2 1395 [end] server status: AUTOCOMMIT 1396 [end] warning count: 0 1397 [end] affected rows: 0 1398 [end] last insert id: 0 1399 [end] message: 1400[CS_BINARY_REPRESENTATION] 1401 [meta] rows: 1 1402 [meta] cols: 1 1403 [meta] server status: 2 1404 [meta] server status: AUTOCOMMIT 1405 [meta] warning count: 0 1406 1407 [meta][field] db name: 1408 [meta][field] table name: 1409 [meta][field] org table name: 1410 [meta][field] col name: a 1411 [meta][field] org col name: 1412 [meta][field] length: 63 1413 [meta][field] charsetnr: 33 1414 [meta][field] flags: 1 (NOT_NULL ) 1415 [meta][field] decimals: 31 1416 [meta][field] type: VARCHAR (15) 1417 1418 1419 [meta][charset result] number: 33 1420 [meta][charset result] name: utf8 1421 [meta][charset result] collation: utf8_general_ci 1422 [meta][charset result] sort order: 1423 1424 [data][.a][ 21][first complex command] 1425 1426 [end] server status: 2 1427 [end] server status: AUTOCOMMIT 1428 [end] warning count: 0 1429 [end] affected rows: 0 1430 [end] last insert id: 0 1431 [end] message: 1432======================================================================== 1433EXECUTING:[COM_INIT_DB][test] 1434======================================================================== 1435EXECUTING:[62][INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,1), (5,2), (6,3)] 1436[CS_TEXT_REPRESENTATION] 1437 [meta] rows: 0 1438 [meta] cols: 0 1439 [meta] server status: 0 1440 [meta] server status: 1441 [meta] warning count: 0 1442 1443 [meta] no columns 1444 1445 [meta] no charset 1446 1447 [data] no rows 1448 1449 [end] server status: 2 1450 [end] server status: AUTOCOMMIT 1451 [end] warning count: 0 1452 [end] affected rows: 6 1453 [end] last insert id: 0 1454 [end] message: Records: 6 Duplicates: 0 Warnings: 0 1455======================================================================== 1456EXECUTING:[COM_INIT_DB][test] 1457======================================================================== 1458EXECUTING:[16][SELECT * FROM t1] 1459[CS_TEXT_REPRESENTATION] 1460 [meta] rows: 24 1461 [meta] cols: 2 1462 [meta] server status: 34 1463 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 1464 [meta] warning count: 0 1465 1466 [meta][field] db name: test 1467 [meta][field] table name: t1 1468 [meta][field] org table name: t1 1469 [meta][field] col name: c1 1470 [meta][field] org col name: c1 1471 [meta][field] length: 11 1472 [meta][field] charsetnr: 8 1473 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) 1474 [meta][field] decimals: 0 1475 [meta][field] type: LONG (3) 1476 1477 [meta][field] db name: test 1478 [meta][field] table name: t1 1479 [meta][field] org table name: t1 1480 [meta][field] col name: c2 1481 [meta][field] org col name: c2 1482 [meta][field] length: 11 1483 [meta][field] charsetnr: 8 1484 [meta][field] flags: 0 1485 [meta][field] decimals: 0 1486 [meta][field] type: LONG (3) 1487 1488 1489 [meta][charset result] number: 33 1490 [meta][charset result] name: utf8 1491 [meta][charset result] collation: utf8_general_ci 1492 [meta][charset result] sort order: 1493 1494 [data][t1.c1][ 1][1] 1495 [data][t1.c2][ 1][1] 1496 1497 [data][t1.c1][ 3][100] 1498 [data][t1.c2][ 1][2] 1499 1500 [data][t1.c1][ 1][3] 1501 [data][t1.c2][ 1][3] 1502 1503 [data][t1.c1][ 1][4] 1504 [data][t1.c2][ 1][1] 1505 1506 [data][t1.c1][ 3][100] 1507 [data][t1.c2][ 1][2] 1508 1509 [data][t1.c1][ 1][6] 1510 [data][t1.c2][ 1][3] 1511 1512 [data][t1.c1][ 1][1] 1513 [data][t1.c2][ 1][1] 1514 1515 [data][t1.c1][ 3][100] 1516 [data][t1.c2][ 1][2] 1517 1518 [data][t1.c1][ 1][3] 1519 [data][t1.c2][ 1][3] 1520 1521 [data][t1.c1][ 1][4] 1522 [data][t1.c2][ 1][1] 1523 1524 [data][t1.c1][ 3][100] 1525 [data][t1.c2][ 1][2] 1526 1527 [data][t1.c1][ 1][6] 1528 [data][t1.c2][ 1][3] 1529 1530 [data][t1.c1][ 1][1] 1531 [data][t1.c2][ 1][1] 1532 1533 [data][t1.c1][ 3][100] 1534 [data][t1.c2][ 1][2] 1535 1536 [data][t1.c1][ 1][3] 1537 [data][t1.c2][ 1][3] 1538 1539 [data][t1.c1][ 1][4] 1540 [data][t1.c2][ 1][1] 1541 1542 [data][t1.c1][ 3][100] 1543 [data][t1.c2][ 1][2] 1544 1545 [data][t1.c1][ 1][6] 1546 [data][t1.c2][ 1][3] 1547 1548 [data][t1.c1][ 1][1] 1549 [data][t1.c2][ 1][1] 1550 1551 [data][t1.c1][ 1][2] 1552 [data][t1.c2][ 1][2] 1553 1554 [data][t1.c1][ 1][3] 1555 [data][t1.c2][ 1][3] 1556 1557 [data][t1.c1][ 1][4] 1558 [data][t1.c2][ 1][1] 1559 1560 [data][t1.c1][ 1][5] 1561 [data][t1.c2][ 1][2] 1562 1563 [data][t1.c1][ 1][6] 1564 [data][t1.c2][ 1][3] 1565 1566 [end] server status: 34 1567 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 1568 [end] warning count: 0 1569 [end] affected rows: 0 1570 [end] last insert id: 0 1571 [end] message: 1572[CS_BINARY_REPRESENTATION] 1573 [meta] rows: 24 1574 [meta] cols: 2 1575 [meta] server status: 34 1576 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 1577 [meta] warning count: 0 1578 1579 [meta][field] db name: test 1580 [meta][field] table name: t1 1581 [meta][field] org table name: t1 1582 [meta][field] col name: c1 1583 [meta][field] org col name: c1 1584 [meta][field] length: 11 1585 [meta][field] charsetnr: 8 1586 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) 1587 [meta][field] decimals: 0 1588 [meta][field] type: LONG (3) 1589 1590 [meta][field] db name: test 1591 [meta][field] table name: t1 1592 [meta][field] org table name: t1 1593 [meta][field] col name: c2 1594 [meta][field] org col name: c2 1595 [meta][field] length: 11 1596 [meta][field] charsetnr: 8 1597 [meta][field] flags: 0 1598 [meta][field] decimals: 0 1599 [meta][field] type: LONG (3) 1600 1601 1602 [meta][charset result] number: 33 1603 [meta][charset result] name: utf8 1604 [meta][charset result] collation: utf8_general_ci 1605 [meta][charset result] sort order: 1606 1607 [data][t1.c1][ 1][1] 1608 [data][t1.c2][ 1][1] 1609 1610 [data][t1.c1][ 3][100] 1611 [data][t1.c2][ 1][2] 1612 1613 [data][t1.c1][ 1][3] 1614 [data][t1.c2][ 1][3] 1615 1616 [data][t1.c1][ 1][4] 1617 [data][t1.c2][ 1][1] 1618 1619 [data][t1.c1][ 3][100] 1620 [data][t1.c2][ 1][2] 1621 1622 [data][t1.c1][ 1][6] 1623 [data][t1.c2][ 1][3] 1624 1625 [data][t1.c1][ 1][1] 1626 [data][t1.c2][ 1][1] 1627 1628 [data][t1.c1][ 3][100] 1629 [data][t1.c2][ 1][2] 1630 1631 [data][t1.c1][ 1][3] 1632 [data][t1.c2][ 1][3] 1633 1634 [data][t1.c1][ 1][4] 1635 [data][t1.c2][ 1][1] 1636 1637 [data][t1.c1][ 3][100] 1638 [data][t1.c2][ 1][2] 1639 1640 [data][t1.c1][ 1][6] 1641 [data][t1.c2][ 1][3] 1642 1643 [data][t1.c1][ 1][1] 1644 [data][t1.c2][ 1][1] 1645 1646 [data][t1.c1][ 3][100] 1647 [data][t1.c2][ 1][2] 1648 1649 [data][t1.c1][ 1][3] 1650 [data][t1.c2][ 1][3] 1651 1652 [data][t1.c1][ 1][4] 1653 [data][t1.c2][ 1][1] 1654 1655 [data][t1.c1][ 3][100] 1656 [data][t1.c2][ 1][2] 1657 1658 [data][t1.c1][ 1][6] 1659 [data][t1.c2][ 1][3] 1660 1661 [data][t1.c1][ 1][1] 1662 [data][t1.c2][ 1][1] 1663 1664 [data][t1.c1][ 1][2] 1665 [data][t1.c2][ 1][2] 1666 1667 [data][t1.c1][ 1][3] 1668 [data][t1.c2][ 1][3] 1669 1670 [data][t1.c1][ 1][4] 1671 [data][t1.c2][ 1][1] 1672 1673 [data][t1.c1][ 1][5] 1674 [data][t1.c2][ 1][2] 1675 1676 [data][t1.c1][ 1][6] 1677 [data][t1.c2][ 1][3] 1678 1679 [end] server status: 34 1680 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 1681 [end] warning count: 0 1682 [end] affected rows: 0 1683 [end] last insert id: 0 1684 [end] message: 1685======================================================================== 1686EXECUTING:[COM_INIT_DB][test] 1687======================================================================== 1688EXECUTING:[35][UPDATE t1 SET c1 = 100 WHERE c2 = 2] 1689[CS_TEXT_REPRESENTATION] 1690 [meta] rows: 0 1691 [meta] cols: 0 1692 [meta] server status: 0 1693 [meta] server status: 1694 [meta] warning count: 0 1695 1696 [meta] no columns 1697 1698 [meta] no charset 1699 1700 [data] no rows 1701 1702 [end] server status: 34 1703 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 1704 [end] warning count: 0 1705 [end] affected rows: 2 1706 [end] last insert id: 0 1707 [end] message: Rows matched: 8 Changed: 2 Warnings: 0 1708======================================================================== 1709EXECUTING:[COM_INIT_DB][test] 1710======================================================================== 1711EXECUTING:[16][SELECT * FROM t1] 1712[CS_TEXT_REPRESENTATION] 1713 [meta] rows: 24 1714 [meta] cols: 2 1715 [meta] server status: 34 1716 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 1717 [meta] warning count: 0 1718 1719 [meta][field] db name: test 1720 [meta][field] table name: t1 1721 [meta][field] org table name: t1 1722 [meta][field] col name: c1 1723 [meta][field] org col name: c1 1724 [meta][field] length: 11 1725 [meta][field] charsetnr: 8 1726 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) 1727 [meta][field] decimals: 0 1728 [meta][field] type: LONG (3) 1729 1730 [meta][field] db name: test 1731 [meta][field] table name: t1 1732 [meta][field] org table name: t1 1733 [meta][field] col name: c2 1734 [meta][field] org col name: c2 1735 [meta][field] length: 11 1736 [meta][field] charsetnr: 8 1737 [meta][field] flags: 0 1738 [meta][field] decimals: 0 1739 [meta][field] type: LONG (3) 1740 1741 1742 [meta][charset result] number: 33 1743 [meta][charset result] name: utf8 1744 [meta][charset result] collation: utf8_general_ci 1745 [meta][charset result] sort order: 1746 1747 [data][t1.c1][ 1][1] 1748 [data][t1.c2][ 1][1] 1749 1750 [data][t1.c1][ 3][100] 1751 [data][t1.c2][ 1][2] 1752 1753 [data][t1.c1][ 1][3] 1754 [data][t1.c2][ 1][3] 1755 1756 [data][t1.c1][ 1][4] 1757 [data][t1.c2][ 1][1] 1758 1759 [data][t1.c1][ 3][100] 1760 [data][t1.c2][ 1][2] 1761 1762 [data][t1.c1][ 1][6] 1763 [data][t1.c2][ 1][3] 1764 1765 [data][t1.c1][ 1][1] 1766 [data][t1.c2][ 1][1] 1767 1768 [data][t1.c1][ 3][100] 1769 [data][t1.c2][ 1][2] 1770 1771 [data][t1.c1][ 1][3] 1772 [data][t1.c2][ 1][3] 1773 1774 [data][t1.c1][ 1][4] 1775 [data][t1.c2][ 1][1] 1776 1777 [data][t1.c1][ 3][100] 1778 [data][t1.c2][ 1][2] 1779 1780 [data][t1.c1][ 1][6] 1781 [data][t1.c2][ 1][3] 1782 1783 [data][t1.c1][ 1][1] 1784 [data][t1.c2][ 1][1] 1785 1786 [data][t1.c1][ 3][100] 1787 [data][t1.c2][ 1][2] 1788 1789 [data][t1.c1][ 1][3] 1790 [data][t1.c2][ 1][3] 1791 1792 [data][t1.c1][ 1][4] 1793 [data][t1.c2][ 1][1] 1794 1795 [data][t1.c1][ 3][100] 1796 [data][t1.c2][ 1][2] 1797 1798 [data][t1.c1][ 1][6] 1799 [data][t1.c2][ 1][3] 1800 1801 [data][t1.c1][ 1][1] 1802 [data][t1.c2][ 1][1] 1803 1804 [data][t1.c1][ 3][100] 1805 [data][t1.c2][ 1][2] 1806 1807 [data][t1.c1][ 1][3] 1808 [data][t1.c2][ 1][3] 1809 1810 [data][t1.c1][ 1][4] 1811 [data][t1.c2][ 1][1] 1812 1813 [data][t1.c1][ 3][100] 1814 [data][t1.c2][ 1][2] 1815 1816 [data][t1.c1][ 1][6] 1817 [data][t1.c2][ 1][3] 1818 1819 [end] server status: 34 1820 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 1821 [end] warning count: 0 1822 [end] affected rows: 0 1823 [end] last insert id: 0 1824 [end] message: 1825[CS_BINARY_REPRESENTATION] 1826 [meta] rows: 24 1827 [meta] cols: 2 1828 [meta] server status: 34 1829 [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 1830 [meta] warning count: 0 1831 1832 [meta][field] db name: test 1833 [meta][field] table name: t1 1834 [meta][field] org table name: t1 1835 [meta][field] col name: c1 1836 [meta][field] org col name: c1 1837 [meta][field] length: 11 1838 [meta][field] charsetnr: 8 1839 [meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) 1840 [meta][field] decimals: 0 1841 [meta][field] type: LONG (3) 1842 1843 [meta][field] db name: test 1844 [meta][field] table name: t1 1845 [meta][field] org table name: t1 1846 [meta][field] col name: c2 1847 [meta][field] org col name: c2 1848 [meta][field] length: 11 1849 [meta][field] charsetnr: 8 1850 [meta][field] flags: 0 1851 [meta][field] decimals: 0 1852 [meta][field] type: LONG (3) 1853 1854 1855 [meta][charset result] number: 33 1856 [meta][charset result] name: utf8 1857 [meta][charset result] collation: utf8_general_ci 1858 [meta][charset result] sort order: 1859 1860 [data][t1.c1][ 1][1] 1861 [data][t1.c2][ 1][1] 1862 1863 [data][t1.c1][ 3][100] 1864 [data][t1.c2][ 1][2] 1865 1866 [data][t1.c1][ 1][3] 1867 [data][t1.c2][ 1][3] 1868 1869 [data][t1.c1][ 1][4] 1870 [data][t1.c2][ 1][1] 1871 1872 [data][t1.c1][ 3][100] 1873 [data][t1.c2][ 1][2] 1874 1875 [data][t1.c1][ 1][6] 1876 [data][t1.c2][ 1][3] 1877 1878 [data][t1.c1][ 1][1] 1879 [data][t1.c2][ 1][1] 1880 1881 [data][t1.c1][ 3][100] 1882 [data][t1.c2][ 1][2] 1883 1884 [data][t1.c1][ 1][3] 1885 [data][t1.c2][ 1][3] 1886 1887 [data][t1.c1][ 1][4] 1888 [data][t1.c2][ 1][1] 1889 1890 [data][t1.c1][ 3][100] 1891 [data][t1.c2][ 1][2] 1892 1893 [data][t1.c1][ 1][6] 1894 [data][t1.c2][ 1][3] 1895 1896 [data][t1.c1][ 1][1] 1897 [data][t1.c2][ 1][1] 1898 1899 [data][t1.c1][ 3][100] 1900 [data][t1.c2][ 1][2] 1901 1902 [data][t1.c1][ 1][3] 1903 [data][t1.c2][ 1][3] 1904 1905 [data][t1.c1][ 1][4] 1906 [data][t1.c2][ 1][1] 1907 1908 [data][t1.c1][ 3][100] 1909 [data][t1.c2][ 1][2] 1910 1911 [data][t1.c1][ 1][6] 1912 [data][t1.c2][ 1][3] 1913 1914 [data][t1.c1][ 1][1] 1915 [data][t1.c2][ 1][1] 1916 1917 [data][t1.c1][ 3][100] 1918 [data][t1.c2][ 1][2] 1919 1920 [data][t1.c1][ 1][3] 1921 [data][t1.c2][ 1][3] 1922 1923 [data][t1.c1][ 1][4] 1924 [data][t1.c2][ 1][1] 1925 1926 [data][t1.c1][ 3][100] 1927 [data][t1.c2][ 1][2] 1928 1929 [data][t1.c1][ 1][6] 1930 [data][t1.c2][ 1][3] 1931 1932 [end] server status: 34 1933 [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED 1934 [end] warning count: 0 1935 [end] affected rows: 0 1936 [end] last insert id: 0 1937 [end] message: 1938======================================================================== 1939[srv_session_close] 1940deinit thread 1941SELECT * FROM t1; 1942c1 c2 19431 1 1944100 2 19453 3 19464 1 1947100 2 19486 3 19491 1 1950100 2 19513 3 19524 1 1953100 2 19546 3 19551 1 1956100 2 19573 3 19584 1 1959100 2 19606 3 19611 1 1962100 2 19633 3 19644 1 1965100 2 19666 3 1967include/sync_slave_sql_with_master.inc 1968[Connection Slave] 1969SELECT * FROM t1; 1970c1 c2 19711 1 1972100 2 19733 3 19744 1 1975100 2 19766 3 19771 1 1978100 2 19793 3 19804 1 1981100 2 19826 3 19831 1 1984100 2 19853 3 19864 1 1987100 2 19886 3 19891 1 1990100 2 19913 3 19924 1 1993100 2 19946 3 1995include/diff_tables.inc [master:t1,slave:t1] 1996[Connection Master] 1997# Dropping the created table 1998DROP TABLE t1; 1999SELECT * FROM t1; 2000ERROR 42S02: Table 'test.t1' doesn't exist 2001include/sync_slave_sql_with_master.inc 2002[Connection Slave] 2003SELECT * FROM t1; 2004ERROR 42S02: Table 'test.t1' doesn't exist 2005include/rpl_end.inc 2006