test/cache/Bidirectional/exp.test015.ksh

   1 table creation file created
   2 select file created
   3 Update file created
   4 Trigger file generated
   5 Drop trigger file generated
   6 Log table created in target DB
   7 server  started
   8 echo select * from t1;
   9 ---------------------------------------------------------
  10         t1.f1   t1.f2
  11 ---------------------------------------------------------
  12         1       2
  13         10      20
  14         11      21
  15
  16 echo select * from t2;
  17 ---------------------------------------------------------
  18         t2.f1   t2.f2
  19 ---------------------------------------------------------
  20         1       2
  21         10      20
  22         11      21
  23
  24 echo select * from t3;
  25 ---------------------------------------------------------
  26         t3.f1   t3.f2
  27 ---------------------------------------------------------
  28         1       2
  29         10      20
  30         11      21
  31
  32 echo select * from t4;
  33 ---------------------------------------------------------
  34         t4.f1   t4.f2
  35 ---------------------------------------------------------
  36         1       2
  37         10      20
  38         11      21
  39
  40 echo select * from t5;
  41 ---------------------------------------------------------
  42         t5.f1   t5.f2
  43 ---------------------------------------------------------
  44         1       2
  45         10      20
  46         11      21
  47
  48 echo select * from t6;
  49 ---------------------------------------------------------
  50         t6.f1   t6.f2
  51 ---------------------------------------------------------
  52         1       2
  53         10      20
  54         11      21
  55
  56 echo select * from t7;
  57 ---------------------------------------------------------
  58         t7.f1   t7.f2
  59 ---------------------------------------------------------
  60         1       2
  61         10      20
  62         11      21
  63
  64 echo select * from t8;
  65 ---------------------------------------------------------
  66         t8.f1   t8.f2
  67 ---------------------------------------------------------
  68         1       2
  69         10      20
  70         11      21
  71
  72 echo select * from t9;
  73 ---------------------------------------------------------
  74         t9.f1   t9.f2
  75 ---------------------------------------------------------
  76         1       2
  77         10      20
  78         11      21
  79
  80 echo select * from t10;
  81 ---------------------------------------------------------
  82         t10.f1  t10.f2
  83 ---------------------------------------------------------
  84         1       2
  85         10      20
  86         11      21
  87
  88 echo select * from t11;
  89 ---------------------------------------------------------
  90         t11.f1  t11.f2
  91 ---------------------------------------------------------
  92         1       2
  93         10      20
  94         11      21
  95
  96 echo select * from t12;
  97 ---------------------------------------------------------
  98         t12.f1  t12.f2
  99 ---------------------------------------------------------
 100         1       2
 101         10      20
 102         11      21
 103
 104 echo select * from t13;
 105 ---------------------------------------------------------
 106         t13.f1  t13.f2
 107 ---------------------------------------------------------
 108         1       2
 109         10      20
 110         11      21
 111
 112 echo select * from t14;
 113 ---------------------------------------------------------
 114         t14.f1  t14.f2
 115 ---------------------------------------------------------
 116         1       2
 117         10      20
 118         11      21
 119
 120 echo select * from t15;
 121 ---------------------------------------------------------
 122         t15.f1  t15.f2
 123 ---------------------------------------------------------
 124         1       2
 125         10      20
 126         11      21
 127
 128 echo select * from t16;
 129 ---------------------------------------------------------
 130         t16.f1  t16.f2
 131 ---------------------------------------------------------
 132         1       2
 133         10      20
 134         11      21
 135
 136 echo select * from t17;
 137 ---------------------------------------------------------
 138         t17.f1  t17.f2
 139 ---------------------------------------------------------
 140         1       2
 141         10      20
 142         11      21
 143
 144 echo select * from t18;
 145 ---------------------------------------------------------
 146         t18.f1  t18.f2
 147 ---------------------------------------------------------
 148         1       2
 149         10      20
 150         11      21
 151
 152 echo select * from t19;
 153 ---------------------------------------------------------
 154         t19.f1  t19.f2
 155 ---------------------------------------------------------
 156         1       2
 157         10      20
 158         11      21
 159
 160 echo select * from t20;
 161 ---------------------------------------------------------
 162         t20.f1  t20.f2
 163 ---------------------------------------------------------
 164         1       2
 165         10      20
 166         11      21
 167
 168 echo select * from t21;
 169 ---------------------------------------------------------
 170         t21.f1  t21.f2
 171 ---------------------------------------------------------
 172         1       2
 173         10      20
 174         11      21
 175
 176 echo select * from t22;
 177 ---------------------------------------------------------
 178         t22.f1  t22.f2
 179 ---------------------------------------------------------
 180         1       2
 181         10      20
 182         11      21
 183
 184 echo select * from t23;
 185 ---------------------------------------------------------
 186         t23.f1  t23.f2
 187 ---------------------------------------------------------
 188         1       2
 189         10      20
 190         11      21
 191
 192 echo select * from t24;
 193 ---------------------------------------------------------
 194         t24.f1  t24.f2
 195 ---------------------------------------------------------
 196         1       2
 197         10      20
 198         11      21
 199
 200 echo select * from t25;
 201 ---------------------------------------------------------
 202         t25.f1  t25.f2
 203 ---------------------------------------------------------
 204         1       2
 205         10      20
 206         11      21
 207
 208 echo select * from t26;
 209 ---------------------------------------------------------
 210         t26.f1  t26.f2
 211 ---------------------------------------------------------
 212         1       2
 213         10      20
 214         11      21
 215
 216 echo select * from t27;
 217 ---------------------------------------------------------
 218         t27.f1  t27.f2
 219 ---------------------------------------------------------
 220         1       2
 221         10      20
 222         11      21
 223
 224 echo select * from t28;
 225 ---------------------------------------------------------
 226         t28.f1  t28.f2
 227 ---------------------------------------------------------
 228         1       2
 229         10      20
 230         11      21
 231
 232 echo select * from t29;
 233 ---------------------------------------------------------
 234         t29.f1  t29.f2
 235 ---------------------------------------------------------
 236         1       2
 237         10      20
 238         11      21
 239
 240 echo select * from t30;
 241 ---------------------------------------------------------
 242         t30.f1  t30.f2
 243 ---------------------------------------------------------
 244         1       2
 245         10      20
 246         11      21
 247
 248 echo select * from t31;
 249 ---------------------------------------------------------
 250         t31.f1  t31.f2
 251 ---------------------------------------------------------
 252         1       2
 253         10      20
 254         11      21
 255
 256 echo select * from t32;
 257 ---------------------------------------------------------
 258         t32.f1  t32.f2
 259 ---------------------------------------------------------
 260         1       2
 261         10      20
 262         11      21
 263
 264 echo select * from t33;
 265 ---------------------------------------------------------
 266         t33.f1  t33.f2
 267 ---------------------------------------------------------
 268         1       2
 269         10      20
 270         11      21
 271
 272 echo select * from t34;
 273 ---------------------------------------------------------
 274         t34.f1  t34.f2
 275 ---------------------------------------------------------
 276         1       2
 277         10      20
 278         11      21
 279
 280 echo select * from t35;
 281 ---------------------------------------------------------
 282         t35.f1  t35.f2
 283 ---------------------------------------------------------
 284         1       2
 285         10      20
 286         11      21
 287
 288 echo select * from t36;
 289 ---------------------------------------------------------
 290         t36.f1  t36.f2
 291 ---------------------------------------------------------
 292         1       2
 293         10      20
 294         11      21
 295
 296 echo select * from t37;
 297 ---------------------------------------------------------
 298         t37.f1  t37.f2
 299 ---------------------------------------------------------
 300         1       2
 301         10      20
 302         11      21
 303
 304 echo select * from t38;
 305 ---------------------------------------------------------
 306         t38.f1  t38.f2
 307 ---------------------------------------------------------
 308         1       2
 309         10      20
 310         11      21
 311
 312 echo select * from t39;
 313 ---------------------------------------------------------
 314         t39.f1  t39.f2
 315 ---------------------------------------------------------
 316         1       2
 317         10      20
 318         11      21
 319
 320 echo select * from t40;
 321 ---------------------------------------------------------
 322         t40.f1  t40.f2
 323 ---------------------------------------------------------
 324         1       2
 325         10      20
 326         11      21
 327
 328 echo select * from t41;
 329 ---------------------------------------------------------
 330         t41.f1  t41.f2
 331 ---------------------------------------------------------
 332         1       2
 333         10      20
 334         11      21
 335
 336 echo select * from t42;
 337 ---------------------------------------------------------
 338         t42.f1  t42.f2
 339 ---------------------------------------------------------
 340         1       2
 341         10      20
 342         11      21
 343
 344 echo select * from t43;
 345 ---------------------------------------------------------
 346         t43.f1  t43.f2
 347 ---------------------------------------------------------
 348         1       2
 349         10      20
 350         11      21
 351
 352 echo select * from t44;
 353 ---------------------------------------------------------
 354         t44.f1  t44.f2
 355 ---------------------------------------------------------
 356         1       2
 357         10      20
 358         11      21
 359
 360 echo select * from t45;
 361 ---------------------------------------------------------
 362         t45.f1  t45.f2
 363 ---------------------------------------------------------
 364         1       2
 365         10      20
 366         11      21
 367
 368 echo select * from t46;
 369 ---------------------------------------------------------
 370         t46.f1  t46.f2
 371 ---------------------------------------------------------
 372         1       2
 373         10      20
 374         11      21
 375
 376 echo select * from t47;
 377 ---------------------------------------------------------
 378         t47.f1  t47.f2
 379 ---------------------------------------------------------
 380         1       2
 381         10      20
 382         11      21
 383
 384 echo select * from t48;
 385 ---------------------------------------------------------
 386         t48.f1  t48.f2
 387 ---------------------------------------------------------
 388         1       2
 389         10      20
 390         11      21
 391
 392 echo select * from t49;
 393 ---------------------------------------------------------
 394         t49.f1  t49.f2
 395 ---------------------------------------------------------
 396         1       2
 397         10      20
 398         11      21
 399
 400 echo select * from t50;
 401 ---------------------------------------------------------
 402         t50.f1  t50.f2
 403 ---------------------------------------------------------
 404         1       2
 405         10      20
 406         11      21
 407
 408 echo select * from t51;
 409 ---------------------------------------------------------
 410         t51.f1  t51.f2
 411 ---------------------------------------------------------
 412         1       2
 413         10      20
 414         11      21
 415
 416 echo select * from t52;
 417 ---------------------------------------------------------
 418         t52.f1  t52.f2
 419 ---------------------------------------------------------
 420         1       2
 421         10      20
 422         11      21
 423
 424 echo select * from t53;
 425 ---------------------------------------------------------
 426         t53.f1  t53.f2
 427 ---------------------------------------------------------
 428         1       2
 429         10      20
 430         11      21
 431
 432 echo select * from t54;
 433 ---------------------------------------------------------
 434         t54.f1  t54.f2
 435 ---------------------------------------------------------
 436         1       2
 437         10      20
 438         11      21
 439
 440 echo select * from t55;
 441 ---------------------------------------------------------
 442         t55.f1  t55.f2
 443 ---------------------------------------------------------
 444         1       2
 445         10      20
 446         11      21
 447
 448 echo select * from t56;
 449 ---------------------------------------------------------
 450         t56.f1  t56.f2
 451 ---------------------------------------------------------
 452         1       2
 453         10      20
 454         11      21
 455
 456 echo select * from t57;
 457 ---------------------------------------------------------
 458         t57.f1  t57.f2
 459 ---------------------------------------------------------
 460         1       2
 461         10      20
 462         11      21
 463
 464 echo select * from t58;
 465 ---------------------------------------------------------
 466         t58.f1  t58.f2
 467 ---------------------------------------------------------
 468         1       2
 469         10      20
 470         11      21
 471
 472 echo select * from t59;
 473 ---------------------------------------------------------
 474         t59.f1  t59.f2
 475 ---------------------------------------------------------
 476         1       2
 477         10      20
 478         11      21
 479
 480 echo select * from t60;
 481 ---------------------------------------------------------
 482         t60.f1  t60.f2
 483 ---------------------------------------------------------
 484         1       2
 485         10      20
 486         11      21
 487
 488 echo select * from t61;
 489 ---------------------------------------------------------
 490         t61.f1  t61.f2
 491 ---------------------------------------------------------
 492         1       2
 493         10      20
 494         11      21
 495
 496 echo select * from t62;
 497 ---------------------------------------------------------
 498         t62.f1  t62.f2
 499 ---------------------------------------------------------
 500         1       2
 501         10      20
 502         11      21
 503
 504 echo select * from t63;
 505 ---------------------------------------------------------
 506         t63.f1  t63.f2
 507 ---------------------------------------------------------
 508         1       2
 509         10      20
 510         11      21
 511
 512 echo select * from t64;
 513 ---------------------------------------------------------
 514         t64.f1  t64.f2
 515 ---------------------------------------------------------
 516         1       2
 517         10      20
 518         11      21
 519
 520 echo select * from t65;
 521 ---------------------------------------------------------
 522         t65.f1  t65.f2
 523 ---------------------------------------------------------
 524         1       2
 525         10      20
 526         11      21
 527
 528 echo select * from t66;
 529 ---------------------------------------------------------
 530         t66.f1  t66.f2
 531 ---------------------------------------------------------
 532         1       2
 533         10      20
 534         11      21
 535
 536 echo select * from t67;
 537 ---------------------------------------------------------
 538         t67.f1  t67.f2
 539 ---------------------------------------------------------
 540         1       2
 541         10      20
 542         11      21
 543
 544 echo select * from t68;
 545 ---------------------------------------------------------
 546         t68.f1  t68.f2
 547 ---------------------------------------------------------
 548         1       2
 549         10      20
 550         11      21
 551
 552 echo select * from t69;
 553 ---------------------------------------------------------
 554         t69.f1  t69.f2
 555 ---------------------------------------------------------
 556         1       2
 557         10      20
 558         11      21
 559
 560 echo select * from t70;
 561 ---------------------------------------------------------
 562         t70.f1  t70.f2
 563 ---------------------------------------------------------
 564         1       2
 565         10      20
 566         11      21
 567
 568 echo select * from t71;
 569 ---------------------------------------------------------
 570         t71.f1  t71.f2
 571 ---------------------------------------------------------
 572         1       2
 573         10      20
 574         11      21
 575
 576 echo select * from t72;
 577 ---------------------------------------------------------
 578         t72.f1  t72.f2
 579 ---------------------------------------------------------
 580         1       2
 581         10      20
 582         11      21
 583
 584 echo select * from t73;
 585 ---------------------------------------------------------
 586         t73.f1  t73.f2
 587 ---------------------------------------------------------
 588         1       2
 589         10      20
 590         11      21
 591
 592 echo select * from t74;
 593 ---------------------------------------------------------
 594         t74.f1  t74.f2
 595 ---------------------------------------------------------
 596         1       2
 597         10      20
 598         11      21
 599
 600 echo select * from t75;
 601 ---------------------------------------------------------
 602         t75.f1  t75.f2
 603 ---------------------------------------------------------
 604         1       2
 605         10      20
 606         11      21
 607
 608 echo select * from t76;
 609 ---------------------------------------------------------
 610         t76.f1  t76.f2
 611 ---------------------------------------------------------
 612         1       2
 613         10      20
 614         11      21
 615
 616 echo select * from t77;
 617 ---------------------------------------------------------
 618         t77.f1  t77.f2
 619 ---------------------------------------------------------
 620         1       2
 621         10      20
 622         11      21
 623
 624 echo select * from t78;
 625 ---------------------------------------------------------
 626         t78.f1  t78.f2
 627 ---------------------------------------------------------
 628         1       2
 629         10      20
 630         11      21
 631
 632 echo select * from t79;
 633 ---------------------------------------------------------
 634         t79.f1  t79.f2
 635 ---------------------------------------------------------
 636         1       2
 637         10      20
 638         11      21
 639
 640 echo select * from t80;
 641 ---------------------------------------------------------
 642         t80.f1  t80.f2
 643 ---------------------------------------------------------
 644         1       2
 645         10      20
 646         11      21
 647
 648 echo select * from t81;
 649 ---------------------------------------------------------
 650         t81.f1  t81.f2
 651 ---------------------------------------------------------
 652         1       2
 653         10      20
 654         11      21
 655
 656 echo select * from t82;
 657 ---------------------------------------------------------
 658         t82.f1  t82.f2
 659 ---------------------------------------------------------
 660         1       2
 661         10      20
 662         11      21
 663
 664 echo select * from t83;
 665 ---------------------------------------------------------
 666         t83.f1  t83.f2
 667 ---------------------------------------------------------
 668         1       2
 669         10      20
 670         11      21
 671
 672 echo select * from t84;
 673 ---------------------------------------------------------
 674         t84.f1  t84.f2
 675 ---------------------------------------------------------
 676         1       2
 677         10      20
 678         11      21
 679
 680 echo select * from t85;
 681 ---------------------------------------------------------
 682         t85.f1  t85.f2
 683 ---------------------------------------------------------
 684         1       2
 685         10      20
 686         11      21
 687
 688 echo select * from t86;
 689 ---------------------------------------------------------
 690         t86.f1  t86.f2
 691 ---------------------------------------------------------
 692         1       2
 693         10      20
 694         11      21
 695
 696 echo select * from t87;
 697 ---------------------------------------------------------
 698         t87.f1  t87.f2
 699 ---------------------------------------------------------
 700         1       2
 701         10      20
 702         11      21
 703
 704 echo select * from t88;
 705 ---------------------------------------------------------
 706         t88.f1  t88.f2
 707 ---------------------------------------------------------
 708         1       2
 709         10      20
 710         11      21
 711
 712 echo select * from t89;
 713 ---------------------------------------------------------
 714         t89.f1  t89.f2
 715 ---------------------------------------------------------
 716         1       2
 717         10      20
 718         11      21
 719
 720 echo select * from t90;
 721 ---------------------------------------------------------
 722         t90.f1  t90.f2
 723 ---------------------------------------------------------
 724         1       2
 725         10      20
 726         11      21
 727
 728 echo select * from t91;
 729 ---------------------------------------------------------
 730         t91.f1  t91.f2
 731 ---------------------------------------------------------
 732         1       2
 733         10      20
 734         11      21
 735
 736 echo select * from t92;
 737 ---------------------------------------------------------
 738         t92.f1  t92.f2
 739 ---------------------------------------------------------
 740         1       2
 741         10      20
 742         11      21
 743
 744 echo select * from t93;
 745 ---------------------------------------------------------
 746         t93.f1  t93.f2
 747 ---------------------------------------------------------
 748         1       2
 749         10      20
 750         11      21
 751
 752 echo select * from t94;
 753 ---------------------------------------------------------
 754         t94.f1  t94.f2
 755 ---------------------------------------------------------
 756         1       2
 757         10      20
 758         11      21
 759
 760 echo select * from t95;
 761 ---------------------------------------------------------
 762         t95.f1  t95.f2
 763 ---------------------------------------------------------
 764         1       2
 765         10      20
 766         11      21
 767
 768 echo select * from t96;
 769 ---------------------------------------------------------
 770         t96.f1  t96.f2
 771 ---------------------------------------------------------
 772         1       2
 773         10      20
 774         11      21
 775
 776 echo select * from t97;
 777 ---------------------------------------------------------
 778         t97.f1  t97.f2
 779 ---------------------------------------------------------
 780         1       2
 781         10      20
 782         11      21
 783
 784 echo select * from t98;
 785 ---------------------------------------------------------
 786         t98.f1  t98.f2
 787 ---------------------------------------------------------
 788         1       2
 789         10      20
 790         11      21
 791
 792 echo select * from t99;
 793 ---------------------------------------------------------
 794         t99.f1  t99.f2
 795 ---------------------------------------------------------
 796         1       2
 797         10      20
 798         11      21
 799
 800 echo select * from t100;
 801 ---------------------------------------------------------
 802         t100.f1 t100.f2
 803 ---------------------------------------------------------
 804         1       2
 805         10      20
 806         11      21
 807
 808 Delete some record in target database
 809 Records in csql after Delete some recode from target DB
 810 echo select * from t1;
 811 ---------------------------------------------------------
 812         t1.f1   t1.f2
 813 ---------------------------------------------------------
 814         1       2
 815
 816 echo select * from t2;
 817 ---------------------------------------------------------
 818         t2.f1   t2.f2
 819 ---------------------------------------------------------
 820         1       2
 821
 822 echo select * from t3;
 823 ---------------------------------------------------------
 824         t3.f1   t3.f2
 825 ---------------------------------------------------------
 826         1       2
 827
 828 echo select * from t4;
 829 ---------------------------------------------------------
 830         t4.f1   t4.f2
 831 ---------------------------------------------------------
 832         1       2
 833
 834 echo select * from t5;
 835 ---------------------------------------------------------
 836         t5.f1   t5.f2
 837 ---------------------------------------------------------
 838         1       2
 839
 840 echo select * from t6;
 841 ---------------------------------------------------------
 842         t6.f1   t6.f2
 843 ---------------------------------------------------------
 844         1       2
 845
 846 echo select * from t7;
 847 ---------------------------------------------------------
 848         t7.f1   t7.f2
 849 ---------------------------------------------------------
 850         1       2
 851
 852 echo select * from t8;
 853 ---------------------------------------------------------
 854         t8.f1   t8.f2
 855 ---------------------------------------------------------
 856         1       2
 857
 858 echo select * from t9;
 859 ---------------------------------------------------------
 860         t9.f1   t9.f2
 861 ---------------------------------------------------------
 862         1       2
 863
 864 echo select * from t10;
 865 ---------------------------------------------------------
 866         t10.f1  t10.f2
 867 ---------------------------------------------------------
 868         1       2
 869
 870 echo select * from t11;
 871 ---------------------------------------------------------
 872         t11.f1  t11.f2
 873 ---------------------------------------------------------
 874         1       2
 875
 876 echo select * from t12;
 877 ---------------------------------------------------------
 878         t12.f1  t12.f2
 879 ---------------------------------------------------------
 880         1       2
 881
 882 echo select * from t13;
 883 ---------------------------------------------------------
 884         t13.f1  t13.f2
 885 ---------------------------------------------------------
 886         1       2
 887
 888 echo select * from t14;
 889 ---------------------------------------------------------
 890         t14.f1  t14.f2
 891 ---------------------------------------------------------
 892         1       2
 893
 894 echo select * from t15;
 895 ---------------------------------------------------------
 896         t15.f1  t15.f2
 897 ---------------------------------------------------------
 898         1       2
 899
 900 echo select * from t16;
 901 ---------------------------------------------------------
 902         t16.f1  t16.f2
 903 ---------------------------------------------------------
 904         1       2
 905
 906 echo select * from t17;
 907 ---------------------------------------------------------
 908         t17.f1  t17.f2
 909 ---------------------------------------------------------
 910         1       2
 911
 912 echo select * from t18;
 913 ---------------------------------------------------------
 914         t18.f1  t18.f2
 915 ---------------------------------------------------------
 916         1       2
 917
 918 echo select * from t19;
 919 ---------------------------------------------------------
 920         t19.f1  t19.f2
 921 ---------------------------------------------------------
 922         1       2
 923
 924 echo select * from t20;
 925 ---------------------------------------------------------
 926         t20.f1  t20.f2
 927 ---------------------------------------------------------
 928         1       2
 929
 930 echo select * from t21;
 931 ---------------------------------------------------------
 932         t21.f1  t21.f2
 933 ---------------------------------------------------------
 934         1       2
 935
 936 echo select * from t22;
 937 ---------------------------------------------------------
 938         t22.f1  t22.f2
 939 ---------------------------------------------------------
 940         1       2
 941
 942 echo select * from t23;
 943 ---------------------------------------------------------
 944         t23.f1  t23.f2
 945 ---------------------------------------------------------
 946         1       2
 947
 948 echo select * from t24;
 949 ---------------------------------------------------------
 950         t24.f1  t24.f2
 951 ---------------------------------------------------------
 952         1       2
 953
 954 echo select * from t25;
 955 ---------------------------------------------------------
 956         t25.f1  t25.f2
 957 ---------------------------------------------------------
 958         1       2
 959
 960 echo select * from t26;
 961 ---------------------------------------------------------
 962         t26.f1  t26.f2
 963 ---------------------------------------------------------
 964         1       2
 965
 966 echo select * from t27;
 967 ---------------------------------------------------------
 968         t27.f1  t27.f2
 969 ---------------------------------------------------------
 970         1       2
 971
 972 echo select * from t28;
 973 ---------------------------------------------------------
 974         t28.f1  t28.f2
 975 ---------------------------------------------------------
 976         1       2
 977
 978 echo select * from t29;
 979 ---------------------------------------------------------
 980         t29.f1  t29.f2
 981 ---------------------------------------------------------
 982         1       2
 983
 984 echo select * from t30;
 985 ---------------------------------------------------------
 986         t30.f1  t30.f2
 987 ---------------------------------------------------------
 988         1       2
 989
 990 echo select * from t31;
 991 ---------------------------------------------------------
 992         t31.f1  t31.f2
 993 ---------------------------------------------------------
 994         1       2
 995
 996 echo select * from t32;
 997 ---------------------------------------------------------
 998         t32.f1  t32.f2
 999 ---------------------------------------------------------
