Debian Codegraph @

mysql-test/suite/compat/oracle/r/binlog_stm_sp_package.result

raw
1 SET sql_mode=ORACLE;
2 CREATE PACKAGE p1 AS
3 PROCEDURE p1;
4 FUNCTION f1 RETURN INT;
5 END;
6 $$
7 CREATE PACKAGE IF NOT EXISTS p1 AS
8 PROCEDURE p1;
9 FUNCTION f1 RETURN INT;
10 END;
11 $$
12 Warnings:
13 Note 1304 PACKAGE p1 already exists
14 CREATE PACKAGE BODY p1 AS
15 PROCEDURE p1 AS
16 BEGIN
17 NULL;
18 END;
19 FUNCTION f1 RETURN INT AS
20 BEGIN
21 RETURN 10;
22 END;
23 END;
24 $$
25 DROP PACKAGE BODY p1;
26 DROP PACKAGE p1;
27 DROP PACKAGE IF EXISTS p1;
28 Warnings:
29 Note 1305 PACKAGE test.p1 does not exist
30 #
31 # Creating a package with a COMMENT clause
32 #
33 CREATE PACKAGE p1 COMMENT 'package-p1-comment' AS
34 PROCEDURE p1;
35 END;
36 $$
37 CREATE PACKAGE BODY p1 COMMENT 'package-body-p1-comment' AS
38 PROCEDURE p1 AS
39 BEGIN
40 NULL;
41 END;
42 END;
43 $$
44 DROP PACKAGE p1;
45 #
46 # Creating a package with a different DEFINER
47 #
48 CREATE DEFINER=xxx@localhost PACKAGE p1 AS
49 PROCEDURE p1;
50 END;
51 $$
52 Warnings:
53 Note 1449 The user specified as a definer ('xxx'@'localhost') does not exist
54 CREATE DEFINER=xxx@localhost PACKAGE BODY p1 AS
55 PROCEDURE p1 AS
56 BEGIN
57 NULL;
58 END;
59 END;
60 $$
61 Warnings:
62 Note 1449 The user specified as a definer ('xxx'@'localhost') does not exist
63 DROP PACKAGE p1;
64 #
65 # Creating a package with a different DEFINER, with SQL SECURITY INVOKER
66 #
67 CREATE DEFINER=xxx@localhost PACKAGE p1 SQL SECURITY INVOKER AS
68 PROCEDURE p1;
69 END;
70 $$
71 Warnings:
72 Note 1449 The user specified as a definer ('xxx'@'localhost') does not exist
73 CREATE DEFINER=xxx@localhost PACKAGE BODY p1 SQL SECURITY INVOKER AS
74 PROCEDURE p1 AS
75 BEGIN
76 NULL;
77 END;
78 END;
79 $$
80 Warnings:
81 Note 1449 The user specified as a definer ('xxx'@'localhost') does not exist
82 DROP PACKAGE p1;
83 #
84 # Creating a new package in a remote database
85 #
86 CREATE DATABASE test2;
87 CREATE PACKAGE test2.test2 COMMENT 'package-test2-comment' AS
88 FUNCTION f1 RETURN INT;
89 PROCEDURE p1;
90 END
91 $$
92 CREATE PACKAGE BODY test2.test2 COMMENT 'package-body-test2-comment' AS
93 FUNCTION f1 RETURN INT AS BEGIN RETURN 10; END;
94 PROCEDURE p1 AS BEGIN SELECT f1(); END;
95 END;
96 $$
97 DROP PACKAGE BODY test2.test2;
98 DROP PACKAGE test2.test2;
99 DROP DATABASE test2;
100 #
101 # MDEV-13139 Package-wide variables in CREATE PACKAGE
102 #
103 CREATE TABLE t1 (a INT);
104 CREATE PACKAGE p1 AS
105 PROCEDURE p1;
106 END;
107 $$
108 CREATE PACKAGE BODY p1 AS
109 a INT:=0;
110 PROCEDURE p1 AS
111 BEGIN
112 INSERT INTO t1 VALUES (a);
113 a:=a+1;
114 END;
115 BEGIN
116 a:=10;
117 END;
118 $$
119 CALL p1.p1();
120 CALL p1.p1();
121 SELECT * FROM t1;
122 a
123 10
124 11
125 # sp-cache-invalidate
126 CALL p1.p1();
127 CALL p1.p1();
128 SELECT * FROM t1;
129 a
130 10
131 11
132 10
133 11
134 DROP PACKAGE p1;
135 DROP TABLE t1;
136 include/show_binlog_events.inc
137 Log_name Pos Event_type Server_id End_log_pos Info
138 master-bin.000001 # Gtid # # GTID #-#-#
139 master-bin.000001 # Query # # use `test`; CREATE DEFINER="root"@"localhost" PACKAGE "p1" AS
140 PROCEDURE p1;
141 FUNCTION f1 RETURN INT;
142 END
143 master-bin.000001 # Gtid # # GTID #-#-#
144 master-bin.000001 # Query # # use `test`; CREATE DEFINER="root"@"localhost" PACKAGE IF NOT EXISTS "p1" AS
145 PROCEDURE p1;
146 FUNCTION f1 RETURN INT;
147 END
148 master-bin.000001 # Gtid # # GTID #-#-#
149 master-bin.000001 # Query # # use `test`; CREATE DEFINER="root"@"localhost" PACKAGE BODY "p1" AS
150 PROCEDURE p1 AS
151 BEGIN
152 NULL;
153 END;
154 FUNCTION f1 RETURN INT AS
155 BEGIN
156 RETURN 10;
157 END;
158 END
159 master-bin.000001 # Gtid # # GTID #-#-#
160 master-bin.000001 # Query # # use `test`; DROP PACKAGE BODY p1
161 master-bin.000001 # Gtid # # GTID #-#-#
162 master-bin.000001 # Query # # use `test`; DROP PACKAGE p1
163 master-bin.000001 # Gtid # # GTID #-#-#
164 master-bin.000001 # Query # # use `test`; DROP PACKAGE IF EXISTS p1
165 master-bin.000001 # Gtid # # GTID #-#-#
166 master-bin.000001 # Query # # use `test`; CREATE DEFINER="root"@"localhost" PACKAGE "p1" COMMENT 'package-p1-comment'
167 AS
168 PROCEDURE p1;
169 END
170 master-bin.000001 # Gtid # # GTID #-#-#
171 master-bin.000001 # Query # # use `test`; CREATE DEFINER="root"@"localhost" PACKAGE BODY "p1" COMMENT 'package-body-p1-comment'
172 AS
173 PROCEDURE p1 AS
174 BEGIN
175 NULL;
176 END;
177 END
178 master-bin.000001 # Gtid # # GTID #-#-#
179 master-bin.000001 # Query # # use `test`; DROP PACKAGE p1
180 master-bin.000001 # Gtid # # GTID #-#-#
181 master-bin.000001 # Query # # use `test`; CREATE DEFINER="xxx"@"localhost" PACKAGE "p1" AS
182 PROCEDURE p1;
183 END
184 master-bin.000001 # Gtid # # GTID #-#-#
185 master-bin.000001 # Query # # use `test`; CREATE DEFINER="xxx"@"localhost" PACKAGE BODY "p1" AS
186 PROCEDURE p1 AS
187 BEGIN
188 NULL;
189 END;
190 END
191 master-bin.000001 # Gtid # # GTID #-#-#
192 master-bin.000001 # Query # # use `test`; DROP PACKAGE p1
193 master-bin.000001 # Gtid # # GTID #-#-#
194 master-bin.000001 # Query # # use `test`; CREATE DEFINER="xxx"@"localhost" PACKAGE "p1" SQL SECURITY INVOKER
195 AS
196 PROCEDURE p1;
197 END
198 master-bin.000001 # Gtid # # GTID #-#-#
199 master-bin.000001 # Query # # use `test`; CREATE DEFINER="xxx"@"localhost" PACKAGE BODY "p1" SQL SECURITY INVOKER
200 AS
201 PROCEDURE p1 AS
202 BEGIN
203 NULL;
204 END;
205 END
206 master-bin.000001 # Gtid # # GTID #-#-#
207 master-bin.000001 # Query # # use `test`; DROP PACKAGE p1
208 master-bin.000001 # Gtid # # GTID #-#-#
209 master-bin.000001 # Query # # CREATE DATABASE test2
210 master-bin.000001 # Gtid # # GTID #-#-#
211 master-bin.000001 # Query # # use `test`; CREATE DEFINER="root"@"localhost" PACKAGE "test2"."test2" COMMENT 'package-test2-comment'
212 AS
213 FUNCTION f1 RETURN INT;
214 PROCEDURE p1;
215 END
216 master-bin.000001 # Gtid # # GTID #-#-#
217 master-bin.000001 # Query # # use `test`; CREATE DEFINER="root"@"localhost" PACKAGE BODY "test2"."test2" COMMENT 'package-body-test2-comment'
218 AS
219 FUNCTION f1 RETURN INT AS BEGIN RETURN 10; END;
220 PROCEDURE p1 AS BEGIN SELECT f1(); END;
221 END
222 master-bin.000001 # Gtid # # GTID #-#-#
223 master-bin.000001 # Query # # use `test`; DROP PACKAGE BODY test2.test2
224 master-bin.000001 # Gtid # # GTID #-#-#
225 master-bin.000001 # Query # # use `test`; DROP PACKAGE test2.test2
226 master-bin.000001 # Gtid # # GTID #-#-#
227 master-bin.000001 # Query # # DROP DATABASE test2
228 master-bin.000001 # Gtid # # GTID #-#-#
229 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
230 master-bin.000001 # Gtid # # GTID #-#-#
231 master-bin.000001 # Query # # use `test`; CREATE DEFINER="root"@"localhost" PACKAGE "p1" AS
232 PROCEDURE p1;
233 END
234 master-bin.000001 # Gtid # # GTID #-#-#
235 master-bin.000001 # Query # # use `test`; CREATE DEFINER="root"@"localhost" PACKAGE BODY "p1" AS
236 a INT:=0;
237 PROCEDURE p1 AS
238 BEGIN
239 INSERT INTO t1 VALUES (a);
240 a:=a+1;
241 END;
242 BEGIN
243 a:=10;
244 END
245 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
246 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES ( NAME_CONST('a',10))
247 master-bin.000001 # Query # # COMMIT
248 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
249 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES ( NAME_CONST('a',11))
250 master-bin.000001 # Query # # COMMIT
251 master-bin.000001 # Gtid # # GTID #-#-#
252 master-bin.000001 # Query # # use `test`; CREATE DEFINER="root"@"localhost" FUNCTION "dummy"() RETURN int(11)
253 AS
254 BEGIN
255 RETURN 1;
256 END
257 master-bin.000001 # Gtid # # GTID #-#-#
258 master-bin.000001 # Query # # use `test`; DROP FUNCTION dummy
259 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
260 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES ( NAME_CONST('a',10))
261 master-bin.000001 # Query # # COMMIT
262 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
263 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES ( NAME_CONST('a',11))
264 master-bin.000001 # Query # # COMMIT
265 master-bin.000001 # Gtid # # GTID #-#-#
266 master-bin.000001 # Query # # use `test`; DROP PACKAGE p1
267 master-bin.000001 # Gtid # # GTID #-#-#
268 master-bin.000001 # Query # # use `test`; DROP TABLE "t1" /* generated by server */