Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 SET sql_mode=ORACLE;
5 #
6 # MDEV-13139 Package-wide variables in CREATE PACKAGE
7 #
8 connection master;
9 CREATE PACKAGE p1 AS
10 PROCEDURE p1;
11 END;
12 $$
13 CREATE PACKAGE BODY p1 AS
14 va INT:=10;
15 PROCEDURE p1 AS
16 BEGIN
17 INSERT INTO t1 VALUES (va);
18 END;
19 BEGIN
20 CREATE OR REPLACE TABLE t1 (a INT);
21 END;
22 $$
23 CALL p1.p1();
24 CALL p1.p1();
25 SELECT * FROM t1;
26 a
27 10
28 10
29 connection slave;
30 SELECT * FROM t1;
31 a
32 10
33 10
34 connection master;
35 DROP PACKAGE p1;
36 DROP TABLE t1;
37 connection slave;
38 include/rpl_end.inc