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
Triage: D3 (Medium) / R2 (Low) / E2 (Low)

[4 Sep 2008 23:48] Marcos Palacios
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
[4 Sep 2008 23:55] Andy Bang
Fix committed in revision 225 of the advisor repo.  Please test after Keith builds new advisors.
[5 Sep 2008 19:51] Marcos Palacios
Verified fixed in Advisor version 2.0.0.7046.
[15 Oct 2008 12:55] Tony Bedford
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.