Debian Codegraph @

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

raw
1 TABLE: "events_statements_summary_by_digest"
2 INDEXES: PK (SCHEMA_NAME, DIGEST)
3
4 ===== SETUP =====
5 ## Connection Default
6 ## Disable events from the default connection
7
8 ## Create user1, user2, user3
9 CREATE USER user1@localhost;
10 CREATE USER user2@localhost;
11 CREATE USER user3@localhost;
12 GRANT ALL ON *.* to 'user1'@localhost;
13 GRANT ALL ON *.* to 'user2'@localhost;
14 GRANT ALL ON *.* to 'user3'@localhost;
15
16 ## Setup test connection 1
17 ## Setup test connection 2
18 ## Setup test connection 3
19
20 ## Default connection
21
22 ## Create data tables
23 CREATE TABLE test.t1(a INT, b INT, c INT, d INT DEFAULT 0, PRIMARY KEY(a), INDEX index_b(b), INDEX index_cb(c, b));
24 CREATE TABLE test.t2 LIKE test.t1;
25 CREATE TABLE test.t3 LIKE test.t1;
26
27 ## Generate event data from 3 connections
28 ## Connection 1
29 ## Connection 2
30 ## Connection 3
31 ## Connection 2
32 ## Create prepared statements on connection 2
33 PREPARE st1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse';
34 PREPARE st3 FROM 'INSERT INTO test.t1 SELECT * FROM test.t1 WHERE a<=?';
35 PREPARE st4 FROM '(SELECT a FROM test.t1) UNION (SELECT a+10 FROM test.t1) ORDER BY RAND()*0+a';
36 ## Create stored procedure connection 2
37 CREATE PROCEDURE SampleProc1()
38 BEGIN
39 SET @table = 'test.t1';
40 SET @s = CONCAT('SELECT * FROM ', @table);
41 PREPARE st2 FROM @s;
42 END|
43
44 Call SampleProc1() to prepare a statement
45 CALL SampleProc1();
46 ## Connection default
47
48 ## Use Connection 2 for default target thread id
49
50 ## Create index_test() procedure
51 truncate performance_schema.events_statements_summary_by_digest;
52 ## Connection 2
53 CREATE DATABASE test2;
54 USE test2;
55 SELECT COUNT(*) FROM test.t1;
56 COUNT(*)
57 3
58 USE test;
59 ## Default connection
60
61 ## Test SCHEMA_NAME, DIGEST
62 SET @pfs_columns = "SCHEMA_NAME, DIGEST, DIGEST_TEXT";
63
64 ===== BEGIN TEST =====
65 ========
66 SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT FROM performance_schema.events_statements_summary_by_digest WHERE schema_name is null
67
68 OK: Handler_read_key
69
70 OK: Result set: Empty Expected: Empty
71
72 OK: Extra rows: 0 Missing rows: 0
73 ========
74 SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT FROM performance_schema.events_statements_summary_by_digest WHERE schema_name is not null
75
76 OK: Handler_read_key
77
78 OK: Result set: Non-empty Expected: Non-empty
79
80 OK: Extra rows: 0 Missing rows: 0
81 ========
82 SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT FROM performance_schema.events_statements_summary_by_digest WHERE schema_name = 'test2' and digest is null
83
84 OK: Handler_read_key
85
86 OK: Result set: Empty Expected: Empty
87
88 OK: Extra rows: 0 Missing rows: 0
89 ========
90 SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT FROM performance_schema.events_statements_summary_by_digest WHERE schema_name = 'test2' and digest is not null
91
92 OK: Handler_read_key
93
94 OK: Result set: Non-empty Expected: Non-empty
95
96 OK: Extra rows: 0 Missing rows: 0
97 ========
98 SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT FROM performance_schema.events_statements_summary_by_digest WHERE schema_name = 'test2'
99
100 OK: Handler_read_key
101
102 OK: Result set: Non-empty Expected: Non-empty
103
104 OK: Extra rows: 0 Missing rows: 0
105 ========
106 SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT FROM performance_schema.events_statements_summary_by_digest WHERE schema_name != 'test2'
107
108 OK: Handler_read_key
109
110 OK: Result set: Non-empty Expected: Non-empty
111
112 OK: Extra rows: 0 Missing rows: 0
113 ========
114 SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT FROM performance_schema.events_statements_summary_by_digest WHERE schema_name = 'test2' AND digest = @target_digest
115
116 OK: Handler_read_key
117
118 OK: Result set: Non-empty Expected: Non-empty
119
120 OK: Extra rows: 0 Missing rows: 0
121 ========
122 SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT FROM performance_schema.events_statements_summary_by_digest WHERE schema_name = 'test2' AND digest = 'impossible'
123
124 OK: Handler_read_key
125
126 OK: Result set: Empty Expected: Empty
127
128 OK: Extra rows: 0 Missing rows: 0
129 ========
130 SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT FROM performance_schema.events_statements_summary_by_digest WHERE schema_name = 'noschema_name' AND digest = @target_digest
131
132 OK: Handler_read_key
133
134 OK: Result set: Empty Expected: Empty
135
136 OK: Extra rows: 0 Missing rows: 0
137 DROP DATABASE test2;
138
139 ===== CLEAN UP =====
140 ## Default connection
141 DEALLOCATE PREPARE st1;
142 DEALLOCATE PREPARE st2;
143 DEALLOCATE PREPARE st3;
144 DEALLOCATE PREPARE st4;
145 DROP PROCEDURE SampleProc1;
146 DROP PROCEDURE index_test;
147 DROP TABLE IF EXISTS test.indexes_off;
148 DROP TABLE IF EXISTS test.indexes_on;
149 DROP TABLE test.t1;
150 DROP TABLE test.t2;
151 DROP TABLE test.t3;
152 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user1@localhost;
153 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user2@localhost;
154 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user3@localhost;
155 DROP USER user1@localhost;
156 DROP USER user2@localhost;
157 DROP USER user3@localhost;
158 UPDATE performance_schema.threads SET INSTRUMENTED = 'YES';