Bug #151 MySQL accepts empty table names
Submitted: 14 Mar 2003 6:43 Modified: 19 Mar 2003 11:48
Reporter: Alexander Keremidarski Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:all OS:
Assigned to: Michael Widenius CPU Architecture:Any

[14 Mar 2003 6:43] Alexander Keremidarski 
Description:
Table can be created and used with empty name.
As a result database contains files like

-rw-rw----    1 mysql     mysql         8548 Mar 14 15:50 .frm
-rw-rw----    1 mysql     mysql            5 Mar 14 15:50 .MYD
-rw-rw----    1 mysql     mysql         1024 Mar 14 15:50 .MYI

It works with both MyISAM and InnoDB tables.

How to repeat:
create table `` (a int);
insert into `` values(1);
select * from `` where a = 1;
+------+
| a    |
+------+
|    1 |
+------+
1 row in set (0.03 sec)

update `` set a=11;

select * from `` as a, `` as b;
+------+------+
| a    | a    |
+------+------+
|   11 |   11 |
+------+------+

drop table ``;
[19 Mar 2003 11:48] Michael Widenius 
Thank you for your bug report. This issue has been fixed in the latest
development tree for that product. You can find more information about
accessing our development trees at 
    http://www.mysql.com/doc/en/Installing_source_tree.html