Debian Codegraph @

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

raw
1 #
2 # MDEV-15070 Crash when doing a CREATE VIEW inside a package routine
3 #
4 SET @object_type='db';
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 DATABASE test1;
34 CREATE FUNCTION test1.f1() RETURNS INT RETURN 10;
35 DROP DATABASE test1;
36 DO RELEASE_LOCK('mdev15070');
37 disconnect con2;
38 connection default;
39 msg
40 This is p1
41 msg
42 This is p2
43 DROP PACKAGE IF EXISTS pkg1;