Bug #63368 case sensitivity in P_S
Submitted: 21 Nov 2011 19:09 Modified: 8 Dec 2011 3:34
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[21 Nov 2011 19:09] Peter Laursen
Docs disagree with itself:

"The database name performance_schema is lowercase. The names of tables in the database are uppercase. Normal case sensitivity rules apply, so on systems with case-sensitive file names, the database name and table names must be specified in the lettercase just indicated. This behavior can be modified by setting the lower_case_table_names system variable."

The name of the performance_schema database is lowercase, as are the names of tables within it. Queries should specify the names in lowercase. .. Before MySQL 5.5.8, the table names were uppercase, which caused problems on some systems for certain values of the lower_case_table_names system variable"

1st quote is wrong as regards lettercase of PS_tables.  2nd quote is wrong as regards "Queries should specify the names in lowercase" (even though 'should be' is a *softened* variant of 'must be')

Also see: http://bugs.mysql.com/bug.php?id=63341

How to repeat:
yes! :-)

Suggested fix:
yes! :-)
[21 Nov 2011 19:19] Valeriy Kravchuk
Indeed, "uppercase" at http://dev.mysql.com/doc/refman/5.5/en/performance-schema-table-characteristics.html should be fixed, in any case...
[29 Nov 2011 18:28] Marc ALFF
See related:

[8 Dec 2011 3:34] Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.