test/cache/Bidirectional/exp.test013.ksh

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