Bug #46796 REPLACE / CALL do not have a rows graph in statement popup
Submitted: 18 Aug 2009 21:14 Modified: 18 Jan 2010 13:48
Reporter: Mark Leith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Web Severity:S3 (Non-critical)
Version:2.1.0.1094 OS:Any
Assigned to: MEM Service Manager Devs CPU Architecture:Any

[18 Aug 2009 21:14] Mark Leith 
Description:
The REPLACE and CALL commands does not show a rows graph within the statement popup graph tab, though REPLACE commands do show rows affected within the QUAN overview.

How to repeat:
o Set up agent/proxy etc. and run:

create table test.t1 (i int, j int, primary key (i)); 
insert into test.t1 values (1,2);
replace into test.t1 values (1,2);

Suggested fix:
Track rows affected in a graph for both REPLACE and CALL statements as well.
[19 Aug 2009 18:18] Enterprise Tools JIRA Robot 
Mark Matthews writes: 
Wondering what would happen if we just hard-code "supportsRows" to true for everything? All statements in mysql return rows, or a row count.
[16 Dec 2009 19:43] Enterprise Tools JIRA Robot 
Josh Sled writes: 
revno: 7497
revision-id: jsled@asynchronous.org-20091216192732-kjvsizn5757jvpnw
parent: aggie@sun.com-20091215183738-49vqhxz1948vxruu
committer: Josh Sled <jsled@asynchronous.org>
branch nick: 2.1
timestamp: Wed 2009-12-16 14:27:32 -0500
message:
  EM-3530: add REPLACE, CALL, LOAD DATA and TRUNCATE to the set of "rows supported" queries.
[16 Dec 2009 20:17] Enterprise Tools JIRA Robot 
Josh Sled writes: 
and on 2.2 / trunk:

revno: 7819
revision-id: jsled@asynchronous.org-20091216200354-6vq6csrpch2o3fj2
parent: eric@mysql.com-20091216101405-n159hcpg56tpb7rh
committer: Josh Sled <jsled@asynchronous.org>
branch nick: fix
timestamp: Wed 2009-12-16 15:03:54 -0500
message:
  [merge branches/2.1] EM-3530: add REPLACE, CALL, LOAD DATA and TRUNCATE to the set of "rows supported" queries.
[18 Dec 2009 4:04] Enterprise Tools JIRA Robot 
Keith Russell writes: 
Patch installed in versions => 2.1.1.1131.
[19 Dec 2009 1:12] Enterprise Tools JIRA Robot 
Bill Weber writes: 
diego gets all things proxy :) - looks like this is fixed in both 2.1 and 2.2
[15 Jan 2010 18:59] Enterprise Tools JIRA Robot 
Diego Medina writes: 
Verified fixed on 2.1.1.1131 and 2.2.0.1606
[18 Jan 2010 13:48] MC Brown 
A note has been added to the 2.1.1 and 2.2.0 changelog: 

The <literal>REPLACE</literal> and <literal>CALL</literal> statments did not show a rows graph within the statement popup graph tab.