MySQL Bugs: #52418: Highlight potentially troublesome fieldnames in red in the diagram editor.

Bug #52418	Highlight potentially troublesome fieldnames in red in the diagram editor.
Submitted:	28 Mar 2010 14:55	Modified:	29 Mar 2010 7:42
Reporter:	Pascal Bakhuis	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench	Severity:	S4 (Feature request)
Version:	5.2.16	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Highlight potentially troublesome keywords in red to indicate that's not exactly good practice to use them. This means all the MySQL keywords, which I'm sure you already have somewhere in the program for the syntax highlighter in trigger field.

The highlight could both be done in the 'columns' tab and in the diagram itself. Perhaps provide a tooltip with a link to http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html on mouseover?

How to repeat:
Create a diagram with a table containing a field date of the type DATE (common mistake I tend to make). Now you have a field that could potentially cause some trouble.