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