Bug #42688 formatted query is missing bits
Submitted: 9 Feb 2009 11:27 Modified: 1 Dec 2009 14:41
Reporter: Daniel Fischer Email Updates:
Status: Closed Impact on me:
Category:MySQL Enterprise Monitor: Web Severity:S3 (Non-critical)
Version: OS:Solaris
Assigned to: Kay Roepke CPU Architecture:Any

[9 Feb 2009 11:27] Daniel Fischer
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"/>

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
[23 Nov 2009 22:02] Enterprise Tools JIRA Robot
Diego Medina writes: 
Verified fixed on
[1 Dec 2009 14:41] MC Brown
A note has been added to the 2.2.0 changelog