Debian Codegraph @

mysql-test/suite/perfschema/include/object_collation.inc

raw
1
2 --source include/no_protocol.inc
3
4 #
5 # SETUP
6 #
7
8 UPDATE performance_schema.setup_instruments
9 SET ENABLED='NO' WHERE NAME LIKE "wait/synch/%";
10
11 #
12 # DUMP CRITICAL COLUMNS COLLATIONS
13 #
14
15 SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME
16 FROM INFORMATION_SCHEMA.COLUMNS
17 WHERE TABLE_SCHEMA = 'performance_schema'
18 AND COLUMN_NAME LIKE '%SCHEMA%'
19 ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME;
20
21 SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME
22 FROM INFORMATION_SCHEMA.COLUMNS
23 WHERE TABLE_SCHEMA = 'performance_schema'
24 AND COLUMN_NAME LIKE '%OBJECT_NAME%'
25 ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME;
26
27 SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME
28 FROM INFORMATION_SCHEMA.COLUMNS
29 WHERE TABLE_SCHEMA = 'performance_schema'
30 AND COLUMN_NAME LIKE '%COLUMN%'
31 ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME;
32
33
34 #
35 # SCHEMA NAME torture
36 #
37
38 TRUNCATE TABLE performance_schema.events_waits_history_long;
39 TRUNCATE TABLE performance_schema.events_statements_history_long;
40
41 CREATE SCHEMA `BroKen`;
42 CREATE SCHEMA `BroKén`;
43 CREATE SCHEMA `bRŎKȩn`;
44 CREATE SCHEMA `∀p∊ℙ`;
45
46 SHOW DATABASES;
47
48 use `∀p∊ℙ`;
49
50 INSERT IGNORE INTO performance_schema.setup_objects VALUES
51 ('TABLE', 'BroKen', '%', 'YES', 'YES'),
52 ('TABLE', 'BroKén', '%', 'YES', 'YES'),
53 ('TABLE', 'bRŎKȩn', '%', 'YES', 'YES'),
54 ('TABLE', '∀p∊ℙ', '%', 'YES', 'YES');
55
56 -- echo "---------------------------------------------------------"
57 SELECT * FROM performance_schema.setup_objects
58 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
59 CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
60 -- echo "---------------------------------------------------------"
61
62 CREATE TABLE `∀p∊ℙ`.`torture`(a int);
63 CREATE TABLE `BroKen`.`torture`(a int);
64 CREATE TABLE `BroKén`.`torture`(a int);
65 CREATE TABLE `bRŎKȩn`.`torture`(a int);
66
67 BEGIN;
68
69 SELECT * from `∀p∊ℙ`.`torture`;
70 SELECT * from `BroKen`.`torture`;
71 SELECT * from `BroKén`.`torture`;
72 SELECT * from `bRŎKȩn`.`torture`;
73
74 -- echo "---------------------------------------------------------"
75 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME
76 FROM performance_schema.events_waits_history_long
77 WHERE OBJECT_NAME = 'torture'
78 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME,
79 CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
80
81 -- echo "---------------------------------------------------------"
82 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA
83 FROM performance_schema.events_statements_history_long
84 WHERE OBJECT_NAME = 'torture'
85 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME,
86 CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
87
88 -- echo "---------------------------------------------------------"
89 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
90 LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
91 FROM performance_schema.metadata_locks
92 WHERE OBJECT_NAME = 'torture'
93 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
94 CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
95
96 -- echo "---------------------------------------------------------"
97 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
98 FROM performance_schema.table_lock_waits_summary_by_table
99 WHERE OBJECT_NAME = 'torture'
100 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
101 CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
102
103 -- echo "---------------------------------------------------------"
104 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
105 FROM performance_schema.table_io_waits_summary_by_table
106 WHERE OBJECT_NAME = 'torture'
107 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
108 CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
109
110 -- echo "---------------------------------------------------------"
111 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
112 FROM performance_schema.table_io_waits_summary_by_index_usage
113 WHERE OBJECT_NAME = 'torture'
114 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
115 CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
116
117 -- echo "---------------------------------------------------------"
118 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
119 FROM performance_schema.table_handles
120 WHERE OBJECT_NAME = 'torture'
121 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
122 CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
123
124 -- echo "---------------------------------------------------------"
125 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
126 FROM performance_schema.objects_summary_global_by_type
127 WHERE OBJECT_NAME = 'torture'
128 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
129 CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
130
131 -- echo "---------------------------------------------------------"
132 COMMIT;
133
134 DELETE FROM performance_schema.setup_objects
135 WHERE OBJECT_SCHEMA IN ('BroKen', 'BroKén', 'bRŎKȩn', '∀p∊ℙ');
136
137 DROP SCHEMA `BroKen`;
138 DROP SCHEMA `BroKén`;
139 DROP SCHEMA `bRŎKȩn`;
140 DROP SCHEMA `∀p∊ℙ`;
141
142 #
143 # TABLE NAME torture
144 #
145
146 TRUNCATE TABLE performance_schema.events_waits_history_long;
147 TRUNCATE TABLE performance_schema.events_statements_history_long;
148
149 CREATE SCHEMA `torture`;
150
151 use `torture`;
152
153 INSERT IGNORE INTO performance_schema.setup_objects VALUES
154 ('TABLE', 'torture', 'BroKen', 'YES', 'YES'),
155 ('TABLE', 'torture', 'BroKén', 'YES', 'YES'),
156 ('TABLE', 'torture', 'bRŎKȩn', 'YES', 'YES'),
157 ('TABLE', 'torture', '∀p∊ℙ', 'YES', 'YES');
158
159 -- echo "---------------------------------------------------------"
160 SELECT * FROM performance_schema.setup_objects
161 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
162 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
163 -- echo "---------------------------------------------------------"
164
165 CREATE TABLE `torture`.`∀p∊ℙ`(a int);
166 CREATE TABLE `torture`.`BroKen`(a int);
167 CREATE TABLE `torture`.`BroKén`(a int);
168 CREATE TABLE `torture`.`bRŎKȩn`(a int);
169
170 BEGIN;
171
172 SELECT * from `torture`.`∀p∊ℙ`;
173 SELECT * from `torture`.`BroKen`;
174 SELECT * from `torture`.`BroKén`;
175 SELECT * from `torture`.`bRŎKȩn`;
176
177 -- echo "---------------------------------------------------------"
178 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME
179 FROM performance_schema.events_waits_history_long
180 WHERE OBJECT_SCHEMA = 'torture'
181 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME,
182 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
183
184 -- echo "---------------------------------------------------------"
185 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA
186 FROM performance_schema.events_statements_history_long
187 WHERE OBJECT_SCHEMA = 'torture'
188 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME,
189 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
190
191 -- echo "---------------------------------------------------------"
192 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
193 LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
194 FROM performance_schema.metadata_locks
195 WHERE OBJECT_SCHEMA = 'torture'
196 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
197 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
198
199 -- echo "---------------------------------------------------------"
200 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
201 FROM performance_schema.table_lock_waits_summary_by_table
202 WHERE OBJECT_SCHEMA = 'torture'
203 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
204 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
205
206 -- echo "---------------------------------------------------------"
207 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
208 FROM performance_schema.table_io_waits_summary_by_table
209 WHERE OBJECT_SCHEMA = 'torture'
210 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
211 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
212
213 -- echo "---------------------------------------------------------"
214 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
215 FROM performance_schema.table_io_waits_summary_by_index_usage
216 WHERE OBJECT_SCHEMA = 'torture'
217 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
218 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
219
220 -- echo "---------------------------------------------------------"
221 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
222 FROM performance_schema.table_handles
223 WHERE OBJECT_SCHEMA = 'torture'
224 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
225 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
226
227 -- echo "---------------------------------------------------------"
228 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
229 FROM performance_schema.objects_summary_global_by_type
230 WHERE OBJECT_SCHEMA = 'torture'
231 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
232 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
233
234 -- echo "---------------------------------------------------------"
235 COMMIT;
236
237 DELETE FROM performance_schema.setup_objects
238 WHERE OBJECT_NAME IN ('BroKen', 'BroKén', 'bRŎKȩn', '∀p∊ℙ');
239
240 DROP TABLE `torture`.`BroKen`;
241 DROP TABLE `torture`.`BroKén`;
242 DROP TABLE `torture`.`bRŎKȩn`;
243 DROP TABLE `torture`.`∀p∊ℙ`;
244
245 #
246 # INDEX NAME torture
247 #
248
249 TRUNCATE TABLE performance_schema.events_waits_history_long;
250 TRUNCATE TABLE performance_schema.events_statements_history_long;
251
252 CREATE TABLE `torture`.`torture`(
253 id int,
254 `∀p∊ℙ` int, `BroKen` int, `BroKén` int, `bRŎKȩn` int,
255 PRIMARY KEY (`id`),
256 KEY (`∀p∊ℙ`),
257 KEY (`BroKen`),
258 KEY (`BroKén`),
259 KEY (`bRŎKȩn`)
260 );
261
262 BEGIN;
263
264 INSERT INTO `torture`.`torture` VALUES (0, 1, 2, 3, 4);
265
266 SELECT * from `torture`.`torture`;
267
268 SELECT * from `torture`.`torture` USE INDEX (`∀p∊ℙ`) WHERE `∀p∊ℙ` = 1;
269 SELECT * from `torture`.`torture` USE INDEX (`BroKen`) WHERE `BroKen` = 2;
270 SELECT * from `torture`.`torture` USE INDEX (`BroKén`) WHERE `BroKén` = 3;
271 SELECT * from `torture`.`torture` USE INDEX (`bRŎKȩn`) WHERE `bRŎKȩn` = 4;
272
273 -- echo "---------------------------------------------------------"
274 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME
275 FROM performance_schema.events_waits_history_long
276 WHERE OBJECT_SCHEMA = 'torture'
277 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME,
278 CONVERT(INDEX_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
279
280 -- echo "---------------------------------------------------------"
281 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA
282 FROM performance_schema.events_statements_history_long
283 WHERE OBJECT_SCHEMA = 'torture'
284 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME;
285
286 -- echo "---------------------------------------------------------"
287 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
288 LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
289 FROM performance_schema.metadata_locks
290 WHERE OBJECT_SCHEMA = 'torture'
291 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
292
293 -- echo "---------------------------------------------------------"
294 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
295 FROM performance_schema.table_lock_waits_summary_by_table
296 WHERE OBJECT_SCHEMA = 'torture'
297 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
298
299 -- echo "---------------------------------------------------------"
300 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
301 FROM performance_schema.table_io_waits_summary_by_table
302 WHERE OBJECT_SCHEMA = 'torture'
303 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
304
305 -- echo "---------------------------------------------------------"
306 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
307 FROM performance_schema.table_io_waits_summary_by_index_usage
308 WHERE OBJECT_SCHEMA = 'torture'
309 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME,
310 CONVERT(INDEX_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
311
312 -- echo "---------------------------------------------------------"
313 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
314 FROM performance_schema.table_handles
315 WHERE OBJECT_SCHEMA = 'torture'
316 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
317
318 -- echo "---------------------------------------------------------"
319 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
320 FROM performance_schema.objects_summary_global_by_type
321 WHERE OBJECT_SCHEMA = 'torture'
322 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
323
324 -- echo "---------------------------------------------------------"
325 COMMIT;
326
327 DROP TABLE `torture`.`torture`;
328
329 #
330 # PROCEDURE NAME torture
331 #
332
333 TRUNCATE TABLE performance_schema.events_waits_history_long;
334 TRUNCATE TABLE performance_schema.events_statements_history_long;
335
336 DELIMITER $$;
337
338 CREATE PROCEDURE `torture`.`∀p∊ℙ`()
339 BEGIN
340 SELECT 1;
341 END
342 $$
343
344 CREATE PROCEDURE `torture`.`BroKen`()
345 BEGIN
346 SELECT 2;
347 END
348 $$
349
350 -- error ER_SP_ALREADY_EXISTS
351 CREATE PROCEDURE `torture`.`BroKén`()
352 BEGIN
353 SELECT 3;
354 END
355 $$
356
357 -- error ER_SP_ALREADY_EXISTS
358 CREATE PROCEDURE `torture`.`bRŎKȩn`()
359 BEGIN
360 SELECT 4;
361 END
362 $$
363
364 DELIMITER ;$$
365
366 BEGIN;
367
368 CALL `torture`.`∀p∊ℙ`;
369 CALL `torture`.`BroKen`;
370 CALL `torture`.`BroKén`;
371 CALL `torture`.`bRŎKȩn`;
372
373 -- echo "---------------------------------------------------------"
374 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME
375 FROM performance_schema.events_waits_history_long
376 WHERE OBJECT_SCHEMA = 'torture'
377 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME,
378 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
379
380 -- echo "---------------------------------------------------------"
381 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA
382 FROM performance_schema.events_statements_history_long
383 WHERE OBJECT_SCHEMA = 'torture'
384 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME,
385 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
386
387 -- echo "---------------------------------------------------------"
388 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
389 LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
390 FROM performance_schema.metadata_locks
391 WHERE OBJECT_SCHEMA = 'torture'
392 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
393 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
394
395 -- echo "---------------------------------------------------------"
396 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
397 FROM performance_schema.table_lock_waits_summary_by_table
398 WHERE OBJECT_SCHEMA = 'torture'
399 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
400 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
401
402 -- echo "---------------------------------------------------------"
403 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
404 FROM performance_schema.table_io_waits_summary_by_table
405 WHERE OBJECT_SCHEMA = 'torture'
406 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
407 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
408
409 -- echo "---------------------------------------------------------"
410 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
411 FROM performance_schema.table_io_waits_summary_by_index_usage
412 WHERE OBJECT_SCHEMA = 'torture'
413 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
414 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
415
416 -- echo "---------------------------------------------------------"
417 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
418 FROM performance_schema.table_handles
419 WHERE OBJECT_SCHEMA = 'torture'
420 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
421 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
422
423 -- echo "---------------------------------------------------------"
424 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
425 FROM performance_schema.objects_summary_global_by_type
426 WHERE OBJECT_SCHEMA = 'torture'
427 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
428 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
429
430 -- echo "---------------------------------------------------------"
431 COMMIT;
432
433 DROP PROCEDURE `torture`.`∀p∊ℙ`;
434 DROP PROCEDURE `torture`.`BroKen`;
435
436 -- error ER_SP_DOES_NOT_EXIST
437 DROP PROCEDURE `torture`.`BroKén`;
438
439 -- error ER_SP_DOES_NOT_EXIST
440 DROP PROCEDURE `torture`.`bRŎKȩn`;
441
442 #
443 # FUNCTION NAME torture
444 #
445
446 TRUNCATE TABLE performance_schema.events_waits_history_long;
447 TRUNCATE TABLE performance_schema.events_statements_history_long;
448
449 DELIMITER $$;
450
451 CREATE FUNCTION `torture`.`∀p∊ℙ`()
452 RETURNS INTEGER
453 BEGIN
454 RETURN 1;
455 END
456 $$
457
458 CREATE FUNCTION `torture`.`BroKen`()
459 RETURNS INTEGER
460 BEGIN
461 RETURN 2;
462 END
463 $$
464
465 -- error ER_SP_ALREADY_EXISTS
466 CREATE FUNCTION `torture`.`BroKén`()
467 RETURNS INTEGER
468 BEGIN
469 RETURN 3;
470 END
471 $$
472
473 -- error ER_SP_ALREADY_EXISTS
474 CREATE FUNCTION `torture`.`bRŎKȩn`()
475 RETURNS INTEGER
476 BEGIN
477 RETURN 4;
478 END
479 $$
480
481 DELIMITER ;$$
482
483 BEGIN;
484
485 SELECT `torture`.`∀p∊ℙ`();
486 SELECT `torture`.`BroKen`();
487 SELECT `torture`.`BroKén`();
488 SELECT `torture`.`bRŎKȩn`();
489
490 -- echo "---------------------------------------------------------"
491 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME
492 FROM performance_schema.events_waits_history_long
493 WHERE OBJECT_SCHEMA = 'torture'
494 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME,
495 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
496
497 -- echo "---------------------------------------------------------"
498 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA
499 FROM performance_schema.events_statements_history_long
500 WHERE OBJECT_SCHEMA = 'torture'
501 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME,
502 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
503
504 -- echo "---------------------------------------------------------"
505 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
506 LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
507 FROM performance_schema.metadata_locks
508 WHERE OBJECT_SCHEMA = 'torture'
509 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
510 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
511
512 -- echo "---------------------------------------------------------"
513 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
514 FROM performance_schema.table_lock_waits_summary_by_table
515 WHERE OBJECT_SCHEMA = 'torture'
516 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
517 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
518
519 -- echo "---------------------------------------------------------"
520 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
521 FROM performance_schema.table_io_waits_summary_by_table
522 WHERE OBJECT_SCHEMA = 'torture'
523 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
524 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
525
526 -- echo "---------------------------------------------------------"
527 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
528 FROM performance_schema.table_io_waits_summary_by_index_usage
529 WHERE OBJECT_SCHEMA = 'torture'
530 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
531 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
532
533 -- echo "---------------------------------------------------------"
534 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
535 FROM performance_schema.table_handles
536 WHERE OBJECT_SCHEMA = 'torture'
537 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
538 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
539
540 -- echo "---------------------------------------------------------"
541 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
542 FROM performance_schema.objects_summary_global_by_type
543 WHERE OBJECT_SCHEMA = 'torture'
544 ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
545 CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
546
547 -- echo "---------------------------------------------------------"
548 COMMIT;
549
550 DROP FUNCTION `torture`.`∀p∊ℙ`;
551 DROP FUNCTION `torture`.`BroKen`;
552
553 -- error ER_SP_DOES_NOT_EXIST
554 DROP FUNCTION `torture`.`BroKén`;
555
556 -- error ER_SP_DOES_NOT_EXIST
557 DROP FUNCTION `torture`.`bRŎKȩn`;
558
559 #
560 # EVENT NAME torture
561 #
562
563 #
564 # TRIGGER NAME torture
565 #
566
567
568 CREATE TABLE test.t1(a int);
569
570 CREATE TRIGGER test.t1_bi_broken BEFORE INSERT ON test.t1
571 FOR EACH ROW BEGIN END;
572
573 # Force the server to execute the trigger,
574 # so it gets instrumented.
575 INSERT INTO test.t1 VALUES (1);
576
577 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
578 FROM performance_schema.events_statements_summary_by_program
579 WHERE OBJECT_SCHEMA='test';
580
581 DROP TRIGGER test.`t1_bi_brokén`;
582
583 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
584 FROM performance_schema.events_statements_summary_by_program
585 WHERE OBJECT_SCHEMA='test';
586
587 DROP TABLE test.t1;
588
589 DROP SCHEMA `torture`;
590
591 UPDATE performance_schema.setup_instruments
592 SET ENABLED='YES' WHERE NAME LIKE "wait/synch/%";
593