UPDATE performance_schema.setup_instruments
SET ENABLED='NO' WHERE NAME LIKE "wait/synch/%";
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'performance_schema'
  AND COLUMN_NAME LIKE '%SCHEMA%'
  ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME;
TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	COLLATION_NAME
performance_schema	data_locks	OBJECT_SCHEMA	utf8mb4_0900_ai_ci
performance_schema	events_statements_current	CURRENT_SCHEMA	utf8mb4_0900_ai_ci
performance_schema	events_statements_current	OBJECT_SCHEMA	utf8mb4_0900_ai_ci
performance_schema	events_statements_histogram_by_digest	SCHEMA_NAME	utf8mb4_0900_ai_ci
performance_schema	events_statements_history	CURRENT_SCHEMA	utf8mb4_0900_ai_ci
performance_schema	events_statements_history	OBJECT_SCHEMA	utf8mb4_0900_ai_ci
performance_schema	events_statements_history_long	CURRENT_SCHEMA	utf8mb4_0900_ai_ci
performance_schema	events_statements_history_long	OBJECT_SCHEMA	utf8mb4_0900_ai_ci
performance_schema	events_statements_summary_by_digest	SCHEMA_NAME	utf8mb4_0900_ai_ci
performance_schema	events_statements_summary_by_program	OBJECT_SCHEMA	utf8mb4_0900_ai_ci
performance_schema	events_waits_current	OBJECT_SCHEMA	utf8mb4_0900_ai_ci
performance_schema	events_waits_history	OBJECT_SCHEMA	utf8mb4_0900_ai_ci
performance_schema	events_waits_history_long	OBJECT_SCHEMA	utf8mb4_0900_ai_ci
performance_schema	metadata_locks	OBJECT_SCHEMA	utf8mb4_0900_ai_ci
performance_schema	objects_summary_global_by_type	OBJECT_SCHEMA	utf8mb4_0900_ai_ci
performance_schema	prepared_statements_instances	OWNER_OBJECT_SCHEMA	utf8mb4_0900_ai_ci
performance_schema	setup_objects	OBJECT_SCHEMA	utf8mb4_0900_ai_ci
performance_schema	table_handles	OBJECT_SCHEMA	utf8mb4_0900_ai_ci
performance_schema	table_io_waits_summary_by_index_usage	OBJECT_SCHEMA	utf8mb4_0900_ai_ci
performance_schema	table_io_waits_summary_by_table	OBJECT_SCHEMA	utf8mb4_0900_ai_ci
performance_schema	table_lock_waits_summary_by_table	OBJECT_SCHEMA	utf8mb4_0900_ai_ci
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'performance_schema'
  AND COLUMN_NAME LIKE '%OBJECT_NAME%'
  ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME;
TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	COLLATION_NAME
performance_schema	data_locks	OBJECT_NAME	utf8mb4_0900_ai_ci
performance_schema	events_statements_current	OBJECT_NAME	utf8mb4_0900_ai_ci
performance_schema	events_statements_history	OBJECT_NAME	utf8mb4_0900_ai_ci
performance_schema	events_statements_history_long	OBJECT_NAME	utf8mb4_0900_ai_ci
performance_schema	events_statements_summary_by_program	OBJECT_NAME	utf8mb4_0900_ai_ci
performance_schema	events_waits_current	OBJECT_NAME	utf8mb4_0900_ai_ci
performance_schema	events_waits_history	OBJECT_NAME	utf8mb4_0900_ai_ci
performance_schema	events_waits_history_long	OBJECT_NAME	utf8mb4_0900_ai_ci
performance_schema	metadata_locks	OBJECT_NAME	utf8mb4_0900_ai_ci
performance_schema	objects_summary_global_by_type	OBJECT_NAME	utf8mb4_0900_ai_ci
performance_schema	prepared_statements_instances	OWNER_OBJECT_NAME	utf8mb4_0900_ai_ci
performance_schema	setup_objects	OBJECT_NAME	utf8mb4_0900_ai_ci
performance_schema	table_handles	OBJECT_NAME	utf8mb4_0900_ai_ci
performance_schema	table_io_waits_summary_by_index_usage	OBJECT_NAME	utf8mb4_0900_ai_ci
performance_schema	table_io_waits_summary_by_table	OBJECT_NAME	utf8mb4_0900_ai_ci
performance_schema	table_lock_waits_summary_by_table	OBJECT_NAME	utf8mb4_0900_ai_ci
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'performance_schema'
  AND COLUMN_NAME LIKE '%COLUMN%'
  ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME;
TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	COLLATION_NAME
performance_schema	metadata_locks	COLUMN_NAME	utf8mb4_0900_ai_ci
TRUNCATE TABLE performance_schema.events_waits_history_long;
TRUNCATE TABLE performance_schema.events_statements_history_long;
CREATE SCHEMA `BroKen`;
CREATE SCHEMA `BroKén`;
CREATE SCHEMA `bRŎKȩn`;
CREATE SCHEMA `∀p∊ℙ`;
SHOW DATABASES;
Database
BroKen
BroKén
bRŎKȩn
information_schema
mtr
mysql
performance_schema
sys
test
∀p∊ℙ
use `∀p∊ℙ`;
INSERT IGNORE INTO performance_schema.setup_objects VALUES
('TABLE', 'BroKen', '%', 'YES', 'YES'),
('TABLE', 'BroKén', '%', 'YES', 'YES'),
('TABLE', 'bRŎKȩn', '%', 'YES', 'YES'),
('TABLE', '∀p∊ℙ', '%', 'YES', 'YES');
"---------------------------------------------------------"
SELECT * FROM performance_schema.setup_objects
ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	ENABLED	TIMED
EVENT	%	%	YES	YES
EVENT	information_schema	%	NO	NO
EVENT	mysql	%	NO	NO
EVENT	performance_schema	%	NO	NO
FUNCTION	%	%	YES	YES
FUNCTION	information_schema	%	NO	NO
FUNCTION	mysql	%	NO	NO
FUNCTION	performance_schema	%	NO	NO
PROCEDURE	%	%	YES	YES
PROCEDURE	information_schema	%	NO	NO
PROCEDURE	mysql	%	NO	NO
PROCEDURE	performance_schema	%	NO	NO
TABLE	%	%	YES	YES
TABLE	∀p∊ℙ	%	YES	YES
TABLE	broken	%	YES	YES
TABLE	brokén	%	YES	YES
TABLE	brŏkȩn	%	YES	YES
TABLE	information_schema	%	NO	NO
TABLE	mysql	%	NO	NO
TABLE	performance_schema	%	NO	NO
TRIGGER	%	%	YES	YES
TRIGGER	information_schema	%	NO	NO
TRIGGER	mysql	%	NO	NO
TRIGGER	performance_schema	%	NO	NO
"---------------------------------------------------------"
CREATE TABLE `∀p∊ℙ`.`torture`(a int);
CREATE TABLE `BroKen`.`torture`(a int);
CREATE TABLE `BroKén`.`torture`(a int);
CREATE TABLE `bRŎKȩn`.`torture`(a int);
BEGIN;
SELECT * from `∀p∊ℙ`.`torture`;
a
SELECT * from `BroKen`.`torture`;
a
SELECT * from `BroKén`.`torture`;
a
SELECT * from `bRŎKȩn`.`torture`;
a
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME
FROM performance_schema.events_waits_history_long
WHERE OBJECT_NAME = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME,
CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	INDEX_NAME	EVENT_NAME
TABLE	∀p∊ℙ	torture	NULL	wait/io/table/sql/handler
TABLE	∀p∊ℙ	torture	NULL	wait/lock/table/sql/handler
TABLE	broken	torture	NULL	wait/io/table/sql/handler
TABLE	brokén	torture	NULL	wait/io/table/sql/handler
TABLE	brŏkȩn	torture	NULL	wait/io/table/sql/handler
TABLE	broken	torture	NULL	wait/lock/table/sql/handler
TABLE	brokén	torture	NULL	wait/lock/table/sql/handler
TABLE	brŏkȩn	torture	NULL	wait/lock/table/sql/handler
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA
FROM performance_schema.events_statements_history_long
WHERE OBJECT_NAME = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME,
CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	EVENT_NAME	CURRENT_SCHEMA
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
FROM performance_schema.metadata_locks
WHERE OBJECT_NAME = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	LOCK_TYPE	LOCK_DURATION	LOCK_STATUS
TABLE	∀p∊ℙ	torture	SHARED_READ	TRANSACTION	GRANTED
TABLE	broken	torture	SHARED_READ	TRANSACTION	GRANTED
TABLE	brokén	torture	SHARED_READ	TRANSACTION	GRANTED
TABLE	brŏkȩn	torture	SHARED_READ	TRANSACTION	GRANTED
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.table_lock_waits_summary_by_table
WHERE OBJECT_NAME = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
TABLE	∀p∊ℙ	torture
TABLE	broken	torture
TABLE	brokén	torture
TABLE	brŏkȩn	torture
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.table_io_waits_summary_by_table
WHERE OBJECT_NAME = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
TABLE	∀p∊ℙ	torture
TABLE	broken	torture
TABLE	brokén	torture
TABLE	brŏkȩn	torture
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.table_io_waits_summary_by_index_usage
WHERE OBJECT_NAME = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
TABLE	∀p∊ℙ	torture
TABLE	broken	torture
TABLE	brokén	torture
TABLE	brŏkȩn	torture
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.table_handles
WHERE OBJECT_NAME = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
TABLE	∀p∊ℙ	torture
TABLE	broken	torture
TABLE	brokén	torture
TABLE	brŏkȩn	torture
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.objects_summary_global_by_type
WHERE OBJECT_NAME = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
TABLE	∀p∊ℙ	torture
TABLE	broken	torture
TABLE	brokén	torture
TABLE	brŏkȩn	torture
"---------------------------------------------------------"
COMMIT;
DELETE FROM performance_schema.setup_objects
WHERE OBJECT_SCHEMA IN ('BroKen', 'BroKén', 'bRŎKȩn', '∀p∊ℙ');
DROP SCHEMA `BroKen`;
DROP SCHEMA `BroKén`;
DROP SCHEMA `bRŎKȩn`;
DROP SCHEMA `∀p∊ℙ`;
TRUNCATE TABLE performance_schema.events_waits_history_long;
TRUNCATE TABLE performance_schema.events_statements_history_long;
CREATE SCHEMA `torture`;
use `torture`;
INSERT IGNORE INTO performance_schema.setup_objects VALUES
('TABLE', 'torture', 'BroKen', 'YES', 'YES'),
('TABLE', 'torture', 'BroKén', 'YES', 'YES'),
('TABLE', 'torture', 'bRŎKȩn', 'YES', 'YES'),
('TABLE', 'torture', '∀p∊ℙ', 'YES', 'YES');
"---------------------------------------------------------"
SELECT * FROM performance_schema.setup_objects
ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	ENABLED	TIMED
EVENT	%	%	YES	YES
EVENT	information_schema	%	NO	NO
EVENT	mysql	%	NO	NO
EVENT	performance_schema	%	NO	NO
FUNCTION	%	%	YES	YES
FUNCTION	information_schema	%	NO	NO
FUNCTION	mysql	%	NO	NO
FUNCTION	performance_schema	%	NO	NO
PROCEDURE	%	%	YES	YES
PROCEDURE	information_schema	%	NO	NO
PROCEDURE	mysql	%	NO	NO
PROCEDURE	performance_schema	%	NO	NO
TABLE	%	%	YES	YES
TABLE	information_schema	%	NO	NO
TABLE	mysql	%	NO	NO
TABLE	performance_schema	%	NO	NO
TABLE	torture	∀p∊ℙ	YES	YES
TABLE	torture	broken	YES	YES
TABLE	torture	brokén	YES	YES
TABLE	torture	brŏkȩn	YES	YES
TRIGGER	%	%	YES	YES
TRIGGER	information_schema	%	NO	NO
TRIGGER	mysql	%	NO	NO
TRIGGER	performance_schema	%	NO	NO
"---------------------------------------------------------"
CREATE TABLE `torture`.`∀p∊ℙ`(a int);
CREATE TABLE `torture`.`BroKen`(a int);
CREATE TABLE `torture`.`BroKén`(a int);
CREATE TABLE `torture`.`bRŎKȩn`(a int);
BEGIN;
SELECT * from `torture`.`∀p∊ℙ`;
a
SELECT * from `torture`.`BroKen`;
a
SELECT * from `torture`.`BroKén`;
a
SELECT * from `torture`.`bRŎKȩn`;
a
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME
FROM performance_schema.events_waits_history_long
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	INDEX_NAME	EVENT_NAME
TABLE	torture	∀p∊ℙ	NULL	wait/io/table/sql/handler
TABLE	torture	∀p∊ℙ	NULL	wait/lock/table/sql/handler
TABLE	torture	broken	NULL	wait/io/table/sql/handler
TABLE	torture	brokén	NULL	wait/io/table/sql/handler
TABLE	torture	brŏkȩn	NULL	wait/io/table/sql/handler
TABLE	torture	broken	NULL	wait/lock/table/sql/handler
TABLE	torture	brokén	NULL	wait/lock/table/sql/handler
TABLE	torture	brŏkȩn	NULL	wait/lock/table/sql/handler
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA
FROM performance_schema.events_statements_history_long
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	EVENT_NAME	CURRENT_SCHEMA
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
FROM performance_schema.metadata_locks
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	LOCK_TYPE	LOCK_DURATION	LOCK_STATUS
SCHEMA	torture	NULL	INTENTION_EXCLUSIVE	TRANSACTION	GRANTED
TABLE	torture	∀p∊ℙ	SHARED_READ	TRANSACTION	GRANTED
TABLE	torture	broken	SHARED_READ	TRANSACTION	GRANTED
TABLE	torture	brokén	SHARED_READ	TRANSACTION	GRANTED
TABLE	torture	brŏkȩn	SHARED_READ	TRANSACTION	GRANTED
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.table_lock_waits_summary_by_table
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
TABLE	torture	∀p∊ℙ
TABLE	torture	broken
TABLE	torture	brokén
TABLE	torture	brŏkȩn
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.table_io_waits_summary_by_table
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
TABLE	torture	∀p∊ℙ
TABLE	torture	broken
TABLE	torture	brokén
TABLE	torture	brŏkȩn
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.table_io_waits_summary_by_index_usage
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
TABLE	torture	∀p∊ℙ
TABLE	torture	broken
TABLE	torture	brokén
TABLE	torture	brŏkȩn
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.table_handles
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
TABLE	torture	∀p∊ℙ
TABLE	torture	broken
TABLE	torture	brokén
TABLE	torture	brŏkȩn
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.objects_summary_global_by_type
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
TABLE	torture	∀p∊ℙ
TABLE	torture	broken
TABLE	torture	brokén
TABLE	torture	brŏkȩn
"---------------------------------------------------------"
COMMIT;
DELETE FROM performance_schema.setup_objects
WHERE OBJECT_NAME IN ('BroKen', 'BroKén', 'bRŎKȩn', '∀p∊ℙ');
DROP TABLE `torture`.`BroKen`;
DROP TABLE `torture`.`BroKén`;
DROP TABLE `torture`.`bRŎKȩn`;
DROP TABLE `torture`.`∀p∊ℙ`;
TRUNCATE TABLE performance_schema.events_waits_history_long;
TRUNCATE TABLE performance_schema.events_statements_history_long;
CREATE TABLE `torture`.`torture`(
id int,
`∀p∊ℙ` int, `BroKen` int, `BroKén` int, `bRŎKȩn` int,
PRIMARY KEY (`id`),
KEY (`∀p∊ℙ`),
KEY (`BroKen`),
KEY (`BroKén`),
KEY (`bRŎKȩn`)
);
BEGIN;
INSERT INTO `torture`.`torture` VALUES (0, 1, 2, 3, 4);
SELECT * from `torture`.`torture`;
id	∀p∊ℙ	BroKen	BroKén	bRŎKȩn
0	1	2	3	4
SELECT * from `torture`.`torture` USE INDEX (`∀p∊ℙ`) WHERE `∀p∊ℙ` = 1;
id	∀p∊ℙ	BroKen	BroKén	bRŎKȩn
0	1	2	3	4
SELECT * from `torture`.`torture` USE INDEX (`BroKen`) WHERE `BroKen` = 2;
id	∀p∊ℙ	BroKen	BroKén	bRŎKȩn
0	1	2	3	4
SELECT * from `torture`.`torture` USE INDEX (`BroKén`) WHERE `BroKén` = 3;
id	∀p∊ℙ	BroKen	BroKén	bRŎKȩn
0	1	2	3	4
SELECT * from `torture`.`torture` USE INDEX (`bRŎKȩn`) WHERE `bRŎKȩn` = 4;
id	∀p∊ℙ	BroKen	BroKén	bRŎKȩn
0	1	2	3	4
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME
FROM performance_schema.events_waits_history_long
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME,
CONVERT(INDEX_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	INDEX_NAME	EVENT_NAME
TABLE	torture	torture	NULL	wait/io/table/sql/handler
TABLE	torture	torture	NULL	wait/io/table/sql/handler
TABLE	torture	torture	∀p∊ℙ	wait/io/table/sql/handler
TABLE	torture	torture	BroKen	wait/io/table/sql/handler
TABLE	torture	torture	BroKén	wait/io/table/sql/handler
TABLE	torture	torture	bRŎKȩn	wait/io/table/sql/handler
TABLE	torture	torture	PRIMARY	wait/lock/table/sql/handler
TABLE	torture	torture	PRIMARY	wait/lock/table/sql/handler
TABLE	torture	torture	PRIMARY	wait/lock/table/sql/handler
TABLE	torture	torture	PRIMARY	wait/lock/table/sql/handler
TABLE	torture	torture	PRIMARY	wait/lock/table/sql/handler
TABLE	torture	torture	PRIMARY	wait/lock/table/sql/handler
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA
FROM performance_schema.events_statements_history_long
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	EVENT_NAME	CURRENT_SCHEMA
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
FROM performance_schema.metadata_locks
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	LOCK_TYPE	LOCK_DURATION	LOCK_STATUS
SCHEMA	torture	NULL	INTENTION_EXCLUSIVE	TRANSACTION	GRANTED
TABLE	torture	torture	SHARED_WRITE	TRANSACTION	GRANTED
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.table_lock_waits_summary_by_table
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
TABLE	torture	torture
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.table_io_waits_summary_by_table
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
TABLE	torture	torture
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
FROM performance_schema.table_io_waits_summary_by_index_usage
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME,
CONVERT(INDEX_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	INDEX_NAME
TABLE	torture	torture	NULL
TABLE	torture	torture	∀p∊ℙ
TABLE	torture	torture	BroKen
TABLE	torture	torture	BroKén
TABLE	torture	torture	bRŎKȩn
TABLE	torture	torture	PRIMARY
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.table_handles
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
TABLE	torture	torture
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.objects_summary_global_by_type
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
TABLE	torture	torture
"---------------------------------------------------------"
COMMIT;
DROP TABLE `torture`.`torture`;
TRUNCATE TABLE performance_schema.events_waits_history_long;
TRUNCATE TABLE performance_schema.events_statements_history_long;
CREATE PROCEDURE `torture`.`∀p∊ℙ`()
BEGIN
SELECT 1;
END
$$
CREATE PROCEDURE `torture`.`BroKen`()
BEGIN
SELECT 2;
END
$$
CREATE PROCEDURE `torture`.`BroKén`()
BEGIN
SELECT 3;
END
$$
ERROR 42000: PROCEDURE BroKén already exists
CREATE PROCEDURE `torture`.`bRŎKȩn`()
BEGIN
SELECT 4;
END
$$
ERROR 42000: PROCEDURE bRŎKȩn already exists
BEGIN;
CALL `torture`.`∀p∊ℙ`;
1
1
CALL `torture`.`BroKen`;
2
2
CALL `torture`.`BroKén`;
2
2
CALL `torture`.`bRŎKȩn`;
2
2
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME
FROM performance_schema.events_waits_history_long
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	INDEX_NAME	EVENT_NAME
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA
FROM performance_schema.events_statements_history_long
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	EVENT_NAME	CURRENT_SCHEMA
PROCEDURE	torture	∀p∊ℙ	statement/sp/stmt	torture
PROCEDURE	torture	BroKen	statement/sp/stmt	torture
PROCEDURE	torture	BroKen	statement/sp/stmt	torture
PROCEDURE	torture	BroKen	statement/sp/stmt	torture
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
FROM performance_schema.metadata_locks
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	LOCK_TYPE	LOCK_DURATION	LOCK_STATUS
PROCEDURE	torture	∀p∊ℙ	SHARED	TRANSACTION	GRANTED
PROCEDURE	torture	BroKen	SHARED	TRANSACTION	GRANTED
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.table_lock_waits_summary_by_table
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.table_io_waits_summary_by_table
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
FROM performance_schema.table_io_waits_summary_by_index_usage
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	INDEX_NAME
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.table_handles
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.objects_summary_global_by_type
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
PROCEDURE	torture	∀p∊ℙ
PROCEDURE	torture	BroKen
"---------------------------------------------------------"
COMMIT;
DROP PROCEDURE `torture`.`∀p∊ℙ`;
DROP PROCEDURE `torture`.`BroKen`;
DROP PROCEDURE `torture`.`BroKén`;
ERROR 42000: PROCEDURE torture.BroKén does not exist
DROP PROCEDURE `torture`.`bRŎKȩn`;
ERROR 42000: PROCEDURE torture.bRŎKȩn does not exist
TRUNCATE TABLE performance_schema.events_waits_history_long;
TRUNCATE TABLE performance_schema.events_statements_history_long;
CREATE FUNCTION `torture`.`∀p∊ℙ`()
RETURNS INTEGER
BEGIN
RETURN 1;
END
$$
CREATE FUNCTION `torture`.`BroKen`()
RETURNS INTEGER
BEGIN
RETURN 2;
END
$$
CREATE FUNCTION `torture`.`BroKén`()
RETURNS INTEGER
BEGIN
RETURN 3;
END
$$
ERROR 42000: FUNCTION BroKén already exists
CREATE FUNCTION `torture`.`bRŎKȩn`()
RETURNS INTEGER
BEGIN
RETURN 4;
END
$$
ERROR 42000: FUNCTION bRŎKȩn already exists
BEGIN;
SELECT `torture`.`∀p∊ℙ`();
`torture`.`∀p∊ℙ`()
1
SELECT `torture`.`BroKen`();
`torture`.`BroKen`()
2
SELECT `torture`.`BroKén`();
`torture`.`BroKén`()
2
SELECT `torture`.`bRŎKȩn`();
`torture`.`bRŎKȩn`()
2
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME
FROM performance_schema.events_waits_history_long
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	INDEX_NAME	EVENT_NAME
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA
FROM performance_schema.events_statements_history_long
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	EVENT_NAME	CURRENT_SCHEMA
FUNCTION	torture	∀p∊ℙ	statement/sp/freturn	torture
FUNCTION	torture	BroKen	statement/sp/freturn	torture
FUNCTION	torture	BroKen	statement/sp/freturn	torture
FUNCTION	torture	BroKen	statement/sp/freturn	torture
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
FROM performance_schema.metadata_locks
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	LOCK_TYPE	LOCK_DURATION	LOCK_STATUS
FUNCTION	torture	∀p∊ℙ	SHARED	TRANSACTION	GRANTED
FUNCTION	torture	BroKen	SHARED	TRANSACTION	GRANTED
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.table_lock_waits_summary_by_table
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.table_io_waits_summary_by_table
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
FROM performance_schema.table_io_waits_summary_by_index_usage
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME	INDEX_NAME
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.table_handles
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
"---------------------------------------------------------"
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.objects_summary_global_by_type
WHERE OBJECT_SCHEMA = 'torture'
  ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin;
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
FUNCTION	torture	∀p∊ℙ
FUNCTION	torture	BroKen
"---------------------------------------------------------"
COMMIT;
DROP FUNCTION `torture`.`∀p∊ℙ`;
DROP FUNCTION `torture`.`BroKen`;
DROP FUNCTION `torture`.`BroKén`;
ERROR 42000: FUNCTION torture.BroKén does not exist
DROP FUNCTION `torture`.`bRŎKȩn`;
ERROR 42000: FUNCTION torture.bRŎKȩn does not exist
CREATE TABLE test.t1(a int);
CREATE TRIGGER test.t1_bi_broken BEFORE INSERT ON test.t1
FOR EACH ROW BEGIN END;
INSERT INTO test.t1 VALUES (1);
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.events_statements_summary_by_program
WHERE OBJECT_SCHEMA='test';
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
TRIGGER	test	t1_bi_broken
DROP TRIGGER test.`t1_bi_brokén`;
SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
FROM performance_schema.events_statements_summary_by_program
WHERE OBJECT_SCHEMA='test';
OBJECT_TYPE	OBJECT_SCHEMA	OBJECT_NAME
DROP TABLE test.t1;
DROP SCHEMA `torture`;
UPDATE performance_schema.setup_instruments
SET ENABLED='YES' WHERE NAME LIKE "wait/synch/%";