MySQL Bugs: #63368: case sensitivity in P

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:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Docs disagree with itself:

http://dev.mysql.com/doc/refman/5.5/en/performance-schema-table-characteristics.html
"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."

http://dev.mysql.com/doc/refman/5.5/en/performance-schema-quick-start.html
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! :-)

Indeed, "uppercase" at http://dev.mysql.com/doc/refman/5.5/en/performance-schema-table-characteristics.html should be fixed, in any case...

See related:

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

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.