MySQL Bugs: #45087: Table or column names are truncated to 64 characters

Bug #45087	Table or column names are truncated to 64 characters
Submitted:	26 May 2009 7:11	Modified:	26 May 2009 7:26
Reporter:	Peter Lieverdink	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.51a	OS:	Linux (Ubuntu 8.04 LTS (amd64))
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
MySQL truncates tablename.columnname to 64 characters when displaying an error.

How to repeat:
mysql> CREATE TABLE t1 (i INT UNSIGNED NOT NULL);

mysql> INSERT INTO t1 VALUES(1);

mysql> SELECT abcdefghijlkmnopqrstuvwxyz01234567890.abcdefghijlkmnopqrstuvwxyz01234567890 AS foo FROM t1;
ERROR 1054 (42S22): Unknown column 'abcdefghijlkmnopqrstuvwxyz01234567890.abcdefghijlkmnopqrstuvwxyz' in 'field list'

Suggested fix:
Do not truncate the table or column name.

Thank you for the report.

According to http://dev.mysql.com/doc/refman/5.0/en/identifiers.html maximum length of column name is 64 characters. so closing as "Not a Bug"