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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.