Debian Codegraph @

mysql-test/suite/compat/oracle/t/sp-package-i_s.test

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