Bug #27356 Text appears on one line in the pop-up editor
Submitted: 21 Mar 2007 19:42 Modified: 22 Mar 2007 16:30
Reporter: Peter Lavin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.2.10 OS:Linux (Linux)
Assigned to: CPU Architecture:Any
Tags: pop-up editor

[21 Mar 2007 19:42] Peter Lavin 
Description:
Text such as the following, appears all on one line when using the pop-up editor:

CREATE ALGORITHM=UNDEFINED DEFINER=`peter`@`%` SQL SECURITY DEFINER VIEW `vwOrphanedAccreditations` AS select `tma`.`accreditationacronym` AS `accreditationacronym`,`tma`.`memberid` AS `memberid`,`tma`.`certificationnumber` AS `certificationnumber`,`tma`.`expirydate` AS `expirydate` from (`tblmemberaccreditations` `tma` left join `tblmembers` `t` on((`tma`.`memberid` = `t`.`id`))) where isnull(`t`.`id`)

Under Windows there are line feeds to break up long lines like this.

How to repeat:
Do SHOW CREATE TABLE on a large table and look at the results in the pop-up editor.

Suggested fix:
See above.
[22 Mar 2007 16:30] Peter Lavin 
I've just looked at this again and it seems that the appearance of the text is determined by the format of the SQL used to create the table in the first place. Format it nicely when you create a table, and SHOW CREATE TABLE will give it back to you nicely formatted. 

I'm going to close this "bug" but I I'll also add a comment to the docs.