MySQL Bugs: #41968: QUAN Query Type filter for SELECT ignores statements starting with parenthesis

Bug #41968	QUAN Query Type filter for SELECT ignores statements starting with parenthesis
Submitted:	8 Jan 2009 14:54	Modified:	6 Mar 2009 16:17
Reporter:	Mark Leith	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Agent	Severity:	S3 (Non-critical)
Version:	2.0.1.7125	OS:	Any
Assigned to:	MC Brown	CPU Architecture:	Any
Tags:	mem_20_maint

Description:
If you send a statement through QUAN starting with parenthesis, such as:

(SELECT 1 FROM dual);

Then try to filter for SELECT queries only, any queries starting with parenthesis are filtered away incorrectly. 

How to repeat:
o Set up MEM with QUAN
o Run "(SELECT 1 FROM dual)" through the proxy port
o View the period with the select in the UI
o Filter "Query Type" to SELECT

Suggested fix:
Strip/ignore leading parenthesis when filtering.

Committed and pushed to trunk and rel-2.0

revno: 1226
committer: jan@mysql.com
branch nick: rel-2.0
timestamp: Tue 2009-03-03 15:47:05 +0100
message:
  take the first token that is starting with a [:alpha:] (fixes #41968)

revno: 1217
committer: jan@mysql.com
branch nick: trunk
timestamp: Tue 2009-03-03 15:37:14 +0100
message:
  take the first token that is starting with a [:alpha:] (fixes #41968)

Patch installed in versions => 2.0.5.7150.

Verified fixed on 2.0.5.7151

An entry was added to the 2.0.5 changelog:

Query Analyzer's Query Type filter for SELECT ignored statements starting with parenthesis.

If you sent a statement through Query Analyzer starting with parenthesis, such as:

(SELECT 1 FROM dual);

and then attempted to filter for SELECT queries only, queries starting with parenthesis were not displayed.