MySQL Bugs: #71830: Beautify Query only works on valid SQL

Bug #71830	Beautify Query only works on valid SQL
Submitted:	25 Feb 2014 19:03	Modified:	13 Jul 2014 7:49
Reporter:	Mark Pahulje	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench	Severity:	S4 (Feature request)
Version:	6.0.9, 6.1.7	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Beautify Query only works on valid SQL.

If there is any error in the SQL syntax, then it cannot beautified, in the sql  editor window. 

For example, you cannot beautify this, because it is missing a S.
ELECT * FROM wordpress.wp_usermeta;

Can you fix this, since we are trying to correct syntax errors and beautify helps read the SQL we are trying to correct. 

How to repeat:
Paste any invalid sql into the SQL Editor window and try to beautify (ctrl-b) it will not work.

Suggested fix:
Can we beautify regardless if sql syntax is valid. Because the whole point of this is to be able to read SQL to debug it.

Hello Mark,

Thank you for the feature request!

Thanks,
Umesh