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

[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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.