Debian Codegraph @

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

raw
1 #
2 # MDEV-15070 Crash when doing a CREATE VIEW inside a package routine
3 #
4 SET @object_type='package_replace_pkg1';
5 #
6 # Start of sp-package-concurrent-dml.inc
7 #
8 SET sql_mode=ORACLE;
9 CREATE PACKAGE pkg1 AS
10 PROCEDURE p1;
11 END;
12 $$
13 CREATE PACKAGE BODY pkg1 AS
14 PROCEDURE p2 AS
15 BEGIN
16 SELECT 'This is p2' AS msg;
17 END;
18 PROCEDURE p1 AS
19 BEGIN
20 SELECT 'This is p1' AS msg;
21 DO GET_LOCK('mdev15070',120);
22 CALL p2();
23 DO RELEASE_LOCK('mdev15070');
24 END;
25 END;
26 $$
27 connect con2,localhost,root;
28 connection con2;
29 DO GET_LOCK('mdev15070', 120);
30 connection default;
31 CALL pkg1.p1;
32 connection con2;
33 SET sql_mode=ORACLE;
34 CREATE OR REPLACE PACKAGE pkg1 AS
35 PROCEDURE p1;
36 END;
37 $$
38 DROP PACKAGE pkg1;
39 DO RELEASE_LOCK('mdev15070');
40 disconnect con2;
41 connection default;
42 msg
43 This is p1
44 msg
45 This is p2
46 DROP PACKAGE IF EXISTS pkg1;
47 Warnings:
48 Note 1305 PACKAGE test.pkg1 does not exist
49 SET @object_type='package_body_replace_pkg1';
50 #
51 # Start of sp-package-concurrent-dml.inc
52 #
53 SET sql_mode=ORACLE;
54 CREATE PACKAGE pkg1 AS
55 PROCEDURE p1;
56 END;
57 $$
58 CREATE PACKAGE BODY pkg1 AS
59 PROCEDURE p2 AS
60 BEGIN
61 SELECT 'This is p2' AS msg;
62 END;
63 PROCEDURE p1 AS
64 BEGIN
65 SELECT 'This is p1' AS msg;
66 DO GET_LOCK('mdev15070',120);
67 CALL p2();
68 DO RELEASE_LOCK('mdev15070');
69 END;
70 END;
71 $$
72 connect con2,localhost,root;
73 connection con2;
74 DO GET_LOCK('mdev15070', 120);
75 connection default;
76 CALL pkg1.p1;
77 connection con2;
78 SET sql_mode=ORACLE;
79 CREATE OR REPLACE PACKAGE BODY pkg1 AS
80 PROCEDURE p1 AS
81 BEGIN
82 SELECT 'This is p1 version 2' AS msg;
83 END;
84 END;
85 $$
86 DROP PACKAGE pkg1;
87 DO RELEASE_LOCK('mdev15070');
88 disconnect con2;
89 connection default;
90 msg
91 This is p1
92 msg
93 This is p2
94 DROP PACKAGE IF EXISTS pkg1;
95 Warnings:
96 Note 1305 PACKAGE test.pkg1 does not exist