1 echo testing Select Operation Using Primary key
2 echo CREATE TABLE T4
(F1 INT
,F2 SMALLINT
,F3 BIGINT
,PRIMARY KEY
(F1
,F2
));
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 ---------------------------------------------------------
15 ---------------------------------------------------------
20 echo SELECT
* FROM T4 WHERE F1
=1;
21 ---------------------------------------------------------
23 ---------------------------------------------------------
27 echo SELECT
* FROM T4 WHERE F1
=1 AND F2
=20;
28 ---------------------------------------------------------
30 ---------------------------------------------------------
33 echo SELECT
* FROM T4 WHERE F1
=1 OR F2
=20;
34 ---------------------------------------------------------
36 ---------------------------------------------------------
40 echo testing Updation Operation Using Primary key
41 echo CREATE TABLE T1
(F1 INT
,F2 SMALLINT
,F3 BIGINT
,PRIMARY KEY
(F1
,F2
));
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 ---------------------------------------------------------
54 ---------------------------------------------------------
59 echo UPDATE T1 SET F3
=200;
60 Statement Executed
: Rows Affected
= 3
61 echo SELECT
* FROM T1
;
62 ---------------------------------------------------------
64 ---------------------------------------------------------
69 echo UPDATE T1 SET F3
=100 WHERE F1
=1;
70 Statement Executed
: Rows Affected
= 2
71 echo SELECT
* FROM T1
;
72 ---------------------------------------------------------
74 ---------------------------------------------------------
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 ---------------------------------------------------------
84 ---------------------------------------------------------
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 ---------------------------------------------------------
94 ---------------------------------------------------------
99 echo testing Deletion Operation Using Primary key
100 echo CREATE TABLE T2
(F1 INT
,F2 SMALLINT
,F3 BIGINT
,PRIMARY KEY
(F1
,F2
));
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 ---------------------------------------------------------
113 ---------------------------------------------------------
118 echo DELETE FROM T2 WHERE F1
=1 AND F2
=20;
119 Statement Executed
: Rows Affected
= 1
120 echo SELECT
* FROM T2
;
121 ---------------------------------------------------------
123 ---------------------------------------------------------
127 echo DELETE FROM T2 WHERE F1
<=1;
128 Statement Executed
: Rows Affected
= 1
129 echo SELECT
* FROM T2
;
130 ---------------------------------------------------------
132 ---------------------------------------------------------
135 echo DELETE FROM T2 WHERE F1
<=2;
136 Statement Executed
: Rows Affected
= 1
137 echo SELECT
* FROM T2
;
138 ---------------------------------------------------------
140 ---------------------------------------------------------
143 Statement Executed
: Rows Affected
= 0
144 echo SELECT
* FROM T2
;
145 ---------------------------------------------------------
147 ---------------------------------------------------------
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
));
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 ---------------------------------------------------------
163 ---------------------------------------------------------
168 echo UPDATE T3 SET F3
=200;
169 Statement Executed
: Rows Affected
= 3
170 echo SELECT
* FROM T3
;
171 ---------------------------------------------------------
173 ---------------------------------------------------------
178 echo UPDATE T3 SET F3
=100 WHERE F1
=1;
179 Statement Executed
: Rows Affected
= 2
180 echo SELECT
* FROM T3
;
181 ---------------------------------------------------------
183 ---------------------------------------------------------
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 ---------------------------------------------------------
193 ---------------------------------------------------------
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 ---------------------------------------------------------
203 ---------------------------------------------------------
208 echo DELETE FROM T3 WHERE F1
=1 AND F2
=20;
209 Statement Executed
: Rows Affected
= 1
210 echo SELECT
* FROM T3
;
211 ---------------------------------------------------------
213 ---------------------------------------------------------
217 echo DELETE FROM T3 WHERE F1
<=1;
218 Statement Executed
: Rows Affected
= 1
219 echo SELECT
* FROM T3
;
220 ---------------------------------------------------------
222 ---------------------------------------------------------
225 echo DELETE FROM T3 WHERE F2
<=20;
226 Statement Executed
: Rows Affected
= 1
227 echo SELECT
* FROM T3
;
228 ---------------------------------------------------------
230 ---------------------------------------------------------
233 Statement Executed
: Rows Affected
= 0
234 echo SELECT
* FROM T3
;
235 ---------------------------------------------------------
237 ---------------------------------------------------------
239 echo Testing Select Operation Using Primary key
240 echo CREATE TABLE T5
(F1 INT
,F2 SMALLINT
,F3 BIGINT
,PRIMARY KEY
(F3
,F2
));
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 ---------------------------------------------------------
253 ---------------------------------------------------------
258 echo SELECT
* FROM T5 WHERE F3
=100;
259 ---------------------------------------------------------
261 ---------------------------------------------------------
265 echo SELECT
* FROM T5 WHERE F3
=100 AND F2
=20;
266 ---------------------------------------------------------
268 ---------------------------------------------------------
271 echo SELECT
* FROM T5 WHERE F2
=20 OR F3
=100;
272 ---------------------------------------------------------
274 ---------------------------------------------------------
278 echo Testing updation Operation Using Primary key
279 echo CREATE TABLE T6
(F1 INT
,F2 SMALLINT
,F3 BIGINT
,PRIMARY KEY
(F3
,F2
));
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 ---------------------------------------------------------
292 ---------------------------------------------------------
297 echo UPDATE T6 SET F1
=2;
298 Statement Executed
: Rows Affected
= 3
299 echo SELECT
* FROM T6
;
300 ---------------------------------------------------------
302 ---------------------------------------------------------
307 echo UPDATE T6 SET F1
=1 WHERE F3
=100;
308 Statement Executed
: Rows Affected
= 2
309 echo SELECT
* FROM T6
;
310 ---------------------------------------------------------
312 ---------------------------------------------------------
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 ---------------------------------------------------------
322 ---------------------------------------------------------
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 ---------------------------------------------------------
332 ---------------------------------------------------------
337 echo testing Deletion Operation Using Primary key
338 echo CREATE TABLE T7
(F1 INT
,F2 SMALLINT
,F3 BIGINT
,PRIMARY KEY
(F3
,F2
));
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 ---------------------------------------------------------
351 ---------------------------------------------------------
356 echo DELETE FROM T7 WHERE F3
=100 AND F2
=20;
357 Statement Executed
: Rows Affected
= 1
358 echo SELECT
* FROM T7
;
359 ---------------------------------------------------------
361 ---------------------------------------------------------
365 echo DELETE FROM T7 WHERE F3
<=100;
366 Statement Executed
: Rows Affected
= 1
367 echo SELECT
* FROM T7
;
368 ---------------------------------------------------------
370 ---------------------------------------------------------
373 echo DELETE FROM T7 WHERE F3
<=200;
374 Statement Executed
: Rows Affected
= 1
375 echo SELECT
* FROM T7
;
376 ---------------------------------------------------------
378 ---------------------------------------------------------
381 Statement Executed
: Rows Affected
= 0
382 echo SELECT
* FROM T7
;
383 ---------------------------------------------------------
385 ---------------------------------------------------------
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
));
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 ---------------------------------------------------------
401 ---------------------------------------------------------
406 echo UPDATE T8 SET F1
=2;
407 Statement Executed
: Rows Affected
= 3
408 echo SELECT
* FROM T8
;
409 ---------------------------------------------------------
411 ---------------------------------------------------------
416 echo UPDATE T8 SET F1
=1 WHERE F3
=100;
417 Statement Executed
: Rows Affected
= 2
418 echo SELECT
* FROM T8
;
419 ---------------------------------------------------------
421 ---------------------------------------------------------
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 ---------------------------------------------------------
431 ---------------------------------------------------------
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 ---------------------------------------------------------
441 ---------------------------------------------------------
446 echo DELETE FROM T8 WHERE F3
=100 AND F2
=20;
447 Statement Executed
: Rows Affected
= 1
448 echo SELECT
* FROM T8
;
449 ---------------------------------------------------------
451 ---------------------------------------------------------
455 echo DELETE FROM T8 WHERE F3
<=100;
456 Statement Executed
: Rows Affected
= 1
457 echo SELECT
* FROM T8
;
458 ---------------------------------------------------------
460 ---------------------------------------------------------
463 echo DELETE FROM T8 WHERE F3
<=200;
464 Statement Executed
: Rows Affected
= 1
465 echo SELECT
* FROM T8
;
466 ---------------------------------------------------------
468 ---------------------------------------------------------
471 Statement Executed
: Rows Affected
= 0
472 echo SELECT
* FROM T8
;
473 ---------------------------------------------------------
475 ---------------------------------------------------------
477 echo Testing Select Operation Using Primary key
478 echo CREATE TABLE T9
(F1 INT
,F2 SMALLINT
,F3 BIGINT
,PRIMARY KEY
(F1
,F3
));
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 ---------------------------------------------------------
491 ---------------------------------------------------------
496 echo SELECT
* FROM T9 WHERE F1
=1;
497 ---------------------------------------------------------
499 ---------------------------------------------------------
503 echo SELECT
* FROM T9 WHERE F1
<=1 AND F2
=20;
504 ---------------------------------------------------------
506 ---------------------------------------------------------
508 echo SELECT
* FROM T9 WHERE F2
=20 OR F1
=1;
509 ---------------------------------------------------------
511 ---------------------------------------------------------
515 echo Testing updation Operation Using Primary key
516 echo CREATE TABLE T10
(F1 INT
,F2 SMALLINT
,F3 BIGINT
,PRIMARY KEY
(F1
,F3
));
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 ---------------------------------------------------------
529 ---------------------------------------------------------
534 echo UPDATE T10 SET F2
=20;
535 Statement Executed
: Rows Affected
= 3
536 echo SELECT
* FROM T10
;
537 ---------------------------------------------------------
539 ---------------------------------------------------------
544 echo UPDATE T10 SET F2
=10 WHERE F1
=1;
545 Statement Executed
: Rows Affected
= 2
546 echo SELECT
* FROM T10
;
547 ---------------------------------------------------------
549 ---------------------------------------------------------
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 ---------------------------------------------------------
559 ---------------------------------------------------------
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 ---------------------------------------------------------
569 ---------------------------------------------------------
574 echo testing Deletion Operation Using Primary key
575 echo CREATE TABLE T11
(F1 INT
,F2 SMALLINT
,F3 BIGINT
,PRIMARY KEY
(F1
,F3
));
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 ---------------------------------------------------------
588 ---------------------------------------------------------
593 echo DELETE FROM T11 WHERE F3
=100 AND F1
=1;
594 Statement Executed
: Rows Affected
= 1
595 echo SELECT
* FROM T11
;
596 ---------------------------------------------------------
598 ---------------------------------------------------------
602 echo DELETE FROM T11 WHERE F1
<=1;
603 Statement Executed
: Rows Affected
= 1
604 echo SELECT
* FROM T11
;
605 ---------------------------------------------------------
607 ---------------------------------------------------------
610 echo DELETE FROM T11 WHERE F3
<=200;
611 Statement Executed
: Rows Affected
= 1
612 echo SELECT
* FROM T11
;
613 ---------------------------------------------------------
615 ---------------------------------------------------------
617 echo DELETE FROM T11
;
618 Statement Executed
: Rows Affected
= 0
619 echo SELECT
* FROM T11
;
620 ---------------------------------------------------------
622 ---------------------------------------------------------
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
));
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 ---------------------------------------------------------
638 ---------------------------------------------------------
643 echo UPDATE T12 SET F2
=20;
644 Statement Executed
: Rows Affected
= 3
645 echo SELECT
* FROM T12
;
646 ---------------------------------------------------------
648 ---------------------------------------------------------
653 echo UPDATE T12 SET F2
=10 WHERE F1
=1;
654 Statement Executed
: Rows Affected
= 2
655 echo SELECT
* FROM T12
;
656 ---------------------------------------------------------
658 ---------------------------------------------------------
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 ---------------------------------------------------------
668 ---------------------------------------------------------
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 ---------------------------------------------------------
678 ---------------------------------------------------------
683 echo DELETE FROM T12 WHERE F1
=1 AND F2
=20;
684 Statement Executed
: Rows Affected
= 0
685 echo SELECT
* FROM T12
;
686 ---------------------------------------------------------
688 ---------------------------------------------------------
693 echo DELETE FROM T12 WHERE F1
<=1;
694 Statement Executed
: Rows Affected
= 2
695 echo SELECT
* FROM T12
;
696 ---------------------------------------------------------
698 ---------------------------------------------------------
701 echo DELETE FROM T12 WHERE F1
>=2;
702 Statement Executed
: Rows Affected
= 1
703 echo SELECT
* FROM T12
;
704 ---------------------------------------------------------
706 ---------------------------------------------------------
708 echo DELETE FROM T12
;
709 Statement Executed
: Rows Affected
= 0
710 echo SELECT
* FROM T12
;
711 ---------------------------------------------------------
713 ---------------------------------------------------------