1000         1       2
1001
1002 echo select * from t33;
1003 ---------------------------------------------------------
1004         t33.f1  t33.f2
1005 ---------------------------------------------------------
1006         1       2
1007
1008 echo select * from t34;
1009 ---------------------------------------------------------
1010         t34.f1  t34.f2
1011 ---------------------------------------------------------
1012         1       2
1013
1014 echo select * from t35;
1015 ---------------------------------------------------------
1016         t35.f1  t35.f2
1017 ---------------------------------------------------------
1018         1       2
1019
1020 echo select * from t36;
1021 ---------------------------------------------------------
1022         t36.f1  t36.f2
1023 ---------------------------------------------------------
1024         1       2
1025
1026 echo select * from t37;
1027 ---------------------------------------------------------
1028         t37.f1  t37.f2
1029 ---------------------------------------------------------
1030         1       2
1031
1032 echo select * from t38;
1033 ---------------------------------------------------------
1034         t38.f1  t38.f2
1035 ---------------------------------------------------------
1036         1       2
1037
1038 echo select * from t39;
1039 ---------------------------------------------------------
1040         t39.f1  t39.f2
1041 ---------------------------------------------------------
1042         1       2
1043
1044 echo select * from t40;
1045 ---------------------------------------------------------
1046         t40.f1  t40.f2
1047 ---------------------------------------------------------
1048         1       2
1049
1050 echo select * from t41;
1051 ---------------------------------------------------------
1052         t41.f1  t41.f2
1053 ---------------------------------------------------------
1054         1       2
1055
1056 echo select * from t42;
1057 ---------------------------------------------------------
1058         t42.f1  t42.f2
1059 ---------------------------------------------------------
1060         1       2
1061
1062 echo select * from t43;
1063 ---------------------------------------------------------
1064         t43.f1  t43.f2
1065 ---------------------------------------------------------
1066         1       2
1067
1068 echo select * from t44;
1069 ---------------------------------------------------------
1070         t44.f1  t44.f2
1071 ---------------------------------------------------------
1072         1       2
1073
1074 echo select * from t45;
1075 ---------------------------------------------------------
1076         t45.f1  t45.f2
1077 ---------------------------------------------------------
1078         1       2
1079
1080 echo select * from t46;
1081 ---------------------------------------------------------
1082         t46.f1  t46.f2
1083 ---------------------------------------------------------
1084         1       2
1085
1086 echo select * from t47;
1087 ---------------------------------------------------------
1088         t47.f1  t47.f2
1089 ---------------------------------------------------------
1090         1       2
1091
1092 echo select * from t48;
1093 ---------------------------------------------------------
1094         t48.f1  t48.f2
1095 ---------------------------------------------------------
1096         1       2
1097
1098 echo select * from t49;
1099 ---------------------------------------------------------
1100         t49.f1  t49.f2
1101 ---------------------------------------------------------
1102         1       2
1103
1104 echo select * from t50;
1105 ---------------------------------------------------------
1106         t50.f1  t50.f2
1107 ---------------------------------------------------------
1108         1       2
1109
1110 echo select * from t51;
1111 ---------------------------------------------------------
1112         t51.f1  t51.f2
1113 ---------------------------------------------------------
1114         1       2
1115
1116 echo select * from t52;
1117 ---------------------------------------------------------
1118         t52.f1  t52.f2
1119 ---------------------------------------------------------
1120         1       2
1121
1122 echo select * from t53;
1123 ---------------------------------------------------------
1124         t53.f1  t53.f2
1125 ---------------------------------------------------------
1126         1       2
1127
1128 echo select * from t54;
1129 ---------------------------------------------------------
1130         t54.f1  t54.f2
1131 ---------------------------------------------------------
1132         1       2
1133
1134 echo select * from t55;
1135 ---------------------------------------------------------
1136         t55.f1  t55.f2
1137 ---------------------------------------------------------
1138         1       2
1139
1140 echo select * from t56;
1141 ---------------------------------------------------------
1142         t56.f1  t56.f2
1143 ---------------------------------------------------------
1144         1       2
1145
1146 echo select * from t57;
1147 ---------------------------------------------------------
1148         t57.f1  t57.f2
1149 ---------------------------------------------------------
1150         1       2
1151
1152 echo select * from t58;
1153 ---------------------------------------------------------
1154         t58.f1  t58.f2
1155 ---------------------------------------------------------
1156         1       2
1157
1158 echo select * from t59;
1159 ---------------------------------------------------------
1160         t59.f1  t59.f2
1161 ---------------------------------------------------------
1162         1       2
1163
1164 echo select * from t60;
1165 ---------------------------------------------------------
1166         t60.f1  t60.f2
1167 ---------------------------------------------------------
1168         1       2
1169
1170 echo select * from t61;
1171 ---------------------------------------------------------
1172         t61.f1  t61.f2
1173 ---------------------------------------------------------
1174         1       2
1175
1176 echo select * from t62;
1177 ---------------------------------------------------------
1178         t62.f1  t62.f2
1179 ---------------------------------------------------------
1180         1       2
1181
1182 echo select * from t63;
1183 ---------------------------------------------------------
1184         t63.f1  t63.f2
1185 ---------------------------------------------------------
1186         1       2
1187
1188 echo select * from t64;
1189 ---------------------------------------------------------
1190         t64.f1  t64.f2
1191 ---------------------------------------------------------
1192         1       2
1193
1194 echo select * from t65;
1195 ---------------------------------------------------------
1196         t65.f1  t65.f2
1197 ---------------------------------------------------------
1198         1       2
1199
1200 echo select * from t66;
1201 ---------------------------------------------------------
1202         t66.f1  t66.f2
1203 ---------------------------------------------------------
1204         1       2
1205
1206 echo select * from t67;
1207 ---------------------------------------------------------
1208         t67.f1  t67.f2
1209 ---------------------------------------------------------
1210         1       2
1211
1212 echo select * from t68;
1213 ---------------------------------------------------------
1214         t68.f1  t68.f2
1215 ---------------------------------------------------------
1216         1       2
1217
1218 echo select * from t69;
1219 ---------------------------------------------------------
1220         t69.f1  t69.f2
1221 ---------------------------------------------------------
1222         1       2
1223
1224 echo select * from t70;
1225 ---------------------------------------------------------
1226         t70.f1  t70.f2
1227 ---------------------------------------------------------
1228         1       2
1229
1230 echo select * from t71;
1231 ---------------------------------------------------------
1232         t71.f1  t71.f2
1233 ---------------------------------------------------------
1234         1       2
1235
1236 echo select * from t72;
1237 ---------------------------------------------------------
1238         t72.f1  t72.f2
1239 ---------------------------------------------------------
1240         1       2
1241
1242 echo select * from t73;
1243 ---------------------------------------------------------
1244         t73.f1  t73.f2
1245 ---------------------------------------------------------
1246         1       2
1247
1248 echo select * from t74;
1249 ---------------------------------------------------------
1250         t74.f1  t74.f2
1251 ---------------------------------------------------------
1252         1       2
1253
1254 echo select * from t75;
1255 ---------------------------------------------------------
1256         t75.f1  t75.f2
1257 ---------------------------------------------------------
1258         1       2
1259
1260 echo select * from t76;
1261 ---------------------------------------------------------
1262         t76.f1  t76.f2
1263 ---------------------------------------------------------
1264         1       2
1265
1266 echo select * from t77;
1267 ---------------------------------------------------------
1268         t77.f1  t77.f2
1269 ---------------------------------------------------------
1270         1       2
1271
1272 echo select * from t78;
1273 ---------------------------------------------------------
1274         t78.f1  t78.f2
1275 ---------------------------------------------------------
1276         1       2
1277
1278 echo select * from t79;
1279 ---------------------------------------------------------
1280         t79.f1  t79.f2
1281 ---------------------------------------------------------
1282         1       2
1283
1284 echo select * from t80;
1285 ---------------------------------------------------------
1286         t80.f1  t80.f2
1287 ---------------------------------------------------------
1288         1       2
1289
1290 echo select * from t81;
1291 ---------------------------------------------------------
1292         t81.f1  t81.f2
1293 ---------------------------------------------------------
1294         1       2
1295
1296 echo select * from t82;
1297 ---------------------------------------------------------
1298         t82.f1  t82.f2
1299 ---------------------------------------------------------
1300         1       2
1301
1302 echo select * from t83;
1303 ---------------------------------------------------------
1304         t83.f1  t83.f2
1305 ---------------------------------------------------------
1306         1       2
1307
1308 echo select * from t84;
1309 ---------------------------------------------------------
1310         t84.f1  t84.f2
1311 ---------------------------------------------------------
1312         1       2
1313
1314 echo select * from t85;
1315 ---------------------------------------------------------
1316         t85.f1  t85.f2
1317 ---------------------------------------------------------
1318         1       2
1319
1320 echo select * from t86;
1321 ---------------------------------------------------------
1322         t86.f1  t86.f2
1323 ---------------------------------------------------------
1324         1       2
1325
1326 echo select * from t87;
1327 ---------------------------------------------------------
1328         t87.f1  t87.f2
1329 ---------------------------------------------------------
1330         1       2
1331
1332 echo select * from t88;
1333 ---------------------------------------------------------
1334         t88.f1  t88.f2
1335 ---------------------------------------------------------
1336         1       2
1337
1338 echo select * from t89;
1339 ---------------------------------------------------------
1340         t89.f1  t89.f2
1341 ---------------------------------------------------------
1342         1       2
1343
1344 echo select * from t90;
1345 ---------------------------------------------------------
1346         t90.f1  t90.f2
1347 ---------------------------------------------------------
1348         1       2
1349
1350 echo select * from t91;
1351 ---------------------------------------------------------
1352         t91.f1  t91.f2
1353 ---------------------------------------------------------
1354         1       2
1355
1356 echo select * from t92;
1357 ---------------------------------------------------------
1358         t92.f1  t92.f2
1359 ---------------------------------------------------------
1360         1       2
1361
1362 echo select * from t93;
1363 ---------------------------------------------------------
1364         t93.f1  t93.f2
1365 ---------------------------------------------------------
1366         1       2
1367
1368 echo select * from t94;
1369 ---------------------------------------------------------
1370         t94.f1  t94.f2
1371 ---------------------------------------------------------
1372         1       2
1373
1374 echo select * from t95;
1375 ---------------------------------------------------------
1376         t95.f1  t95.f2
1377 ---------------------------------------------------------
1378         1       2
1379
1380 echo select * from t96;
1381 ---------------------------------------------------------
1382         t96.f1  t96.f2
1383 ---------------------------------------------------------
1384         1       2
1385
1386 echo select * from t97;
1387 ---------------------------------------------------------
1388         t97.f1  t97.f2
1389 ---------------------------------------------------------
1390         1       2
1391
1392 echo select * from t98;
1393 ---------------------------------------------------------
1394         t98.f1  t98.f2
1395 ---------------------------------------------------------
1396         1       2
1397
1398 echo select * from t99;
1399 ---------------------------------------------------------
1400         t99.f1  t99.f2
1401 ---------------------------------------------------------
1402         1       2
1403
1404 echo select * from t100;
1405 ---------------------------------------------------------
1406         t100.f1 t100.f2
1407 ---------------------------------------------------------
1408         1       2
1409