Bug #41259 Minimum > average value shown for the query
Submitted: 5 Dec 2008 13:36 Modified: 9 Mar 2009 17:07
Reporter: Simon Mudd (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Agent Severity:S3 (Non-critical)
Version:2.0.0.7101 OS:Any
Assigned to: MC Brown CPU Architecture:Any
Tags: mem_20_maint

[5 Dec 2008 13:36] Simon Mudd
Description:
Go to the query analysis page and click on a query. The minimum is greater than the average! That must be wrong.

How to repeat:
Go to the query analysis page and click on a query. The minimum is greater than the average! That must be wrong.

Suggested fix:
Check the values being shown, probably just exchange the 2.
[6 Jan 2009 17:07] Gary Whizin
How easy is this to reproduce? Are you still seeing it?
[7 Jan 2009 10:23] Simon Mudd
Hi Gary, this seems to be fixed now. I'll privately upload a copy of the same query that was giving a problem before which appears to be shown properly.

Note: we're using agent 2.0.0.7111 and server: 2.0.1.7125
[16 Jan 2009 18:01] Diego Medina
We are unable to reproduce this bug consistently, but we have seen some cases where the values are not correct.

We are working on a better implementation of the agent where this situation will be drastically reduced.
[27 Feb 2009 17:23] Gary Whizin
Next step: QA to add test code to check for consistency and add results to this bug report
[4 Mar 2009 19:06] Jan Kneschke
Committed and Pushed to rel-2.0 and trunk/

revno: 1229
committer: jan@mysql.com
branch nick: rel-2.0
timestamp: Wed 2009-03-04 20:05:37 +0100
message:
  fixed the rolling min() and max() functions (fixes #41259)
  
    * added test-cases 
    * fixed not-working min/max

revno: 1220
committer: jan@mysql.com
branch nick: trunk
timestamp: Wed 2009-03-04 20:00:08 +0100
message:
  fixed the rolling min() and max() functions (fixes #41259)
  
    * added test-cases 
    * fixed not-working min/max
[9 Mar 2009 15:53] Keith Russell
Patch installed in versions => 2.1.0.1014.
[9 Mar 2009 16:18] Diego Medina
Verified fixed on 2.0.5.7151
[9 Mar 2009 17:07] Tony Bedford
An entry was added to the 2.0.5 changelog:

On the Query Analysis page, if a query was clicked the minimum displayed was greater than the average.