Bug #48479 Copy/paste from quan ui tab (canonical,formatted) concatenates words with msie 7
Submitted: 2 Nov 2009 16:49 Modified: 26 Feb 2010 16:51
Reporter: Shannon Wade Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Web Severity:S3 (Non-critical)
Version:2.1.0.1093 OS:Windows
Assigned to: Josh Sled CPU Architecture:Any

[2 Nov 2009 16:49] Shannon Wade 
Description:
When copying from the MEM QUAN UI -> canonical or example -> full formatted, then pasting with msie 7 on windows, the paste output concatenates words:

So a query displayed such as this:

SELECT
c1,c2
FROM t1
WHERE c2 = 4

is pasted as:

SELECT
c1,c2
FROMt1
WHEREc2 = 4

OS running dashboard irrelevant, seems like windows tab, space,etc interpretation issue. Doesn't seem to happen with firefox, nor didn't happen when i tested with OSX.

Does not seem to be related to specific queries, I got the behavior with just about anything that was multi-line.

How to repeat:
Use QUAN, go to examine query, copy, paste into anything (notepad,etc). Words will be concatenated.
[18 Feb 2010 20:00] Enterprise Tools JIRA Robot 
Josh Sled writes: 
Whoops.  This was resolved as part of:

revno: 7906
revision-id: jsled@asynchronous.org-20100217203930-9hfov7mvruip7be3
parent: jsled@asynchronous.org-20100217181411-fe10putzen9nn3sc
committer: Josh Sled <jsled@asynchronous.org>
branch nick: local
timestamp: Wed 2010-02-17 15:39:30 -0500
message:
  EM-2882: sanity check html formated sql queries

and in the sql parser source tree:

revno: 119
revision-id: jsled@asynchronous.org-20100216195745-8vx89wt7t8u9igd2
parent: jsled@asynchronous.org-20100216194810-iw4jyf89j7efco2v
committer: Josh Sled <jsled@asynchronous.org>
branch nick: parser
timestamp: Tue 2010-02-16 14:57:45 -0500
message:
  EM-3698: add some forced spaces to the HTML formatting
[18 Feb 2010 20:00] Enterprise Tools JIRA Robot 
Josh Sled writes: 
This is AIB in server build >= 2.2.0.1628
[19 Feb 2010 17:48] Enterprise Tools JIRA Robot 
Marcos Palacios writes: 
Verified fixed in Monitor build 2.2.0.1628.
[26 Feb 2010 16:51] MC Brown 
A note has been added to the 2.2.0 changelog: 

        Cutting and pasting sample queries from Query Analyzer page in                                                                                     
        Microsoft Internet Explorer could lead to bad concatenation of                                                                                     
        the query components.