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

• Submitted: 5 Sep 2008 1:48
• Modified: 15 Oct 2008 14:55
• Reporter: Marcos Palacios
• Status: Closed
• Category: Monitoring: Localization
• Severity: S3 (Non-critical)
• Version: 2.0.0.7044
• OS: Any
• Assigned to: Andy Bang
• Triage: D3 (Medium) / R2 (Low) / E2 (Low)

[5 Sep 2008 1: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

[5 Sep 2008 1:55] Andy Bang

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

[5 Sep 2008 21:51] Marcos Palacios

Verified fixed in Advisor version 2.0.0.7046.

[15 Oct 2008 14: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.