MySQL Bugs: #62308: Preserve formatting on saved views

Bug #62308	Preserve formatting on saved views
Submitted:	31 Aug 2011 8:55	Modified:	20 Sep 2011 14:36
Reporter:	Tjaart Blignaut	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S4 (Feature request)
Version:	5.2.34	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Please make it possible to preserve the original formatting of a query, tabs spaces etc. when selecting alter view. Long queries are difficult to edit on one line and "wrap lines" is insufficient.

Formatting seems to be preserved in routines.

How to repeat:
1. Create a view
2. Format the statements in the view
3. Apply
4. Re-open the view. All formatting changes are lost.

Typos in synopsis

Storage of formatting for views and SPs in the database is not something that depends on Workbench, but of the MySQL server itself, so we cannot fix that in Workbench.

OTOH we can make the Edit -> Format -> Beautify Query command work for the ALTER table editor, so it would at least improve the situation.

my 2 cents: anything would be better than the one line we have to work with when altering a view using MySql Workbench.

Can't this bug be moved to MySql database for a possible fix there? I am used to working in sql server management studio where formatting for everything is preserved. For a really heavy view with about 30 joins working on one line is unrealistic and beautification may not agree with the way different people would like to see their queries formatted. 

At the moment I am formatting my view queries every single time I edit them, which makes a lot of effort just to edit a view.