Debian Codegraph @

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

raw
1 SET sql_mode=ORACLE;
2 DO GET_LOCK('lock',300);
3 connect conn1,localhost,root,,;
4 SET sql_mode=ORACLE;
5 CREATE PACKAGE pkg1 AS
6 PROCEDURE p1;
7 FUNCTION f1 RETURN INT;
8 END;
9 $$
10 CREATE PACKAGE BODY pkg1 AS
11 PROCEDURE p1 AS
12 BEGIN
13 DO GET_LOCK('lock',300);
14 END;
15 FUNCTION f1 RETURN INT AS
16 BEGIN
17 CALL p1;
18 RETURN 1;
19 END;
20 END;
21 $$
22 SELECT pkg1.f1();
23 connection default;
24 connect conn2,localhost,root,,;
25 SET sql_mode=ORACLE;
26 DROP PACKAGE pkg1;
27 connection default;
28 CREATE TEMPORARY TABLE mythreads(t_id INT UNSIGNED NOT NULL, t_name VARCHAR(16));
29 INSERT INTO mythreads VALUES(CONNECTION_ID(), 'default_id'),($conn1_id, 'conn1_id'),($conn2_id, 'conn2_id');
30 SELECT t_name AS CONN,INFO,STATE,LOCK_MODE,LOCK_TYPE,TABLE_NAME
31 FROM INFORMATION_SCHEMA.PROCESSLIST
32 INNER JOIN mythreads
33 ON (ID=t_id)
34 LEFT JOIN INFORMATION_SCHEMA.METADATA_LOCK_INFO
35 ON (ID=THREAD_ID)
36 ORDER BY ID,TABLE_NAME,LOCK_MODE,LOCK_TYPE;
37 CONN default_id
38 INFO SELECT t_name AS CONN,INFO,STATE,LOCK_MODE,LOCK_TYPE,TABLE_NAME
39 FROM INFORMATION_SCHEMA.PROCESSLIST
40 INNER JOIN mythreads
41 ON (ID=t_id)
42 LEFT JOIN INFORMATION_SCHEMA.METADATA_LOCK_INFO
43 ON (ID=THREAD_ID)
44 ORDER BY ID,TABLE_NAME,LOCK_MODE,LOCK_TYPE
45 STATE Filling schema table
46 LOCK_MODE MDL_SHARED_NO_WRITE
47 LOCK_TYPE User lock
48 TABLE_NAME
49 CONN conn1_id
50 INFO DO GET_LOCK('lock',300)
51 STATE User lock
52 LOCK_MODE MDL_SHARED
53 LOCK_TYPE Stored package body metadata lock
54 TABLE_NAME pkg1
55 CONN conn1_id
56 INFO DO GET_LOCK('lock',300)
57 STATE User lock
58 LOCK_MODE MDL_SHARED
59 LOCK_TYPE Stored function metadata lock
60 TABLE_NAME pkg1.f1
61 CONN conn1_id
62 INFO DO GET_LOCK('lock',300)
63 STATE User lock
64 LOCK_MODE MDL_SHARED
65 LOCK_TYPE Stored procedure metadata lock
66 TABLE_NAME pkg1.p1
67 CONN conn2_id
68 INFO DROP PACKAGE pkg1
69 STATE Waiting for stored package body metadata lock
70 LOCK_MODE MDL_BACKUP_DDL
71 LOCK_TYPE Backup lock
72 TABLE_NAME
73 CONN conn2_id
74 INFO DROP PACKAGE pkg1
75 STATE Waiting for stored package body metadata lock
76 LOCK_MODE MDL_INTENTION_EXCLUSIVE
77 LOCK_TYPE Schema metadata lock
78 TABLE_NAME
79 DROP TABLE mythreads;
80 DO RELEASE_LOCK('lock');
81 connection conn1;
82 pkg1.f1()
83 1
84 disconnect conn1;
85 connection conn2;
86 disconnect conn2;
87 connection default;