test/tools/csql/exp.test091.ksh

   1 echo create table t1(f1 int);
   2 Statement Executed
   3 echo create index idx1 on t1(f1);
   4 Statement Executed
   5 echo insert into t1 values(1);
   6 Statement Executed: Rows Affected = 1
   7 echo insert into t1 values(3);
   8 Statement Executed: Rows Affected = 1
   9 echo insert into t1 values(2);
  10 Statement Executed: Rows Affected = 1
  11 echo insert into t1 values(11);
  12 Statement Executed: Rows Affected = 1
  13 echo insert into t1 values(10);
  14 Statement Executed: Rows Affected = 1
  15 echo select * from t1;
  16 ---------------------------------------------------------
  17         t1.f1
  18 ---------------------------------------------------------
  19         1
  20         3
  21         2
  22         11
  23         10
  24
  25 echo set autocommit off;
  26 AUTOCOMMIT Mode is set to OFF
  27 echo insert into t1  values(8);
  28 Statement Executed: Rows Affected = 1
  29 echo insert into t1  values(10);
  30 Statement Executed: Rows Affected = 1
  31 echo select * from t1;
  32 ---------------------------------------------------------
  33         t1.f1
  34 ---------------------------------------------------------
  35         1
  36         3
  37         2
  38         11
  39         10
  40         8
  41         10
  42
  43 echo commit;
  44 echo select * from t1;
  45 ---------------------------------------------------------
  46         t1.f1
  47 ---------------------------------------------------------
  48         1
  49         3
  50         2
  51         11
  52         10
  53         8
  54         10
  55
  56 echo rollback;
  57 echo select * from t1;
  58 ---------------------------------------------------------
  59         t1.f1
  60 ---------------------------------------------------------
  61         1
  62         3
  63         2
  64         11
  65         10
  66         8
  67         10
  68
  69 echo insert into t1 values(12);
  70 Statement Executed: Rows Affected = 1
  71 echo insert into t1 values(11);
  72 Statement Executed: Rows Affected = 1
  73 echo select * from t1;
  74 ---------------------------------------------------------
  75         t1.f1
  76 ---------------------------------------------------------
  77         1
  78         3
  79         2
  80         11
  81         10
  82         8
  83         10
  84         12
  85         11
  86
  87 echo rollback;
  88 echo select * from t1;
  89 ---------------------------------------------------------
  90         t1.f1
  91 ---------------------------------------------------------
  92         1
  93         3
  94         2
  95         11
  96         10
  97         8
  98         10
  99
 100 echo commit;
 101 echo select * from t1;
 102 ---------------------------------------------------------
 103         t1.f1
 104 ---------------------------------------------------------
 105         1
 106         3
 107         2
 108         11
 109         10
 110         8
 111         10
 112
 113 echo update t1 set f1=15 where f1=3;
 114 Statement Executed: Rows Affected = 1
 115 echo update t1 set f1=11 where f1=2;
 116 Statement Executed: Rows Affected = 1
 117 echo select * from t1;
 118 ---------------------------------------------------------
 119         t1.f1
 120 ---------------------------------------------------------
 121         1
 122         15
 123         11
 124         11
 125         10
 126         8
 127         10
 128
 129 echo rollback;
 130 echo select * from t1;
 131 ---------------------------------------------------------
 132         t1.f1
 133 ---------------------------------------------------------
 134         1
 135         3
 136         2
 137         11
 138         10
 139         8
 140         10
 141
 142 echo select * from t1 where f1=3;
 143 ---------------------------------------------------------
 144         t1.f1
 145 ---------------------------------------------------------
 146         3
 147
 148 echo update t1 set f1=30 where f1=3;
 149 Statement Executed: Rows Affected = 1
 150 echo select * from t1;
 151 ---------------------------------------------------------
 152         t1.f1
 153 ---------------------------------------------------------
 154         1
 155         30
 156         2
 157         11
 158         10
 159         8
 160         10
 161
 162 echo commit;
 163 echo select * from t1;
 164 ---------------------------------------------------------
 165         t1.f1
 166 ---------------------------------------------------------
 167         1
 168         30
 169         2
 170         11
 171         10
 172         8
 173         10
 174
 175 echo delete from t1 where f1=30;
 176 Statement Executed: Rows Affected = 1
 177 echo select * from t1;
 178 ---------------------------------------------------------
 179         t1.f1
 180 ---------------------------------------------------------
 181         1
 182         2
 183         11
 184         10
 185         8
 186         10
 187
 188 echo delete from t1 where f1=3;
 189 Statement Executed: Rows Affected = 0
 190 echo select * from t1;
 191 ---------------------------------------------------------
 192         t1.f1
 193 ---------------------------------------------------------
 194         1
 195         2
 196         11
 197         10
 198         8
 199         10
 200
 201 echo rollback;
 202 echo select * from t1;
 203 ---------------------------------------------------------
 204         t1.f1
 205 ---------------------------------------------------------
 206         1
 207         30
 208         2
 209         11
 210         10
 211         8
 212         10
 213
 214 echo delete from t1 where f1=30;
 215 Statement Executed: Rows Affected = 1
 216 echo select * from t1;
 217 ---------------------------------------------------------
 218         t1.f1
 219 ---------------------------------------------------------
 220         1
 221         2
 222         11
 223         10
 224         8
 225         10
 226
 227 echo delete from t1 where f1=3;
 228 Statement Executed: Rows Affected = 0
 229 echo select * from t1;
 230 ---------------------------------------------------------
 231         t1.f1
 232 ---------------------------------------------------------
 233         1
 234         2
 235         11
 236         10
 237         8
 238         10
 239
 240 echo commit;
 241 echo select * from t1;
 242 ---------------------------------------------------------
 243         t1.f1
 244 ---------------------------------------------------------
 245         1
 246         2
 247         11
 248         10
 249         8
 250         10
 251
 252 echo delete  from t1 where f1<=10;
 253 Statement Executed: Rows Affected = 5
 254 echo select * from t1;
 255 ---------------------------------------------------------
 256         t1.f1
 257 ---------------------------------------------------------
 258         11
 259
 260 echo delete from t1;
 261 Statement Executed: Rows Affected = 1
 262 echo commit;
 263 echo select * from t1;
 264 ---------------------------------------------------------
 265         t1.f1
 266 ---------------------------------------------------------
 267
 268 echo drop table t1;
 269 Statement Executed
 270 echo quit;
 271 echo create table t1(f1 int,f2 int,f3 int);
 272 Statement Executed
 273 echo create index idx1 on t1(f1,f2);
 274 Statement Executed
 275 echo insert into t1 values(1,10,100);
 276 Statement Executed: Rows Affected = 1
 277 echo insert into t1 values(3,33,333);
 278 Statement Executed: Rows Affected = 1
 279 echo insert into t1 values(2,33,444);
 280 Statement Executed: Rows Affected = 1
 281 echo set autocommit off;
 282 AUTOCOMMIT Mode is set to OFF
 283 echo insert into t1 values(4,40,400);
 284 Statement Executed: Rows Affected = 1
 285 echo insert into t1 values(3,33,333);
 286 Statement Executed: Rows Affected = 1
 287 echo select * from t1;
 288 ---------------------------------------------------------
 289         t1.f1   t1.f2   t1.f3
 290 ---------------------------------------------------------
 291         1       10      100
 292         3       33      333
 293         2       33      444
 294         4       40      400
 295         3       33      333
 296
 297 echo rollback;
 298 echo select * from t1;
 299 ---------------------------------------------------------
 300         t1.f1   t1.f2   t1.f3
 301 ---------------------------------------------------------
 302         1       10      100
 303         3       33      333
 304         2       33      444
 305
 306 echo commit;
 307 echo select * from t1;
 308 ---------------------------------------------------------
 309         t1.f1   t1.f2   t1.f3
 310 ---------------------------------------------------------
 311         1       10      100
 312         3       33      333
 313         2       33      444
 314
 315 echo insert into t1 values(4,40,400);
 316 Statement Executed: Rows Affected = 1
 317 echo insert into t1 values(3,33,333);
 318 Statement Executed: Rows Affected = 1
 319 echo select * from t1;
 320 ---------------------------------------------------------
 321         t1.f1   t1.f2   t1.f3
 322 ---------------------------------------------------------
 323         1       10      100
 324         3       33      333
 325         2       33      444
 326         4       40      400
 327         3       33      333
 328
 329 echo commit;
 330 echo select * from t1;
 331 ---------------------------------------------------------
 332         t1.f1   t1.f2   t1.f3
 333 ---------------------------------------------------------
 334         1       10      100
 335         3       33      333
 336         2       33      444
 337         4       40      400
 338         3       33      333
 339
 340 echo rollback;
 341 echo select * from t1;
 342 ---------------------------------------------------------
 343         t1.f1   t1.f2   t1.f3
 344 ---------------------------------------------------------
 345         1       10      100
 346         3       33      333
 347         2       33      444
 348         4       40      400
 349         3       33      333
 350
 351 echo update t1 set f1=20 where f1=2;
 352 Statement Executed: Rows Affected = 1
 353 echo select * from t1 where f1=20;
 354 ---------------------------------------------------------
 355         t1.f1   t1.f2   t1.f3
 356 ---------------------------------------------------------
 357         20      33      444
 358
 359 echo update t1 set f2=333 where f3=444;
 360 Statement Executed: Rows Affected = 1
 361 echo select * from t1 where f3=444;
 362 ---------------------------------------------------------
 363         t1.f1   t1.f2   t1.f3
 364 ---------------------------------------------------------
 365         20      333     444
 366
 367 echo select * from t1;
 368 ---------------------------------------------------------
 369         t1.f1   t1.f2   t1.f3
 370 ---------------------------------------------------------
 371         1       10      100
 372         3       33      333
 373         20      333     444
 374         4       40      400
 375         3       33      333
 376
 377 echo update t1 set f1=1,f2=10 where f1=20;
 378 Statement Executed: Rows Affected = 1
 379 echo select * from t1;
 380 ---------------------------------------------------------
 381         f1      f2      f3
 382 ---------------------------------------------------------
 383         1       10      100
 384         3       33      333
 385         1       10      444
 386         4       40      400
 387         3       33      333
 388
 389 echo rollback;
 390 echo select * from t1 where f1=33;
 391 ---------------------------------------------------------
 392         t1f1    t1f2    t1.f3
 393 ---------------------------------------------------------
 394
 395 echo select * from t1 where f1=2;
 396 ---------------------------------------------------------
 397         t1.f1   t1.f2   t1.f3
 398 ---------------------------------------------------------
 399         2       33      444
 400
 401 echo select * from t1 where f1=2 and f2=33;
 402 ---------------------------------------------------------
 403         t1.f1   t1.f2   t1.f3
 404 ---------------------------------------------------------
 405         2       33      444
 406
 407 echo update t1 set f1=20 where f1=2;
 408 Statement Executed: Rows Affected = 1
 409 echo select * from t1 where f1=20;
 410 ---------------------------------------------------------
 411         t1.f1   t1.f2   t1.f3
 412 ---------------------------------------------------------
 413         20      33      444
 414
 415 echo update t1 set f2=333 where f3=444;
 416 Statement Executed: Rows Affected = 1
 417 echo select * from t1;
 418 ---------------------------------------------------------
 419         t1.f1   t1.f2   t1.f3
 420 ---------------------------------------------------------
 421         1       10      100
 422         3       33      333
 423         20      333     444
 424         4       40      400
 425         3       33      333
 426
 427 echo select * from t1 where f3=444;
 428 ---------------------------------------------------------
 429         t1.f1   t1.f2   t1.f3
 430 ---------------------------------------------------------
 431         20      333     444
 432
 433 echo select * from t1;
 434 ---------------------------------------------------------
 435         t1.f1   t1.f2   t1.f3
 436 ---------------------------------------------------------
 437         1       10      100
 438         3       33      333
 439         20      333     444
 440         4       40      400
 441         3       33      333
 442
 443 echo update t1 set f1=1,f2=10 where f1=20;
 444 Statement Executed: Rows Affected = 1
 445 echo select * from t1;
 446 ---------------------------------------------------------
 447         t1.f1   t1.f2   t1.f3
 448 ---------------------------------------------------------
 449         1       10      100
 450         3       33      333
 451         1       10      444
 452         4       40      400
 453         3       33      333
 454
 455 echo commit;
 456 echo select *from t1;
 457 ---------------------------------------------------------
 458         t1.f1   t1.f2   t1.f3
 459 ---------------------------------------------------------
 460         1       10      100
 461         3       33      333
 462         1       10      444
 463         4       40      400
 464         3       33      333
 465
 466 echo select * from t1 where f1=1;
 467 ---------------------------------------------------------
 468         t1.f1   t1.f2   t1.f3
 469 ---------------------------------------------------------
 470         1       10      100
 471         1       10      444
 472
 473 echo select * from t1 where f1=2;
 474 ---------------------------------------------------------
 475         t1.f1   t1.f2   t1.f3
 476 ---------------------------------------------------------
 477
 478 echo select * from t1 where f1=2 and f2=33;
 479 ---------------------------------------------------------
 480         t1.f1   t1.f2   t1.f3
 481 ---------------------------------------------------------
 482
 483 echo select * from t1;
 484 ---------------------------------------------------------
 485         t1.f1   t1.f2   t1.f3
 486 ---------------------------------------------------------
 487         1       10      100
 488         3       33      333
 489         1       10      444
 490         4       40      400
 491         3       33      333
 492
 493 echo delete from t1 where f1=3 and f2=33;
 494 Statement Executed: Rows Affected = 2
 495 echo select * from t1;
 496 ---------------------------------------------------------
 497         t1.f1   t1.f2   t1.f3
 498 ---------------------------------------------------------
 499         1       10      100
 500         1       10      444
 501         4       40      400
 502
 503 echo delete from t1 where f1 in(1,5) and f2 in(50,10);
 504 Statement Executed: Rows Affected = 2
 505 echo select * from t1;
 506 ---------------------------------------------------------
 507         t1.f1   t1.f2   t1.f3
 508 ---------------------------------------------------------
 509         4       40      400
 510
 511 echo delete from t1 where f2 between 33 and 45;
 512 Statement Executed: Rows Affected = 1
 513 echo select * from t1;
 514 ---------------------------------------------------------
 515         t1.f1   t1.f2   t1.f3
 516 ---------------------------------------------------------
 517
 518 echo delete from t1;
 519 Statement Executed: Rows Affected = 0
 520 echo select * from t1;
 521 ---------------------------------------------------------
 522         t1.f1   t1.f2   t1.f3
 523 ---------------------------------------------------------
 524
 525 echo rollback;
 526 echo select * from t1;
 527 ---------------------------------------------------------
 528         t1.f1   t1.f2   t1.f3
 529 ---------------------------------------------------------
 530         1       10      100
 531         3       33      333
 532         1       10      444
 533         4       40      400
 534         3       33      333
 535
 536 echo delete from t1 where f1=3 and f2=33;
 537 Statement Executed: Rows Affected = 2
 538 echo select * from t1;
 539 ---------------------------------------------------------
 540         t1.f1   t1.f2   t1.f3
 541 ---------------------------------------------------------
 542         1       10      100
 543         1       10      444
 544         4       40      400
 545
 546 echo delete from t1 where f1 in(1,5) and f2 in(50,10);
 547 Statement Executed: Rows Affected = 2
 548 echo select * from t1;
 549 ---------------------------------------------------------
 550         t1.f1   t1.f2   t1.f3
 551 ---------------------------------------------------------
 552         4       40      400
 553
 554 echo commit;
 555 echo delete from t1 where f2 between 33 and 45;
 556 Statement Executed: Rows Affected = 1
 557 echo select * from t1;
 558 ---------------------------------------------------------
 559         t1.f1   t1.f2   t1.f3
 560 ---------------------------------------------------------
 561
 562 echo delete from t1;
 563 Statement Executed: Rows Affected = 0
 564 echo select * from t1;
 565 ---------------------------------------------------------
 566         t1.f1   t1.f2   t1.f3
 567 ---------------------------------------------------------
 568
 569 echo select * from t1;
 570 ---------------------------------------------------------
 571         t1.f1   t1.f2   t1.f3
 572 ---------------------------------------------------------
 573
 574 echo drop table t1;
 575 Statement Executed
 576 echo quit;
 577 echo create table t1(f1 int,f2 int,f3 int);
 578 Statement Executed
 579 echo create index idx1 on t1(f1,f3);
 580 Statement Executed
 581 echo insert into t1 values(1,10,100);
 582 Statement Executed: Rows Affected = 1
 583 echo insert into t1 values(3,33,333);
 584 Statement Executed: Rows Affected = 1
 585 echo insert into t1 values(2,33,444);
 586 Statement Executed: Rows Affected = 1
 587 echo set autocommit off;
 588 AUTOCOMMIT Mode is set to OFF
 589 echo insert into t1 values(4,40,400);
 590 Statement Executed: Rows Affected = 1
 591 echo insert into t1 values(3,33,333);
 592 Statement Executed: Rows Affected = 1
 593 echo select * from t1;
 594 ---------------------------------------------------------
 595         t1.f1   t1.f2   t1.f3
 596 ---------------------------------------------------------
 597         1       10      100
 598         3       33      333
 599         2       33      444
 600         4       40      400
 601         3       33      333
 602
 603 echo rollback;
 604 echo select * from t1;
 605 ---------------------------------------------------------
 606         t1.f1   t1.f2   t1.f3
 607 ---------------------------------------------------------
 608         1       10      100
 609         3       33      333
 610         2       33      444
 611
 612 echo commit;
 613 echo select * from t1;
 614 ---------------------------------------------------------
 615         t1.f1   t1.f2   t1.f3
 616 ---------------------------------------------------------
 617         1       10      100
 618         3       33      333
 619         2       33      444
 620
 621 echo insert into t1 values(4,40,400);
 622 Statement Executed: Rows Affected = 1
 623 echo insert into t1 values(3,33,333);
 624 Statement Executed: Rows Affected = 1
 625 echo select * from t1;
 626 ---------------------------------------------------------
 627         t1.f1   t1.f2   t1.f3
 628 ---------------------------------------------------------
 629         1       10      100
 630         3       33      333
 631         2       33      444
 632         4       40      400
 633         3       33      333
 634
 635 echo commit;
 636 echo select * from t1;
 637 ---------------------------------------------------------
 638         t1.f1   t1.f2   t1.f3
 639 ---------------------------------------------------------
 640         1       10      100
 641         3       33      333
 642         2       33      444
 643         4       40      400
 644         3       33      333
 645
 646 echo rollback;
 647 echo select * from t1;
 648 ---------------------------------------------------------
 649         t1.f1   t1.f2   t1.f3
 650 ---------------------------------------------------------
 651         1       10      100
 652         3       33      333
 653         2       33      444
 654         4       40      400
 655         3       33      333
 656
 657 echo update t1 set f1=20 where f1=2;
 658 Statement Executed: Rows Affected = 1
 659 echo select * from t1 where f1=20;
 660 ---------------------------------------------------------
 661         t1.f1   t1.f2   t1.f3
 662 ---------------------------------------------------------
 663         20      33      444
 664
 665 echo update t1 set f2=333 where f3=444;
 666 Statement Executed: Rows Affected = 1
 667 echo select * from t1 where f3=444;
 668 ---------------------------------------------------------
 669         t1.f1   t1.f2   t1.f3
 670 ---------------------------------------------------------
 671         20      333     444
 672
 673 echo select * from t1;
 674 ---------------------------------------------------------
 675         t1.f1   t1.f2   t1.f3
 676 ---------------------------------------------------------
 677         1       10      100
 678         3       33      333
 679         20      333     444
 680         4       40      400
 681         3       33      333
 682
 683 echo update t1 set f1=1,f2=10 where f1=20;
 684 Statement Executed: Rows Affected = 1
 685 echo select * from t1;
 686 ---------------------------------------------------------
 687         t1.f1   t1.f2   t1.f3
 688 ---------------------------------------------------------
 689         1       10      100
 690         3       33      333
 691         1       10      444
 692         4       40      400
 693         3       33      333
 694
 695 echo rollback;
 696 echo select * from t1 where f1=33;
 697 ---------------------------------------------------------
 698         t1.f1   t1.f2   t1.f3
 699 ---------------------------------------------------------
 700
 701 echo select * from t1 where f1=2;
 702 ---------------------------------------------------------
 703         t1.f1   t1.f2   t1.f3
 704 ---------------------------------------------------------
 705         2       33      444
 706
 707 echo select * from t1 where f1=2 and f3=444;
 708 ---------------------------------------------------------
 709         t1.f1   t1.f2   t1.f3
 710 ---------------------------------------------------------
 711         2       33      444
 712
 713 echo update t1 set f1=20 where f1=2;
 714 Statement Executed: Rows Affected = 1
 715 echo select * from t1 where f1=20;
 716 ---------------------------------------------------------
 717         t1.f1   t1.f2   t1.f3
 718 ---------------------------------------------------------
 719         20      33      444
 720
 721 echo update t1 set f2=333 where f3=444;
 722 Statement Executed: Rows Affected = 1
 723 echo select * from t1;
 724 ---------------------------------------------------------
 725         t1.f1   t1.f2   t1.f3
 726 ---------------------------------------------------------
 727         1       10      100
 728         3       33      333
 729         20      333     444
 730         4       40      400
 731         3       33      333
 732
 733 echo select * from t1 where f3=444;
 734 ---------------------------------------------------------
 735         t1.f1   t1.f2   t1.f3
 736 ---------------------------------------------------------
 737         20      333     444
 738
 739 echo select * from t1;
 740 ---------------------------------------------------------
 741         t1.f1   t1.f2   t1.f3
 742 ---------------------------------------------------------
 743         1       10      100
 744         3       33      333
 745         20      333     444
 746         4       40      400
 747         3       33      333
 748
 749 echo update t1 set f1=1,f2=10 where f1=20;
 750 Statement Executed: Rows Affected = 1
 751 echo select * from t1;
 752 ---------------------------------------------------------
 753         t1.f1   t1.f2   t1.f3
 754 ---------------------------------------------------------
 755         1       10      100
 756         3       33      333
 757         1       10      444
 758         4       40      400
 759         3       33      333
 760
 761 echo commit;
 762 echo select *from t1;
 763 ---------------------------------------------------------
 764         t1.f1   t1.f2   t1.f3
 765 ---------------------------------------------------------
 766         1       10      100
 767         3       33      333
 768         1       10      444
 769         4       40      400
 770         3       33      333
 771
 772 echo select * from t1 where f1=1;
 773 ---------------------------------------------------------
 774         t1.f1   t1.f2   t1.f3
 775 ---------------------------------------------------------
 776         1       10      100
 777         1       10      444
 778
 779 echo select * from t1 where f1=2;
 780 ---------------------------------------------------------
 781         t1.f1   t1.f2   t1.f3
 782 ---------------------------------------------------------
 783
 784 echo select * from t1 where f1=2 and f3=444;
 785 ---------------------------------------------------------
 786         t1.f1   t1.f2   t1.f3
 787 ---------------------------------------------------------
 788
 789 echo select * from t1;
 790 ---------------------------------------------------------
 791         t1.f1   t1.f2   t1.f3
 792 ---------------------------------------------------------
 793         1       10      100
 794         3       33      333
 795         1       10      444
 796         4       40      400
 797         3       33      333
 798
 799 echo delete from t1 where f1=3 and f3=333;
 800 Statement Executed: Rows Affected = 2
 801 echo select * from t1;
 802 ---------------------------------------------------------
 803         t1.f1   t1.f2   t1.f3
 804 ---------------------------------------------------------
 805         1       10      100
 806         1       10      444
 807         4       40      400
 808
 809 echo delete from t1 where f1 in(1,5) and f3 in(50,100);
 810 Statement Executed: Rows Affected = 1
 811 echo select * from t1;
 812 ---------------------------------------------------------
 813         t1.f1   t1.f2   t1.f3
 814 ---------------------------------------------------------
 815         1       10      444
 816         4       40      400
 817
 818 echo delete from t1 where f2 between 33 and 45;
 819 Statement Executed: Rows Affected = 1
 820 echo select * from t1;
 821 ---------------------------------------------------------
 822         t1.f1   t1.f2   t1.f3
 823 ---------------------------------------------------------
 824         1       10      444
 825
 826 echo delete from t1;
 827 Statement Executed: Rows Affected = 1
 828 echo select * from t1;
 829 ---------------------------------------------------------
 830         t1.f1   t1.f2   t1.f3
 831 ---------------------------------------------------------
 832
 833 echo rollback;
 834 echo select * from t1;
 835 ---------------------------------------------------------
 836         t1.f1   t1.f2   t1.f3
 837 ---------------------------------------------------------
 838         1       10      100
 839         3       33      333
 840         1       10      444
 841         4       40      400
 842         3       33      333
 843
 844 echo delete from t1 where f1=3 and f3=333;
 845 Statement Executed: Rows Affected = 2
 846 echo select * from t1;
 847 ---------------------------------------------------------
 848         t1.f1   t1.f2   t1.f3
 849 ---------------------------------------------------------
 850         1       10      100
 851         1       10      444
 852         4       40      400
 853
 854 echo delete from t1 where f1 in(1,5) and f3 in(50,100);
 855 Statement Executed: Rows Affected = 1
 856 echo select * from t1;
 857 ---------------------------------------------------------
 858         t1.f1   t1.f2   t1.f3
 859 ---------------------------------------------------------
 860         1       10      444
 861         4       40      400
 862
 863 echo commit;
 864 echo delete from t1 where f2 between 33 and 45;
 865 Statement Executed: Rows Affected = 1
 866 echo select * from t1;
 867 ---------------------------------------------------------
 868         t1.f1   t1.f2   t1.f3
 869 ---------------------------------------------------------
 870         1       10      444
 871
 872 echo delete from t1;
 873 Statement Executed: Rows Affected = 1
 874 echo select * from t1;
 875 ---------------------------------------------------------
 876         t1.f1   t1.f2   t1.f3
 877 ---------------------------------------------------------
 878
 879 echo select * from t1;
 880 ---------------------------------------------------------
 881         t1.f1   t1.f2   t1.f3
 882 ---------------------------------------------------------
 883
 884 echo drop table t1;
 885 Statement Executed
 886 echo quit;
 887 echo create table t1(f1 int,f2 int,f3 int);
 888 Statement Executed
 889 echo create index idx1 on t1(f3,f2);
 890 Statement Executed
 891 echo insert into t1 values(1,10,100);
 892 Statement Executed: Rows Affected = 1
 893 echo insert into t1 values(3,33,333);
 894 Statement Executed: Rows Affected = 1
 895 echo insert into t1 values(2,33,444);
 896 Statement Executed: Rows Affected = 1
 897 echo set autocommit off;
 898 AUTOCOMMIT Mode is set to OFF
 899 echo insert into t1 values(4,40,400);
 900 Statement Executed: Rows Affected = 1
 901 echo insert into t1 values(3,33,333);
 902 Statement Executed: Rows Affected = 1
 903 echo select * from t1;
 904 ---------------------------------------------------------
 905         t1.f1   t1.f2   t1.f3
 906 ---------------------------------------------------------
 907         1       10      100
 908         3       33      333
 909         2       33      444
 910         4       40      400
 911         3       33      333
 912
 913 echo rollback;
 914 echo select * from t1;
 915 ---------------------------------------------------------
 916         t1.f1   t1.f2   t1.f3
 917 ---------------------------------------------------------
 918         1       10      100
 919         3       33      333
 920         2       33      444
 921
 922 echo commit;
 923 echo select * from t1;
 924 ---------------------------------------------------------
 925         t1.f1   t1.f2   t1.f3
 926 ---------------------------------------------------------
 927         1       10      100
 928         3       33      333
 929         2       33      444
 930
 931 echo insert into t1 values(4,40,400);
 932 Statement Executed: Rows Affected = 1
 933 echo insert into t1 values(3,33,333);
 934 Statement Executed: Rows Affected = 1
 935 echo select * from t1;
 936 ---------------------------------------------------------
 937         t1.f1   t1.f2   t1.f3
 938 ---------------------------------------------------------
 939         1       10      100
 940         3       33      333
 941         2       33      444
 942         4       40      400
 943         3       33      333
 944
 945 echo commit;
 946 echo select * from t1;
 947 ---------------------------------------------------------
 948         t1.f1   t1.f2   t1.f3
 949 ---------------------------------------------------------
 950         1       10      100
 951         3       33      333
 952         2       33      444
 953         4       40      400
 954         3       33      333
 955
 956 echo rollback;
 957 echo select * from t1;
 958 ---------------------------------------------------------
 959         t1.f1   t1.f2   t1.f3
 960 ---------------------------------------------------------
 961         1       10      100
 962         3       33      333
 963         2       33      444
 964         4       40      400
 965         3       33      333
 966
 967 echo update t1 set f1=20 where f1=2;
 968 Statement Executed: Rows Affected = 1
 969 echo select * from t1 where f1=20;
 970 ---------------------------------------------------------
 971         t1.f1   t1.f2   t1.f3
 972 ---------------------------------------------------------
 973         20      33      444
 974
 975 echo update t1 set f2=333 where f3=444;
 976 Statement Executed: Rows Affected = 1
 977 echo select * from t1 where f3=444;
 978 ---------------------------------------------------------
 979         t1.f1   t1.f2   t1.f3
 980 ---------------------------------------------------------
 981         20      333     444
 982
 983 echo select * from t1;
 984 ---------------------------------------------------------
 985         t1.f1   t1.f2   t1.f3
 986 ---------------------------------------------------------
 987         1       10      100
 988         3       33      333
 989         20      333     444
 990         4       40      400
 991         3       33      333
 992
 993 echo update t1 set f1=1,f2=10 where f1=20;
 994 Statement Executed: Rows Affected = 1
 995 echo select * from t1;
 996 ---------------------------------------------------------
 997         t1.f1   t1.f2   t1.f3
 998 ---------------------------------------------------------
 999         1       10      100
