Bug #686 MySQL allows a no name fieldname, but will not import it properly
Submitted: 19 Jun 2003 13:58 Modified: 19 Jun 2003 14:10
Reporter: Timothy Crider Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.0-alpha OS:Linux (Red Hat 8.0 / Red Hat 7.3)
Assigned to: CPU Architecture:Any

[19 Jun 2003 13:58] Timothy Crider
When you create a table with a no length field name:

CREATE TABLE `test` ( `` INT(10));

It allows the table to be created but when you try and import, that table (after a dump) it fails.

How to repeat:
CREATE TABLE `test` ( `` INT(10));
DESC `test`;

Suggested fix:
Either disable, no named fields in MySQL, or let the importer allow them.
[19 Jun 2003 14:10] Indrek Siitan
I wasn't able to repeat it neither with 4.1.0 release or the latest BK tree. Trying it yields the same 
results on both:

mysql> CREATE TABLE `test` ( `` INT(10));
ERROR 1166: Incorrect column name ''
[19 Jun 2003 14:25] Timothy Crider
I apologize, The MySQL Version is: