Debian Codegraph @

mysql-test/suite/compat/oracle/r/sp-goto-debug.result

raw
1 SET sql_mode=ORACLE;
2 #
3 # MDEV-20667 Server crash on pop_cursor
4 #
5 CREATE PROCEDURE p1() IS
6 BEGIN
7 IF 1=2 THEN
8 BEGIN
9 DECLARE
10 CURSOR cur1 IS SELECT a FROM t1 ;
11 BEGIN
12 GOTO iac_err;
13 END;
14 END;
15 END IF;
16 IF 1=1 THEN
17 GOTO iac_err;
18 END IF;
19 << iac_err >>
20 RETURN;
21 END//
22 SHOW PROCEDURE CODE p1;
23 Pos Instruction
24 0 jump_if_not 5(5) 1 = 2
25 1 cpush cur1@0
26 2 jump 3
27 3 cpop 1
28 4 jump 7
29 5 jump_if_not 7(7) 1 = 1
30 6 jump 7
31 7 preturn
32 DROP PROCEDURE p1;
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 SHOW PROCEDURE CODE p1;
51 Pos Instruction
52 0 jump_if_not 5(5) 1 = 2
53 1 cpush cur1@0
54 2 jump 3
55 3 cpop 1
56 4 jump 7
57 5 jump_if_not 7(7) 1 = 1
58 6 jump 7
59 7 preturn
60 DROP PROCEDURE p1;
61 CREATE PROCEDURE p1() IS
62 BEGIN
63 IF 1=2 THEN
64 BEGIN
65 DECLARE
66 CURSOR cur1 IS SELECT a FROM t1 ;
67 BEGIN
68 GOTO iac_err;
69 END;
70 END;
71 END IF;
72 GOTO iac_err;
73 << iac_err >>
74 RETURN ;
75 END//
76 SHOW PROCEDURE CODE p1;
77 Pos Instruction
78 0 jump_if_not 5(5) 1 = 2
79 1 cpush cur1@0
80 2 jump 3
81 3 cpop 1
82 4 jump 5
83 5 preturn
84 DROP PROCEDURE p1;
85 CREATE PROCEDURE p1() IS
86 BEGIN
87 IF 1=1 THEN
88 DECLARE
89 CURSOR cur2 IS SELECT 'cur2' FROM DUAL;
90 BEGIN
91 SELECT 'cur2';
92 IF 1=1 THEN
93 DECLARE
94 CURSOR cur3 IS SELECT 'cur3' FROM DUAL;
95 BEGIN
96 SELECT 'cur3';
97 IF 1=1 THEN
98 DECLARE
99 CURSOR cur4 IS SELECT 'cur4' FROM DUAL;
100 BEGIN
101 SELECT 'cur4';
102 GOTO ret;
103 END;
104 END IF;
105 GOTO ret;
106 END;
107 END IF;
108 GOTO ret;
109 END;
110 END IF;
111 <<ret>>
112 RETURN;
113 END;
114 //
115 SHOW PROCEDURE CODE p1;
116 Pos Instruction
117 0 jump_if_not 15(15) 1 = 1
118 1 cpush cur2@0
119 2 stmt 0 "SELECT 'cur2'"
120 3 jump_if_not 13(13) 1 = 1
121 4 cpush cur3@1
122 5 stmt 0 "SELECT 'cur3'"
123 6 jump_if_not 11(11) 1 = 1
124 7 cpush cur4@2
125 8 stmt 0 "SELECT 'cur4'"
126 9 cpop 3
127 10 jump 15
128 11 cpop 2
129 12 jump 15
130 13 cpop 1
131 14 jump 15
132 15 preturn
133 DROP PROCEDURE p1;
134 CREATE PROCEDURE p1(lab VARCHAR(32)) IS
135 BEGIN
136 IF 1=1 THEN
137 DECLARE
138 CURSOR cur2 IS SELECT 'cur2' FROM DUAL;
139 BEGIN
140 IF 1=1 THEN
141 DECLARE
142 CURSOR cur3 IS SELECT 'cur3' FROM DUAL;
143 BEGIN
144 IF 1=1 THEN
145 DECLARE
146 CURSOR cur4 IS SELECT 'cur4' FROM DUAL;
147 BEGIN
148 IF lab = 'cur4' THEN
149 SELECT 'goto from cur4' AS comment;
150 GOTO ret;
151 END IF;
152 END;
153 END IF;
154 IF lab = 'cur3' THEN
155 SELECT 'goto from cur3' AS comment;
156 GOTO ret;
157 END IF;
158 END;
159 END IF;
160 IF lab = 'cur2' THEN
161 SELECT 'goto from cur2' AS comment;
162 GOTO ret;
163 END IF;
164 END;
165 END IF;
166 <<ret>>
167 RETURN;
168 END;
169 //
170 SHOW PROCEDURE CODE p1;
171 Pos Instruction
172 0 jump_if_not 21(21) 1 = 1
173 1 cpush cur2@0
174 2 jump_if_not 16(16) 1 = 1
175 3 cpush cur3@1
176 4 jump_if_not 11(11) 1 = 1
177 5 cpush cur4@2
178 6 jump_if_not 10(10) lab@0 = 'cur4'
179 7 stmt 0 "SELECT 'goto from cur4' AS comment"
180 8 cpop 3
181 9 jump 21
182 10 cpop 1
183 11 jump_if_not 15(15) lab@0 = 'cur3'
184 12 stmt 0 "SELECT 'goto from cur3' AS comment"
185 13 cpop 2
186 14 jump 21
187 15 cpop 1
188 16 jump_if_not 20(20) lab@0 = 'cur2'
189 17 stmt 0 "SELECT 'goto from cur2' AS comment"
190 18 cpop 1
191 19 jump 21
192 20 cpop 1
193 21 preturn
194 CALL p1('');
195 CALL p1('cur2');
196 comment
197 goto from cur2
198 CALL p1('cur3');
199 comment
200 goto from cur3
201 CALL p1('cur4');
202 comment
203 goto from cur4
204 DROP PROCEDURE p1;
205 CREATE PROCEDURE p1() IS
206 BEGIN
207 IF 1=2 THEN
208 BEGIN
209 DECLARE
210 CONTINUE HANDLER FOR SQLSTATE '23000' SET @x2 = 1;
211 BEGIN
212 GOTO iac_err;
213 END;
214 END;
215 END IF;
216 IF 1=1 THEN
217 GOTO iac_err;
218 END IF;
219 <<iac_err >>
220 RETURN;
221 END//
222 SHOW PROCEDURE CODE p1;
223 Pos Instruction
224 0 jump_if_not 9(9) 1 = 2
225 1 hpush_jump 4 0 CONTINUE
226 2 stmt 31 "SET @x2 = 1"
227 3 hreturn 0
228 4 hpop 1
229 5 jump 11
230 6 jump 11
231 7 hpop 1
232 8 jump 9
233 9 jump_if_not 11(11) 1 = 1
234 10 jump 11
235 11 preturn
236 DROP PROCEDURE p1;