Debian Codegraph @

mysql-test/suite/compat/oracle/t/rpl_sp_package.test

raw
1 --source include/master-slave.inc
2
3 connection master;
4
5 SET sql_mode=ORACLE;
6 DELIMITER $$;
7 CREATE PACKAGE pack AS
8 FUNCTION f1 RETURN INT;
9 PROCEDURE p1;
10 END;
11 $$
12 DELIMITER ;$$
13
14 DELIMITER $$;
15 CREATE PACKAGE BODY pack AS
16 FUNCTION f1 RETURN INT AS
17 BEGIN
18 RETURN 10;
19 END;
20 PROCEDURE p1 AS
21 BEGIN
22 SELECT f1();
23 END;
24 END pack;
25 $$
26 DELIMITER ;$$
27
28 sync_slave_with_master;
29 connection slave;
30 --vertical_results
31 --replace_column 13 # 14 #
32 SELECT * FROM mysql.proc WHERE db='test' AND name='pack';
33 --replace_column 13 # 14 #
34 SELECT * FROM mysql.proc WHERE db='test' AND name LIKE 'pack.%';
35 --horizontal_results
36
37 SET @@sql_mode=ORACLE;
38 SELECT pack.f1();
39 CALL pack.p1();
40 SET @@sql_mode=DEFAULT;
41
42 connection master;
43 DROP PACKAGE pack;
44
45 sync_slave_with_master;
46 connection slave;
47 SELECT COUNT(*) FROM mysql.proc WHERE db='test' AND name='pack';
48
49 --echo #
50 --echo # Creating a package with a COMMENT
51 --echo #
52
53 connection master;
54
55 DELIMITER $$;
56 CREATE PACKAGE p1 COMMENT 'package-p1-comment' AS
57 PROCEDURE p1;
58 END;
59 $$
60 CREATE PACKAGE BODY p1 COMMENT 'package-body-p1-comment' AS
61 PROCEDURE p1 AS
62 BEGIN
63 NULL;
64 END;
65 END;
66 $$
67 DELIMITER ;$$
68
69 SELECT definer, name, security_type, type, `comment` FROM mysql.proc WHERE name LIKE 'p1%' ORDER BY definer, name, type;
70 sync_slave_with_master;
71 SELECT definer, name, security_type, type, `comment` FROM mysql.proc WHERE name LIKE 'p1%' ORDER BY definer, name, type;
72
73 connection master;
74 DROP PACKAGE p1;
75 sync_slave_with_master;
76
77
78 --echo #
79 --echo # Creating a package with a different DEFINER
80 --echo #
81
82 connection master;
83
84 DELIMITER $$;
85 CREATE DEFINER=xxx@localhost PACKAGE p1 AS
86 PROCEDURE p1;
87 END;
88 $$
89 CREATE DEFINER=xxx@localhost PACKAGE BODY p1 AS
90 PROCEDURE p1 AS
91 BEGIN
92 NULL;
93 END;
94 END;
95 $$
96 DELIMITER ;$$
97
98 SELECT definer, name, security_type, type FROM mysql.proc WHERE name LIKE 'p1%' ORDER BY definer, name, type;
99 sync_slave_with_master;
100 SELECT definer, name, security_type, type FROM mysql.proc WHERE name LIKE 'p1%' ORDER BY definer, name, type;
101
102 connection master;
103 DROP PACKAGE p1;
104 sync_slave_with_master;
105
106 --echo #
107 --echo # Creating a package with a different DEFINER + SQL SECURITY INVOKER
108 --echo #
109
110 connection master;
111
112 DELIMITER $$;
113 CREATE DEFINER=xxx@localhost PACKAGE p1 SQL SECURITY INVOKER AS
114 PROCEDURE p1;
115 END;
116 $$
117 CREATE DEFINER=xxx@localhost PACKAGE BODY p1 SQL SECURITY INVOKER AS
118 PROCEDURE p1 AS
119 BEGIN
120 NULL;
121 END;
122 END;
123 $$
124 DELIMITER ;$$
125
126 SELECT definer, name, security_type, type FROM mysql.proc WHERE name LIKE 'p1%' ORDER BY definer, name, type;
127 sync_slave_with_master;
128 SELECT definer, name, security_type, type FROM mysql.proc WHERE name LIKE 'p1%' ORDER BY definer, name, type;
129
130 connection master;
131 DROP PACKAGE p1;
132 sync_slave_with_master;
133
134 --source include/rpl_end.inc