Bug #53564 Add "TRANSACTION STATEMENTS" to the list of statement type filters
Submitted: 11 May 2010 12:36 Modified: 24 May 2010 12:33
Reporter: Mark Leith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Web Severity:S3 (Non-critical)
Version:2.2.0.1709 OS:Any
Assigned to: Josh Sled CPU Architecture:Any

[11 May 2010 12:36] Mark Leith
Description:
Split from Bug#53425 / EM-4471. 

We would like to also be able to filter by "all transactional statements" rather than just "COMMIT", or just "ROLLBACK" for example. 

This is a request to implement a "TRANSACTION STATEMENTS" super filter, which filters for the following query types:

BEGIN
START
COMMIT
ROLLBACK
SAVEPOINT
RELEASE

How to repeat:
Try to filter by the above query types at the same time conveniently.. FAIL..
[13 May 2010 14:22] Enterprise Tools JIRA Robot
Josh Sled writes: 
revno: 8076
revision-id: josh.sled@oracle.com-20100513142007-e1run3mq00picbdp
parent: mark.matthews@oracle.com-20100512032331-03yzmhhn2xny9sq6
committer: Josh Sled <josh.sled@oracle.com>
branch nick: 2.2
timestamp: Thu 2010-05-13 10:20:07 -0400
message:
  EM-4482, EM-4246: move statement type list into StatementFilter interface, add some new options including a composite "Transactional Statements" option.  Turn filter l
ist into a list/multi-select at both the UI and StatementFilter level.  Update Selenium tests for multi-select, other improvements.
[13 May 2010 23:37] Enterprise Tools JIRA Robot
Andy Bang writes: 
In build 2.2.1.1718.
[15 May 2010 0:17] Enterprise Tools JIRA Robot
Bill Weber writes: 
verified the Statement Type selection is multi-select and there is a new "Transactional" selection which filters on transaction statements in build 2.2.1.1718
[24 May 2010 12:33] MC Brown
A note has been added to the 2.2.1 changelog: 

        The Query Analyzer now includes                                                                                                                    
        a <literal>Transactional</literal> filter to cover all transaction related statements, in addition to the                                          
        individual statement filters                                                                                                                       
        for <literal>BEGIN</literal>, <literal>START</literal>, <literal>COMMIT</literal>, <literal>ROLLBACK</literal>, <literal>SAVEPOINT</literal>,      
        and <literal>RELEASE</literal>.