Bug #38137 Line-breaks in View definition not kept
Submitted: 15 Jul 2008 14:02 Modified: 28 May 2009 12:48
Reporter: Kai Sautter (Basic Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.12 OS:Windows (Xp SP3)
Assigned to: CPU Architecture:Any

[15 Jul 2008 14:02] Kai Sautter 
Description:
Line breaks made when defining a view using MySQL Administrator are not kept, i.e. if the view is edited later, the definition is displayed as one long line, which is very difficult to edit.

The same applies to the edit view functionality in Query Browser.

How to repeat:
Create a view using MySQL Administrator and write the definition using line breaks. If you edit the view, the definition is all in one line.

Suggested fix:
It might be an option to simply break lines after each field and certain key words/phrases like "CREATE VIEW xyz AS" or "WHERE" instead of storing information on line breaks.
[15 Jul 2008 15:09] MySQL Verification Team 
Thank you for the bug report.
[16 Feb 2009 6:26] Jared S 
Duplicate of http://bugs.mysql.com/bug.php?id=5159
[28 May 2009 12:48] Susanne Ebrecht 
This is a duplicate of bug #5159