Bug #40736 Trying to alias COMMIT, ROLLBACK, BEGIN et al results in error

• Submitted: 14 Nov 2008 13:08
• Modified: 28 Nov 2008 18:24
• Reporter: Mark Leith
• Status: Closed
• Category: Monitoring: Web
• Severity: S3 (Non-critical)
• Version: 2.0.0.7088
• OS: Any
• Assigned to: Kay Roepke
• Target Version: 2.0 GA

[14 Nov 2008 13:08] Mark Leith

Description:
If you try to "alias" statements such as COMMIT, ROLLBACK, BEGIN, they result in the
following error in the UI:

Can't find template commitTnx.st; group hierarchy is [HTMLFormatting]
org.antlr.stringtemplate.StringTemplateGroup.lookupTemplate(StringTemplateGroup.java:507)

How to repeat:
o Run BEGIN / COMMIT / ROLLBACK through QUAN
o When they show up in the Query Analysis tab, try to "alias" them

Suggested fix:
Add formatting templates for these statements as well

[27 Nov 2008 0:18] Marcos Palacios

Verified fixed in *agent* build 2.0.0.7110.

[28 Nov 2008 18:24] Tony Bedford

Added an entry to the 2.0 changelog:

Attempting to create an alias of statements such as COMMIT, ROLLBACK, BEGIN, resulted in
the error:

Can't find template commitTnx.st; group hierarchy is [HTMLFormatting]
org.antlr.stringtemplate.StringTemplateGroup.lookupTemplate(StringTemplateGroup.java:507)