MySQL Bugs: #33265: Length on Table Name, Column Name, View Name, etc

Bug #33265	Length on Table Name, Column Name, View Name, etc
Submitted:	16 Dec 2007 0:52	Modified:	15 Mar 2008 12:25
Reporter:	Mike Willbanks	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.0.10 SE Beta	OS:	Windows (XP SP2)
Assigned to:		CPU Architecture:	Any
Tags:	column length, routine length, table length, view length

Description:
Presently when working in the workbench it does not follow the maximum length given from MySQL (http://dev.mysql.com/doc/refman/6.0/en/identifiers.html).  Instead you can create a table name with a massive amount of characters, when this happens it does not display on the canvas (create a table with about a paragraph of characters).

How to repeat:
1. Create a new Table
2. Name the table with a bunch of random letters (holding down the keys for a while helps until it gets drastically large)
3. Create a column the same way
4. You will notice that this does not have a max limit further when you do this, it will not display on the canvas.

Suggested fix:
Implement the max table name, column name, etc from http://dev.mysql.com/doc/refman/6.0/en/identifiers.html.  Many of these are 64 characters in 6.0 and the aliases are 255.

Thank you for the bug report.

this rules also apply to identifiers in 5.0 and 5.1

There were existing checks within validation module for names of tables, procedures, views.
Added following checks for names of column, index, trigger.

the MySQL-Validation Module "Integrity Validation" now checks lengths of column/table/view-names

A note has been added to the 5.15 changelog: 

Identifiers (tables, column, index, triggers and other data types) could be created with names longer than the maximum support by MySQL Server.