Bug #40676 Query Analyzer "formatted" display incorrect for queries with "inner join"
Submitted: 12 Nov 2008 20:25 Modified: 1 Dec 2009 14:44
Reporter: Craig Sylvester Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Web Severity:S3 (Non-critical)
Version:2.0.0.7078, 2.0.0.7092 OS:MacOS (10.5.5)
Assigned to: Kay Roepke CPU Architecture:Any
Tags: formatter, INNER JOIN, query analyzer, sqlparser

[12 Nov 2008 20:25] Craig Sylvester 
Description:
Using the Query Analysis functionality, when displaying SELECT queries with INNER JOIN as part of the syntax, the "formatted" display of the query is incorrect.

How to repeat:
Install MEM 2.0
Install agent
Using the World database, enter:
  select c1.name as City, c2.name as Country
  from city c1 inner join country c2 on c1.countrycode = c2.code;
Display the query in Query Analyzer. Choose Formatted option.
Displays as:

SELECT
    c1.name AS City,
    c2.name AS Country
FROM
    City
    AS c1 INNER JOIN
    country
    AS c2 JOIN
    country
    AS c2 ON c1.CountryCode = c2.Code

Suggested fix:
Correct display error.
[14 Nov 2008 19:01] Valeriy Kravchuk 
Thank you for a bug report. Verified just as described with a newer version.
[17 Sep 2009 17:13] Enterprise Tools JIRA Robot 
Kay Roepke writes: 
this was purely a html template problem. there was wrongly nested if statement.
[23 Nov 2009 22:02] Enterprise Tools JIRA Robot 
Andy Bang writes: 
This is in build 2.2.0.1547.
[24 Nov 2009 19:17] Enterprise Tools JIRA Robot 
Diego Medina writes: 
Verified fixed on 2.2.0.1547
[1 Dec 2009 14:44] MC Brown 
An entry has been added to the 2.2.0 changelog
[1 Dec 2009 14:50] MC Brown 
An entry has been added to the 2.2.0 changelog