| 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: | |
| Category: | MySQL Enterprise Monitor: Web | Severity: | S3 (Non-critical) |
| Version: | 2.1.x | OS: | Any |
| Assigned to: | Kay Roepke | CPU Architecture: | Any |
[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.

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.