Debian Codegraph @

mysql-test/suite/perfschema/r/statement_program_concurrency.result

raw
1 TRUNCATE TABLE performance_schema.events_statements_summary_by_program;
2 TRUNCATE TABLE performance_schema.events_statements_history;
3 # concurrency check through multi connections
4 CREATE DATABASE db1;
5 CREATE DATABASE db2;
6 CREATE DATABASE db3;
7 USE db1;
8 CREATE TABLE t1(
9 i INT NOT NULL
10 );
11 LOAD DATA INFILE '../../std_data/wl5766_data.txt' INTO TABLE t1;
12 CREATE PROCEDURE proc()
13 BEGIN
14 INSERT INTO t1 SELECT * FROM t1;
15 END|
16 CALL proc();;
17 USE db2;
18 CREATE TABLE t2(
19 i INT NOT NULL
20 );
21 LOAD DATA INFILE '../../std_data/wl5766_data.txt' INTO TABLE t2;
22 CREATE FUNCTION addition(x INT, y INT) RETURNS INT
23 BEGIN
24 INSERT INTO t2 SELECT * FROM t2;
25 RETURN x+y;
26 END|
27 SELECT addition(1234,9876);;
28 USE db3;
29 CREATE TABLE t(
30 i INT NOT NULL,
31 j INT
32 );
33 CREATE TABLE t3(
34 i INT NOT NULL
35 );
36 LOAD DATA INFILE '../../std_data/wl5766_data.txt' INTO TABLE t3;
37 INSERT INTO t VALUES ( 10,1000 );
38 CREATE TRIGGER trg AFTER INSERT ON t FOR EACH ROW
39 INSERT INTO t3 SELECT * FROM t3;
40 INSERT INTO t VALUES ( 20,2000);;
41 addition(1234,9876)
42 11110
43 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, COUNT_STAR, COUNT_STATEMENTS
44 FROM performance_schema.events_statements_summary_by_program
45 WHERE OBJECT_SCHEMA='db1' OR OBJECT_SCHEMA='db2' OR OBJECT_SCHEMA='db3'
46 ORDER BY OBJECT_SCHEMA, OBJECT_NAME;
47 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME COUNT_STAR COUNT_STATEMENTS
48 PROCEDURE db1 proc 1 1
49 FUNCTION db2 addition 1 2
50 TRIGGER db3 trg 1 1
51 SELECT EVENT_NAME, SQL_TEXT, CURRENT_SCHEMA, OBJECT_TYPE, OBJECT_SCHEMA,
52 OBJECT_NAME, NESTING_EVENT_TYPE, NESTING_EVENT_LEVEL FROM
53 performance_schema.events_statements_history WHERE CURRENT_SCHEMA='db1'
54 OR CURRENT_SCHEMA='db2' OR CURRENT_SCHEMA='db3'
55 ORDER BY CURRENT_SCHEMA, OBJECT_NAME, EVENT_ID;
56 EVENT_NAME SQL_TEXT CURRENT_SCHEMA OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME NESTING_EVENT_TYPE NESTING_EVENT_LEVEL
57 statement/sql/change_db USE db1 db1 NULL NULL NULL NULL 0
58 statement/sql/create_table CREATE TABLE t1(
59 i INT NOT NULL
60 ) db1 NULL NULL NULL NULL 0
61 statement/sql/load LOAD DATA INFILE '../../std_data/wl5766_data.txt' INTO TABLE t1 db1 NULL NULL NULL NULL 0
62 statement/sql/create_procedure CREATE PROCEDURE proc()
63 BEGIN
64 INSERT INTO t1 SELECT * FROM t1;
65 END db1 NULL NULL NULL NULL 0
66 statement/sql/call_procedure CALL proc() db1 NULL NULL NULL NULL 0
67 statement/sp/stmt INSERT INTO t1 SELECT * FROM t1 db1 PROCEDURE db1 proc STATEMENT 1
68 statement/sql/change_db USE db2 db2 NULL NULL NULL NULL 0
69 statement/sql/create_table CREATE TABLE t2(
70 i INT NOT NULL
71 ) db2 NULL NULL NULL NULL 0
72 statement/sql/load LOAD DATA INFILE '../../std_data/wl5766_data.txt' INTO TABLE t2 db2 NULL NULL NULL NULL 0
73 statement/sql/create_function CREATE FUNCTION addition(x INT, y INT) RETURNS INT
74 BEGIN
75 INSERT INTO t2 SELECT * FROM t2;
76 RETURN x+y;
77 END db2 NULL NULL NULL NULL 0
78 statement/sql/select SELECT addition(1234,9876) db2 NULL NULL NULL NULL 0
79 statement/sp/stmt INSERT INTO t2 SELECT * FROM t2 db2 FUNCTION db2 addition TRANSACTION 1
80 statement/sp/freturn NULL db2 FUNCTION db2 addition TRANSACTION 1
81 statement/sql/change_db USE db3 db3 NULL NULL NULL NULL 0
82 statement/sql/create_table CREATE TABLE t(
83 i INT NOT NULL,
84 j INT
85 ) db3 NULL NULL NULL NULL 0
86 statement/sql/create_table CREATE TABLE t3(
87 i INT NOT NULL
88 ) db3 NULL NULL NULL NULL 0
89 statement/sql/load LOAD DATA INFILE '../../std_data/wl5766_data.txt' INTO TABLE t3 db3 NULL NULL NULL NULL 0
90 statement/sql/insert INSERT INTO t VALUES ( 10,1000 ) db3 NULL NULL NULL NULL 0
91 statement/sql/create_trigger CREATE TRIGGER trg AFTER INSERT ON t FOR EACH ROW
92 INSERT INTO t3 SELECT * FROM t3 db3 NULL NULL NULL NULL 0
93 statement/sql/insert INSERT INTO t VALUES ( 20,2000) db3 NULL NULL NULL NULL 0
94 statement/sp/stmt INSERT INTO t3 SELECT * FROM t3 db3 TRIGGER db3 trg TRANSACTION 1
95 TRUNCATE TABLE performance_schema.events_statements_summary_by_program;
96 TRUNCATE TABLE performance_schema.events_statements_history;
97 # Clean-up
98 DROP PROCEDURE db1.proc;
99 DROP FUNCTION db2.addition;
100 DROP TRIGGER db3.trg;
101 DROP TABLE db1.t1;
102 DROP TABLE db2.t2;
103 DROP TABLE db3.t3;
104 DROP TABLE db3.t;
105 DROP DATABASE db1;
106 DROP DATABASE db2;
107 DROP DATABASE db3;