Debian Codegraph @

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

raw
1 #
2 # Start of 10.5 tests
3 #
4 #
5 # MDEV-30662 SQL/PL package body does not appear in I_S.ROUTINES.ROUTINE_DEFINITION
6 #
7 SET sql_mode=ORACLE;
8 CREATE OR REPLACE PACKAGE pkg1 AS
9 FUNCTION f1() RETURN INT;
10 END;
11 $$
12 CREATE PACKAGE BODY pkg1 AS
13 FUNCTION f1() RETURN INT AS
14 BEGIN
15 RETURN 1;
16 END;
17 END;
18 $$
19 SELECT routine_name, routine_type, routine_definition
20 FROM information_schema.routines
21 WHERE routine_type LIKE 'PACKAGE%'
22 ORDER BY routine_type;
23 routine_name pkg1
24 routine_type PACKAGE
25 routine_definition AS
26 FUNCTION f1() RETURN INT;
27 END
28 routine_name pkg1
29 routine_type PACKAGE BODY
30 routine_definition AS
31 FUNCTION f1() RETURN INT AS
32 BEGIN
33 RETURN 1;
34 END;
35 END
36 DROP PACKAGE pkg1;
37 SET sql_mode=ORACLE;
38 CREATE OR REPLACE PACKAGE pkg1 AS
39 FUNCTION f1() RETURN INT;
40 END;
41 $$
42 CREATE PACKAGE BODY pkg1 AS
43 FUNCTION f1() RETURN INT AS
44 BEGIN
45 RETURN 1;
46 END;
47 BEGIN
48 SET @a=10;
49 SET @a=f1();
50 END;
51 $$
52 SELECT routine_name, routine_type, routine_definition
53 FROM information_schema.routines
54 WHERE routine_type LIKE 'PACKAGE%'
55 ORDER BY routine_type;
56 routine_name pkg1
57 routine_type PACKAGE
58 routine_definition AS
59 FUNCTION f1() RETURN INT;
60 END
61 routine_name pkg1
62 routine_type PACKAGE BODY
63 routine_definition AS
64 FUNCTION f1() RETURN INT AS
65 BEGIN
66 RETURN 1;
67 END;
68 BEGIN
69 SET @a=10;
70 SET @a=f1();
71 END
72 DROP PACKAGE pkg1;
73 #
74 # End of 10.5 tests
75 #