1000         3       33      333
1001         1       10      444
1002         4       40      400
1003         3       33      333
1004
1005 echo rollback;
1006 echo select * from t1 where f1=33;
1007 ---------------------------------------------------------
1008         t1.f1   t1.f2   t1.f3
1009 ---------------------------------------------------------
1010
1011 echo select * from t1 where f1=2;
1012 ---------------------------------------------------------
1013         t1.f1   t1.f2   t1.f3
1014 ---------------------------------------------------------
1015         2       33      444
1016
1017 echo select * from t1 where f1=2 and f2=33;
1018 ---------------------------------------------------------
1019         t1.f1   t1.f2   t1.f3
1020 ---------------------------------------------------------
1021         2       33      444
1022
1023 echo update t1 set f1=20 where f1=2;
1024 Statement Executed: Rows Affected = 1
1025 echo select * from t1 where f1=20;
1026 ---------------------------------------------------------
1027         t1.f1   t1.f2   t1.f3
1028 ---------------------------------------------------------
1029         20      33      444
1030
1031 echo update t1 set f2=333 where f3=444;
1032 Statement Executed: Rows Affected = 1
1033 echo select * from t1;
1034 ---------------------------------------------------------
1035         t1.f1   t1.f2   t1.f3
1036 ---------------------------------------------------------
1037         1       10      100
1038         3       33      333
1039         20      333     444
1040         4       40      400
1041         3       33      333
1042
1043 echo select * from t1 where f3=444;
1044 ---------------------------------------------------------
1045         t1.f1   t1.f2   t1.f3
1046 ---------------------------------------------------------
1047         20      333     444
1048
1049 echo select * from t1;
1050 ---------------------------------------------------------
1051         t1.f1   t1.f2   t1.f3
1052 ---------------------------------------------------------
1053         1       10      100
1054         3       33      333
1055         20      333     444
1056         4       40      400
1057         3       33      333
1058
1059 echo update t1 set f1=1,f2=10 where f1=20;
1060 Statement Executed: Rows Affected = 1
1061 echo select * from t1;
1062 ---------------------------------------------------------
1063         t1.f1   t1.f2   t1.f3
1064 ---------------------------------------------------------
1065         1       10      100
1066         3       33      333
1067         1       10      444
1068         4       40      400
1069         3       33      333
1070
1071 echo commit;
1072 echo select *from t1;
1073 ---------------------------------------------------------
1074         t1.f1   t1.f2   t1.f3
1075 ---------------------------------------------------------
1076         1       10      100
1077         3       33      333
1078         1       10      444
1079         4       40      400
1080         3       33      333
1081
1082 echo select * from t1 where f1=1;
1083 ---------------------------------------------------------
1084         t1.f1   t1.f2   t1.f3
1085 ---------------------------------------------------------
1086         1       10      100
1087         1       10      444
1088
1089 echo select * from t1 where f1=2;
1090 ---------------------------------------------------------
1091         t1.f1   t1.f2   t1.f3
1092 ---------------------------------------------------------
1093
1094 echo select * from t1 where f1=2 and f2=33;
1095 ---------------------------------------------------------
1096         t1.f1   t1.f2   t1.f3
1097 ---------------------------------------------------------
1098
1099 echo select * from t1;
1100 ---------------------------------------------------------
1101         t1.f1   t1.f2   t1.f3
1102 ---------------------------------------------------------
1103         1       10      100
1104         3       33      333
1105         1       10      444
1106         4       40      400
1107         3       33      333
1108
1109 echo delete from t1 where f3=333 and f2=33;
1110 Statement Executed: Rows Affected = 2
1111 echo select * from t1;
1112 ---------------------------------------------------------
1113         t1.f1   t1.f2   t1.f3
1114 ---------------------------------------------------------
1115         1       10      100
1116         1       10      444
1117         4       40      400
1118
1119 echo delete from t1 where f2 in(10,40) and f3 in(400,10);
1120 Statement Executed: Rows Affected = 1
1121 echo select * from t1;
1122 ---------------------------------------------------------
1123         t1.f1   t1.f2   t1.f3
1124 ---------------------------------------------------------
1125         1       10      100
1126         1       10      444
1127
1128 echo delete from t1 where f2 between 33 and 45;
1129 Statement Executed: Rows Affected = 0
1130 echo select * from t1;
1131 ---------------------------------------------------------
1132         t1.f1   t1.f2   t1.f3
1133 ---------------------------------------------------------
1134         1       10      100
1135         1       10      444
1136
1137 echo delete from t1;
1138 Statement Executed: Rows Affected = 2
1139 echo select * from t1;
1140 ---------------------------------------------------------
1141         t1.f1   t1.f2   t1.f3
1142 ---------------------------------------------------------
1143
1144 echo rollback;
1145 echo select * from t1;
1146 ---------------------------------------------------------
1147         t1.f1   t1.f2   t1.f3
1148 ---------------------------------------------------------
1149         1       10      100
1150         3       33      333
1151         1       10      444
1152         4       40      400
1153         3       33      333
1154
1155 echo delete from t1 where f3=333 and f2=33;
1156 Statement Executed: Rows Affected = 2
1157 echo select * from t1;
1158 ---------------------------------------------------------
1159         t1.f1   t1.f2   t1.f3
1160 ---------------------------------------------------------
1161         1       10      100
1162         1       10      444
1163         4       40      400
1164
1165 echo delete from t1 where f2 in(10,40) and f3 in(400,10);
1166 Statement Executed: Rows Affected = 1
1167 echo select * from t1;
1168 ---------------------------------------------------------
1169         t1.f1   t1.f2   t1.f3
1170 ---------------------------------------------------------
1171         1       10      100
1172         1       10      444
1173
1174 echo commit;
1175 echo delete from t1 where f2 between 33 and 45;
1176 Statement Executed: Rows Affected = 0
1177 echo select * from t1;
1178 ---------------------------------------------------------
1179         t1.f1   t1.f2   t1.f3
1180 ---------------------------------------------------------
1181         1       10      100
1182         1       10      444
1183
1184 echo delete from t1;
1185 Statement Executed: Rows Affected = 2
1186 echo select * from t1;
1187 ---------------------------------------------------------
1188         t1.f1   t1.f2   t1.f3
1189 ---------------------------------------------------------
1190
1191 echo select * from t1;
1192 ---------------------------------------------------------
1193         t1.f1   t1.f2   t1.f3
1194 ---------------------------------------------------------
1195
1196 echo drop table t1;
1197 Statement Executed
1198 echo quit;