Debian Codegraph @

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

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