Debian Codegraph @

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

raw
1 -- source include/have_debug.inc
2
3 SET sql_mode=ORACLE;
4
5 --echo #
6 --echo # MDEV-20667 Server crash on pop_cursor
7 --echo #
8
9 DELIMITER //;
10 CREATE PROCEDURE p1() IS
11 BEGIN
12 IF 1=2 THEN
13 BEGIN
14 DECLARE
15 CURSOR cur1 IS SELECT a FROM t1 ;
16 BEGIN
17 GOTO iac_err;
18 END;
19 END;
20 END IF;
21 IF 1=1 THEN
22 GOTO iac_err;
23 END IF;
24 << iac_err >>
25 RETURN;
26 END//
27 DELIMITER ;//
28 SHOW PROCEDURE CODE p1;
29 DROP PROCEDURE p1;
30
31
32 DELIMITER //;
33 CREATE PROCEDURE p1() IS
34 BEGIN
35 IF 1=2 THEN
36 BEGIN
37 DECLARE
38 CURSOR cur1 IS SELECT a FROM t1 ;
39 BEGIN
40 GOTO iac_err;
41 END;
42 END;
43 END IF;
44 IF 1=1 THEN
45 GOTO iac_err;
46 END IF;
47 << iac_err >>
48 RETURN ;
49 END//
50 DELIMITER ;//
51 SHOW PROCEDURE CODE p1;
52 DROP PROCEDURE p1;
53
54
55 DELIMITER //;
56 CREATE PROCEDURE p1() IS
57 BEGIN
58 IF 1=2 THEN
59 BEGIN
60 DECLARE
61 CURSOR cur1 IS SELECT a FROM t1 ;
62 BEGIN
63 GOTO iac_err;
64 END;
65 END;
66 END IF;
67 GOTO iac_err;
68 << iac_err >>
69 RETURN ;
70 END//
71 DELIMITER ;//
72 SHOW PROCEDURE CODE p1;
73 DROP PROCEDURE p1;
74
75
76 DELIMITER //;
77 CREATE PROCEDURE p1() IS
78 BEGIN
79 IF 1=1 THEN
80 DECLARE
81 CURSOR cur2 IS SELECT 'cur2' FROM DUAL;
82 BEGIN
83 SELECT 'cur2';
84 IF 1=1 THEN
85 DECLARE
86 CURSOR cur3 IS SELECT 'cur3' FROM DUAL;
87 BEGIN
88 SELECT 'cur3';
89 IF 1=1 THEN
90 DECLARE
91 CURSOR cur4 IS SELECT 'cur4' FROM DUAL;
92 BEGIN
93 SELECT 'cur4';
94 GOTO ret;
95 END;
96 END IF;
97 GOTO ret;
98 END;
99 END IF;
100 GOTO ret;
101 END;
102 END IF;
103 <<ret>>
104 RETURN;
105 END;
106 //
107 DELIMITER ;//
108 SHOW PROCEDURE CODE p1;
109 DROP PROCEDURE p1;
110
111
112 DELIMITER //;
113 CREATE PROCEDURE p1(lab VARCHAR(32)) IS
114 BEGIN
115 IF 1=1 THEN
116 DECLARE
117 CURSOR cur2 IS SELECT 'cur2' FROM DUAL;
118 BEGIN
119 IF 1=1 THEN
120 DECLARE
121 CURSOR cur3 IS SELECT 'cur3' FROM DUAL;
122 BEGIN
123 IF 1=1 THEN
124 DECLARE
125 CURSOR cur4 IS SELECT 'cur4' FROM DUAL;
126 BEGIN
127 IF lab = 'cur4' THEN
128 SELECT 'goto from cur4' AS comment;
129 GOTO ret;
130 END IF;
131 END;
132 END IF;
133 IF lab = 'cur3' THEN
134 SELECT 'goto from cur3' AS comment;
135 GOTO ret;
136 END IF;
137 END;
138 END IF;
139 IF lab = 'cur2' THEN
140 SELECT 'goto from cur2' AS comment;
141 GOTO ret;
142 END IF;
143 END;
144 END IF;
145 <<ret>>
146 RETURN;
147 END;
148 //
149 DELIMITER ;//
150 SHOW PROCEDURE CODE p1;
151 CALL p1('');
152 CALL p1('cur2');
153 CALL p1('cur3');
154 CALL p1('cur4');
155 DROP PROCEDURE p1;
156
157
158 DELIMITER //;
159 CREATE PROCEDURE p1() IS
160 BEGIN
161 IF 1=2 THEN
162 BEGIN
163 DECLARE
164 CONTINUE HANDLER FOR SQLSTATE '23000' SET @x2 = 1;
165 BEGIN
166 GOTO iac_err;
167 END;
168 END;
169 END IF;
170 IF 1=1 THEN
171 GOTO iac_err;
172 END IF;
173 <<iac_err >>
174 RETURN;
175 END//
176 DELIMITER ;//
177 SHOW PROCEDURE CODE p1;
178 DROP PROCEDURE p1;