MySQL Bugs: #42317: mysql extensions documentation page wrong

Bug #42317	mysql extensions documentation page wrong
Submitted:	24 Jan 2009 0:48	Modified:	28 Jan 2009 0:08
Reporter:	Sheeri Cabral (Candidate Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S5 (Performance)
Version:	5.1, 6.0	OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any
Tags:	identifiers, qc

Description:
The manual (http://dev.mysql.com/doc/refman/6.0/en/extensions-to-ansi.html and the 5.1 page too) says " Database and table names cannot contain path name separator characters (“/”, “\”). "

How to repeat:
look at the manual page...

But this is not true for MySQL versions 5.1 and up, as they have escaped database names:

mysql> SELECT @@version;
+-------------+
| @@version   |
+-------------+
| 6.0.8-alpha | 
+-------------+
1 row in set (0.00 sec)

mysql> drop TABLE `foo/bar\baz`;
ERROR 1051 (42S02): Unknown table 'foo/bar\baz'
mysql> CREATE TABLE `foo/bar\baz` (id int);
Query OK, 0 rows affected (0.07 sec)

mysql> select * from `foo/bar\baz`;
Empty set (0.00 sec)

On disk, the table names look like this:

foo@002fbar@005cbaz.frm
foo@002fbar@005cbaz.MYI
foo@002fbar@005cbaz.MYD

Databases are handled similarly.

Suggested fix:
fix the 5.1 and 6.0 documentation.

Thank you for the problem report.

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.

This change occurred in MySQL 5.1.6:
http://dev.mysql.com/doc/refman/5.1/en/identifier-mapping.html

I made the extensions paragraph in the 5.1 manual version-specific and removed the paragraph in the 6.0 manual.