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