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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.042 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.