Debian Codegraph @

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

raw
1 #
2 # MDEV-15070 Crash when doing a CREATE VIEW inside a package routine
3 #
4 SET @object_type='view';
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 CREATE VIEW v1 AS SELECT 1 AS c;
34 DROP VIEW v1;
35 DO RELEASE_LOCK('mdev15070');
36 disconnect con2;
37 connection default;
38 msg
39 This is p1
40 msg
41 This is p2
42 DROP PACKAGE IF EXISTS pkg1;