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
• Status: Can't repeat
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 4.1.0-alpha
• OS: Linux (Red Hat 8.0 / Red Hat 7.3)
• CPU Architecture: Any

[19 Jun 2003 13:58] Timothy Crider

Description:
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:

3.23.53a