Debian Codegraph @

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

raw
1 SET sql_mode=ORACLE;
2 CREATE PROCEDURE p1 AS
3 BEGIN
4 SELECT pkg1.f1(); -- a standalone routine calls a package routine
5 END;
6 $$
7 CREATE PACKAGE pkg1 AS
8 PROCEDURE p1;
9 FUNCTION f1 RETURN INT;
10 END;
11 $$
12 CREATE PACKAGE BODY pkg1 AS
13 PROCEDURE p1 AS
14 BEGIN
15 CALL test.p1; -- a package routine calls a standalone routine
16 END;
17 FUNCTION f1 RETURN INT AS
18 BEGIN
19 RETURN 10;
20 END;
21 END;
22 $$
23 CALL p1;
24 pkg1.f1()
25 10
26 CALL pkg1.p1;
27 pkg1.f1()
28 10
29 SELECT pkg1.f1();
30 pkg1.f1()
31 10
32 CREATE PACKAGE pkg2 AS
33 PROCEDURE p1;
34 FUNCTION f1 RETURN INT;
35 END;
36 $$
37 /*M!999999\- enable the sandbox mode */
38
39 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
40 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
41 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
42 /*!40101 SET NAMES utf8mb4 */;
43 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
44 /*!40103 SET TIME_ZONE='+00:00' */;
45 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
46 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
47 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
48 /*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */;
49 /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
50 /*!50003 SET sql_mode = 'PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT' */ ;
51 /*!50003 DROP PROCEDURE IF EXISTS `p1` */;
52 /*!50003 SET @saved_cs_client = @@character_set_client */ ;
53 /*!50003 SET @saved_cs_results = @@character_set_results */ ;
54 /*!50003 SET @saved_col_connection = @@collation_connection */ ;
55 /*!50003 SET character_set_client = latin1 */ ;
56 /*!50003 SET character_set_results = latin1 */ ;
57 /*!50003 SET collation_connection = latin1_swedish_ci */ ;
58 DELIMITER ;;
59 CREATE DEFINER="root"@"localhost" PROCEDURE "p1"()
60 AS
61 BEGIN
62 SELECT pkg1.f1(); -- a standalone routine calls a package routine
63 END
64 ;;
65 DELIMITER ;
66 /*!50003 SET sql_mode = @saved_sql_mode */ ;
67 /*!50003 SET character_set_client = @saved_cs_client */ ;
68 /*!50003 SET character_set_results = @saved_cs_results */ ;
69 /*!50003 SET collation_connection = @saved_col_connection */ ;
70 /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
71 /*!50003 SET sql_mode = 'PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT' */ ;
72 /*!50003 DROP PACKAGE IF EXISTS `pkg1` */;
73 /*!50003 SET @saved_cs_client = @@character_set_client */ ;
74 /*!50003 SET @saved_cs_results = @@character_set_results */ ;
75 /*!50003 SET @saved_col_connection = @@collation_connection */ ;
76 /*!50003 SET character_set_client = latin1 */ ;
77 /*!50003 SET character_set_results = latin1 */ ;
78 /*!50003 SET collation_connection = latin1_swedish_ci */ ;
79 DELIMITER ;;
80 CREATE DEFINER="root"@"localhost" PACKAGE "pkg1" AS
81 PROCEDURE p1;
82 FUNCTION f1 RETURN INT;
83 END
84 ;;
85 DELIMITER ;
86 /*!50003 SET sql_mode = @saved_sql_mode */ ;
87 /*!50003 SET character_set_client = @saved_cs_client */ ;
88 /*!50003 SET character_set_results = @saved_cs_results */ ;
89 /*!50003 SET collation_connection = @saved_col_connection */ ;
90 /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
91 /*!50003 SET sql_mode = 'PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT' */ ;
92 /*!50003 DROP PACKAGE IF EXISTS `pkg2` */;
93 /*!50003 SET @saved_cs_client = @@character_set_client */ ;
94 /*!50003 SET @saved_cs_results = @@character_set_results */ ;
95 /*!50003 SET @saved_col_connection = @@collation_connection */ ;
96 /*!50003 SET character_set_client = latin1 */ ;
97 /*!50003 SET character_set_results = latin1 */ ;
98 /*!50003 SET collation_connection = latin1_swedish_ci */ ;
99 DELIMITER ;;
100 CREATE DEFINER="root"@"localhost" PACKAGE "pkg2" AS
101 PROCEDURE p1;
102 FUNCTION f1 RETURN INT;
103 END
104 ;;
105 DELIMITER ;
106 /*!50003 SET sql_mode = @saved_sql_mode */ ;
107 /*!50003 SET character_set_client = @saved_cs_client */ ;
108 /*!50003 SET character_set_results = @saved_cs_results */ ;
109 /*!50003 SET collation_connection = @saved_col_connection */ ;
110 /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
111 /*!50003 SET sql_mode = 'PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT' */ ;
112 /*!50003 DROP PACKAGE BODY IF EXISTS `pkg1` */;
113 /*!50003 SET @saved_cs_client = @@character_set_client */ ;
114 /*!50003 SET @saved_cs_results = @@character_set_results */ ;
115 /*!50003 SET @saved_col_connection = @@collation_connection */ ;
116 /*!50003 SET character_set_client = latin1 */ ;
117 /*!50003 SET character_set_results = latin1 */ ;
118 /*!50003 SET collation_connection = latin1_swedish_ci */ ;
119 DELIMITER ;;
120 CREATE DEFINER="root"@"localhost" PACKAGE BODY "pkg1" AS
121 PROCEDURE p1 AS
122 BEGIN
123 CALL test.p1; -- a package routine calls a standalone routine
124 END;
125 FUNCTION f1 RETURN INT AS
126 BEGIN
127 RETURN 10;
128 END;
129 END
130 ;;
131 DELIMITER ;
132 /*!50003 SET sql_mode = @saved_sql_mode */ ;
133 /*!50003 SET character_set_client = @saved_cs_client */ ;
134 /*!50003 SET character_set_results = @saved_cs_results */ ;
135 /*!50003 SET collation_connection = @saved_col_connection */ ;
136 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
137
138 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
139 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
140 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
141 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
142 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
143 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
144 /*M!100616 SET NOTE_VERBOSITY=@OLD_NOTE_VERBOSITY */;
145
146 <?xml version="1.0"?>
147 <mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
148 <database name="test">
149 <routines>
150 <routine Procedure="p1" sql_mode="PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT" character_set_client="latin1" collation_connection="latin1_swedish_ci" Database_Collation="utf8mb4_uca1400_ai_ci">
151 <![CDATA[
152 CREATE DEFINER="root"@"localhost" PROCEDURE "p1"()
153 AS
154 BEGIN
155 SELECT pkg1.f1(); -- a standalone routine calls a package routine
156 END
157 ]]>
158 </routine>
159 <routine Package="pkg1" sql_mode="PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT" character_set_client="latin1" collation_connection="latin1_swedish_ci" Database_Collation="utf8mb4_uca1400_ai_ci">
160 <![CDATA[
161 CREATE DEFINER="root"@"localhost" PACKAGE "pkg1" AS
162 PROCEDURE p1;
163 FUNCTION f1 RETURN INT;
164 END
165 ]]>
166 </routine>
167 <routine Package="pkg2" sql_mode="PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT" character_set_client="latin1" collation_connection="latin1_swedish_ci" Database_Collation="utf8mb4_uca1400_ai_ci">
168 <![CDATA[
169 CREATE DEFINER="root"@"localhost" PACKAGE "pkg2" AS
170 PROCEDURE p1;
171 FUNCTION f1 RETURN INT;
172 END
173 ]]>
174 </routine>
175 <routine Package_body="pkg1" sql_mode="PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT" character_set_client="latin1" collation_connection="latin1_swedish_ci" Database_Collation="utf8mb4_uca1400_ai_ci">
176 <![CDATA[
177 CREATE DEFINER="root"@"localhost" PACKAGE BODY "pkg1" AS
178 PROCEDURE p1 AS
179 BEGIN
180 CALL test.p1; -- a package routine calls a standalone routine
181 END;
182 FUNCTION f1 RETURN INT AS
183 BEGIN
184 RETURN 10;
185 END;
186 END
187 ]]>
188 </routine>
189 </routines>
190 </database>
191 </mysqldump>
192 DROP PACKAGE pkg1;
193 DROP PACKAGE pkg2;
194 DROP PROCEDURE p1;
195 SHOW PACKAGE STATUS;
196 Db test
197 Name pkg1
198 Type PACKAGE
199 Definer root@localhost
200 Modified 0000-00-00 00:00:00
201 Created 0000-00-00 00:00:00
202 Security_type DEFINER
203 Comment
204 character_set_client latin1
205 collation_connection latin1_swedish_ci
206 Database Collation utf8mb4_uca1400_ai_ci
207 Db test
208 Name pkg2
209 Type PACKAGE
210 Definer root@localhost
211 Modified 0000-00-00 00:00:00
212 Created 0000-00-00 00:00:00
213 Security_type DEFINER
214 Comment
215 character_set_client latin1
216 collation_connection latin1_swedish_ci
217 Database Collation utf8mb4_uca1400_ai_ci
218 SHOW PACKAGE BODY STATUS;
219 Db test
220 Name pkg1
221 Type PACKAGE BODY
222 Definer root@localhost
223 Modified 0000-00-00 00:00:00
224 Created 0000-00-00 00:00:00
225 Security_type DEFINER
226 Comment
227 character_set_client latin1
228 collation_connection latin1_swedish_ci
229 Database Collation utf8mb4_uca1400_ai_ci
230 SHOW CREATE PACKAGE pkg1;
231 Package sql_mode Create Package character_set_client collation_connection Database Collation
232 pkg1 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT CREATE DEFINER="root"@"localhost" PACKAGE "pkg1" AS
233 PROCEDURE p1;
234 FUNCTION f1 RETURN INT;
235 END latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
236 SHOW CREATE PACKAGE pkg2;
237 Package sql_mode Create Package character_set_client collation_connection Database Collation
238 pkg2 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT CREATE DEFINER="root"@"localhost" PACKAGE "pkg2" AS
239 PROCEDURE p1;
240 FUNCTION f1 RETURN INT;
241 END latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
242 SHOW CREATE PACKAGE BODY pkg1;
243 Package body sql_mode Create Package Body character_set_client collation_connection Database Collation
244 pkg1 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT CREATE DEFINER="root"@"localhost" PACKAGE BODY "pkg1" AS
245 PROCEDURE p1 AS
246 BEGIN
247 CALL test.p1;
248 END;
249 FUNCTION f1 RETURN INT AS
250 BEGIN
251 RETURN 10;
252 END;
253 END latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
254 CALL p1;
255 pkg1.f1()
256 10
257 CALL pkg1.p1;
258 pkg1.f1()
259 10
260 SELECT pkg1.f1();
261 pkg1.f1()
262 10
263 DROP PACKAGE pkg1;
264 DROP PACKAGE pkg2;
265 DROP PROCEDURE p1;
266 # removing the dump file