MySQL Bugs: #41259: Minimum > average value shown for the query

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

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.

How easy is this to reproduce? Are you still seeing it?

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

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.

Next step: QA to add test code to check for consistency and add results to this bug report

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

Patch installed in versions => 2.1.0.1014.

Verified fixed on 2.0.5.7151

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.