Bug #105326 system view will be invalid with special characters table name
| Submitted: | 26 Oct 2021 12:13 | Modified: | 26 Oct 2021 12:42 |
|---|---|---|---|
| Reporter: | yi qian | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: SYS Schema | Severity: | S3 (Non-critical) |
| Version: | 8.0.25, 5.7.36 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | sys.x$ps_schema_table_statistics_io | ||
[26 Oct 2021 12:42]
MySQL Verification Team
Hello yi qian, Thank you for the report and test case. Verified as described with 5.7.36 build. regards, Umesh
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: System view sys.x$ps_schema_table_statistics_io will be invalid when statistics tables with special characters. This is because the view takes `FILE_NAME` of table performance_schema.file_summary_by_instance as table_name. However, for table whicn table name has special characters, file name and table name are inconsistent and have been converted. This will lead to sys.x$ps_schema_table_statistics_io invalid when statistics tables with special characters. How to repeat: 1.prepare data: mysql> create database testdb; Query OK, 1 row affected (0.01 sec) mysql> use testdb; Database changed mysql> create table `t`(id int not null); Query OK, 0 rows affected (0.61 sec) mysql> create table `t#`(id int not null); Query OK, 0 rows affected (0.66 sec) 2.When the table name does not contain special characters: mysql> select * from `sys`.`x$ps_schema_table_statistics_io` where table_name = 't'\G *************************** 1. row *************************** table_schema: testdb table_name: t count_read: 0 sum_number_of_bytes_read: 0 sum_timer_read: 0 count_write: 7 sum_number_of_bytes_write: 212992 sum_timer_write: 1088754668 count_misc: 6 sum_timer_misc: 1015060064 1 row in set (0.07 sec) 3.When the table name contain special characters: mysql> select * from `sys`.`x$ps_schema_table_statistics_io` where table_name = 't#'\G Empty set (0.07 sec)