2
DROP TABLE IF EXISTS t1,t2,t3;
3
DROP PROCEDURE IF EXISTS sp1;
5
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
6
CREATE TABLE t2 (i INTEGER NULL);
7
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
8
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
9
INSERT INTO t2 VALUES(1),(2),(3);
11
CREATE PROCEDURE sp1()
13
DECLARE done INT DEFAULT 0;
16
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
17
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
18
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
26
INSERT INTO t3 VALUES (a,b);
28
INSERT INTO t3 VALUES (a,c);
31
UNTIL done END REPEAT;
36
ALTER PROCEDURE sp1 #DET# ;
38
SELECT * FROM t1 ORDER BY id;
39
SELECT * FROM t2 ORDER BY i;
40
SELECT * FROM t3 ORDER BY id;
43
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
44
CREATE TABLE t2 (i INTEGER NULL);
45
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
46
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
47
INSERT INTO t2 VALUES(1),(2),(3);
49
CREATE PROCEDURE sp1()
51
DECLARE done INT DEFAULT 0;
54
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
55
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
56
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
64
INSERT INTO t3 VALUES (a,b);
66
INSERT INTO t3 VALUES (a,c);
69
UNTIL done END REPEAT;
74
ALTER PROCEDURE sp1 #DET# CONTAINS SQL ;
76
SELECT * FROM t1 ORDER BY id;
77
SELECT * FROM t2 ORDER BY i;
78
SELECT * FROM t3 ORDER BY id;
81
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
82
CREATE TABLE t2 (i INTEGER NULL);
83
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
84
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
85
INSERT INTO t2 VALUES(1),(2),(3);
87
CREATE PROCEDURE sp1()
89
DECLARE done INT DEFAULT 0;
92
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
93
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
94
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
102
INSERT INTO t3 VALUES (a,b);
104
INSERT INTO t3 VALUES (a,c);
107
UNTIL done END REPEAT;
112
ALTER PROCEDURE sp1 #DET# NO SQL ;
114
SELECT * FROM t1 ORDER BY id;
115
SELECT * FROM t2 ORDER BY i;
116
SELECT * FROM t3 ORDER BY id;
119
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
120
CREATE TABLE t2 (i INTEGER NULL);
121
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
122
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
123
INSERT INTO t2 VALUES(1),(2),(3);
125
CREATE PROCEDURE sp1()
127
DECLARE done INT DEFAULT 0;
130
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
131
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
132
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
136
FETCH cur1 INTO a, b;
140
INSERT INTO t3 VALUES (a,b);
142
INSERT INTO t3 VALUES (a,c);
145
UNTIL done END REPEAT;
150
ALTER PROCEDURE sp1 #DET# READS SQL DATA ;
152
SELECT * FROM t1 ORDER BY id;
153
SELECT * FROM t2 ORDER BY i;
154
SELECT * FROM t3 ORDER BY id;
157
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
158
CREATE TABLE t2 (i INTEGER NULL);
159
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
160
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
161
INSERT INTO t2 VALUES(1),(2),(3);
163
CREATE PROCEDURE sp1()
165
DECLARE done INT DEFAULT 0;
168
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
169
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
170
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
174
FETCH cur1 INTO a, b;
178
INSERT INTO t3 VALUES (a,b);
180
INSERT INTO t3 VALUES (a,c);
183
UNTIL done END REPEAT;
188
ALTER PROCEDURE sp1 #DET# MODIFIES SQL DATA ;
190
SELECT * FROM t1 ORDER BY id;
191
SELECT * FROM t2 ORDER BY i;
192
SELECT * FROM t3 ORDER BY id;
195
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
196
CREATE TABLE t2 (i INTEGER NULL);
197
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
198
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
199
INSERT INTO t2 VALUES(1),(2),(3);
201
CREATE PROCEDURE sp1()
203
DECLARE done INT DEFAULT 0;
206
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
207
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
208
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
212
FETCH cur1 INTO a, b;
216
INSERT INTO t3 VALUES (a,b);
218
INSERT INTO t3 VALUES (a,c);
221
UNTIL done END REPEAT;
226
ALTER PROCEDURE sp1 #DET# COMMENT 'comment' ;
228
SELECT * FROM t1 ORDER BY id;
229
SELECT * FROM t2 ORDER BY i;
230
SELECT * FROM t3 ORDER BY id;
233
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
234
CREATE TABLE t2 (i INTEGER NULL);
235
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
236
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
237
INSERT INTO t2 VALUES(1),(2),(3);
239
CREATE PROCEDURE sp1()
241
DECLARE done INT DEFAULT 0;
244
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
245
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
246
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
250
FETCH cur1 INTO a, b;
254
INSERT INTO t3 VALUES (a,b);
256
INSERT INTO t3 VALUES (a,c);
259
UNTIL done END REPEAT;
264
ALTER PROCEDURE sp1 #DET# CONTAINS SQL COMMENT 'comment' ;
266
SELECT * FROM t1 ORDER BY id;
267
SELECT * FROM t2 ORDER BY i;
268
SELECT * FROM t3 ORDER BY id;
271
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
272
CREATE TABLE t2 (i INTEGER NULL);
273
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
274
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
275
INSERT INTO t2 VALUES(1),(2),(3);
277
CREATE PROCEDURE sp1()
279
DECLARE done INT DEFAULT 0;
282
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
283
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
284
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
288
FETCH cur1 INTO a, b;
292
INSERT INTO t3 VALUES (a,b);
294
INSERT INTO t3 VALUES (a,c);
297
UNTIL done END REPEAT;
302
ALTER PROCEDURE sp1 #DET# NO SQL COMMENT 'comment' ;
304
SELECT * FROM t1 ORDER BY id;
305
SELECT * FROM t2 ORDER BY i;
306
SELECT * FROM t3 ORDER BY id;
309
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
310
CREATE TABLE t2 (i INTEGER NULL);
311
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
312
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
313
INSERT INTO t2 VALUES(1),(2),(3);
315
CREATE PROCEDURE sp1()
317
DECLARE done INT DEFAULT 0;
320
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
321
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
322
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
326
FETCH cur1 INTO a, b;
330
INSERT INTO t3 VALUES (a,b);
332
INSERT INTO t3 VALUES (a,c);
335
UNTIL done END REPEAT;
340
ALTER PROCEDURE sp1 #DET# READS SQL DATA COMMENT 'comment' ;
342
SELECT * FROM t1 ORDER BY id;
343
SELECT * FROM t2 ORDER BY i;
344
SELECT * FROM t3 ORDER BY id;
347
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
348
CREATE TABLE t2 (i INTEGER NULL);
349
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
350
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
351
INSERT INTO t2 VALUES(1),(2),(3);
353
CREATE PROCEDURE sp1()
355
DECLARE done INT DEFAULT 0;
358
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
359
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
360
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
364
FETCH cur1 INTO a, b;
368
INSERT INTO t3 VALUES (a,b);
370
INSERT INTO t3 VALUES (a,c);
373
UNTIL done END REPEAT;
378
ALTER PROCEDURE sp1 #DET# MODIFIES SQL DATA COMMENT 'comment' ;
380
SELECT * FROM t1 ORDER BY id;
381
SELECT * FROM t2 ORDER BY i;
382
SELECT * FROM t3 ORDER BY id;
385
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
386
CREATE TABLE t2 (i INTEGER NULL);
387
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
388
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
389
INSERT INTO t2 VALUES(1),(2),(3);
391
CREATE PROCEDURE sp1()
393
DECLARE done INT DEFAULT 0;
396
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
397
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
398
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
402
FETCH cur1 INTO a, b;
406
INSERT INTO t3 VALUES (a,b);
408
INSERT INTO t3 VALUES (a,c);
411
UNTIL done END REPEAT;
416
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# ;
418
SELECT * FROM t1 ORDER BY id;
419
SELECT * FROM t2 ORDER BY i;
420
SELECT * FROM t3 ORDER BY id;
423
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
424
CREATE TABLE t2 (i INTEGER NULL);
425
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
426
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
427
INSERT INTO t2 VALUES(1),(2),(3);
429
CREATE PROCEDURE sp1()
431
DECLARE done INT DEFAULT 0;
434
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
435
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
436
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
440
FETCH cur1 INTO a, b;
444
INSERT INTO t3 VALUES (a,b);
446
INSERT INTO t3 VALUES (a,c);
449
UNTIL done END REPEAT;
454
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# CONTAINS SQL ;
456
SELECT * FROM t1 ORDER BY id;
457
SELECT * FROM t2 ORDER BY i;
458
SELECT * FROM t3 ORDER BY id;
461
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
462
CREATE TABLE t2 (i INTEGER NULL);
463
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
464
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
465
INSERT INTO t2 VALUES(1),(2),(3);
467
CREATE PROCEDURE sp1()
469
DECLARE done INT DEFAULT 0;
472
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
473
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
474
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
478
FETCH cur1 INTO a, b;
482
INSERT INTO t3 VALUES (a,b);
484
INSERT INTO t3 VALUES (a,c);
487
UNTIL done END REPEAT;
492
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# NO SQL ;
494
SELECT * FROM t1 ORDER BY id;
495
SELECT * FROM t2 ORDER BY i;
496
SELECT * FROM t3 ORDER BY id;
499
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
500
CREATE TABLE t2 (i INTEGER NULL);
501
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
502
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
503
INSERT INTO t2 VALUES(1),(2),(3);
505
CREATE PROCEDURE sp1()
507
DECLARE done INT DEFAULT 0;
510
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
511
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
512
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
516
FETCH cur1 INTO a, b;
520
INSERT INTO t3 VALUES (a,b);
522
INSERT INTO t3 VALUES (a,c);
525
UNTIL done END REPEAT;
530
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# READS SQL DATA ;
532
SELECT * FROM t1 ORDER BY id;
533
SELECT * FROM t2 ORDER BY i;
534
SELECT * FROM t3 ORDER BY id;
537
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
538
CREATE TABLE t2 (i INTEGER NULL);
539
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
540
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
541
INSERT INTO t2 VALUES(1),(2),(3);
543
CREATE PROCEDURE sp1()
545
DECLARE done INT DEFAULT 0;
548
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
549
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
550
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
554
FETCH cur1 INTO a, b;
558
INSERT INTO t3 VALUES (a,b);
560
INSERT INTO t3 VALUES (a,c);
563
UNTIL done END REPEAT;
568
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# MODIFIES SQL DATA ;
570
SELECT * FROM t1 ORDER BY id;
571
SELECT * FROM t2 ORDER BY i;
572
SELECT * FROM t3 ORDER BY id;
575
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
576
CREATE TABLE t2 (i INTEGER NULL);
577
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
578
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
579
INSERT INTO t2 VALUES(1),(2),(3);
581
CREATE PROCEDURE sp1()
583
DECLARE done INT DEFAULT 0;
586
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
587
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
588
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
592
FETCH cur1 INTO a, b;
596
INSERT INTO t3 VALUES (a,b);
598
INSERT INTO t3 VALUES (a,c);
601
UNTIL done END REPEAT;
606
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# COMMENT 'comment' ;
608
SELECT * FROM t1 ORDER BY id;
609
SELECT * FROM t2 ORDER BY i;
610
SELECT * FROM t3 ORDER BY id;
613
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
614
CREATE TABLE t2 (i INTEGER NULL);
615
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
616
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
617
INSERT INTO t2 VALUES(1),(2),(3);
619
CREATE PROCEDURE sp1()
621
DECLARE done INT DEFAULT 0;
624
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
625
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
626
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
630
FETCH cur1 INTO a, b;
634
INSERT INTO t3 VALUES (a,b);
636
INSERT INTO t3 VALUES (a,c);
639
UNTIL done END REPEAT;
644
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# CONTAINS SQL COMMENT 'comment' ;
646
SELECT * FROM t1 ORDER BY id;
647
SELECT * FROM t2 ORDER BY i;
648
SELECT * FROM t3 ORDER BY id;
651
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
652
CREATE TABLE t2 (i INTEGER NULL);
653
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
654
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
655
INSERT INTO t2 VALUES(1),(2),(3);
657
CREATE PROCEDURE sp1()
659
DECLARE done INT DEFAULT 0;
662
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
663
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
664
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
668
FETCH cur1 INTO a, b;
672
INSERT INTO t3 VALUES (a,b);
674
INSERT INTO t3 VALUES (a,c);
677
UNTIL done END REPEAT;
682
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# NO SQL COMMENT 'comment' ;
684
SELECT * FROM t1 ORDER BY id;
685
SELECT * FROM t2 ORDER BY i;
686
SELECT * FROM t3 ORDER BY id;
689
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
690
CREATE TABLE t2 (i INTEGER NULL);
691
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
692
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
693
INSERT INTO t2 VALUES(1),(2),(3);
695
CREATE PROCEDURE sp1()
697
DECLARE done INT DEFAULT 0;
700
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
701
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
702
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
706
FETCH cur1 INTO a, b;
710
INSERT INTO t3 VALUES (a,b);
712
INSERT INTO t3 VALUES (a,c);
715
UNTIL done END REPEAT;
720
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# READS SQL DATA COMMENT 'comment' ;
722
SELECT * FROM t1 ORDER BY id;
723
SELECT * FROM t2 ORDER BY i;
724
SELECT * FROM t3 ORDER BY id;
727
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
728
CREATE TABLE t2 (i INTEGER NULL);
729
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
730
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
731
INSERT INTO t2 VALUES(1),(2),(3);
733
CREATE PROCEDURE sp1()
735
DECLARE done INT DEFAULT 0;
738
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
739
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
740
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
744
FETCH cur1 INTO a, b;
748
INSERT INTO t3 VALUES (a,b);
750
INSERT INTO t3 VALUES (a,c);
753
UNTIL done END REPEAT;
758
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# MODIFIES SQL DATA COMMENT 'comment' ;
760
SELECT * FROM t1 ORDER BY id;
761
SELECT * FROM t2 ORDER BY i;
762
SELECT * FROM t3 ORDER BY id;
765
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
766
CREATE TABLE t2 (i INTEGER NULL);
767
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
768
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
769
INSERT INTO t2 VALUES(1),(2),(3);
771
CREATE PROCEDURE sp1()
773
DECLARE done INT DEFAULT 0;
776
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
777
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
778
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
782
FETCH cur1 INTO a, b;
786
INSERT INTO t3 VALUES (a,b);
788
INSERT INTO t3 VALUES (a,c);
791
UNTIL done END REPEAT;
796
ALTER PROCEDURE sp1 #DET# SQL SECURITY INVOKER ;
798
SELECT * FROM t1 ORDER BY id;
799
SELECT * FROM t2 ORDER BY i;
800
SELECT * FROM t3 ORDER BY id;
803
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
804
CREATE TABLE t2 (i INTEGER NULL);
805
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
806
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
807
INSERT INTO t2 VALUES(1),(2),(3);
809
CREATE PROCEDURE sp1()
811
DECLARE done INT DEFAULT 0;
814
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
815
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
816
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
820
FETCH cur1 INTO a, b;
824
INSERT INTO t3 VALUES (a,b);
826
INSERT INTO t3 VALUES (a,c);
829
UNTIL done END REPEAT;
834
ALTER PROCEDURE sp1 #DET# CONTAINS SQL SQL SECURITY INVOKER ;
836
SELECT * FROM t1 ORDER BY id;
837
SELECT * FROM t2 ORDER BY i;
838
SELECT * FROM t3 ORDER BY id;
841
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
842
CREATE TABLE t2 (i INTEGER NULL);
843
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
844
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
845
INSERT INTO t2 VALUES(1),(2),(3);
847
CREATE PROCEDURE sp1()
849
DECLARE done INT DEFAULT 0;
852
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
853
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
854
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
858
FETCH cur1 INTO a, b;
862
INSERT INTO t3 VALUES (a,b);
864
INSERT INTO t3 VALUES (a,c);
867
UNTIL done END REPEAT;
872
ALTER PROCEDURE sp1 #DET# NO SQL SQL SECURITY INVOKER ;
874
SELECT * FROM t1 ORDER BY id;
875
SELECT * FROM t2 ORDER BY i;
876
SELECT * FROM t3 ORDER BY id;
879
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
880
CREATE TABLE t2 (i INTEGER NULL);
881
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
882
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
883
INSERT INTO t2 VALUES(1),(2),(3);
885
CREATE PROCEDURE sp1()
887
DECLARE done INT DEFAULT 0;
890
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
891
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
892
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
896
FETCH cur1 INTO a, b;
900
INSERT INTO t3 VALUES (a,b);
902
INSERT INTO t3 VALUES (a,c);
905
UNTIL done END REPEAT;
910
ALTER PROCEDURE sp1 #DET# READS SQL DATA SQL SECURITY INVOKER ;
912
SELECT * FROM t1 ORDER BY id;
913
SELECT * FROM t2 ORDER BY i;
914
SELECT * FROM t3 ORDER BY id;
917
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
918
CREATE TABLE t2 (i INTEGER NULL);
919
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
920
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
921
INSERT INTO t2 VALUES(1),(2),(3);
923
CREATE PROCEDURE sp1()
925
DECLARE done INT DEFAULT 0;
928
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
929
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
930
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
934
FETCH cur1 INTO a, b;
938
INSERT INTO t3 VALUES (a,b);
940
INSERT INTO t3 VALUES (a,c);
943
UNTIL done END REPEAT;
948
ALTER PROCEDURE sp1 #DET# MODIFIES SQL DATA SQL SECURITY INVOKER ;
950
SELECT * FROM t1 ORDER BY id;
951
SELECT * FROM t2 ORDER BY i;
952
SELECT * FROM t3 ORDER BY id;
955
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
956
CREATE TABLE t2 (i INTEGER NULL);
957
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
958
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
959
INSERT INTO t2 VALUES(1),(2),(3);
961
CREATE PROCEDURE sp1()
963
DECLARE done INT DEFAULT 0;
966
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
967
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
968
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
972
FETCH cur1 INTO a, b;
976
INSERT INTO t3 VALUES (a,b);
978
INSERT INTO t3 VALUES (a,c);
981
UNTIL done END REPEAT;
986
ALTER PROCEDURE sp1 #DET# SQL SECURITY INVOKER COMMENT 'comment' ;
988
SELECT * FROM t1 ORDER BY id;
989
SELECT * FROM t2 ORDER BY i;
990
SELECT * FROM t3 ORDER BY id;
993
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
994
CREATE TABLE t2 (i INTEGER NULL);
995
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
996
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
997
INSERT INTO t2 VALUES(1),(2),(3);
999
CREATE PROCEDURE sp1()
1001
DECLARE done INT DEFAULT 0;
1004
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1005
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1006
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1010
FETCH cur1 INTO a, b;
1014
INSERT INTO t3 VALUES (a,b);
1016
INSERT INTO t3 VALUES (a,c);
1019
UNTIL done END REPEAT;
1024
ALTER PROCEDURE sp1 #DET# CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment' ;
1026
SELECT * FROM t1 ORDER BY id;
1027
SELECT * FROM t2 ORDER BY i;
1028
SELECT * FROM t3 ORDER BY id;
1030
DROP TABLE t1,t2,t3;
1031
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1032
CREATE TABLE t2 (i INTEGER NULL);
1033
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1034
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1035
INSERT INTO t2 VALUES(1),(2),(3);
1037
CREATE PROCEDURE sp1()
1039
DECLARE done INT DEFAULT 0;
1042
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1043
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1044
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1048
FETCH cur1 INTO a, b;
1052
INSERT INTO t3 VALUES (a,b);
1054
INSERT INTO t3 VALUES (a,c);
1057
UNTIL done END REPEAT;
1062
ALTER PROCEDURE sp1 #DET# NO SQL SQL SECURITY INVOKER COMMENT 'comment' ;
1064
SELECT * FROM t1 ORDER BY id;
1065
SELECT * FROM t2 ORDER BY i;
1066
SELECT * FROM t3 ORDER BY id;
1068
DROP TABLE t1,t2,t3;
1069
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1070
CREATE TABLE t2 (i INTEGER NULL);
1071
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1072
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1073
INSERT INTO t2 VALUES(1),(2),(3);
1075
CREATE PROCEDURE sp1()
1077
DECLARE done INT DEFAULT 0;
1080
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1081
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1082
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1086
FETCH cur1 INTO a, b;
1090
INSERT INTO t3 VALUES (a,b);
1092
INSERT INTO t3 VALUES (a,c);
1095
UNTIL done END REPEAT;
1100
ALTER PROCEDURE sp1 #DET# READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment' ;
1102
SELECT * FROM t1 ORDER BY id;
1103
SELECT * FROM t2 ORDER BY i;
1104
SELECT * FROM t3 ORDER BY id;
1106
DROP TABLE t1,t2,t3;
1107
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1108
CREATE TABLE t2 (i INTEGER NULL);
1109
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1110
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1111
INSERT INTO t2 VALUES(1),(2),(3);
1113
CREATE PROCEDURE sp1()
1115
DECLARE done INT DEFAULT 0;
1118
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1119
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1120
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1124
FETCH cur1 INTO a, b;
1128
INSERT INTO t3 VALUES (a,b);
1130
INSERT INTO t3 VALUES (a,c);
1133
UNTIL done END REPEAT;
1138
ALTER PROCEDURE sp1 #DET# MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment' ;
1140
SELECT * FROM t1 ORDER BY id;
1141
SELECT * FROM t2 ORDER BY i;
1142
SELECT * FROM t3 ORDER BY id;
1144
DROP TABLE t1,t2,t3;
1145
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1146
CREATE TABLE t2 (i INTEGER NULL);
1147
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1148
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1149
INSERT INTO t2 VALUES(1),(2),(3);
1151
CREATE PROCEDURE sp1()
1153
DECLARE done INT DEFAULT 0;
1156
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1157
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1158
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1162
FETCH cur1 INTO a, b;
1166
INSERT INTO t3 VALUES (a,b);
1168
INSERT INTO t3 VALUES (a,c);
1171
UNTIL done END REPEAT;
1176
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# SQL SECURITY INVOKER ;
1178
SELECT * FROM t1 ORDER BY id;
1179
SELECT * FROM t2 ORDER BY i;
1180
SELECT * FROM t3 ORDER BY id;
1182
DROP TABLE t1,t2,t3;
1183
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1184
CREATE TABLE t2 (i INTEGER NULL);
1185
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1186
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1187
INSERT INTO t2 VALUES(1),(2),(3);
1189
CREATE PROCEDURE sp1()
1191
DECLARE done INT DEFAULT 0;
1194
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1195
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1196
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1200
FETCH cur1 INTO a, b;
1204
INSERT INTO t3 VALUES (a,b);
1206
INSERT INTO t3 VALUES (a,c);
1209
UNTIL done END REPEAT;
1214
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# CONTAINS SQL SQL SECURITY INVOKER ;
1216
SELECT * FROM t1 ORDER BY id;
1217
SELECT * FROM t2 ORDER BY i;
1218
SELECT * FROM t3 ORDER BY id;
1220
DROP TABLE t1,t2,t3;
1221
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1222
CREATE TABLE t2 (i INTEGER NULL);
1223
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1224
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1225
INSERT INTO t2 VALUES(1),(2),(3);
1227
CREATE PROCEDURE sp1()
1229
DECLARE done INT DEFAULT 0;
1232
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1233
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1234
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1238
FETCH cur1 INTO a, b;
1242
INSERT INTO t3 VALUES (a,b);
1244
INSERT INTO t3 VALUES (a,c);
1247
UNTIL done END REPEAT;
1252
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# NO SQL SQL SECURITY INVOKER ;
1254
SELECT * FROM t1 ORDER BY id;
1255
SELECT * FROM t2 ORDER BY i;
1256
SELECT * FROM t3 ORDER BY id;
1258
DROP TABLE t1,t2,t3;
1259
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1260
CREATE TABLE t2 (i INTEGER NULL);
1261
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1262
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1263
INSERT INTO t2 VALUES(1),(2),(3);
1265
CREATE PROCEDURE sp1()
1267
DECLARE done INT DEFAULT 0;
1270
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1271
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1272
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1276
FETCH cur1 INTO a, b;
1280
INSERT INTO t3 VALUES (a,b);
1282
INSERT INTO t3 VALUES (a,c);
1285
UNTIL done END REPEAT;
1290
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# READS SQL DATA SQL SECURITY INVOKER ;
1292
SELECT * FROM t1 ORDER BY id;
1293
SELECT * FROM t2 ORDER BY i;
1294
SELECT * FROM t3 ORDER BY id;
1296
DROP TABLE t1,t2,t3;
1297
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1298
CREATE TABLE t2 (i INTEGER NULL);
1299
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1300
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1301
INSERT INTO t2 VALUES(1),(2),(3);
1303
CREATE PROCEDURE sp1()
1305
DECLARE done INT DEFAULT 0;
1308
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1309
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1310
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1314
FETCH cur1 INTO a, b;
1318
INSERT INTO t3 VALUES (a,b);
1320
INSERT INTO t3 VALUES (a,c);
1323
UNTIL done END REPEAT;
1328
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# MODIFIES SQL DATA SQL SECURITY INVOKER ;
1330
SELECT * FROM t1 ORDER BY id;
1331
SELECT * FROM t2 ORDER BY i;
1332
SELECT * FROM t3 ORDER BY id;
1334
DROP TABLE t1,t2,t3;
1335
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1336
CREATE TABLE t2 (i INTEGER NULL);
1337
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1338
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1339
INSERT INTO t2 VALUES(1),(2),(3);
1341
CREATE PROCEDURE sp1()
1343
DECLARE done INT DEFAULT 0;
1346
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1347
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1348
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1352
FETCH cur1 INTO a, b;
1356
INSERT INTO t3 VALUES (a,b);
1358
INSERT INTO t3 VALUES (a,c);
1361
UNTIL done END REPEAT;
1366
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# SQL SECURITY INVOKER COMMENT 'comment' ;
1368
SELECT * FROM t1 ORDER BY id;
1369
SELECT * FROM t2 ORDER BY i;
1370
SELECT * FROM t3 ORDER BY id;
1372
DROP TABLE t1,t2,t3;
1373
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1374
CREATE TABLE t2 (i INTEGER NULL);
1375
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1376
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1377
INSERT INTO t2 VALUES(1),(2),(3);
1379
CREATE PROCEDURE sp1()
1381
DECLARE done INT DEFAULT 0;
1384
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1385
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1386
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1390
FETCH cur1 INTO a, b;
1394
INSERT INTO t3 VALUES (a,b);
1396
INSERT INTO t3 VALUES (a,c);
1399
UNTIL done END REPEAT;
1404
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment' ;
1406
SELECT * FROM t1 ORDER BY id;
1407
SELECT * FROM t2 ORDER BY i;
1408
SELECT * FROM t3 ORDER BY id;
1410
DROP TABLE t1,t2,t3;
1411
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1412
CREATE TABLE t2 (i INTEGER NULL);
1413
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1414
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1415
INSERT INTO t2 VALUES(1),(2),(3);
1417
CREATE PROCEDURE sp1()
1419
DECLARE done INT DEFAULT 0;
1422
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1423
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1424
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1428
FETCH cur1 INTO a, b;
1432
INSERT INTO t3 VALUES (a,b);
1434
INSERT INTO t3 VALUES (a,c);
1437
UNTIL done END REPEAT;
1442
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# NO SQL SQL SECURITY INVOKER COMMENT 'comment' ;
1444
SELECT * FROM t1 ORDER BY id;
1445
SELECT * FROM t2 ORDER BY i;
1446
SELECT * FROM t3 ORDER BY id;
1448
DROP TABLE t1,t2,t3;
1449
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1450
CREATE TABLE t2 (i INTEGER NULL);
1451
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1452
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1453
INSERT INTO t2 VALUES(1),(2),(3);
1455
CREATE PROCEDURE sp1()
1457
DECLARE done INT DEFAULT 0;
1460
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1461
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1462
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1466
FETCH cur1 INTO a, b;
1470
INSERT INTO t3 VALUES (a,b);
1472
INSERT INTO t3 VALUES (a,c);
1475
UNTIL done END REPEAT;
1480
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment' ;
1482
SELECT * FROM t1 ORDER BY id;
1483
SELECT * FROM t2 ORDER BY i;
1484
SELECT * FROM t3 ORDER BY id;
1486
DROP TABLE t1,t2,t3;
1487
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1488
CREATE TABLE t2 (i INTEGER NULL);
1489
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1490
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1491
INSERT INTO t2 VALUES(1),(2),(3);
1493
CREATE PROCEDURE sp1()
1495
DECLARE done INT DEFAULT 0;
1498
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1499
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1500
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1504
FETCH cur1 INTO a, b;
1508
INSERT INTO t3 VALUES (a,b);
1510
INSERT INTO t3 VALUES (a,c);
1513
UNTIL done END REPEAT;
1518
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment' ;
1520
SELECT * FROM t1 ORDER BY id;
1521
SELECT * FROM t2 ORDER BY i;
1522
SELECT * FROM t3 ORDER BY id;
1524
DROP TABLE t1,t2,t3;
1525
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1526
CREATE TABLE t2 (i INTEGER NULL);
1527
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1528
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1529
INSERT INTO t2 VALUES(1),(2),(3);
1531
CREATE PROCEDURE sp1()
1533
DECLARE done INT DEFAULT 0;
1536
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1537
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1538
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1542
FETCH cur1 INTO a, b;
1546
INSERT INTO t3 VALUES (a,b);
1548
INSERT INTO t3 VALUES (a,c);
1551
UNTIL done END REPEAT;
1556
ALTER PROCEDURE sp1 #DET# SQL SECURITY DEFINER ;
1558
SELECT * FROM t1 ORDER BY id;
1559
SELECT * FROM t2 ORDER BY i;
1560
SELECT * FROM t3 ORDER BY id;
1562
DROP TABLE t1,t2,t3;
1563
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1564
CREATE TABLE t2 (i INTEGER NULL);
1565
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1566
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1567
INSERT INTO t2 VALUES(1),(2),(3);
1569
CREATE PROCEDURE sp1()
1571
DECLARE done INT DEFAULT 0;
1574
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1575
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1576
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1580
FETCH cur1 INTO a, b;
1584
INSERT INTO t3 VALUES (a,b);
1586
INSERT INTO t3 VALUES (a,c);
1589
UNTIL done END REPEAT;
1594
ALTER PROCEDURE sp1 #DET# CONTAINS SQL SQL SECURITY DEFINER ;
1596
SELECT * FROM t1 ORDER BY id;
1597
SELECT * FROM t2 ORDER BY i;
1598
SELECT * FROM t3 ORDER BY id;
1600
DROP TABLE t1,t2,t3;
1601
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1602
CREATE TABLE t2 (i INTEGER NULL);
1603
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1604
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1605
INSERT INTO t2 VALUES(1),(2),(3);
1607
CREATE PROCEDURE sp1()
1609
DECLARE done INT DEFAULT 0;
1612
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1613
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1614
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1618
FETCH cur1 INTO a, b;
1622
INSERT INTO t3 VALUES (a,b);
1624
INSERT INTO t3 VALUES (a,c);
1627
UNTIL done END REPEAT;
1632
ALTER PROCEDURE sp1 #DET# NO SQL SQL SECURITY DEFINER ;
1634
SELECT * FROM t1 ORDER BY id;
1635
SELECT * FROM t2 ORDER BY i;
1636
SELECT * FROM t3 ORDER BY id;
1638
DROP TABLE t1,t2,t3;
1639
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1640
CREATE TABLE t2 (i INTEGER NULL);
1641
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1642
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1643
INSERT INTO t2 VALUES(1),(2),(3);
1645
CREATE PROCEDURE sp1()
1647
DECLARE done INT DEFAULT 0;
1650
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1651
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1652
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1656
FETCH cur1 INTO a, b;
1660
INSERT INTO t3 VALUES (a,b);
1662
INSERT INTO t3 VALUES (a,c);
1665
UNTIL done END REPEAT;
1670
ALTER PROCEDURE sp1 #DET# READS SQL DATA SQL SECURITY DEFINER ;
1672
SELECT * FROM t1 ORDER BY id;
1673
SELECT * FROM t2 ORDER BY i;
1674
SELECT * FROM t3 ORDER BY id;
1676
DROP TABLE t1,t2,t3;
1677
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1678
CREATE TABLE t2 (i INTEGER NULL);
1679
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1680
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1681
INSERT INTO t2 VALUES(1),(2),(3);
1683
CREATE PROCEDURE sp1()
1685
DECLARE done INT DEFAULT 0;
1688
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1689
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1690
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1694
FETCH cur1 INTO a, b;
1698
INSERT INTO t3 VALUES (a,b);
1700
INSERT INTO t3 VALUES (a,c);
1703
UNTIL done END REPEAT;
1708
ALTER PROCEDURE sp1 #DET# MODIFIES SQL DATA SQL SECURITY DEFINER ;
1710
SELECT * FROM t1 ORDER BY id;
1711
SELECT * FROM t2 ORDER BY i;
1712
SELECT * FROM t3 ORDER BY id;
1714
DROP TABLE t1,t2,t3;
1715
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1716
CREATE TABLE t2 (i INTEGER NULL);
1717
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1718
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1719
INSERT INTO t2 VALUES(1),(2),(3);
1721
CREATE PROCEDURE sp1()
1723
DECLARE done INT DEFAULT 0;
1726
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1727
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1728
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1732
FETCH cur1 INTO a, b;
1736
INSERT INTO t3 VALUES (a,b);
1738
INSERT INTO t3 VALUES (a,c);
1741
UNTIL done END REPEAT;
1746
ALTER PROCEDURE sp1 #DET# SQL SECURITY DEFINER COMMENT 'comment' ;
1748
SELECT * FROM t1 ORDER BY id;
1749
SELECT * FROM t2 ORDER BY i;
1750
SELECT * FROM t3 ORDER BY id;
1752
DROP TABLE t1,t2,t3;
1753
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1754
CREATE TABLE t2 (i INTEGER NULL);
1755
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1756
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1757
INSERT INTO t2 VALUES(1),(2),(3);
1759
CREATE PROCEDURE sp1()
1761
DECLARE done INT DEFAULT 0;
1764
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1765
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1766
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1770
FETCH cur1 INTO a, b;
1774
INSERT INTO t3 VALUES (a,b);
1776
INSERT INTO t3 VALUES (a,c);
1779
UNTIL done END REPEAT;
1784
ALTER PROCEDURE sp1 #DET# CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment' ;
1786
SELECT * FROM t1 ORDER BY id;
1787
SELECT * FROM t2 ORDER BY i;
1788
SELECT * FROM t3 ORDER BY id;
1790
DROP TABLE t1,t2,t3;
1791
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1792
CREATE TABLE t2 (i INTEGER NULL);
1793
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1794
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1795
INSERT INTO t2 VALUES(1),(2),(3);
1797
CREATE PROCEDURE sp1()
1799
DECLARE done INT DEFAULT 0;
1802
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1803
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1804
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1808
FETCH cur1 INTO a, b;
1812
INSERT INTO t3 VALUES (a,b);
1814
INSERT INTO t3 VALUES (a,c);
1817
UNTIL done END REPEAT;
1822
ALTER PROCEDURE sp1 #DET# NO SQL SQL SECURITY DEFINER COMMENT 'comment' ;
1824
SELECT * FROM t1 ORDER BY id;
1825
SELECT * FROM t2 ORDER BY i;
1826
SELECT * FROM t3 ORDER BY id;
1828
DROP TABLE t1,t2,t3;
1829
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1830
CREATE TABLE t2 (i INTEGER NULL);
1831
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1832
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1833
INSERT INTO t2 VALUES(1),(2),(3);
1835
CREATE PROCEDURE sp1()
1837
DECLARE done INT DEFAULT 0;
1840
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1841
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1842
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1846
FETCH cur1 INTO a, b;
1850
INSERT INTO t3 VALUES (a,b);
1852
INSERT INTO t3 VALUES (a,c);
1855
UNTIL done END REPEAT;
1860
ALTER PROCEDURE sp1 #DET# READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment' ;
1862
SELECT * FROM t1 ORDER BY id;
1863
SELECT * FROM t2 ORDER BY i;
1864
SELECT * FROM t3 ORDER BY id;
1866
DROP TABLE t1,t2,t3;
1867
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1868
CREATE TABLE t2 (i INTEGER NULL);
1869
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1870
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1871
INSERT INTO t2 VALUES(1),(2),(3);
1873
CREATE PROCEDURE sp1()
1875
DECLARE done INT DEFAULT 0;
1878
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1879
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1880
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1884
FETCH cur1 INTO a, b;
1888
INSERT INTO t3 VALUES (a,b);
1890
INSERT INTO t3 VALUES (a,c);
1893
UNTIL done END REPEAT;
1898
ALTER PROCEDURE sp1 #DET# MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment' ;
1900
SELECT * FROM t1 ORDER BY id;
1901
SELECT * FROM t2 ORDER BY i;
1902
SELECT * FROM t3 ORDER BY id;
1904
DROP TABLE t1,t2,t3;
1905
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1906
CREATE TABLE t2 (i INTEGER NULL);
1907
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1908
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1909
INSERT INTO t2 VALUES(1),(2),(3);
1911
CREATE PROCEDURE sp1()
1913
DECLARE done INT DEFAULT 0;
1916
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1917
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1918
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1922
FETCH cur1 INTO a, b;
1926
INSERT INTO t3 VALUES (a,b);
1928
INSERT INTO t3 VALUES (a,c);
1931
UNTIL done END REPEAT;
1936
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# SQL SECURITY DEFINER ;
1938
SELECT * FROM t1 ORDER BY id;
1939
SELECT * FROM t2 ORDER BY i;
1940
SELECT * FROM t3 ORDER BY id;
1942
DROP TABLE t1,t2,t3;
1943
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1944
CREATE TABLE t2 (i INTEGER NULL);
1945
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1946
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1947
INSERT INTO t2 VALUES(1),(2),(3);
1949
CREATE PROCEDURE sp1()
1951
DECLARE done INT DEFAULT 0;
1954
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1955
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1956
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1960
FETCH cur1 INTO a, b;
1964
INSERT INTO t3 VALUES (a,b);
1966
INSERT INTO t3 VALUES (a,c);
1969
UNTIL done END REPEAT;
1974
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# CONTAINS SQL SQL SECURITY DEFINER ;
1976
SELECT * FROM t1 ORDER BY id;
1977
SELECT * FROM t2 ORDER BY i;
1978
SELECT * FROM t3 ORDER BY id;
1980
DROP TABLE t1,t2,t3;
1981
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1982
CREATE TABLE t2 (i INTEGER NULL);
1983
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
1984
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
1985
INSERT INTO t2 VALUES(1),(2),(3);
1987
CREATE PROCEDURE sp1()
1989
DECLARE done INT DEFAULT 0;
1992
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
1993
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
1994
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
1998
FETCH cur1 INTO a, b;
2002
INSERT INTO t3 VALUES (a,b);
2004
INSERT INTO t3 VALUES (a,c);
2007
UNTIL done END REPEAT;
2012
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# NO SQL SQL SECURITY DEFINER ;
2014
SELECT * FROM t1 ORDER BY id;
2015
SELECT * FROM t2 ORDER BY i;
2016
SELECT * FROM t3 ORDER BY id;
2018
DROP TABLE t1,t2,t3;
2019
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
2020
CREATE TABLE t2 (i INTEGER NULL);
2021
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
2022
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
2023
INSERT INTO t2 VALUES(1),(2),(3);
2025
CREATE PROCEDURE sp1()
2027
DECLARE done INT DEFAULT 0;
2030
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
2031
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
2032
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
2036
FETCH cur1 INTO a, b;
2040
INSERT INTO t3 VALUES (a,b);
2042
INSERT INTO t3 VALUES (a,c);
2045
UNTIL done END REPEAT;
2050
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# READS SQL DATA SQL SECURITY DEFINER ;
2052
SELECT * FROM t1 ORDER BY id;
2053
SELECT * FROM t2 ORDER BY i;
2054
SELECT * FROM t3 ORDER BY id;
2056
DROP TABLE t1,t2,t3;
2057
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
2058
CREATE TABLE t2 (i INTEGER NULL);
2059
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
2060
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
2061
INSERT INTO t2 VALUES(1),(2),(3);
2063
CREATE PROCEDURE sp1()
2065
DECLARE done INT DEFAULT 0;
2068
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
2069
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
2070
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
2074
FETCH cur1 INTO a, b;
2078
INSERT INTO t3 VALUES (a,b);
2080
INSERT INTO t3 VALUES (a,c);
2083
UNTIL done END REPEAT;
2088
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# MODIFIES SQL DATA SQL SECURITY DEFINER ;
2090
SELECT * FROM t1 ORDER BY id;
2091
SELECT * FROM t2 ORDER BY i;
2092
SELECT * FROM t3 ORDER BY id;
2094
DROP TABLE t1,t2,t3;
2095
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
2096
CREATE TABLE t2 (i INTEGER NULL);
2097
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
2098
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
2099
INSERT INTO t2 VALUES(1),(2),(3);
2101
CREATE PROCEDURE sp1()
2103
DECLARE done INT DEFAULT 0;
2106
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
2107
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
2108
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
2112
FETCH cur1 INTO a, b;
2116
INSERT INTO t3 VALUES (a,b);
2118
INSERT INTO t3 VALUES (a,c);
2121
UNTIL done END REPEAT;
2126
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# SQL SECURITY DEFINER COMMENT 'comment' ;
2128
SELECT * FROM t1 ORDER BY id;
2129
SELECT * FROM t2 ORDER BY i;
2130
SELECT * FROM t3 ORDER BY id;
2132
DROP TABLE t1,t2,t3;
2133
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
2134
CREATE TABLE t2 (i INTEGER NULL);
2135
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
2136
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
2137
INSERT INTO t2 VALUES(1),(2),(3);
2139
CREATE PROCEDURE sp1()
2141
DECLARE done INT DEFAULT 0;
2144
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
2145
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
2146
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
2150
FETCH cur1 INTO a, b;
2154
INSERT INTO t3 VALUES (a,b);
2156
INSERT INTO t3 VALUES (a,c);
2159
UNTIL done END REPEAT;
2164
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment' ;
2166
SELECT * FROM t1 ORDER BY id;
2167
SELECT * FROM t2 ORDER BY i;
2168
SELECT * FROM t3 ORDER BY id;
2170
DROP TABLE t1,t2,t3;
2171
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
2172
CREATE TABLE t2 (i INTEGER NULL);
2173
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
2174
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
2175
INSERT INTO t2 VALUES(1),(2),(3);
2177
CREATE PROCEDURE sp1()
2179
DECLARE done INT DEFAULT 0;
2182
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
2183
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
2184
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
2188
FETCH cur1 INTO a, b;
2192
INSERT INTO t3 VALUES (a,b);
2194
INSERT INTO t3 VALUES (a,c);
2197
UNTIL done END REPEAT;
2202
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# NO SQL SQL SECURITY DEFINER COMMENT 'comment' ;
2204
SELECT * FROM t1 ORDER BY id;
2205
SELECT * FROM t2 ORDER BY i;
2206
SELECT * FROM t3 ORDER BY id;
2208
DROP TABLE t1,t2,t3;
2209
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
2210
CREATE TABLE t2 (i INTEGER NULL);
2211
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
2212
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
2213
INSERT INTO t2 VALUES(1),(2),(3);
2215
CREATE PROCEDURE sp1()
2217
DECLARE done INT DEFAULT 0;
2220
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
2221
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
2222
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
2226
FETCH cur1 INTO a, b;
2230
INSERT INTO t3 VALUES (a,b);
2232
INSERT INTO t3 VALUES (a,c);
2235
UNTIL done END REPEAT;
2240
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# READS SQL DATA SQL SECURITY DEFINER COMMENT 'comment' ;
2242
SELECT * FROM t1 ORDER BY id;
2243
SELECT * FROM t2 ORDER BY i;
2244
SELECT * FROM t3 ORDER BY id;
2246
DROP TABLE t1,t2,t3;
2247
CREATE TABLE t1 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
2248
CREATE TABLE t2 (i INTEGER NULL);
2249
CREATE TABLE t3 (id INTEGER NOT NULL PRIMARY KEY, data INTEGER NULL);
2250
INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
2251
INSERT INTO t2 VALUES(1),(2),(3);
2253
CREATE PROCEDURE sp1()
2255
DECLARE done INT DEFAULT 0;
2258
DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
2259
DECLARE cur2 CURSOR FOR SELECT i FROM t2;
2260
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
2264
FETCH cur1 INTO a, b;
2268
INSERT INTO t3 VALUES (a,b);
2270
INSERT INTO t3 VALUES (a,c);
2273
UNTIL done END REPEAT;
2278
ALTER PROCEDURE sp1 LANGUAGE SQL #DET# MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'comment' ;
2280
SELECT * FROM t1 ORDER BY id;
2281
SELECT * FROM t2 ORDER BY i;
2282
SELECT * FROM t3 ORDER BY id;
2284
DROP TABLE t1,t2,t3;