MySQL Bugs: #10971: Tables with names beginning with #sql are invisible

Bug #10971	Tables with names beginning with #sql are invisible
Submitted:	30 May 2005 19:51	Modified:	31 May 2005 11:15
Reporter:	Peter Gulutzan	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.7-beta-debug	OS:	Linux (SUSE 9.2)
Assigned to:		CPU Architecture:	Any

Description:
If a table name begins with '#sql', I can't see it with SHOW TABLES or in information_schema.

I am certain that I remember this has been discussed or noted before, somewhere.
However, being unable to search for '#sql*' with the keyword search in bugs.mysql.com,
I am not certain that it was reported before to bugs.mysql.com.

How to repeat:
mysql> create table `#sql1` (s1 int);
Query OK, 0 rows affected (0.01 sec)

mysql> show tables;
+---------------+
| Tables_in_db2 |
+---------------+
| t2            |
| t30           |
| t57           |
| v18           |
+---------------+
4 rows in set (0.00 sec)

Suggested fix:
mysql> create table `#sql` (sq int);
Query OK, 0 rows affected (0.01 sec)

mysql> show tables;
Empty set (0.00 sec)

Thank you for the bug report.

Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

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