MySQL Bugs: #48422: Example queries are not correctly reported for prepared statements

Bug #48422	Example queries are not correctly reported for prepared statements
Submitted:	29 Oct 2009 21:21	Modified:	11 Jan 2011 17:47
Reporter:	Diego Medina	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Agent	Severity:	S2 (Serious)
Version:	2.1.0.1093	OS:	Any
Assigned to:	Mark Matthews	CPU Architecture:	Any

Description:
Prepared statements are not being reported properly to the dashboard, you sometimes see the query as canonical, but other times you see just one character, like a letter "S" or "A" as the query text

This shows the text as a single quote
 </datum>
    <datum>
     <target>
      <namespace>mysql</namespace>
      <classname>statement</classname>
      <instance>b9870433-30da-48d6-978f-ac1a921705c1.mem.7fcda3f996ab4b6caf07fc5901c91e56.4</instance>
      <attribute>text</attribute>
     </target>
     <utc>2009-10-29T21:11:28.739Z</utc>
     <value>'</value>
    </datum>

How to repeat:
1- Install and start the service manager and agent
2- Prepared statements using the mysql command line client do not help reproducing the bug, you need to use prepared statements from some other connector, for example java
3- Send some prepared statements
4- Wait for the queries to make it to the dashboard
5- Click on those queries and then on the example tab
6- If the first time you see a normal canonical query (the prepared statement) close that tab and click on the query again, sooner or later you will see the described bug.

Diego Medina writes: 
Verified fixed on 2.2.4.1758

Added to 2.2.4 change log:

Example queries were not being displayed correctly for prepared statements.