Debian Codegraph @

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

raw
1 UPDATE performance_schema.setup_instruments
2 SET ENABLED='NO' WHERE NAME LIKE "wait/synch/%";
3 SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME
4 FROM INFORMATION_SCHEMA.COLUMNS
5 WHERE TABLE_SCHEMA = 'performance_schema'
6 AND COLUMN_NAME LIKE '%SCHEMA%'
7 ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME;
8 TABLE_SCHEMA TABLE_NAME COLUMN_NAME COLLATION_NAME
9 performance_schema data_locks OBJECT_SCHEMA utf8mb4_0900_ai_ci
10 performance_schema events_statements_current CURRENT_SCHEMA utf8mb4_0900_ai_ci
11 performance_schema events_statements_current OBJECT_SCHEMA utf8mb4_0900_ai_ci
12 performance_schema events_statements_histogram_by_digest SCHEMA_NAME utf8mb4_0900_ai_ci
13 performance_schema events_statements_history CURRENT_SCHEMA utf8mb4_0900_ai_ci
14 performance_schema events_statements_history OBJECT_SCHEMA utf8mb4_0900_ai_ci
15 performance_schema events_statements_history_long CURRENT_SCHEMA utf8mb4_0900_ai_ci
16 performance_schema events_statements_history_long OBJECT_SCHEMA utf8mb4_0900_ai_ci
17 performance_schema events_statements_summary_by_digest SCHEMA_NAME utf8mb4_0900_ai_ci
18 performance_schema events_statements_summary_by_program OBJECT_SCHEMA utf8mb4_0900_ai_ci
19 performance_schema events_waits_current OBJECT_SCHEMA utf8mb4_0900_ai_ci
20 performance_schema events_waits_history OBJECT_SCHEMA utf8mb4_0900_ai_ci
21 performance_schema events_waits_history_long OBJECT_SCHEMA utf8mb4_0900_ai_ci
22 performance_schema metadata_locks OBJECT_SCHEMA utf8mb4_0900_ai_ci
23 performance_schema objects_summary_global_by_type OBJECT_SCHEMA utf8mb4_0900_ai_ci
24 performance_schema prepared_statements_instances OWNER_OBJECT_SCHEMA utf8mb4_0900_ai_ci
25 performance_schema setup_objects OBJECT_SCHEMA utf8mb4_0900_ai_ci
26 performance_schema table_handles OBJECT_SCHEMA utf8mb4_0900_ai_ci
27 performance_schema table_io_waits_summary_by_index_usage OBJECT_SCHEMA utf8mb4_0900_ai_ci
28 performance_schema table_io_waits_summary_by_table OBJECT_SCHEMA utf8mb4_0900_ai_ci
29 performance_schema table_lock_waits_summary_by_table OBJECT_SCHEMA utf8mb4_0900_ai_ci
30 SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME
31 FROM INFORMATION_SCHEMA.COLUMNS
32 WHERE TABLE_SCHEMA = 'performance_schema'
33 AND COLUMN_NAME LIKE '%OBJECT_NAME%'
34 ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME;
35 TABLE_SCHEMA TABLE_NAME COLUMN_NAME COLLATION_NAME
36 performance_schema data_locks OBJECT_NAME utf8mb4_0900_ai_ci
37 performance_schema events_statements_current OBJECT_NAME utf8mb4_0900_ai_ci
38 performance_schema events_statements_history OBJECT_NAME utf8mb4_0900_ai_ci
39 performance_schema events_statements_history_long OBJECT_NAME utf8mb4_0900_ai_ci
40 performance_schema events_statements_summary_by_program OBJECT_NAME utf8mb4_0900_ai_ci
41 performance_schema events_waits_current OBJECT_NAME utf8mb4_0900_ai_ci
42 performance_schema events_waits_history OBJECT_NAME utf8mb4_0900_ai_ci
43 performance_schema events_waits_history_long OBJECT_NAME utf8mb4_0900_ai_ci
44 performance_schema metadata_locks OBJECT_NAME utf8mb4_0900_ai_ci
45 performance_schema objects_summary_global_by_type OBJECT_NAME utf8mb4_0900_ai_ci
46 performance_schema prepared_statements_instances OWNER_OBJECT_NAME utf8mb4_0900_ai_ci
47 performance_schema setup_objects OBJECT_NAME utf8mb4_0900_ai_ci
48 performance_schema table_handles OBJECT_NAME utf8mb4_0900_ai_ci
49 performance_schema table_io_waits_summary_by_index_usage OBJECT_NAME utf8mb4_0900_ai_ci
50 performance_schema table_io_waits_summary_by_table OBJECT_NAME utf8mb4_0900_ai_ci
51 performance_schema table_lock_waits_summary_by_table OBJECT_NAME utf8mb4_0900_ai_ci
52 SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME
53 FROM INFORMATION_SCHEMA.COLUMNS
54 WHERE TABLE_SCHEMA = 'performance_schema'
55 AND COLUMN_NAME LIKE '%COLUMN%'
56 ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME;
57 TABLE_SCHEMA TABLE_NAME COLUMN_NAME COLLATION_NAME
58 performance_schema metadata_locks COLUMN_NAME utf8mb4_0900_ai_ci
59 TRUNCATE TABLE performance_schema.events_waits_history_long;
60 TRUNCATE TABLE performance_schema.events_statements_history_long;
61 CREATE SCHEMA `BroKen`;
62 CREATE SCHEMA `BroKén`;
63 CREATE SCHEMA `bRŎKȩn`;
64 CREATE SCHEMA `∀p∊ℙ`;
65 SHOW DATABASES;
66 Database
67 broken
68 brokén
69 brŏkȩn
70 information_schema
71 mtr
72 mysql
73 performance_schema
74 sys
75 test
76 ∀p∊ℙ
77 use `∀p∊ℙ`;
78 INSERT IGNORE INTO performance_schema.setup_objects VALUES
79 ('TABLE', 'BroKen', '%', 'YES', 'YES'),
80 ('TABLE', 'BroKén', '%', 'YES', 'YES'),
81 ('TABLE', 'bRŎKȩn', '%', 'YES', 'YES'),
82 ('TABLE', '∀p∊ℙ', '%', 'YES', 'YES');
83 "---------------------------------------------------------"
84 SELECT * FROM performance_schema.setup_objects
85 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
86 CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
87 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
88 EVENT % % YES YES
89 EVENT information_schema % NO NO
90 EVENT mysql % NO NO
91 EVENT performance_schema % NO NO
92 FUNCTION % % YES YES
93 FUNCTION information_schema % NO NO
94 FUNCTION mysql % NO NO
95 FUNCTION performance_schema % NO NO
96 PROCEDURE % % YES YES
97 PROCEDURE information_schema % NO NO
98 PROCEDURE mysql % NO NO
99 PROCEDURE performance_schema % NO NO
100 TABLE % % YES YES
101 TABLE ∀p∊ℙ % YES YES
102 TABLE broken % YES YES
103 TABLE brokén % YES YES
104 TABLE brŏkȩn % YES YES
105 TABLE information_schema % NO NO
106 TABLE mysql % NO NO
107 TABLE performance_schema % NO NO
108 TRIGGER % % YES YES
109 TRIGGER information_schema % NO NO
110 TRIGGER mysql % NO NO
111 TRIGGER performance_schema % NO NO
112 "---------------------------------------------------------"
113 CREATE TABLE `∀p∊ℙ`.`torture`(a int);
114 CREATE TABLE `BroKen`.`torture`(a int);
115 CREATE TABLE `BroKén`.`torture`(a int);
116 CREATE TABLE `bRŎKȩn`.`torture`(a int);
117 BEGIN;
118 SELECT * from `∀p∊ℙ`.`torture`;
119 a
120 SELECT * from `BroKen`.`torture`;
121 a
122 SELECT * from `BroKén`.`torture`;
123 a
124 SELECT * from `bRŎKȩn`.`torture`;
125 a
126 "---------------------------------------------------------"
127 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME
128 FROM performance_schema.events_waits_history_long
129 WHERE OBJECT_NAME = 'torture'
130 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME,
131 CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
132 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME EVENT_NAME
133 TABLE ∀p∊ℙ torture NULL wait/io/table/sql/handler
134 TABLE ∀p∊ℙ torture NULL wait/lock/table/sql/handler
135 TABLE broken torture NULL wait/io/table/sql/handler
136 TABLE brokén torture NULL wait/io/table/sql/handler
137 TABLE brŏkȩn torture NULL wait/io/table/sql/handler
138 TABLE broken torture NULL wait/lock/table/sql/handler
139 TABLE brokén torture NULL wait/lock/table/sql/handler
140 TABLE brŏkȩn torture NULL wait/lock/table/sql/handler
141 "---------------------------------------------------------"
142 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA
143 FROM performance_schema.events_statements_history_long
144 WHERE OBJECT_NAME = 'torture'
145 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME,
146 CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
147 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME EVENT_NAME CURRENT_SCHEMA
148 "---------------------------------------------------------"
149 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
150 LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
151 FROM performance_schema.metadata_locks
152 WHERE OBJECT_NAME = 'torture'
153 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
154 CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
155 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS
156 TABLE ∀p∊ℙ torture SHARED_READ TRANSACTION GRANTED
157 TABLE broken torture SHARED_READ TRANSACTION GRANTED
158 TABLE brokén torture SHARED_READ TRANSACTION GRANTED
159 TABLE brŏkȩn torture SHARED_READ TRANSACTION GRANTED
160 "---------------------------------------------------------"
161 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
162 FROM performance_schema.table_lock_waits_summary_by_table
163 WHERE OBJECT_NAME = 'torture'
164 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
165 CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
166 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
167 TABLE ∀p∊ℙ torture
168 TABLE broken torture
169 TABLE brokén torture
170 TABLE brŏkȩn torture
171 "---------------------------------------------------------"
172 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
173 FROM performance_schema.table_io_waits_summary_by_table
174 WHERE OBJECT_NAME = 'torture'
175 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
176 CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
177 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
178 TABLE ∀p∊ℙ torture
179 TABLE broken torture
180 TABLE brokén torture
181 TABLE brŏkȩn torture
182 "---------------------------------------------------------"
183 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
184 FROM performance_schema.table_io_waits_summary_by_index_usage
185 WHERE OBJECT_NAME = 'torture'
186 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
187 CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
188 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
189 TABLE ∀p∊ℙ torture
190 TABLE broken torture
191 TABLE brokén torture
192 TABLE brŏkȩn torture
193 "---------------------------------------------------------"
194 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
195 FROM performance_schema.table_handles
196 WHERE OBJECT_NAME = 'torture'
197 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
198 CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
199 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
200 TABLE ∀p∊ℙ torture
201 TABLE broken torture
202 TABLE brokén torture
203 TABLE brŏkȩn torture
204 "---------------------------------------------------------"
205 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
206 FROM performance_schema.objects_summary_global_by_type
207 WHERE OBJECT_NAME = 'torture'
208 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
209 CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
210 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
211 TABLE ∀p∊ℙ torture
212 TABLE broken torture
213 TABLE brokén torture
214 TABLE brŏkȩn torture
215 "---------------------------------------------------------"
216 COMMIT;
217 DELETE FROM performance_schema.setup_objects
218 WHERE OBJECT_SCHEMA IN ('BroKen', 'BroKén', 'bRŎKȩn', '∀p∊ℙ');
219 DROP SCHEMA `BroKen`;
220 DROP SCHEMA `BroKén`;
221 DROP SCHEMA `bRŎKȩn`;
222 DROP SCHEMA `∀p∊ℙ`;
223 TRUNCATE TABLE performance_schema.events_waits_history_long;
224 TRUNCATE TABLE performance_schema.events_statements_history_long;
225 CREATE SCHEMA `torture`;
226 use `torture`;
227 INSERT IGNORE INTO performance_schema.setup_objects VALUES
228 ('TABLE', 'torture', 'BroKen', 'YES', 'YES'),
229 ('TABLE', 'torture', 'BroKén', 'YES', 'YES'),
230 ('TABLE', 'torture', 'bRŎKȩn', 'YES', 'YES'),
231 ('TABLE', 'torture', '∀p∊ℙ', 'YES', 'YES');
232 "---------------------------------------------------------"
233 SELECT * FROM performance_schema.setup_objects
234 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
235 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
236 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
237 EVENT % % YES YES
238 EVENT information_schema % NO NO
239 EVENT mysql % NO NO
240 EVENT performance_schema % NO NO
241 FUNCTION % % YES YES
242 FUNCTION information_schema % NO NO
243 FUNCTION mysql % NO NO
244 FUNCTION performance_schema % NO NO
245 PROCEDURE % % YES YES
246 PROCEDURE information_schema % NO NO
247 PROCEDURE mysql % NO NO
248 PROCEDURE performance_schema % NO NO
249 TABLE % % YES YES
250 TABLE information_schema % NO NO
251 TABLE mysql % NO NO
252 TABLE performance_schema % NO NO
253 TABLE torture ∀p∊ℙ YES YES
254 TABLE torture broken YES YES
255 TABLE torture brokén YES YES
256 TABLE torture brŏkȩn YES YES
257 TRIGGER % % YES YES
258 TRIGGER information_schema % NO NO
259 TRIGGER mysql % NO NO
260 TRIGGER performance_schema % NO NO
261 "---------------------------------------------------------"
262 CREATE TABLE `torture`.`∀p∊ℙ`(a int);
263 CREATE TABLE `torture`.`BroKen`(a int);
264 CREATE TABLE `torture`.`BroKén`(a int);
265 CREATE TABLE `torture`.`bRŎKȩn`(a int);
266 BEGIN;
267 SELECT * from `torture`.`∀p∊ℙ`;
268 a
269 SELECT * from `torture`.`BroKen`;
270 a
271 SELECT * from `torture`.`BroKén`;
272 a
273 SELECT * from `torture`.`bRŎKȩn`;
274 a
275 "---------------------------------------------------------"
276 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME
277 FROM performance_schema.events_waits_history_long
278 WHERE OBJECT_SCHEMA = 'torture'
279 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME,
280 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
281 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME EVENT_NAME
282 TABLE torture ∀p∊ℙ NULL wait/io/table/sql/handler
283 TABLE torture ∀p∊ℙ NULL wait/lock/table/sql/handler
284 TABLE torture broken NULL wait/io/table/sql/handler
285 TABLE torture brokén NULL wait/io/table/sql/handler
286 TABLE torture brŏkȩn NULL wait/io/table/sql/handler
287 TABLE torture broken NULL wait/lock/table/sql/handler
288 TABLE torture brokén NULL wait/lock/table/sql/handler
289 TABLE torture brŏkȩn NULL wait/lock/table/sql/handler
290 "---------------------------------------------------------"
291 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA
292 FROM performance_schema.events_statements_history_long
293 WHERE OBJECT_SCHEMA = 'torture'
294 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME,
295 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
296 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME EVENT_NAME CURRENT_SCHEMA
297 "---------------------------------------------------------"
298 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
299 LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
300 FROM performance_schema.metadata_locks
301 WHERE OBJECT_SCHEMA = 'torture'
302 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
303 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
304 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS
305 SCHEMA torture NULL INTENTION_EXCLUSIVE TRANSACTION GRANTED
306 TABLE torture ∀p∊ℙ SHARED_READ TRANSACTION GRANTED
307 TABLE torture broken SHARED_READ TRANSACTION GRANTED
308 TABLE torture brokén SHARED_READ TRANSACTION GRANTED
309 TABLE torture brŏkȩn SHARED_READ TRANSACTION GRANTED
310 "---------------------------------------------------------"
311 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
312 FROM performance_schema.table_lock_waits_summary_by_table
313 WHERE OBJECT_SCHEMA = 'torture'
314 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
315 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
316 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
317 TABLE torture ∀p∊ℙ
318 TABLE torture broken
319 TABLE torture brokén
320 TABLE torture brŏkȩn
321 "---------------------------------------------------------"
322 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
323 FROM performance_schema.table_io_waits_summary_by_table
324 WHERE OBJECT_SCHEMA = 'torture'
325 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
326 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
327 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
328 TABLE torture ∀p∊ℙ
329 TABLE torture broken
330 TABLE torture brokén
331 TABLE torture brŏkȩn
332 "---------------------------------------------------------"
333 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
334 FROM performance_schema.table_io_waits_summary_by_index_usage
335 WHERE OBJECT_SCHEMA = 'torture'
336 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
337 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
338 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
339 TABLE torture ∀p∊ℙ
340 TABLE torture broken
341 TABLE torture brokén
342 TABLE torture brŏkȩn
343 "---------------------------------------------------------"
344 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
345 FROM performance_schema.table_handles
346 WHERE OBJECT_SCHEMA = 'torture'
347 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
348 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
349 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
350 TABLE torture ∀p∊ℙ
351 TABLE torture broken
352 TABLE torture brokén
353 TABLE torture brŏkȩn
354 "---------------------------------------------------------"
355 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
356 FROM performance_schema.objects_summary_global_by_type
357 WHERE OBJECT_SCHEMA = 'torture'
358 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
359 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
360 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
361 TABLE torture ∀p∊ℙ
362 TABLE torture broken
363 TABLE torture brokén
364 TABLE torture brŏkȩn
365 "---------------------------------------------------------"
366 COMMIT;
367 DELETE FROM performance_schema.setup_objects
368 WHERE OBJECT_NAME IN ('BroKen', 'BroKén', 'bRŎKȩn', '∀p∊ℙ');
369 DROP TABLE `torture`.`BroKen`;
370 DROP TABLE `torture`.`BroKén`;
371 DROP TABLE `torture`.`bRŎKȩn`;
372 DROP TABLE `torture`.`∀p∊ℙ`;
373 TRUNCATE TABLE performance_schema.events_waits_history_long;
374 TRUNCATE TABLE performance_schema.events_statements_history_long;
375 CREATE TABLE `torture`.`torture`(
376 id int,
377 `∀p∊ℙ` int, `BroKen` int, `BroKén` int, `bRŎKȩn` int,
378 PRIMARY KEY (`id`),
379 KEY (`∀p∊ℙ`),
380 KEY (`BroKen`),
381 KEY (`BroKén`),
382 KEY (`bRŎKȩn`)
383 );
384 BEGIN;
385 INSERT INTO `torture`.`torture` VALUES (0, 1, 2, 3, 4);
386 SELECT * from `torture`.`torture`;
387 id ∀p∊ℙ BroKen BroKén bRŎKȩn
388 0 1 2 3 4
389 SELECT * from `torture`.`torture` USE INDEX (`∀p∊ℙ`) WHERE `∀p∊ℙ` = 1;
390 id ∀p∊ℙ BroKen BroKén bRŎKȩn
391 0 1 2 3 4
392 SELECT * from `torture`.`torture` USE INDEX (`BroKen`) WHERE `BroKen` = 2;
393 id ∀p∊ℙ BroKen BroKén bRŎKȩn
394 0 1 2 3 4
395 SELECT * from `torture`.`torture` USE INDEX (`BroKén`) WHERE `BroKén` = 3;
396 id ∀p∊ℙ BroKen BroKén bRŎKȩn
397 0 1 2 3 4
398 SELECT * from `torture`.`torture` USE INDEX (`bRŎKȩn`) WHERE `bRŎKȩn` = 4;
399 id ∀p∊ℙ BroKen BroKén bRŎKȩn
400 0 1 2 3 4
401 "---------------------------------------------------------"
402 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME
403 FROM performance_schema.events_waits_history_long
404 WHERE OBJECT_SCHEMA = 'torture'
405 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME,
406 CONVERT(INDEX_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
407 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME EVENT_NAME
408 TABLE torture torture NULL wait/io/table/sql/handler
409 TABLE torture torture NULL wait/io/table/sql/handler
410 TABLE torture torture ∀p∊ℙ wait/io/table/sql/handler
411 TABLE torture torture BroKen wait/io/table/sql/handler
412 TABLE torture torture BroKén wait/io/table/sql/handler
413 TABLE torture torture bRŎKȩn wait/io/table/sql/handler
414 TABLE torture torture PRIMARY wait/lock/table/sql/handler
415 TABLE torture torture PRIMARY wait/lock/table/sql/handler
416 TABLE torture torture PRIMARY wait/lock/table/sql/handler
417 TABLE torture torture PRIMARY wait/lock/table/sql/handler
418 TABLE torture torture PRIMARY wait/lock/table/sql/handler
419 TABLE torture torture PRIMARY wait/lock/table/sql/handler
420 "---------------------------------------------------------"
421 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA
422 FROM performance_schema.events_statements_history_long
423 WHERE OBJECT_SCHEMA = 'torture'
424 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME;
425 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME EVENT_NAME CURRENT_SCHEMA
426 "---------------------------------------------------------"
427 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
428 LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
429 FROM performance_schema.metadata_locks
430 WHERE OBJECT_SCHEMA = 'torture'
431 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
432 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS
433 SCHEMA torture NULL INTENTION_EXCLUSIVE TRANSACTION GRANTED
434 TABLE torture torture SHARED_WRITE TRANSACTION GRANTED
435 "---------------------------------------------------------"
436 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
437 FROM performance_schema.table_lock_waits_summary_by_table
438 WHERE OBJECT_SCHEMA = 'torture'
439 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
440 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
441 TABLE torture torture
442 "---------------------------------------------------------"
443 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
444 FROM performance_schema.table_io_waits_summary_by_table
445 WHERE OBJECT_SCHEMA = 'torture'
446 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
447 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
448 TABLE torture torture
449 "---------------------------------------------------------"
450 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
451 FROM performance_schema.table_io_waits_summary_by_index_usage
452 WHERE OBJECT_SCHEMA = 'torture'
453 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME,
454 CONVERT(INDEX_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
455 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME
456 TABLE torture torture NULL
457 TABLE torture torture ∀p∊ℙ
458 TABLE torture torture BroKen
459 TABLE torture torture BroKén
460 TABLE torture torture bRŎKȩn
461 TABLE torture torture PRIMARY
462 "---------------------------------------------------------"
463 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
464 FROM performance_schema.table_handles
465 WHERE OBJECT_SCHEMA = 'torture'
466 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
467 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
468 TABLE torture torture
469 "---------------------------------------------------------"
470 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
471 FROM performance_schema.objects_summary_global_by_type
472 WHERE OBJECT_SCHEMA = 'torture'
473 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
474 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
475 TABLE torture torture
476 "---------------------------------------------------------"
477 COMMIT;
478 DROP TABLE `torture`.`torture`;
479 TRUNCATE TABLE performance_schema.events_waits_history_long;
480 TRUNCATE TABLE performance_schema.events_statements_history_long;
481 CREATE PROCEDURE `torture`.`∀p∊ℙ`()
482 BEGIN
483 SELECT 1;
484 END
485 $$
486 CREATE PROCEDURE `torture`.`BroKen`()
487 BEGIN
488 SELECT 2;
489 END
490 $$
491 CREATE PROCEDURE `torture`.`BroKén`()
492 BEGIN
493 SELECT 3;
494 END
495 $$
496 ERROR 42000: PROCEDURE BroKén already exists
497 CREATE PROCEDURE `torture`.`bRŎKȩn`()
498 BEGIN
499 SELECT 4;
500 END
501 $$
502 ERROR 42000: PROCEDURE bRŎKȩn already exists
503 BEGIN;
504 CALL `torture`.`∀p∊ℙ`;
505 1
506 1
507 CALL `torture`.`BroKen`;
508 2
509 2
510 CALL `torture`.`BroKén`;
511 2
512 2
513 CALL `torture`.`bRŎKȩn`;
514 2
515 2
516 "---------------------------------------------------------"
517 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME
518 FROM performance_schema.events_waits_history_long
519 WHERE OBJECT_SCHEMA = 'torture'
520 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME,
521 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
522 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME EVENT_NAME
523 "---------------------------------------------------------"
524 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA
525 FROM performance_schema.events_statements_history_long
526 WHERE OBJECT_SCHEMA = 'torture'
527 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME,
528 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
529 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME EVENT_NAME CURRENT_SCHEMA
530 PROCEDURE torture ∀p∊ℙ statement/sp/stmt torture
531 PROCEDURE torture BroKen statement/sp/stmt torture
532 PROCEDURE torture BroKen statement/sp/stmt torture
533 PROCEDURE torture BroKen statement/sp/stmt torture
534 "---------------------------------------------------------"
535 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
536 LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
537 FROM performance_schema.metadata_locks
538 WHERE OBJECT_SCHEMA = 'torture'
539 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
540 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
541 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS
542 PROCEDURE torture ∀p∊ℙ SHARED TRANSACTION GRANTED
543 PROCEDURE torture BroKen SHARED TRANSACTION GRANTED
544 "---------------------------------------------------------"
545 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
546 FROM performance_schema.table_lock_waits_summary_by_table
547 WHERE OBJECT_SCHEMA = 'torture'
548 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
549 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
550 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
551 "---------------------------------------------------------"
552 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
553 FROM performance_schema.table_io_waits_summary_by_table
554 WHERE OBJECT_SCHEMA = 'torture'
555 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
556 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
557 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
558 "---------------------------------------------------------"
559 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
560 FROM performance_schema.table_io_waits_summary_by_index_usage
561 WHERE OBJECT_SCHEMA = 'torture'
562 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
563 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
564 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME
565 "---------------------------------------------------------"
566 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
567 FROM performance_schema.table_handles
568 WHERE OBJECT_SCHEMA = 'torture'
569 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
570 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
571 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
572 "---------------------------------------------------------"
573 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
574 FROM performance_schema.objects_summary_global_by_type
575 WHERE OBJECT_SCHEMA = 'torture'
576 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
577 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
578 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
579 PROCEDURE torture ∀p∊ℙ
580 PROCEDURE torture BroKen
581 "---------------------------------------------------------"
582 COMMIT;
583 DROP PROCEDURE `torture`.`∀p∊ℙ`;
584 DROP PROCEDURE `torture`.`BroKen`;
585 DROP PROCEDURE `torture`.`BroKén`;
586 ERROR 42000: PROCEDURE torture.BroKén does not exist
587 DROP PROCEDURE `torture`.`bRŎKȩn`;
588 ERROR 42000: PROCEDURE torture.bRŎKȩn does not exist
589 TRUNCATE TABLE performance_schema.events_waits_history_long;
590 TRUNCATE TABLE performance_schema.events_statements_history_long;
591 CREATE FUNCTION `torture`.`∀p∊ℙ`()
592 RETURNS INTEGER
593 BEGIN
594 RETURN 1;
595 END
596 $$
597 CREATE FUNCTION `torture`.`BroKen`()
598 RETURNS INTEGER
599 BEGIN
600 RETURN 2;
601 END
602 $$
603 CREATE FUNCTION `torture`.`BroKén`()
604 RETURNS INTEGER
605 BEGIN
606 RETURN 3;
607 END
608 $$
609 ERROR 42000: FUNCTION BroKén already exists
610 CREATE FUNCTION `torture`.`bRŎKȩn`()
611 RETURNS INTEGER
612 BEGIN
613 RETURN 4;
614 END
615 $$
616 ERROR 42000: FUNCTION bRŎKȩn already exists
617 BEGIN;
618 SELECT `torture`.`∀p∊ℙ`();
619 `torture`.`∀p∊ℙ`()
620 1
621 SELECT `torture`.`BroKen`();
622 `torture`.`BroKen`()
623 2
624 SELECT `torture`.`BroKén`();
625 `torture`.`BroKén`()
626 2
627 SELECT `torture`.`bRŎKȩn`();
628 `torture`.`bRŎKȩn`()
629 2
630 "---------------------------------------------------------"
631 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME
632 FROM performance_schema.events_waits_history_long
633 WHERE OBJECT_SCHEMA = 'torture'
634 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME,
635 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
636 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME EVENT_NAME
637 "---------------------------------------------------------"
638 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA
639 FROM performance_schema.events_statements_history_long
640 WHERE OBJECT_SCHEMA = 'torture'
641 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME,
642 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
643 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME EVENT_NAME CURRENT_SCHEMA
644 FUNCTION torture ∀p∊ℙ statement/sp/freturn torture
645 FUNCTION torture BroKen statement/sp/freturn torture
646 FUNCTION torture BroKen statement/sp/freturn torture
647 FUNCTION torture BroKen statement/sp/freturn torture
648 "---------------------------------------------------------"
649 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
650 LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
651 FROM performance_schema.metadata_locks
652 WHERE OBJECT_SCHEMA = 'torture'
653 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
654 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
655 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS
656 FUNCTION torture ∀p∊ℙ SHARED TRANSACTION GRANTED
657 FUNCTION torture BroKen SHARED TRANSACTION GRANTED
658 "---------------------------------------------------------"
659 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
660 FROM performance_schema.table_lock_waits_summary_by_table
661 WHERE OBJECT_SCHEMA = 'torture'
662 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
663 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
664 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
665 "---------------------------------------------------------"
666 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
667 FROM performance_schema.table_io_waits_summary_by_table
668 WHERE OBJECT_SCHEMA = 'torture'
669 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
670 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
671 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
672 "---------------------------------------------------------"
673 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
674 FROM performance_schema.table_io_waits_summary_by_index_usage
675 WHERE OBJECT_SCHEMA = 'torture'
676 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
677 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
678 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME
679 "---------------------------------------------------------"
680 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
681 FROM performance_schema.table_handles
682 WHERE OBJECT_SCHEMA = 'torture'
683 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
684 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
685 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
686 "---------------------------------------------------------"
687 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
688 FROM performance_schema.objects_summary_global_by_type
689 WHERE OBJECT_SCHEMA = 'torture'
690 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
691 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
692 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
693 FUNCTION torture ∀p∊ℙ
694 FUNCTION torture BroKen
695 "---------------------------------------------------------"
696 COMMIT;
697 DROP FUNCTION `torture`.`∀p∊ℙ`;
698 DROP FUNCTION `torture`.`BroKen`;
699 DROP FUNCTION `torture`.`BroKén`;
700 ERROR 42000: FUNCTION torture.BroKén does not exist
701 DROP FUNCTION `torture`.`bRŎKȩn`;
702 ERROR 42000: FUNCTION torture.bRŎKȩn does not exist
703 CREATE TABLE test.t1(a int);
704 CREATE TRIGGER test.t1_bi_broken BEFORE INSERT ON test.t1
705 FOR EACH ROW BEGIN END;
706 INSERT INTO test.t1 VALUES (1);
707 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
708 FROM performance_schema.events_statements_summary_by_program
709 WHERE OBJECT_SCHEMA='test';
710 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
711 TRIGGER test t1_bi_broken
712 DROP TRIGGER test.`t1_bi_brokén`;
713 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
714 FROM performance_schema.events_statements_summary_by_program
715 WHERE OBJECT_SCHEMA='test';
716 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
717 DROP TABLE test.t1;
718 DROP SCHEMA `torture`;
719 UPDATE performance_schema.setup_instruments
720 SET ENABLED='YES' WHERE NAME LIKE "wait/synch/%";