Bug #42688 formatted query is missing bits

• Submitted: 9 Feb 2009 11:27
• Modified: 1 Dec 2009 14:41
• Reporter: Daniel Fischer
• Status: Closed
• Category: MySQL Enterprise Monitor: Web
• Severity: S3 (Non-critical)
• Version: 2.1.0.1007
• OS: Solaris
• Assigned to: Kay Roepke
• CPU Architecture: Any

[9 Feb 2009 11:27] Daniel Fischer

Description:
I have the following query:

SELECT file_id , archive_path FROM archive WHERE file_date < DATE_SUB( NOW( ) , INTERVAL ? DAY )

The formatted version of it is this:

SELECT file_id , archive_path FROM archive WHERE

With the part after WHERE missing.

The HTML code for this bit appears to look as follows:

<div class="expr">
<div class="expr"/>
</div>

How to repeat:
Make sure your monitor sees a query like the above, then look at it in the Quan web interface.

[18 Sep 2009 11:00] Enterprise Tools JIRA Robot

Kay Roepke writes: 
the grammar rule for the DATE_SUB function had a stray double left parens token, making it fail.

[23 Nov 2009 21:57] Enterprise Tools JIRA Robot

Andy Bang writes: 
This is in build 2.2.0.1547.

[23 Nov 2009 22:02] Enterprise Tools JIRA Robot

Diego Medina writes: 
Verified fixed on 2.2.0.1547

[1 Dec 2009 14:41] MC Brown

A note has been added to the 2.2.0 changelog