Debian Codegraph @

mysql-test/suite/compat/oracle/t/sp-goto.test

raw
1 set sql_mode=oracle;
2 --echo #
3 --echo # MDEV-10697 sql_mode=ORACLE: GOTO statement
4 --echo #
5
6 --echo # matrice of tests in procedure
7 --echo # |--------------------------------------------------------
8 --echo # | | Same | Outside | to sub | No |
9 --echo # | | block | one block | block | matching |
10 --echo # | | | | | label |
11 --echo # |--------------------------------------------------------
12 --echo # | Forward jump | F1 | F3 | F5 | F7 |
13 --echo # |--------------------------------------------------------
14 --echo # | Backward jump | F2 | F4 | F6 | F8 |
15 --echo # |--------------------------------------------------------
16 --echo # Jump from handler to outside handling code block : F9
17 --echo # Jump from handler to handling code block : F10 (forbidden)
18 --echo # Jump inside handler : F21
19 --echo # Jump between handler : F22 (forbidden)
20 --echo # Jump from cascaded block with handler : F11
21 --echo # Duplicate label in same block : F12 (forbidden)
22 --echo # Duplicate label in different block : F13
23 --echo # Jump outside unlabeled block : F14
24 --echo # Jump inside/outside labeled block : F15
25 --echo # Jump from if / else : F16
26 --echo # Jump with cursors : F17
27 --echo # Jump outside case : F18
28 --echo # Jump inside/outside case block : F19
29 --echo # Jump outside labeled loop : F20
30 --echo # Jump (continue) labeled loop : F23
31 --echo # Two consecutive label : P24
32 --echo # Two consecutive label (backward and forward jump) : P25
33 --echo # Two consecutive label, continue to wrong label : P26
34 --echo # Consecutive goto label and block label : P27
35
36 --echo # Test in function
37 --echo # backward jump : func1
38 --echo # forward jump : func2
39
40 --echo # Test in trigger
41 --echo # forward jump : trg1
42
43 --echo #
44 --echo # Forward jump in same block
45 --echo #
46 DELIMITER $$;
47 CREATE or replace procedure f1(p2 IN OUT VARCHAR)
48 AS
49 BEGIN
50 p2:='a';
51 goto lab1;
52 <<lab1>>
53 goto lab2;
54 p2:='b';
55 <<lab2>>
56 return ;
57 END;
58 $$
59
60 DELIMITER ;$$
61 call f1(@wp1);
62 select 'f1',@wp1;
63 DROP PROCEDURE f1;
64
65 --echo #
66 --echo # Backward jump in same block
67 --echo #
68 DELIMITER $$;
69 CREATE or replace procedure f2(p2 IN OUT VARCHAR)
70 AS
71 BEGIN
72 p2:='a';
73 <<lab1>>
74 if (p2='b') then
75 return ;
76 end if;
77 p2:='b';
78 goto lab1;
79 END;
80 $$
81 DELIMITER ;$$
82 call f2(@wp1);
83 select 'f2',@wp1;
84 DROP PROCEDURE f2;
85
86 --echo #
87 --echo # Forward jump outside one block
88 --echo #
89 DELIMITER $$;
90 CREATE or replace procedure f3(p2 IN OUT VARCHAR)
91 AS
92 BEGIN
93 p2:='a';
94 if (p2='a') then
95 goto lab1;
96 end if;
97 p2:='c';
98 <<lab1>>
99 return ;
100 END;
101 $$
102 DELIMITER ;$$
103 call f3(@wp1);
104 select 'f3',@wp1;
105 DROP PROCEDURE f3;
106
107 --echo #
108 --echo # Backward jump outside one block
109 --echo #
110 DELIMITER $$;
111 CREATE or replace procedure f4(p2 IN OUT VARCHAR)
112 AS
113 BEGIN
114 p2:='a';
115 <<lab1>>
116 if (p2='a') then
117 p2:=p2||'b';
118 goto lab1;
119 end if;
120 if (p2='ab') then
121 p2:=p2||'c';
122 end if;
123 return ;
124 END;
125 $$
126 DELIMITER ;$$
127 call f4(@wp1);
128 select 'f4',@wp1;
129 DROP PROCEDURE f4;
130
131 DELIMITER $$;
132 --echo #
133 --echo # Forward jump inside sub block
134 --error ER_SP_LILABEL_MISMATCH
135 CREATE or replace procedure f5(p2 IN OUT VARCHAR)
136 AS
137 BEGIN
138 p2:='a';
139 goto lab5 ;
140 if (p2='a') then
141 <<lab5>>
142 p2:=p2||'b';
143 end if;
144 return ;
145 END;
146 $$
147 DELIMITER ;$$
148
149 DELIMITER $$;
150 --echo #
151 --echo # Backward jump inside sub block
152 --error ER_SP_LILABEL_MISMATCH
153 CREATE or replace procedure f6(p2 IN OUT VARCHAR)
154 AS
155 BEGIN
156 p2:='a';
157 if (p2='a') then
158 <<lab6>>
159 p2:=p2||'b';
160 return ;
161 end if;
162 goto lab6 ;
163 END;
164 $$
165 DELIMITER ;$$
166
167 DELIMITER $$;
168 --echo #
169 --echo # Backward jump - missing label
170 --error ER_SP_LILABEL_MISMATCH
171 CREATE or replace procedure f7(p2 IN OUT VARCHAR)
172 AS
173 BEGIN
174 <<lab>>
175 goto lab7 ;
176 return ;
177 END;
178 $$
179 DELIMITER ;$$
180
181 DELIMITER $$;
182 --echo #
183 --echo # Forward jump - missing label
184 --error ER_SP_LILABEL_MISMATCH
185 CREATE or replace procedure f8(p2 IN OUT VARCHAR)
186 AS
187 BEGIN
188 goto lab8 ;
189 <<lab>>
190 return ;
191 END;
192 $$
193 DELIMITER ;$$
194
195 --echo #
196 --echo # Jump from handler to procedure code
197 --echo #
198 DELIMITER $$;
199 CREATE or replace procedure f9(lim INT, res OUT VARCHAR)
200 AS
201 a INT;
202 BEGIN
203 <<lab9>>
204 if lim=-1 then
205 res:=res||' -- goto end limit -1 --';
206 goto lab9_end;
207 end if;
208
209 begin
210 SELECT a INTO a FROM information_schema.tables LIMIT lim;
211 EXCEPTION
212 WHEN TOO_MANY_ROWS THEN
213 begin
214 res:=res||'--- too_many_rows cought ---';
215 lim:=0;
216 goto lab9;
217 end;
218 WHEN NO_DATA_FOUND THEN
219 begin
220 res:=res||'--- no_data_found cought ---';
221 lim:=-1;
222 goto lab9;
223 end;
224 end;
225 res:=res||'error';
226 <<lab9_end>>
227 return ;
228 END;
229 $$
230 DELIMITER ;$$
231 SET @res='';
232 CALL f9(2, @res);
233 SELECT 'f9',@res;
234 CALL f9(0, @res);
235 SELECT 'f9',@res;
236 DROP PROCEDURE f9;
237
238 DELIMITER $$;
239 --echo #
240 --echo # Jump from handler to handling bloc
241 --error ER_SP_LILABEL_MISMATCH
242 CREATE or replace procedure f10(lim INT, res OUT VARCHAR)
243 AS
244 a INT;
245 BEGIN
246 begin
247 <<lab10>>
248 SELECT a INTO a FROM information_schema.tables LIMIT lim;
249 EXCEPTION
250 WHEN TOO_MANY_ROWS THEN
251 begin
252 res:='--- too_many_rows cought ---';
253 goto lab10;
254 end;
255 WHEN NO_DATA_FOUND THEN res:='--- no_data_found cought ---';
256 end;
257 return ;
258 END;
259 $$
260
261 --echo #
262 --echo # Jump from cascaded block with handler
263 --echo #
264 CREATE or replace procedure f11(lim INT, res OUT VARCHAR)
265 AS
266 a INT;
267 BEGIN
268 <<lab11a>>
269 begin
270 SELECT a INTO a FROM information_schema.tables LIMIT lim;
271 EXCEPTION
272 WHEN TOO_MANY_ROWS THEN
273 begin
274 res:=res||'--- too_many_rows cought 1 ---';
275 goto lab11b;
276 end;
277 WHEN NO_DATA_FOUND THEN
278 begin
279 res:=res||'--- no_data_found cought 1 ---';
280 lim:=2;
281 SELECT a INTO a FROM information_schema.tables LIMIT lim;
282 EXCEPTION
283 WHEN TOO_MANY_ROWS THEN
284 begin
285 res:=res||'--- too_many_rows cought 2 ---';
286 goto lab11a;
287 end;
288 WHEN NO_DATA_FOUND THEN res:='--- no_data_found cought 2 ---';
289 end;
290 end;
291 set res:=res||' error ';
292 <<lab11b>>
293 return ;
294 END;
295 $$
296 DELIMITER ;$$
297 SET @res='';
298 CALL f11(0, @res);
299 SELECT 'f11',@res;
300 DROP PROCEDURE f11;
301
302 DELIMITER $$;
303 --echo #
304 --echo # Jump inside handler
305 --echo #
306 CREATE or replace procedure f21(lim INT, res OUT VARCHAR)
307 AS
308 a INT;
309 BEGIN
310 begin
311 SELECT a INTO a FROM information_schema.tables LIMIT lim;
312 EXCEPTION
313 WHEN TOO_MANY_ROWS THEN
314 begin
315 <<retry>>
316 lim:=lim-1;
317 loop
318 begin
319 SELECT a INTO a FROM information_schema.tables LIMIT lim;
320 EXCEPTION
321 WHEN TOO_MANY_ROWS THEN
322 begin
323 lim:=lim-1;
324 goto retry;
325 end;
326 end;
327 exit ;
328 end loop;
329 end;
330 end;
331 res:=lim;
332 return ;
333 END;
334 $$
335 DELIMITER ;$$
336 SET @res='';
337 CALL f21(10, @res);
338 SELECT 'f21',@res;
339 drop procedure f21;
340
341 DELIMITER $$;
342 --echo #
343 --echo # Jump beetween handler
344 --error ER_SP_LILABEL_MISMATCH
345 CREATE or replace procedure f22(lim INT, res OUT VARCHAR)
346 AS
347 a INT;
348 BEGIN
349 res:='ok';
350 begin
351 SELECT a INTO a FROM information_schema.tables LIMIT lim;
352 EXCEPTION
353 WHEN TOO_MANY_ROWS THEN
354 goto nodata ;
355 WHEN NO_DATA_FOUND THEN
356 begin
357 <<nodata>>
358 res:='error';
359 end;
360 end;
361 return ;
362 END;
363 $$
364 DELIMITER ;$$
365
366
367 DELIMITER $$;
368 --echo #
369 --echo # Duplicate label in same bloc
370 --error 1309
371 CREATE or replace procedure f12(lim INT, res OUT VARCHAR)
372 AS
373 a INT;
374 BEGIN
375 <<lab12>>
376 res:='error';
377 <<lab12>>
378 return ;
379 END;
380 $$
381 DELIMITER ;$$
382
383 --echo #
384 --echo # Duplicate label in different block
385 --echo #
386 DELIMITER $$;
387 CREATE or replace procedure f13(lim INT, res OUT VARCHAR)
388 AS
389 a INT;
390 BEGIN
391 a:=0;
392 <<lab13>>
393 a:=a+1;
394 begin
395 <<lab13>>
396 a:=a+1;
397 if (a<10) then
398 goto lab13;
399 end if;
400 end;
401 res:=a;
402 if (a=10) then
403 goto lab13;
404 end if;
405 return ;
406 END;
407 $$
408 DELIMITER ;$$
409 SET @res='';
410 CALL f13(0, @res);
411 SELECT 'f13',@res;
412 DROP PROCEDURE f13;
413
414
415 --echo #
416 --echo # Jump outside unlabeled block
417 --echo #
418 DELIMITER $$;
419 CREATE or replace procedure f14(lim INT, res OUT VARCHAR)
420 AS
421 a INT;
422 BEGIN
423 a:=0;
424 loop
425 a:=a+1;
426 if (a<10) then
427 continue;
428 end if;
429 if (a>=lim) then
430 goto lab14;
431 end if;
432 if (a>=20) then
433 exit;
434 end if;
435 end loop;
436 <<lab14>>
437 res:=a;
438 return ;
439 END;
440 $$
441 DELIMITER ;$$
442 SET @res='';
443 CALL f14(15, @res);
444 SELECT 'f14',@res;
445 CALL f14(8, @res);
446 SELECT 'f14',@res;
447 CALL f14(25, @res);
448 SELECT 'f14',@res;
449 DROP PROCEDURE f14;
450
451 --echo #
452 --echo # Jump inside/outside labeled block
453 --echo #
454 DELIMITER $$;
455 CREATE or replace procedure f15(lim INT, res OUT VARCHAR)
456 AS
457 a INT;
458 BEGIN
459 a:=0;
460 <<looplabel>> loop
461 <<beginlooplabel>>
462 a:=a+1;
463 if (a<10) then
464 continue looplabel;
465 end if;
466 if (a>=lim) then
467 goto lab15;
468 end if;
469 if (a>=20) then
470 exit looplabel;
471 end if;
472 goto beginlooplabel;
473 end loop;
474 <<lab15>>
475 res:=a;
476 return ;
477 END;
478 $$
479 DELIMITER ;$$
480 SET @res='';
481 CALL f15(15, @res);
482 SELECT 'f15',@res;
483 CALL f15(8, @res);
484 SELECT 'f15',@res;
485 CALL f15(25, @res);
486 SELECT 'f15',@res;
487 DROP PROCEDURE f15;
488
489 --echo #
490 --echo # Jump from if / else
491 --echo #
492 DELIMITER $$;
493 CREATE or replace procedure f16(lim INT, res OUT VARCHAR)
494 AS
495 a INT;
496 BEGIN
497 if (lim<10) then
498 goto lab16_1;
499 else
500 goto lab16_2;
501 end if;
502 <<lab16_1>>
503 res:='if lab16_1';
504 goto lab16_3;
505 <<lab16_2>>
506 res:='else lab16_2';
507 goto lab16_3;
508 res:='error lab16_3';
509 <<lab16_3>>
510 return ;
511 END;
512 $$
513 DELIMITER ;$$
514 SET @res='';
515 CALL f16(15, @res);
516 SELECT 'f16',@res;
517 CALL f16(8, @res);
518 SELECT 'f16',@res;
519 DROP PROCEDURE f16;
520
521 --echo #
522 --echo # Jump with cursors
523 --echo #
524 DELIMITER $$;
525 CREATE or replace procedure f17(lim INT, res OUT VARCHAR)
526 AS
527 v_a INT;
528 v_b VARCHAR(10);
529 CURSOR cur1 IS SELECT 1 FROM dual where 1=2;
530 BEGIN
531 OPEN cur1;
532 LOOP
533 FETCH cur1 INTO v_a;
534 EXIT WHEN cur1%NOTFOUND;
535 END LOOP;
536 CLOSE cur1;
537 <<lab17>>
538 lim:=lim-1;
539 begin
540 declare
541 CURSOR cur1 IS SELECT 1 FROM dual;
542 CURSOR cur2 IS SELECT 1 FROM dual where 1=2;
543 begin
544 LOOP
545 OPEN cur1;
546 FETCH cur1 INTO v_a;
547 EXIT WHEN cur1%NOTFOUND;
548 res:=res||'-'||lim ;
549 close cur1;
550 if (lim>0) then
551 goto lab17;
552 else
553 goto lab17_end;
554 end if;
555 END LOOP;
556 end;
557 <<lab17_end>>
558 null;
559 end;
560 END;
561 $$
562 DELIMITER ;$$
563 SET @res='';
564 CALL f17(5, @res);
565 SELECT 'f17',@res;
566 DROP PROCEDURE f17;
567
568 --echo #
569 --echo # Jump outside case
570 --echo #
571 DELIMITER $$;
572 CREATE or replace procedure f18(lim INT, res OUT VARCHAR)
573 AS
574 a INT;
575 BEGIN
576 case lim
577 when 1 then
578 res:='case branch 18_1';
579 goto lab18_1;
580 res:='error';
581 when 2 then
582 res:='case branch 18_2';
583 goto lab18_2;
584 res:='error';
585 else
586 res:='default branch 18';
587 end case;
588 <<lab18_1>>
589 null;
590 <<lab18_2>>
591 return ;
592 END;
593 $$
594 DELIMITER ;$$
595 SET @res='';
596 CALL f18(0, @res);
597 SELECT 'f18',@res;
598 CALL f18(1, @res);
599 SELECT 'f18',@res;
600 CALL f18(2, @res);
601 SELECT 'f18',@res;
602 DROP PROCEDURE f18;
603
604 --echo #
605 --echo # Jump inside/outside case block
606 --echo #
607 DELIMITER $$;
608 CREATE or replace procedure f19(lim INT, res OUT VARCHAR)
609 AS
610 a INT;
611 BEGIN
612 a:=1;
613 case lim
614 when 1 then
615 <<lab19_0>>
616 a:=a+1;
617 if (a<10) then
618 goto lab19_0;
619 else
620 goto lab19_1;
621 end if;
622 res:='case branch 19_1';
623 else
624 res:='default branch 18';
625 end case;
626 goto lab19_end;
627 <<lab19_1>>
628 res:=a;
629 <<lab19_end>>
630 return ;
631 END;
632 $$
633 DELIMITER ;$$
634 SET @res='';
635 CALL f19(1, @res);
636 SELECT 'f19',@res;
637 DROP PROCEDURE f19;
638
639 DELIMITER $$;
640 --echo #
641 --echo # Jump outside labeled loop
642 --echo #
643 CREATE OR REPLACE PROCEDURE f20(res OUT VARCHAR)
644 AS
645 a INT := 1;
646 BEGIN
647 <<lab>>
648 FOR i IN a..10 LOOP
649 IF i = 5 THEN
650 a:= a+1;
651 goto lab;
652 END IF;
653 END LOOP;
654 res:=a;
655 END;
656 $$
657 DELIMITER ;$$
658 CALL f20(@res);
659 SELECT 'f20',@res;
660 DROP PROCEDURE f20;
661
662 DELIMITER $$;
663 --echo #
664 --echo # Jump (continue) labeled loop
665 --echo #
666 CREATE OR REPLACE PROCEDURE f23(res OUT VARCHAR)
667 AS
668 a INT := 1;
669 BEGIN
670 <<lab>>
671 FOR i IN a..10 LOOP
672 IF i = 5 THEN
673 a:= a+1;
674 continue lab;
675 END IF;
676 END LOOP;
677 res:=a;
678 END;
679 $$
680 DELIMITER ;$$
681 CALL f23(@res);
682 SELECT 'f23',@res;
683 DROP PROCEDURE f23;
684
685 DELIMITER $$;
686 --echo #
687 --echo # Two consecutive label (backward jump)
688 --echo #
689 CREATE OR REPLACE PROCEDURE p24(action IN INT, res OUT varchar) AS
690 a integer;
691 BEGIN
692 <<lab1>>
693 <<lab2>>
694 if (action = 1) then
695 res:=res||' '||action;
696 action:=2;
697 goto lab1;
698 end if;
699 if (action = 2) then
700 res:=res||' '||action;
701 action:=3;
702 goto lab2;
703 end if;
704 END;
705 $$
706 DELIMITER ;$$
707 call p24(1,@res);
708 select 'p24',@res;
709 DROP PROCEDURE p24;
710
711 DELIMITER $$;
712 --echo #
713 --echo # Two consecutive label (backward and forward jump)
714 --echo #
715 CREATE OR REPLACE PROCEDURE p25(action IN INT, res OUT varchar) AS
716 a integer;
717 BEGIN
718 if (action = 1) then
719 res:=res||' '||action;
720 action:=2;
721 goto lab2;
722 end if;
723 goto lab_end;
724 <<lab1>>
725 <<lab2>>
726 res:=res||' '||action;
727 if (action = 2) then
728 res:=res||' '||action;
729 action:=3;
730 goto lab1;
731 end if;
732 <<lab_end>>
733 null;
734 END;
735 $$
736 DELIMITER ;$$
737 call p25(1,@res);
738 select 'p25',@res;
739 DROP PROCEDURE p25;
740
741
742 DELIMITER $$;
743 --echo #
744 --echo # Two consecutive label, continue to wrong label
745 --error ER_SP_LILABEL_MISMATCH
746 CREATE OR REPLACE PROCEDURE p26(action IN INT, res OUT varchar) AS
747 BEGIN
748 <<lab1>>
749 <<lab2>>
750 FOR i IN 1..10 LOOP
751 continue lab1;
752 END LOOP;
753 END;
754 $$
755 DELIMITER ;$$
756
757 DELIMITER $$;
758 --echo #
759 --echo # Consecutive goto label and block label
760 --echo #
761 CREATE OR REPLACE PROCEDURE p27(action IN INT, res OUT varchar) AS
762 BEGIN
763 res:='';
764 <<lab1>>
765 <<lab2>>
766 FOR i IN 1..10 LOOP
767 if (action = 1) then
768 res:=res||' '||action||'-'||i;
769 action:=2;
770 continue lab2;
771 end if;
772 if (action = 2) then
773 res:=res||' '||action||'-'||i;
774 action:='3';
775 goto lab2;
776 end if;
777 if (action = 3) then
778 res:=res||' '||action||'-'||i;
779 action:='4';
780 goto lab1;
781 end if;
782 if (action = 4) then
783 res:=res||' '||action||'-'||i;
784 exit lab2;
785 end if;
786 END LOOP;
787 END;
788 $$
789
790 DELIMITER ;$$
791 call p27(1,@res);
792 select 'p27',@res;
793 DROP PROCEDURE p27;
794
795 --echo # ----------------------
796 --echo # -- TEST IN FUNCTION --
797 --echo # ----------------------
798
799 --echo #
800 --echo # FUNCTION : Backward jump
801 --echo #
802 DELIMITER $$;
803 CREATE or replace function func1()
804 return varchar
805 AS
806 p2 varchar(10);
807 BEGIN
808 p2:='a';
809 <<lab1>>
810 if (p2='a') then
811 p2:=p2||'b';
812 goto lab1;
813 end if;
814 if (p2='ab') then
815 p2:=p2||'c';
816 end if;
817 return p2;
818 END;
819 $$
820 DELIMITER ;$$
821 select 'func1',func1();
822 DROP function func1;
823
824 --echo #
825 --echo # FUNCTION : forward jump
826 --echo #
827 DELIMITER $$;
828 CREATE or replace function func2()
829 return varchar
830 AS
831 p2 varchar(10);
832 BEGIN
833 p2:='a';
834 if (p2='a') then
835 goto lab1;
836 end if;
837 p2:='b';
838 <<lab1>>
839 return p2;
840 END;
841 $$
842 DELIMITER ;$$
843 select 'func2',func2();
844 DROP function func2;
845
846 --echo # ---------------------
847 --echo # -- TEST IN TRIGGER --
848 --echo # ---------------------
849
850 --echo #
851 --echo # TRIGGER : forward jump
852 --echo #
853 CREATE TABLE t1 (a INT);
854 DELIMITER $$;
855 CREATE TRIGGER trg1 BEFORE INSERT ON t1 FOR EACH ROW
856 BEGIN
857 IF :NEW.a IS NULL
858 THEN
859 :NEW.a:= 15;
860 goto end_trg;
861 END IF;
862 :NEW.a:= 10;
863 <<end_trg>>
864 null;
865 END;
866 $$
867 DELIMITER ;$$
868 insert into t1 values (1);
869 insert into t1 values (null);
870 SELECT * FROM t1;
871 DROP TRIGGER trg1;
872 DROP TABLE t1;
873
874
875 --echo #
876 --echo # MDEV-20667 Server crash on pop_cursor
877 --echo #
878
879 CREATE TABLE t1 (a VARCHAR(6));
880 DELIMITER //;
881 CREATE PROCEDURE p1() IS
882 BEGIN
883 IF 1=2 THEN
884 BEGIN
885 DECLARE
886 CURSOR cur1 IS SELECT a FROM t1 ;
887 BEGIN
888 GOTO iac_err;
889 END;
890 END;
891 END IF;
892 IF 1=1 THEN
893 GOTO iac_err;
894 END IF;
895 << iac_err >>
896 RETURN;
897 END//
898 DELIMITER ;//
899 CALL p1();
900 DROP PROCEDURE p1;
901 DROP TABLE t1;
902
903
904 DELIMITER //;
905 CREATE PROCEDURE p1() IS
906 BEGIN
907 IF 1=2 THEN
908 BEGIN
909 DECLARE
910 CURSOR cur1 IS SELECT a FROM t1 ;
911 BEGIN
912 GOTO iac_err;
913 END;
914 END;
915 END IF;
916 IF 1=1 THEN
917 GOTO iac_err;
918 END IF;
919 << iac_err >>
920 RETURN ;
921 END//
922 DELIMITER ;//
923 CALL p1;
924 DROP PROCEDURE p1;
925
926
927 DELIMITER //;
928 CREATE PROCEDURE p1() IS
929 BEGIN
930 IF 1=2 THEN
931 BEGIN
932 DECLARE
933 CURSOR cur1 IS SELECT a FROM t1 ;
934 BEGIN
935 GOTO iac_err;
936 END;
937 END;
938 END IF;
939 GOTO iac_err;
940 << iac_err >>
941 RETURN ;
942 END//
943 DELIMITER ;//
944 CALL p1;
945 DROP PROCEDURE p1;
946
947
948 DELIMITER //;
949 CREATE PROCEDURE p1() IS
950 BEGIN
951 IF 1=2 THEN
952 BEGIN
953 DECLARE
954 CONTINUE HANDLER FOR SQLSTATE '23000' SET @x2 = 1;
955 BEGIN
956 GOTO iac_err;
957 END;
958 END;
959 END IF;
960 IF 1=1 THEN
961 GOTO iac_err;
962 END IF;
963 <<iac_err >>
964 RETURN;
965 END//
966 DELIMITER ;//
967 CALL p1;
968 DROP PROCEDURE p1;