Debian Codegraph @

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

raw
1 TABLE: "file_instances"
2 INDEXES: PK (FILE_NAME), KEY (EVENT_NAME)
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
52 ## Test FILE_NAME
53 SET @target_name = @file_name;
54
55 ===== BEGIN TEST =====
56 ========
57 SELECT * FROM performance_schema.file_instances WHERE FILE_NAME = @target_name
58
59 OK: Handler_read_key
60
61 OK: Result set: Non-empty Expected: Non-empty
62
63 OK: Extra rows: 0 Missing rows: 0
64 ========
65 SELECT * FROM performance_schema.file_instances WHERE FILE_NAME != @target_name
66
67 OK: Handler_read_key
68
69 OK: Result set: Non-empty Expected: Non-empty
70
71 OK: Extra rows: 0 Missing rows: 0
72 ========
73 SELECT * FROM performance_schema.file_instances WHERE FILE_NAME = 'impossible'
74
75 OK: Handler_read_key
76
77 OK: Result set: Empty Expected: Empty
78
79 OK: Extra rows: 0 Missing rows: 0
80 ========
81 SELECT * FROM performance_schema.file_instances WHERE FILE_NAME != 'impossible' ORDER BY FILE_NAME DESC
82
83 OK: Handler_read_key
84
85 OK: Result set: Non-empty Expected: Non-empty
86
87 OK: Extra rows: 0 Missing rows: 0
88
89 ## Test EVENT_NAME
90
91 ===== BEGIN TEST =====
92 ========
93 SELECT * FROM performance_schema.file_instances WHERE EVENT_NAME is null
94
95 OK: Handler_read_key
96
97 OK: Result set: Empty Expected: Empty
98
99 OK: Extra rows: 0 Missing rows: 0
100 ========
101 SELECT * FROM performance_schema.file_instances WHERE EVENT_NAME is not null
102
103 OK: Handler_read_key
104
105 OK: Result set: Non-empty Expected: Non-empty
106
107 OK: Extra rows: 0 Missing rows: 0
108 ========
109 SELECT * FROM performance_schema.file_instances WHERE EVENT_NAME = 'wait/io/file/sql/ERRMSG'
110
111 OK: Handler_read_key
112
113 OK: Result set: Non-empty Expected: Non-empty
114
115 OK: Extra rows: 0 Missing rows: 0
116 ========
117 SELECT * FROM performance_schema.file_instances WHERE EVENT_NAME != 'wait/io/file/sql/ERRMSG'
118
119 OK: Handler_read_key
120
121 OK: Result set: Non-empty Expected: Non-empty
122
123 OK: Extra rows: 0 Missing rows: 0
124 ========
125 SELECT * FROM performance_schema.file_instances WHERE EVENT_NAME = 'impossible'
126
127 OK: Handler_read_key
128
129 OK: Result set: Empty Expected: Empty
130
131 OK: Extra rows: 0 Missing rows: 0
132 ========
133 SELECT * FROM performance_schema.file_instances WHERE EVENT_NAME != 'impossible' ORDER BY EVENT_NAME DESC
134
135 OK: Handler_read_key
136
137 OK: Result set: Non-empty Expected: Non-empty
138
139 OK: Extra rows: 0 Missing rows: 0
140
141 ===== CLEAN UP =====
142 ## Default connection
143 DEALLOCATE PREPARE st1;
144 DEALLOCATE PREPARE st2;
145 DEALLOCATE PREPARE st3;
146 DEALLOCATE PREPARE st4;
147 DROP PROCEDURE SampleProc1;
148 DROP PROCEDURE index_test;
149 DROP TABLE IF EXISTS test.indexes_off;
150 DROP TABLE IF EXISTS test.indexes_on;
151 DROP TABLE test.t1;
152 DROP TABLE test.t2;
153 DROP TABLE test.t3;
154 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user1@localhost;
155 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user2@localhost;
156 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user3@localhost;
157 DROP USER user1@localhost;
158 DROP USER user2@localhost;
159 DROP USER user3@localhost;
160 UPDATE performance_schema.threads SET INSTRUMENTED = 'YES';