Bug #16649 Edit View Window will not wrap text
Submitted: 19 Jan 2006 20:47 Modified: 3 Aug 2006 13:46
Reporter: Pedro Ruiz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.1.7-1.1.9 OS:Windows (WindowsXP)
Assigned to: Michael G. Zinner CPU Architecture:Any
Tags: Object Editors

[19 Jan 2006 20:47] Pedro Ruiz
Description:
You will notice that the View statement in Administrator is not word wrapped. Even if the window is expanded, the statement will not word wrap. I noticed this in Administrator 1.1.7 on Windows 2000 SP4 and XP SP2. 

Also, you are not able to hit the hot key ctrl-a to copy the whole statement. It will only copy the first 50 characters.

How to repeat:
1. Open Administrator 1.1.7 on either 2000 or XP SP4
2. Click on a schema that has at least one view
3. Click on the view tab.
4. Select a view, then click on Edit View.
You will notice that the statement is not word wrapped. 

Suggested fix:
Word wrap the view statement after pressing Edit View.
[19 Jan 2006 20:49] Pedro Ruiz
A jpeg displaying the described bug.

Attachment: viewnowrap.jpg (image/pjpeg, text), 20.48 KiB.

[20 Jan 2006 8:46] Aleksey Kishkin
mysql admin 1.1.5 works properly. going to test it on latest mysql admin
[20 Jan 2006 13:18] MySQL Verification Team
Thank you for the bug report.
[27 Feb 2006 14:49] Valeriy Kravchuk
Bug #17740 was marked as a duplicate of this one.
[12 May 2006 12:52] MySQL Verification Team
Bug 19751 marked as a duplicate of this
[12 May 2006 12:59] MySQL Verification Team
Bug #16608 marked as a duplicate of this.
[3 Aug 2006 13:45] Vladimir Kolesnikov
Edit window represents text "as is" from the server, so newlines stripping is actually a server limitation. Simple text wrapping (Notepad-style) is not always a good option - as one might have a comment or a string literal wrapped. The thing which is wrong regarding the editor window is that there's no horizontal scroll bar. That's going to be fixed.
[22 Sep 2006 16:56] [ name withheld ]
Should this be reported as a Server bug? New line information for stored procedure is kept on server so the "Edit Procedure" menu item does not have this problem.

The Query Browser "Edit View" can test the SQL length and break the long one line SQL into multiple lines at proper terms such as FROM, WHERE, ORDER BY, LIMIT etc.

Use SHOW CREATE TABLE your_view and SHOW CREATE PROCEDURE your_stored_procedure to see the difference.