MySQL Bugs: #38179: Query text does not include line breaks in IE

Bug #38179	Query text does not include line breaks in IE
Submitted:	16 Jul 2008 16:39	Modified:	30 Jul 2008 21:53
Reporter:	Andy Bang	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Web	Severity:	S3 (Non-critical)
Version:	2.0.0.7006	OS:	Windows
Assigned to:	Kay Roepke	CPU Architecture:	Any

Description:
When you look at a formatted query in the Summary Details popup off the Query Analysis tab in Microsoft Internet Explorer, it's just one big honkin' line of text that forces horizontal scroll bars.  In Firefox it looks just fine.  I'll attach some screen shots.

How to repeat:
1) Start Quan.
2) Go to Query Analysis tab.
3) Find a query that you know will be fairly long in the table and click on it to see the details.
4) In FF it looks good, but in IE it does not.

Suggested fix:
Include line breaks in IE.

Screen shot from Firefox

Attachment: QueryDetailsFF.png (image/x-png, text), 71.93 KiB.

Screen shot from Internet Explorer

Attachment: QueryDetailsIE.png (image/x-png, text), 56.18 KiB.

Possibly related to Bug #36885, QUAN popup shows wrong 'formatted' SQL / nothing if it's a short statement (http://bugs.mysql.com/bug.php?id=36885), but I don't think so.

Currently the formatted query contains literal newlines and is wrapped in <pre> tags.
I'd like to move to a more "civilized" version of it, using divs. That would make both the rendering cleaner, and more customizable (we could for instance have UI elements that highlight certain portions, e.g."show all functions", or modify the indentation on the fly.

It would also allow for user-friendly features like collapsing subqueries and the like.

Verified fixed on ver. 2.0.0.7017.