MySQL Bugs: #39261: Recommended Action needs to be escaped for '[' and ']' on a rule

Bug #39261	Recommended Action needs to be escaped for '[' and ']' on a rule
Submitted:	4 Sep 2008 23:48	Modified:	15 Oct 2008 12:55
Reporter:	Marcos Palacios	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Localization	Severity:	S3 (Non-critical)
Version:	2.0.0.7044	OS:	Any
Assigned to:	Andy Bang	CPU Architecture:	Any

Description:
Recommended Action needs to be escaped for '[' and ']' on rule 'Server-Enforced Data Integrity Checking Not Strict'. I renders as:
Recommended Action
SET sql_mode=modes, where modes is a comma-separated list of different modes. 

Looking at the actual resource text it's:

SET [GLOBAL|SESSION] sql_mode=...

I'm not seeing the "[GLOBAL|SESSION]" part.  I'm pretty sure that's because "[" and "]" are Wiki markup that needs to be escaped in order to show up on screen.  I've escaped those in some places, but not others (i.e. not in this one).

How to repeat:
- let the rule fire
- see the result

Fix committed in revision 225 of the advisor repo.  Please test after Keith builds new advisors.

Verified fixed in Advisor version 2.0.0.7046.

An entry was added to the 2.0 changelog:

For the rule “Server-Enforced Data Integrity Checking Not Strict”, the Recommended Action did not display correctly. It displayed as SET sql_mode=modes, rather than SET [GLOBAL|SESSION] sql_mode=modes.