| Bug #63339 | Incorrect file path in Performance_schema on Windows | ||
|---|---|---|---|
| Submitted: | 20 Nov 2011 11:58 | Modified: | 9 Apr 2012 2:08 |
| Reporter: | Peter Laursen (Basic Quality Contributor) | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Performance Schema | Severity: | S3 (Non-critical) |
| Version: | 5.5.18 | OS: | Windows |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | qc | ||
[20 Nov 2011 12:04]
Peter Laursen
Edited 'file name' >> 'file path' in synopsis.
[20 Nov 2011 12:46]
Valeriy Kravchuk
Thank you for the problem report. Verified just as described on Windows XP.
[9 Apr 2012 2:08]
Paul DuBois
Noted in 5.5.23, 5.6.6 changelogs. The Performance Schema incorrectly displayed some backslashes in Windows file names (by doubling them).

Description: Double backslashes ("\\") display in file path in P_S tables `file_instances` and `file_summary_by_instance` between last folder in path and file name. Between folders a single backslash is correctly used like DRIVE:\path\to\\file.name (example: C:\ProgramData\MySQL\MySQL Server 5.5\Data\mysql\\db.opt) How to repeat: SELECT * FROM `performance_schema`.`file_instances`; SELECT * FROM `performance_schema`.`file_summary_by_instance`; Suggested fix: DRIVE:\path\to\\file.name should be DRIVE:\path\to\file.name