Debian Codegraph @

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

raw
1 --source include/have_utf8mb4.inc
2 --source include/not_embedded.inc
3
4 SET sql_mode=ORACLE;
5
6 #
7 # Create a standalone procedure test.p1 and a package pkg1.
8 # The standalone routine test.p1 and the package routines call each other.
9 #
10
11 DELIMITER $$;
12 CREATE PROCEDURE p1 AS
13 BEGIN
14 SELECT pkg1.f1(); -- a standalone routine calls a package routine
15 END;
16 $$
17 DELIMITER ;$$
18
19
20 DELIMITER $$;
21 CREATE PACKAGE pkg1 AS
22 PROCEDURE p1;
23 FUNCTION f1 RETURN INT;
24 END;
25 $$
26 DELIMITER ;$$
27
28
29 DELIMITER $$;
30 CREATE PACKAGE BODY pkg1 AS
31 PROCEDURE p1 AS
32 BEGIN
33 CALL test.p1; -- a package routine calls a standalone routine
34 END;
35 FUNCTION f1 RETURN INT AS
36 BEGIN
37 RETURN 10;
38 END;
39 END;
40 $$
41 DELIMITER ;$$
42
43 CALL p1;
44 CALL pkg1.p1;
45 SELECT pkg1.f1();
46
47
48 #
49 # Create specifications for one more package, without a BODY
50 #
51 DELIMITER $$;
52 CREATE PACKAGE pkg2 AS
53 PROCEDURE p1;
54 FUNCTION f1 RETURN INT;
55 END;
56 $$
57 DELIMITER ;$$
58
59
60 --exec $MYSQL_DUMP --skip-comments --routines --default-character-set=utf8mb4 test
61 --exec $MYSQL_DUMP --skip-comments --routines --xml test
62
63 let $dump = $MYSQLTEST_VARDIR/tmp/sp-package-mysqldump.sql;
64
65 --exec $MYSQL_DUMP --compact --routines test > $dump
66
67 DROP PACKAGE pkg1;
68 DROP PACKAGE pkg2;
69 DROP PROCEDURE p1;
70
71 --exec $MYSQL test < $dump
72
73 --vertical_results
74 --replace_column 4 'root@localhost' 5 '0000-00-00 00:00:00' 6 '0000-00-00 00:00:00'
75 SHOW PACKAGE STATUS;
76 --replace_column 4 'root@localhost' 5 '0000-00-00 00:00:00' 6 '0000-00-00 00:00:00'
77 SHOW PACKAGE BODY STATUS;
78 --horizontal_results
79
80 SHOW CREATE PACKAGE pkg1;
81 SHOW CREATE PACKAGE pkg2;
82 SHOW CREATE PACKAGE BODY pkg1;
83
84 CALL p1;
85 CALL pkg1.p1;
86 SELECT pkg1.f1();
87
88 DROP PACKAGE pkg1;
89 DROP PACKAGE pkg2;
90 DROP PROCEDURE p1;
91
92 --echo # removing the dump file
93 --error 0,1
94 --remove_file $dump