Bug #25168 "Incorrect table name" instead of "Identifier too long" if table name > 64 chara

• Submitted: 19 Dec 2006 9:33
• Modified: 5 Jun 2012 16:17
• Reporter: Heinz Schweitzer (Gold Quality Contributor)
• Status: Closed
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: 4.1/5.0/5.1
• OS: Windows (XP/Linux)
• CPU Architecture: Any
• Tags: qc

[19 Dec 2006 9:33] Heinz Schweitzer

Description:
"Incorrect table name" instead of "Identifier too long" error when table name > 64 Characters

MySQL-Server-Information
--------------------------------------------------------------------------------
Mit MySQL-Serverinstanz verbunden
  Benutzername:            root
  Hostname:                localhost
  Port:                    3306
--------------------------------------------------------------------------------
Serverinformation
  MySQL-Version:           MySQL 5.0.24a-community-nt via TCP/IP
  Netzwerkname:            localhost
  IP:                      127.0.0.1
--------------------------------------------------------------------------------
Clientinformation
  Version:                 MySQL Client Version 5.1.11
  Netzwerkname:            XXXXXXXXXXX
  IP:                      XXXXXXXXXXX
  Betriebssystem:          Windows XP
  Hardware:                Intel(R) Pentium(R) M processor 1600MHz, 512 MB RAM

How to repeat:
Open  MySQL Administrator 1.2.8 German version
From Kataloge select a schema you can fool around with
In the schema select a table and say edit

Try to set the table name to a length greater 64 characters.
like in screen shot t1

If you try to save changes you will get an error dialog like 
in screen shot t2

[19 Dec 2006 9:33] Heinz Schweitzer

t1

Attachment: t1.jpg (image/jpeg, text), 100.18 KiB.

[19 Dec 2006 9:33] Heinz Schweitzer

t2

Attachment: t2.jpg (image/jpeg, text), 93.80 KiB.

[19 Dec 2006 12:54] MySQL Verification Team

Thank you for the bug report. This isn't Administrator bug it display
the error message send by the server:

C:\dbs\5.0\bin>mysql -uroot -P3307 test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.27-community-nt-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table t01234567890123456789012345678901234567890123456789012345678901234567890123456789(id serial)
    -> ;
ERROR 1103 (42000): Incorrect table name 't01234567890123456789012345678901234567890123456789012345678901234567890123456789'
mysql> create table t01234567890123456789012345678901234567890123456(id serial);
Query OK, 0 rows affected (0.48 sec)

I changed category.

[5 Jun 2012 16:17] Paul DuBois

Noted in 5.6.6 changelog.

For table or database names that are longer than 64 characters, the
error "Incorrect table name" was returned rather than "Identifier too
long".