Debian Codegraph @

mysql-test/suite/compat/oracle/r/sp-package-code.result

raw
1 SET sql_mode=ORACLE;
2 CREATE PACKAGE pkg1 AS
3 PROCEDURE p1;
4 FUNCTION f1 RETURN INT;
5 PROCEDURE p2show;
6 PROCEDURE p2public;
7 FUNCTION f2public RETURN TEXT;
8 END;
9 $$
10 CREATE PACKAGE BODY pkg1 AS
11 a INT:=10;
12 PROCEDURE p1 AS
13 b INT:=20;
14 BEGIN
15 b:=a;
16 b:=a+1;
17 a:=b;
18 a:=b+1;
19 a:=a+1;
20 SET @a:=@a+2;
21 SELECT f1() FROM DUAL;
22 END;
23 FUNCTION f1 RETURN INT AS
24 BEGIN
25 RETURN a;
26 END;
27 PROCEDURE p2private AS
28 BEGIN
29 SELECT 'This is p2private';
30 END;
31 PROCEDURE p2public AS
32 BEGIN
33 SELECT 'This is p2public';
34 END;
35 FUNCTION f2private RETURN TEXT AS
36 BEGIN
37 RETURN 'This is f2private';
38 END;
39 FUNCTION f2public RETURN TEXT AS
40 BEGIN
41 RETURN 'This is f2public';
42 END;
43 PROCEDURE p2show AS
44 BEGIN
45 SHOW FUNCTION CODE f2public;
46 SHOW FUNCTION CODE f2private;
47 SHOW PROCEDURE CODE p2public;
48 SHOW PROCEDURE CODE p2private;
49 SHOW PROCEDURE CODE p2show;
50 END;
51 BEGIN
52 a:=a+1;
53 DECLARE
54 b INT;
55 BEGIN
56 b:=a;
57 b:=a+1;
58 a:=b;
59 a:=b+1;
60 END;
61 END;
62 $$
63 SHOW PROCEDURE CODE pkg1.p1;
64 Pos Instruction
65 0 set b@0 20
66 1 set b@0 PACKAGE_BODY.a@0
67 2 set b@0 PACKAGE_BODY.a@0 + 1
68 3 set PACKAGE_BODY.a@0 b@0
69 4 set PACKAGE_BODY.a@0 b@0 + 1
70 5 set PACKAGE_BODY.a@0 PACKAGE_BODY.a@0 + 1
71 6 stmt 31 "SET @a:=@a+2"
72 7 stmt 0 "SELECT f1() FROM DUAL"
73 SHOW FUNCTION CODE pkg1.f1;
74 Pos Instruction
75 0 freturn int PACKAGE_BODY.a@0
76 SHOW PACKAGE BODY CODE pkg1;
77 Pos Instruction
78 0 set a@0 10
79 1 set a@0 a@0 + 1
80 2 set b@1 NULL
81 3 set b@1 a@0
82 4 set b@1 a@0 + 1
83 5 set a@0 b@1
84 6 set a@0 b@1 + 1
85 7 jump 11
86 CALL pkg1.p2show;
87 Pos Instruction
88 0 freturn blob 'This is f2public'
89 Pos Instruction
90 0 freturn blob 'This is f2private'
91 Pos Instruction
92 0 stmt 0 "SELECT 'This is p2public'"
93 Pos Instruction
94 0 stmt 0 "SELECT 'This is p2private'"
95 Pos Instruction
96 0 stmt 110 "SHOW FUNCTION CODE f2public"
97 1 stmt 110 "SHOW FUNCTION CODE f2private"
98 2 stmt 109 "SHOW PROCEDURE CODE p2public"
99 3 stmt 109 "SHOW PROCEDURE CODE p2private"
100 4 stmt 109 "SHOW PROCEDURE CODE p2show"
101 DROP PACKAGE pkg1;
102 CREATE TABLE t1 (a INT);
103 CREATE PACKAGE pkg1 AS
104 PROCEDURE p1;
105 END;
106 $$
107 CREATE PACKAGE BODY pkg1 AS
108 a t1.a%TYPE:=10;
109 PROCEDURE p1 AS
110 b t1.a%TYPE:=20;
111 BEGIN
112 b:=a;
113 b:=a+1;
114 b:=b+1;
115 a:=b;
116 a:=b+1;
117 a:=a+1;
118 END;
119 BEGIN
120 a:=a+1;
121 DECLARE
122 b t1.a%TYPE;
123 BEGIN
124 b:=a;
125 b:=a+1;
126 a:=b;
127 a:=b+1;
128 END;
129 END;
130 $$
131 SHOW PROCEDURE CODE pkg1.p1;
132 Pos Instruction
133 0 set b@0 20
134 1 set b@0 PACKAGE_BODY.a@0
135 2 set b@0 PACKAGE_BODY.a@0 + 1
136 3 set b@0 b@0 + 1
137 4 set PACKAGE_BODY.a@0 b@0
138 5 set PACKAGE_BODY.a@0 b@0 + 1
139 6 set PACKAGE_BODY.a@0 PACKAGE_BODY.a@0 + 1
140 SHOW PACKAGE BODY CODE pkg1;
141 Pos Instruction
142 0 set a@0 10
143 1 set a@0 a@0 + 1
144 2 set b@1 NULL
145 3 set b@1 a@0
146 4 set b@1 a@0 + 1
147 5 set a@0 b@1
148 6 set a@0 b@1 + 1
149 7 jump 11
150 DROP PACKAGE pkg1;
151 DROP TABLE t1;
152 CREATE PACKAGE pkg1 AS
153 PROCEDURE p1;
154 END;
155 $$
156 CREATE PACKAGE BODY pkg1 AS
157 a ROW(a INT,b TEXT):=ROW(10,'x10');
158 PROCEDURE p1 AS
159 b ROW(a INT,b TEXT):=ROW(20,'x20');
160 BEGIN
161 b:=a;
162 a:=b;
163 b.a:=a.a+1;
164 a.a:=b.a+1;
165 a.a:=a.a+1;
166 END;
167 BEGIN
168 a.a:=a.a+1;
169 DECLARE
170 b ROW(a INT,b TEXT):=ROW(30,'x30');
171 BEGIN
172 b:=a;
173 b.a:=a.a+1;
174 a:=b;
175 a.a:=b.a+1;
176 END;
177 END;
178 $$
179 SHOW PROCEDURE CODE pkg1.p1;
180 Pos Instruction
181 0 set b@0 (20,'x20')
182 1 set b@0 PACKAGE_BODY.a@0
183 2 set PACKAGE_BODY.a@0 b@0
184 3 set b.a@0[0] PACKAGE_BODY.a.a@0[0] + 1
185 4 set PACKAGE_BODY.a.a@0[0] b.a@0[0] + 1
186 5 set PACKAGE_BODY.a.a@0[0] PACKAGE_BODY.a.a@0[0] + 1
187 SHOW PACKAGE BODY CODE pkg1;
188 Pos Instruction
189 0 set a@0 (10,'x10')
190 1 set a.a@0[0] a.a@0[0] + 1
191 2 set b@1 (30,'x30')
192 3 set b@1 a@0
193 4 set b.a@1[0] a.a@0[0] + 1
194 5 set a@0 b@1
195 6 set a.a@0[0] b.a@1[0] + 1
196 7 jump 11
197 DROP PACKAGE pkg1;
198 CREATE TABLE t1 (a INT, b TEXT);
199 CREATE PACKAGE pkg1 AS
200 PROCEDURE p1;
201 END;
202 $$
203 CREATE PACKAGE BODY pkg1 AS
204 a t1%ROWTYPE:=ROW(10,'x10');
205 PROCEDURE p1 AS
206 b t1%ROWTYPE:=ROW(20,'x20');
207 BEGIN
208 b:=a;
209 a:=b;
210 b.a:=a.a+1;
211 a.a:=b.a+1;
212 a.a:=a.a+1;
213 END;
214 BEGIN
215 a.a:=a.a+1;
216 DECLARE
217 b t1%ROWTYPE:=ROW(30,'x30');
218 BEGIN
219 b:=a;
220 b.a:=a.a+1;
221 a:=b;
222 a.a:=b.a+1;
223 END;
224 END;
225 $$
226 SHOW PROCEDURE CODE pkg1.p1;
227 Pos Instruction
228 0 set b@0 (20,'x20')
229 1 set b@0 PACKAGE_BODY.a@0
230 2 set PACKAGE_BODY.a@0 b@0
231 3 set b.a@0["a"] PACKAGE_BODY.a.a@0["a"] + 1
232 4 set PACKAGE_BODY.a.a@0["a"] b.a@0["a"] + 1
233 5 set PACKAGE_BODY.a.a@0["a"] PACKAGE_BODY.a.a@0["a"] + 1
234 SHOW PACKAGE BODY CODE pkg1;
235 Pos Instruction
236 0 set a@0 (10,'x10')
237 1 set a.a@0["a"] a.a@0["a"] + 1
238 2 set b@1 (30,'x30')
239 3 set b@1 a@0
240 4 set b.a@1["a"] a.a@0["a"] + 1
241 5 set a@0 b@1
242 6 set a.a@0["a"] b.a@1["a"] + 1
243 7 jump 11
244 DROP PACKAGE pkg1;
245 DROP TABLE t1;
246 #
247 # MDEV-38451 `SHOW FUNCTION CODE package_func` crashes on the second execution
248 #
249 CREATE PACKAGE pkg1 AS
250 PROCEDURE p1();
251 END;
252 $$
253 CREATE PACKAGE BODY pkg1 AS
254 FUNCTION f1() RETURN INT AS
255 BEGIN
256 RETURN 10;
257 END;
258 PROCEDURE p1() AS
259 BEGIN
260 SHOW FUNCTION CODE f1;
261 END;
262 END;
263 $$
264 CALL pkg1.p1;
265 Pos Instruction
266 0 freturn int 10
267 CALL pkg1.p1;
268 Pos Instruction
269 0 freturn int 10
270 CALL pkg1.p1;
271 Pos Instruction
272 0 freturn int 10
273 DROP PACKAGE pkg1;
274 # End of 10.11 tests
275 #
276 # MDEV-36047 Package body variables are not allowed as FETCH targets
277 #
278 CREATE PACKAGE pkg AS
279 FUNCTION f1 RETURN INT;
280 END;
281 $$
282 CREATE PACKAGE BODY pkg AS
283 vc INT := 0;
284 FUNCTION f1 RETURN INT AS
285 CURSOR cur IS SELECT 1 AS c FROM DUAL;
286 BEGIN
287 OPEN cur;
288 FETCH cur INTO vc; -- SHOW CODE should display vc with a "PACKAGE_BODY" prefix
289 CLOSE cur;
290 RETURN vc;
291 END;
292 BEGIN
293 DECLARE
294 CURSOR cur IS SELECT 1 AS c FROM DUAL;
295 BEGIN
296 OPEN cur;
297 FETCH cur INTO vc; -- SHOW CODE should display vc without a prefix
298 CLOSE cur;
299 END;
300 END;
301 $$
302 SELECT pkg.f1() FROM DUAL;
303 pkg.f1()
304 1
305 SHOW FUNCTION CODE pkg.f1;
306 Pos Instruction
307 0 cpush cur@0
308 1 copen cur@0
309 2 cfetch cur@0 PACKAGE_BODY.vc@0
310 3 cclose cur@0
311 4 freturn int PACKAGE_BODY.vc@0
312 SHOW PACKAGE BODY CODE pkg;
313 Pos Instruction
314 0 set vc@0 0
315 1 cpush cur@0
316 2 copen cur@0
317 3 cfetch cur@0 vc@0
318 4 cclose cur@0
319 5 cpop 1
320 DROP PACKAGE pkg;
321 CREATE PACKAGE pkg AS
322 FUNCTION f1 RETURN TEXT;
323 END;
324 $$
325 CREATE PACKAGE BODY pkg AS
326 vc1 INT := 0;
327 FUNCTION f1 RETURN TEXT AS
328 CURSOR cur IS SELECT 1 AS c1, 2 AS c2 FROM DUAL;
329 vc2 INT := 0;
330 BEGIN
331 OPEN cur;
332 FETCH cur INTO vc1, vc2;
333 CLOSE cur;
334 RETURN vc1 || ' ' || vc2;
335 END;
336 END;
337 $$
338 SELECT pkg.f1() FROM DUAL;
339 pkg.f1()
340 1 2
341 SHOW FUNCTION CODE pkg.f1;
342 Pos Instruction
343 0 set vc2@0 0
344 1 cpush cur@0
345 2 copen cur@0
346 3 cfetch cur@0 PACKAGE_BODY.vc1@0 vc2@0
347 4 cclose cur@0
348 5 freturn blob concat(concat(PACKAGE_BODY.vc1@0,' '),vc2@0)
349 DROP PACKAGE pkg;
350 CREATE PACKAGE pkg AS
351 FUNCTION f1 RETURN TEXT;
352 END;
353 $$
354 CREATE PACKAGE BODY pkg AS
355 vc ROW(p1 INT, p2 INT);
356 FUNCTION f1 RETURN TEXT AS
357 CURSOR cur IS SELECT 1 AS c1, 2 AS c2 FROM DUAL;
358 BEGIN
359 OPEN cur;
360 FETCH cur INTO vc;
361 CLOSE cur;
362 RETURN vc.p1 || ' ' || vc.p2;
363 END;
364 END;
365 $$
366 SELECT pkg.f1() FROM DUAL;
367 pkg.f1()
368 1 2
369 SHOW FUNCTION CODE pkg.f1;
370 Pos Instruction
371 0 cpush cur@0
372 1 copen cur@0
373 2 cfetch cur@0 PACKAGE_BODY.vc@0
374 3 cclose cur@0
375 4 freturn blob concat(concat(PACKAGE_BODY.vc.p1@0[0],' '),PACKAGE_BODY.vc.p2@0[1])
376 DROP PACKAGE pkg;
377 # End of 11.4 tests