Debian Codegraph @

mysql-test/suite/compat/oracle/t/sp-package-concurrent-dml.inc

raw
1 --echo #
2 --echo # Start of sp-package-concurrent-dml.inc
3 --echo #
4
5 --source include/count_sessions.inc
6
7 let $object_type= `SELECT @object_type`;
8
9 SET sql_mode=ORACLE;
10 DELIMITER $$;
11 CREATE PACKAGE pkg1 AS
12 PROCEDURE p1;
13 END;
14 $$
15 CREATE PACKAGE BODY pkg1 AS
16 PROCEDURE p2 AS
17 BEGIN
18 SELECT 'This is p2' AS msg;
19 END;
20 PROCEDURE p1 AS
21 BEGIN
22 SELECT 'This is p1' AS msg;
23 DO GET_LOCK('mdev15070',120);
24 CALL p2();
25 DO RELEASE_LOCK('mdev15070');
26 END;
27 END;
28 $$
29 DELIMITER ;$$
30
31 connect (con2,localhost,root);
32 connection con2;
33 DO GET_LOCK('mdev15070', 120);
34
35 connection default;
36 send CALL pkg1.p1;
37
38 connection con2;
39 let $wait_condition=
40 SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST
41 WHERE state = "User lock" AND info LIKE "%GET_LOCK%mdev15070%";
42 --source include/wait_condition.inc
43
44
45 if ($object_type==view)
46 {
47 CREATE VIEW v1 AS SELECT 1 AS c;
48 DROP VIEW v1;
49 }
50
51
52 if ($object_type==package_replace_pkg1)
53 {
54 SET sql_mode=ORACLE;
55 DELIMITER $$;
56 CREATE OR REPLACE PACKAGE pkg1 AS
57 PROCEDURE p1;
58 END;
59 $$
60 DELIMITER ;$$
61 DROP PACKAGE pkg1;
62 }
63
64
65 if ($object_type==package_body_replace_pkg1)
66 {
67 SET sql_mode=ORACLE;
68 DELIMITER $$;
69 CREATE OR REPLACE PACKAGE BODY pkg1 AS
70 PROCEDURE p1 AS
71 BEGIN
72 SELECT 'This is p1 version 2' AS msg;
73 END;
74 END;
75 $$
76 DELIMITER ;$$
77 DROP PACKAGE pkg1;
78 }
79
80
81 if ($object_type==trigger)
82 {
83 CREATE TABLE t1 (a INT);
84 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.a=1;
85 DROP TRIGGER tr1;
86 DROP TABLE t1;
87 }
88
89
90 if ($object_type=='db')
91 {
92 CREATE DATABASE test1;
93 CREATE FUNCTION test1.f1() RETURNS INT RETURN 10;
94 DROP DATABASE test1;
95 }
96
97
98 DO RELEASE_LOCK('mdev15070');
99
100 disconnect con2;
101
102 connection default;
103 reap;
104
105 DROP PACKAGE IF EXISTS pkg1;
106
107 --source include/wait_until_count_sessions.inc