test/tools/csql/exp.test093.ksh

   1 echo testing Select Operation Using Primary key
   2 echo CREATE TABLE T4(F1 INT,F2 SMALLINT,F3 BIGINT,PRIMARY KEY(F1,F2));
   3 Statement Executed
   4 echo INSERT INTO T4 VALUES(1,10,100);
   5 Statement Executed: Rows Affected = 1
   6 echo INSERT INTO T4 VALUES(2,10,100);
   7 Statement Executed: Rows Affected = 1
   8 echo INSERT INTO T4 VALUES(1,20,100);
   9 Statement Executed: Rows Affected = 1
  10 echo INSERT INTO T4 VALUES(1,10,100);
  11 Statement execute failed with error -21
  12 echo SELECT * FROM T4;
  13 ---------------------------------------------------------
  14         T4.F1   T4.F2   T4.F3
  15 ---------------------------------------------------------
  16         1       10      100
  17         2       10      100
  18         1       20      100
  19
  20 echo SELECT * FROM T4 WHERE F1=1;
  21 ---------------------------------------------------------
  22         T4.F1   T4.F2   T4.F3
  23 ---------------------------------------------------------
  24         1       10      100
  25         1       20      100
  26
  27 echo SELECT * FROM T4 WHERE F1=1 AND F2=20;
  28 ---------------------------------------------------------
  29         T4.F1   T4.F2   T4.F3
  30 ---------------------------------------------------------
  31         1       20      100
  32
  33 echo SELECT * FROM T4 WHERE F1=1 OR F2=20;
  34 ---------------------------------------------------------
  35         T4.F1   T4.F2   T4.F3
  36 ---------------------------------------------------------
  37         1       10      100
  38         1       20      100
  39
  40 echo testing Updation Operation Using Primary key
  41 echo CREATE TABLE T1(F1 INT,F2 SMALLINT,F3 BIGINT,PRIMARY KEY(F1,F2));
  42 Statement Executed
  43 echo INSERT INTO T1 VALUES(1,10,100);
  44 Statement Executed: Rows Affected = 1
  45 echo INSERT INTO T1 VALUES(2,10,100);
  46 Statement Executed: Rows Affected = 1
  47 echo INSERT INTO T1 VALUES(1,20,100);
  48 Statement Executed: Rows Affected = 1
  49 echo INSERT INTO T1 VALUES(1,10,100);
  50 Statement execute failed with error -21
  51 echo SELECT * FROM T1;
  52 ---------------------------------------------------------
  53         T1.F1   T1.F2   T1.F3
  54 ---------------------------------------------------------
  55         1       10      100
  56         2       10      100
  57         1       20      100
  58
  59 echo UPDATE T1 SET F3=200;
  60 Statement Executed: Rows Affected = 3
  61 echo SELECT * FROM T1;
  62 ---------------------------------------------------------
  63         T1.F1   T1.F2   T1.F3
  64 ---------------------------------------------------------
  65         1       10      200
  66         2       10      200
  67         1       20      200
  68
  69 echo UPDATE T1 SET F3=100 WHERE F1=1;
  70 Statement Executed: Rows Affected = 2
  71 echo SELECT * FROM T1;
  72 ---------------------------------------------------------
  73         T1.F1   T1.F2   T1.F3
  74 ---------------------------------------------------------
  75         1       10      100
  76         2       10      200
  77         1       20      100
  78
  79 echo UPDATE T1 SET F3=300 WHERE F1=1 AND F2=20;
  80 Statement Executed: Rows Affected = 1
  81 echo SELECT * FROM T1;
  82 ---------------------------------------------------------
  83         T1.F1   T1.F2   T1.F3
  84 ---------------------------------------------------------
  85         1       10      100
  86         2       10      200
  87         1       20      300
  88
  89 echo UPDATE T1 SET F3=100 WHERE F1=1 OR F2=20;
  90 Statement Executed: Rows Affected = 2
  91 echo SELECT * FROM T1;
  92 ---------------------------------------------------------
  93         T1.F1   T1.F2   T1.F3
  94 ---------------------------------------------------------
  95         1       10      100
  96         2       10      200
  97         1       20      100
  98
  99 echo testing Deletion Operation Using Primary key
 100 echo CREATE TABLE T2(F1 INT,F2 SMALLINT,F3 BIGINT,PRIMARY KEY(F1,F2));
 101 Statement Executed
 102 echo INSERT INTO T2 VALUES(1,10,100);
 103 Statement Executed: Rows Affected = 1
 104 echo INSERT INTO T2 VALUES(2,10,100);
 105 Statement Executed: Rows Affected = 1
 106 echo INSERT INTO T2 VALUES(1,20,100);
 107 Statement Executed: Rows Affected = 1
 108 echo INSERT INTO T2 VALUES(1,10,100);
 109 Statement execute failed with error -21
 110 echo SELECT * FROM T2;
 111 ---------------------------------------------------------
 112         T2.F1   T2.F2   T2.F3
 113 ---------------------------------------------------------
 114         1       10      100
 115         2       10      100
 116         1       20      100
 117
 118 echo DELETE FROM T2 WHERE F1=1 AND F2=20;
 119 Statement Executed: Rows Affected = 1
 120 echo SELECT * FROM T2;
 121 ---------------------------------------------------------
 122         T2.F1   T2.F2   T2.F3
 123 ---------------------------------------------------------
 124         1       10      100
 125         2       10      100
 126
 127 echo DELETE FROM T2 WHERE F1<=1;
 128 Statement Executed: Rows Affected = 1
 129 echo SELECT * FROM T2;
 130 ---------------------------------------------------------
 131         T2.F1   T2.F2   T2.F3
 132 ---------------------------------------------------------
 133         2       10      100
 134
 135 echo DELETE FROM T2 WHERE F1<=2;
 136 Statement Executed: Rows Affected = 1
 137 echo SELECT * FROM T2;
 138 ---------------------------------------------------------
 139         T2.F1   T2.F2   T2.F3
 140 ---------------------------------------------------------
 141
 142 echo DELETE FROM T2;
 143 Statement Executed: Rows Affected = 0
 144 echo SELECT * FROM T2;
 145 ---------------------------------------------------------
 146         T2.F1   T2.F2   T2.F3
 147 ---------------------------------------------------------
 148
 149 echo testing Updation and Deletion Operation Using Primary key
 150 echo CREATE TABLE T3(F1 INT,F2 SMALLINT,F3 BIGINT,PRIMARY KEY(F1,F2));
 151 Statement Executed
 152 echo INSERT INTO T3 VALUES(1,10,100);
 153 Statement Executed: Rows Affected = 1
 154 echo INSERT INTO T3 VALUES(2,10,100);
 155 Statement Executed: Rows Affected = 1
 156 echo INSERT INTO T3 VALUES(1,20,100);
 157 Statement Executed: Rows Affected = 1
 158 echo INSERT INTO T3 VALUES(1,10,100);
 159 Statement execute failed with error -21
 160 echo SELECT * FROM T3;
 161 ---------------------------------------------------------
 162         T3.F1   T3.F2   T3.F3
 163 ---------------------------------------------------------
 164         1       10      100
 165         2       10      100
 166         1       20      100
 167
 168 echo UPDATE T3 SET F3=200;
 169 Statement Executed: Rows Affected = 3
 170 echo SELECT * FROM T3;
 171 ---------------------------------------------------------
 172         T3.F1   T3.F2   T3.F3
 173 ---------------------------------------------------------
 174         1       10      200
 175         2       10      200
 176         1       20      200
 177
 178 echo UPDATE T3 SET F3=100 WHERE F1=1;
 179 Statement Executed: Rows Affected = 2
 180 echo SELECT * FROM T3;
 181 ---------------------------------------------------------
 182         T3.F1   T3.F2   T3.F3
 183 ---------------------------------------------------------
 184         1       10      100
 185         2       10      200
 186         1       20      100
 187
 188 echo UPDATE T3 SET F3=300 WHERE F1=1 AND F2=20;
 189 Statement Executed: Rows Affected = 1
 190 echo SELECT * FROM T3;
 191 ---------------------------------------------------------
 192         T3.F1   T3.F2   T3.F3
 193 ---------------------------------------------------------
 194         1       10      100
 195         2       10      200
 196         1       20      300
 197
 198 echo UPDATE T3 SET F3=100 WHERE F1=1 OR F2=20;
 199 Statement Executed: Rows Affected = 2
 200 echo SELECT * FROM T3;
 201 ---------------------------------------------------------
 202         T3.F1   T3.F2   T3.F3
 203 ---------------------------------------------------------
 204         1       10      100
 205         2       10      200
 206         1       20      100
 207
 208 echo DELETE FROM T3 WHERE F1=1 AND F2=20;
 209 Statement Executed: Rows Affected = 1
 210 echo SELECT * FROM T3;
 211 ---------------------------------------------------------
 212         T3.F1   T3.F2   T3.F3
 213 ---------------------------------------------------------
 214         1       10      100
 215         2       10      200
 216
 217 echo DELETE FROM T3 WHERE F1<=1;
 218 Statement Executed: Rows Affected = 1
 219 echo SELECT * FROM T3;
 220 ---------------------------------------------------------
 221         T3.F1   T3.F2   T3.F3
 222 ---------------------------------------------------------
 223         2       10      200
 224
 225 echo DELETE FROM T3 WHERE F2<=20;
 226 Statement Executed: Rows Affected = 1
 227 echo SELECT * FROM T3;
 228 ---------------------------------------------------------
 229         T3.F1   T3.F2   T3.F3
 230 ---------------------------------------------------------
 231
 232 echo DELETE FROM T3;
 233 Statement Executed: Rows Affected = 0
 234 echo SELECT * FROM T3;
 235 ---------------------------------------------------------
 236         T3.F1   T3.F2   T3.F3
 237 ---------------------------------------------------------
 238
 239 echo Testing Select Operation Using Primary key
 240 echo CREATE TABLE T5(F1 INT,F2 SMALLINT,F3 BIGINT,PRIMARY KEY(F3,F2));
 241 Statement Executed
 242 echo INSERT INTO T5 VALUES(1,10,100);
 243 Statement Executed: Rows Affected = 1
 244 echo INSERT INTO T5 VALUES(1,20,100);
 245 Statement Executed: Rows Affected = 1
 246 echo INSERT INTO T5 VALUES(1,10,200);
 247 Statement Executed: Rows Affected = 1
 248 echo INSERT INTO T5 VALUES(1,10,100);
 249 Statement execute failed with error -21
 250 echo SELECT * FROM T5;
 251 ---------------------------------------------------------
 252         T5.F1   T5.F2   T5.F3
 253 ---------------------------------------------------------
 254         1       10      100
 255         1       20      100
 256         1       10      200
 257
 258 echo SELECT * FROM T5 WHERE F3=100;
 259 ---------------------------------------------------------
 260         T5.F1   T5.F2   T5.F3
 261 ---------------------------------------------------------
 262         1       10      100
 263         1       20      100
 264
 265 echo SELECT * FROM T5 WHERE F3=100 AND F2=20;
 266 ---------------------------------------------------------
 267         T5.F1   T5.F2   T5.F3
 268 ---------------------------------------------------------
 269         1       20      100
 270
 271 echo SELECT * FROM T5 WHERE F2=20 OR F3=100;
 272 ---------------------------------------------------------
 273         T5.F1   T5.F2   T5.F3
 274 ---------------------------------------------------------
 275         1       10      100
 276         1       20      100
 277
 278 echo Testing updation  Operation Using Primary key
 279 echo CREATE TABLE T6(F1 INT,F2 SMALLINT,F3 BIGINT,PRIMARY KEY(F3,F2));
 280 Statement Executed
 281 echo INSERT INTO T6 VALUES(1,10,100);
 282 Statement Executed: Rows Affected = 1
 283 echo INSERT INTO T6 VALUES(1,20,100);
 284 Statement Executed: Rows Affected = 1
 285 echo INSERT INTO T6 VALUES(1,10,200);
 286 Statement Executed: Rows Affected = 1
 287 echo INSERT INTO T6 VALUES(1,10,100);
 288 Statement execute failed with error -21
 289 echo SELECT * FROM T6;
 290 ---------------------------------------------------------
 291         T6.F1   T6.F2   T6.F3
 292 ---------------------------------------------------------
 293         1       10      100
 294         1       20      100
 295         1       10      200
 296
 297 echo UPDATE T6 SET F1=2;
 298 Statement Executed: Rows Affected = 3
 299 echo SELECT * FROM T6;
 300 ---------------------------------------------------------
 301         T6.F1   T6.F2   T6.F3
 302 ---------------------------------------------------------
 303         2       10      100
 304         2       20      100
 305         2       10      200
 306
 307 echo UPDATE T6 SET F1=1 WHERE F3=100;
 308 Statement Executed: Rows Affected = 2
 309 echo SELECT * FROM T6;
 310 ---------------------------------------------------------
 311         T6.F1   T6.F2   T6.F3
 312 ---------------------------------------------------------
 313         1       10      100
 314         1       20      100
 315         2       10      200
 316
 317 echo UPDATE T6 SET F1=3 WHERE F3=100 AND F2=20;
 318 Statement Executed: Rows Affected = 1
 319 echo SELECT * FROM T6;
 320 ---------------------------------------------------------
 321         T6.F1   T6.F2   T6.F3
 322 ---------------------------------------------------------
 323         1       10      100
 324         3       20      100
 325         2       10      200
 326
 327 echo UPDATE T6 SET F1=1 WHERE F2=20 OR F3=100;
 328 Statement Executed: Rows Affected = 2
 329 echo SELECT * FROM T6;
 330 ---------------------------------------------------------
 331         T6.F1   T6.F2   T6.F3
 332 ---------------------------------------------------------
 333         1       10      100
 334         1       20      100
 335         2       10      200
 336
 337 echo testing Deletion Operation Using Primary key
 338 echo CREATE TABLE T7(F1 INT,F2 SMALLINT,F3 BIGINT,PRIMARY KEY(F3,F2));
 339 Statement Executed
 340 echo INSERT INTO T7 VALUES(1,10,100);
 341 Statement Executed: Rows Affected = 1
 342 echo INSERT INTO T7 VALUES(1,20,100);
 343 Statement Executed: Rows Affected = 1
 344 echo INSERT INTO T7 VALUES(1,10,200);
 345 Statement Executed: Rows Affected = 1
 346 echo INSERT INTO T7 VALUES(1,10,100);
 347 Statement execute failed with error -21
 348 echo SELECT * FROM T7;
 349 ---------------------------------------------------------
 350         T7.F1   T7.F2   T7.F3
 351 ---------------------------------------------------------
 352         1       10      100
 353         1       20      100
 354         1       10      200
 355
 356 echo DELETE FROM T7 WHERE F3=100 AND F2=20;
 357 Statement Executed: Rows Affected = 1
 358 echo SELECT * FROM T7;
 359 ---------------------------------------------------------
 360         T7.F1   T7.F2   T7.F3
 361 ---------------------------------------------------------
 362         1       10      100
 363         1       10      200
 364
 365 echo DELETE FROM T7 WHERE F3<=100;
 366 Statement Executed: Rows Affected = 1
 367 echo SELECT * FROM T7;
 368 ---------------------------------------------------------
 369         T7.F1   T7.F2   T7.F3
 370 ---------------------------------------------------------
 371         1       10      200
 372
 373 echo DELETE FROM T7 WHERE F3<=200;
 374 Statement Executed: Rows Affected = 1
 375 echo SELECT * FROM T7;
 376 ---------------------------------------------------------
 377         T7.F1   T7.F2   T7.F3
 378 ---------------------------------------------------------
 379
 380 echo DELETE FROM T7;
 381 Statement Executed: Rows Affected = 0
 382 echo SELECT * FROM T7;
 383 ---------------------------------------------------------
 384         T7.F1   T7.F2   T7.F3
 385 ---------------------------------------------------------
 386
 387 echo Testing updation And Deletion Operation Using Primary key
 388 echo CREATE TABLE T8(F1 INT,F2 SMALLINT,F3 BIGINT,PRIMARY KEY(F3,F2));
 389 Statement Executed
 390 echo INSERT INTO T8 VALUES(1,10,100);
 391 Statement Executed: Rows Affected = 1
 392 echo INSERT INTO T8 VALUES(1,20,100);
 393 Statement Executed: Rows Affected = 1
 394 echo INSERT INTO T8 VALUES(1,10,200);
 395 Statement Executed: Rows Affected = 1
 396 echo INSERT INTO T8 VALUES(1,10,100);
 397 Statement execute failed with error -21
 398 echo SELECT * FROM T8;
 399 ---------------------------------------------------------
 400         T8.F1   T8.F2   T8.F3
 401 ---------------------------------------------------------
 402         1       10      100
 403         1       20      100
 404         1       10      200
 405
 406 echo UPDATE T8 SET F1=2;
 407 Statement Executed: Rows Affected = 3
 408 echo SELECT * FROM T8;
 409 ---------------------------------------------------------
 410         T8.F1   T8.F2   T8.F3
 411 ---------------------------------------------------------
 412         2       10      100
 413         2       20      100
 414         2       10      200
 415
 416 echo UPDATE T8 SET F1=1 WHERE F3=100;
 417 Statement Executed: Rows Affected = 2
 418 echo SELECT * FROM T8;
 419 ---------------------------------------------------------
 420         T8.F1   T8.F2   T8.F3
 421 ---------------------------------------------------------
 422         1       10      100
 423         1       20      100
 424         2       10      200
 425
 426 echo UPDATE T8 SET F1=3 WHERE F3=100 AND F2=20;
 427 Statement Executed: Rows Affected = 1
 428 echo SELECT * FROM T8;
 429 ---------------------------------------------------------
 430         T8.F1   T8.F2   T8.F3
 431 ---------------------------------------------------------
 432         1       10      100
 433         3       20      100
 434         2       10      200
 435
 436 echo UPDATE T8 SET F1=1 WHERE F2=20 OR F3=100;
 437 Statement Executed: Rows Affected = 2
 438 echo SELECT * FROM T8;
 439 ---------------------------------------------------------
 440         T8.F1   T8.F2   T8.F3
 441 ---------------------------------------------------------
 442         1       10      100
 443         1       20      100
 444         2       10      200
 445
 446 echo DELETE FROM T8 WHERE F3=100 AND F2=20;
 447 Statement Executed: Rows Affected = 1
 448 echo SELECT * FROM T8;
 449 ---------------------------------------------------------
 450         T8.F1   T8.F2   T8.F3
 451 ---------------------------------------------------------
 452         1       10      100
 453         2       10      200
 454
 455 echo DELETE FROM T8 WHERE F3<=100;
 456 Statement Executed: Rows Affected = 1
 457 echo SELECT * FROM T8;
 458 ---------------------------------------------------------
 459         T8.F1   T8.F2   T8.F3
 460 ---------------------------------------------------------
 461         2       10      200
 462
 463 echo DELETE FROM T8 WHERE F3<=200;
 464 Statement Executed: Rows Affected = 1
 465 echo SELECT * FROM T8;
 466 ---------------------------------------------------------
 467         T8.F1   T8.F2   T8.F3
 468 ---------------------------------------------------------
 469
 470 echo DELETE FROM T8;
 471 Statement Executed: Rows Affected = 0
 472 echo SELECT * FROM T8;
 473 ---------------------------------------------------------
 474         T8.F1   T8.F2   T8.F3
 475 ---------------------------------------------------------
 476
 477 echo Testing Select Operation Using Primary key
 478 echo CREATE TABLE T9(F1 INT,F2 SMALLINT,F3 BIGINT,PRIMARY KEY(F1,F3));
 479 Statement Executed
 480 echo INSERT INTO T9 VALUES(1,10,100);
 481 Statement Executed: Rows Affected = 1
 482 echo INSERT INTO T9 VALUES(2,10,100);
 483 Statement Executed: Rows Affected = 1
 484 echo INSERT INTO T9 VALUES(1,10,200);
 485 Statement Executed: Rows Affected = 1
 486 echo INSERT INTO T9 VALUES(1,10,100);
 487 Statement execute failed with error -21
 488 echo SELECT * FROM T9;
 489 ---------------------------------------------------------
 490         T9.F1   T9.F2   T9.F3
 491 ---------------------------------------------------------
 492         1       10      100
 493         2       10      100
 494         1       10      200
 495
 496 echo SELECT * FROM T9 WHERE F1=1;
 497 ---------------------------------------------------------
 498         T9.F1   T9.F2   T9.F3
 499 ---------------------------------------------------------
 500         1       10      100
 501         1       10      200
 502
 503 echo SELECT * FROM T9 WHERE F1<=1 AND F2=20;
 504 ---------------------------------------------------------
 505         T9.F1   T9.F2   T9.F3
 506 ---------------------------------------------------------
 507
 508 echo SELECT * FROM T9 WHERE F2=20 OR F1=1;
 509 ---------------------------------------------------------
 510         T9.F1   T9.F2   T9.F3
 511 ---------------------------------------------------------
 512         1       10      100
 513         1       10      200
 514
 515 echo Testing updation  Operation Using Primary key
 516 echo CREATE TABLE T10(F1 INT,F2 SMALLINT,F3 BIGINT,PRIMARY KEY(F1,F3));
 517 Statement Executed
 518 echo INSERT INTO T10 VALUES(1,10,100);
 519 Statement Executed: Rows Affected = 1
 520 echo INSERT INTO T10 VALUES(2,10,100);
 521 Statement Executed: Rows Affected = 1
 522 echo INSERT INTO T10 VALUES(1,10,200);
 523 Statement Executed: Rows Affected = 1
 524 echo INSERT INTO T10 VALUES(1,10,100);
 525 Statement execute failed with error -21
 526 echo SELECT * FROM T10;
 527 ---------------------------------------------------------
 528         T10.F1  T10.F2  T10.F3
 529 ---------------------------------------------------------
 530         1       10      100
 531         2       10      100
 532         1       10      200
 533
 534 echo UPDATE T10 SET F2=20;
 535 Statement Executed: Rows Affected = 3
 536 echo SELECT * FROM T10;
 537 ---------------------------------------------------------
 538         T10.F1  T10.F2  T10.F3
 539 ---------------------------------------------------------
 540         1       20      100
 541         2       20      100
 542         1       20      200
 543
 544 echo UPDATE T10 SET F2=10 WHERE F1=1;
 545 Statement Executed: Rows Affected = 2
 546 echo SELECT * FROM T10;
 547 ---------------------------------------------------------
 548         T10.F1  T10.F2  T10.F3
 549 ---------------------------------------------------------
 550         1       10      100
 551         2       20      100
 552         1       10      200
 553
 554 echo UPDATE T10 SET F2=30 WHERE F1>=1 AND F3=200;
 555 Statement Executed: Rows Affected = 1
 556 echo SELECT * FROM T10;
 557 ---------------------------------------------------------
 558         T10.F1  T10.F2  T10.F3
 559 ---------------------------------------------------------
 560         1       10      100
 561         2       20      100
 562         1       30      200
 563
 564 echo UPDATE T10 SET F2=10 WHERE F2=20 OR F1<=1;
 565 Statement Executed: Rows Affected = 3
 566 echo SELECT * FROM T10;
 567 ---------------------------------------------------------
 568         T10.F1  T10.F2  T10.F3
 569 ---------------------------------------------------------
 570         1       10      100
 571         2       10      100
 572         1       10      200
 573
 574 echo testing Deletion Operation Using Primary key
 575 echo CREATE TABLE T11(F1 INT,F2 SMALLINT,F3 BIGINT,PRIMARY KEY(F1,F3));
 576 Statement Executed
 577 echo INSERT INTO T11 VALUES(1,10,100);
 578 Statement Executed: Rows Affected = 1
 579 echo INSERT INTO T11 VALUES(2,10,100);
 580 Statement Executed: Rows Affected = 1
 581 echo INSERT INTO T11 VALUES(1,10,200);
 582 Statement Executed: Rows Affected = 1
 583 echo INSERT INTO T11 VALUES(1,10,100);
 584 Statement execute failed with error -21
 585 echo SELECT * FROM T11;
 586 ---------------------------------------------------------
 587         T11.F1  T11.F2  T11.F3
 588 ---------------------------------------------------------
 589         1       10      100
 590         2       10      100
 591         1       10      200
 592
 593 echo DELETE FROM T11 WHERE F3=100 AND F1=1;
 594 Statement Executed: Rows Affected = 1
 595 echo SELECT * FROM T11;
 596 ---------------------------------------------------------
 597         T11.F1  T11.F2  T11.F3
 598 ---------------------------------------------------------
 599         2       10      100
 600         1       10      200
 601
 602 echo DELETE FROM T11 WHERE F1<=1;
 603 Statement Executed: Rows Affected = 1
 604 echo SELECT * FROM T11;
 605 ---------------------------------------------------------
 606         T11.F1  T11.F2  T11.F3
 607 ---------------------------------------------------------
 608         2       10      100
 609
 610 echo DELETE FROM T11 WHERE F3<=200;
 611 Statement Executed: Rows Affected = 1
 612 echo SELECT * FROM T11;
 613 ---------------------------------------------------------
 614         T11.F1  T11.F2  T11.F3
 615 ---------------------------------------------------------
 616
 617 echo DELETE FROM T11;
 618 Statement Executed: Rows Affected = 0
 619 echo SELECT * FROM T11;
 620 ---------------------------------------------------------
 621         T11.F1  T11.F2  T11.F3
 622 ---------------------------------------------------------
 623
 624 echo Testing updation And Deletion Operation Using Primary key
 625 echo CREATE TABLE T12(F1 INT,F2 SMALLINT,F3 BIGINT,PRIMARY KEY(F1,F3));
 626 Statement Executed
 627 echo INSERT INTO T12 VALUES(1,10,100);
 628 Statement Executed: Rows Affected = 1
 629 echo INSERT INTO T12 VALUES(2,10,100);
 630 Statement Executed: Rows Affected = 1
 631 echo INSERT INTO T12 VALUES(1,10,200);
 632 Statement Executed: Rows Affected = 1
 633 echo INSERT INTO T12 VALUES(1,10,100);
 634 Statement execute failed with error -21
 635 echo SELECT * FROM T12;
 636 ---------------------------------------------------------
 637         T12.F1  T12.F2  T12.F3
 638 ---------------------------------------------------------
 639         1       10      100
 640         2       10      100
 641         1       10      200
 642
 643 echo UPDATE T12 SET F2=20;
 644 Statement Executed: Rows Affected = 3
 645 echo SELECT * FROM T12;
 646 ---------------------------------------------------------
 647         T12.F1  T12.F2  T12.F3
 648 ---------------------------------------------------------
 649         1       20      100
 650         2       20      100
 651         1       20      200
 652
 653 echo UPDATE T12 SET F2=10 WHERE F1=1;
 654 Statement Executed: Rows Affected = 2
 655 echo SELECT * FROM T12;
 656 ---------------------------------------------------------
 657         T12.F1  T12.F2  T12.F3
 658 ---------------------------------------------------------
 659         1       10      100
 660         2       20      100
 661         1       10      200
 662
 663 echo UPDATE T12 SET F2=30 WHERE F1=1 AND F2=20;
 664 Statement Executed: Rows Affected = 0
 665 echo SELECT * FROM T12;
 666 ---------------------------------------------------------
 667         T12.F1  T12.F2  T12.F3
 668 ---------------------------------------------------------
 669         1       10      100
 670         2       20      100
 671         1       10      200
 672
 673 echo UPDATE T12 SET F2=10 WHERE F2<=20 OR F1=1;
 674 Statement Executed: Rows Affected = 3
 675 echo SELECT * FROM T12;
 676 ---------------------------------------------------------
 677         T12.F1  T12.F2  T12.F3
 678 ---------------------------------------------------------
 679         1       10      100
 680         2       10      100
 681         1       10      200
 682
 683 echo DELETE FROM T12 WHERE F1=1 AND F2=20;
 684 Statement Executed: Rows Affected = 0
 685 echo SELECT * FROM T12;
 686 ---------------------------------------------------------
 687         T12.F1  T12.F2  T12.F3
 688 ---------------------------------------------------------
 689         1       10      100
 690         2       10      100
 691         1       10      200
 692
 693 echo DELETE FROM T12 WHERE F1<=1;
 694 Statement Executed: Rows Affected = 2
 695 echo SELECT * FROM T12;
 696 ---------------------------------------------------------
 697         T12.F1  T12.F2  T12.F3
 698 ---------------------------------------------------------
 699         2       10      100
 700
 701 echo DELETE FROM T12 WHERE F1>=2;
 702 Statement Executed: Rows Affected = 1
 703 echo SELECT * FROM T12;
 704 ---------------------------------------------------------
 705         T12.F1  T12.F2  T12.F3
 706 ---------------------------------------------------------
 707
 708 echo DELETE FROM T12;
 709 Statement Executed: Rows Affected = 0
 710 echo SELECT * FROM T12;
 711 ---------------------------------------------------------
 712         T12.F1  T12.F2  T12.F3
 713 ---------------------------------------------------------
 714
 715 Statement Executed
 716 Statement Executed
 717 Statement Executed
 718 Statement Executed
 719 Statement Executed
 720 Statement Executed
 721 Statement Executed
 722 Statement Executed
 723 Statement Executed
 724 Statement Executed
 725 Statement Executed
 726 Statement Executed