Bug #12059 tables created with the name #sql_xxx are hidden
Submitted: 20 Jul 2005 14:47 Modified: 22 Jul 2005 9:05
Reporter: Max Mether Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0 and 4.1 OS:Any (all)
Assigned to: CPU Architecture:Any

[20 Jul 2005 14:47] Max Mether
Description:
Tables whose name start with #sql_xxx are hidden from SHOW TABLES or INFORMATION_SCHEMA commands

This could also potentially block temporary tables from being created. 

A related bug is #12055

How to repeat:
CREATE TABLE `#sql_test` (a int);
SHOW TABLES;

Suggested fix:
Disallow users from createing, altering or at all accessing tables starting with #sql_
[20 Jul 2005 14:48] Alexander Keremidarski
Verified with 4.1 built from bk tree
ChangeSet@1.2329, 2005-07-20 13:32:43+02:00, georg@lmy002.wdf.sap.corp
[22 Jul 2005 9:05] Georg Richter
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:

duplicate of #1405