test/cache/Bidirectional/exp.test014.ksh

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