Bug #50121 QUAN formatting problem (to allow easy cut/paste)
Submitted: 6 Jan 2010 22:12 Modified: 26 Feb 2010 16:53
Reporter: Adam Dixon Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Web Severity:S3 (Non-critical)
Version:2.1.x OS:Any
Assigned to: Kay Roepke CPU Architecture:Any

[6 Jan 2010 22:12] Adam Dixon
Description:
Send a query like this via QUAN;
SELECT * FROM a_a_ AS b_b_, a_a_ AS c_c_ limit 5;

The sample/formatted query gets formatted like this (when pasted);
SELECT *
FROM
a_a_
AS b_b_ , 
a_a_
AS c_c_ 
limit 5;

mysql> SELECT
    -> *
    -> FROM
    -> a_a_AS b_b_ , a_a_AS c_c_
    -> ;
ERROR 1146 (42S02): Table 'test.a_a_AS' doesn't exist
mysql> 

(cant paste in query window due to missing space) The full version is fine.

How to repeat:
See above.

Suggested fix:
Fix formatting.
[19 Feb 2010 18:50] Enterprise Tools JIRA Robot
Josh Sled writes: 
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
[19 Feb 2010 18:50] Enterprise Tools JIRA Robot
Josh Sled writes: 
This is AIB in server build >= 2.2.0.1628
[19 Feb 2010 22:17] Enterprise Tools JIRA Robot
Marcos Palacios writes: 
Verified fixed in Monitor build 2.2.0.1628.
[26 Feb 2010 16:53] MC Brown
A note has been added to the 2.2.0 changelog: 

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