Bug #36715 No error message by naming a database #mysql# ....
Submitted: 14 May 2008 15:01 Modified: 14 May 2008 15:57
Reporter: Susanne Ebrecht Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:5.1-bk OS:Any
Assigned to: CPU Architecture:Any

[14 May 2008 15:01] Susanne Ebrecht 
Description:
create database "#mysql#something";

You don't get an error message. You also can make a SHOW DATABASES and will see the database its only not stored on file system.

The bug here is only the missing error message.

Tested on Ext3, UFS, ZFS

How to repeat:
See above.

Suggested fix:
Make an error message that identifier #mysql# isn't allowed.
[14 May 2008 15:19] Susanne Ebrecht 
Sorry, I made a typo here.

Create database "#mysql50#bla";

Here is documentation:
http://dev.mysql.com/doc/refman/5.1/en/identifier-mapping.html

The #mysql50# prefix is intended only to be used internally by the server. You should not create databases or tables with names that use this prefix.
[14 May 2008 15:57] Susanne Ebrecht 
Sorry, for confusion.

This is not a bug and I will close it.