SQL Error log entries fail to match or ignore due to special character (4378401)

Customers reported a problem where a sql error alarm would not match or ignore the provided text, example below:

Login failed for user 'spotlight'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]

After extensive testing we have identified the cause of the issue to be the special characters "[" or "]" (square bracket), this has been logged under Defect ID SES-2051.

WORKAROUND:

Replace any squre bracket character "[" or "]" with the "%" (percentage sign) as replacement, this will serve as a wildcard allowing for the match or ignore to happen successfully.

Before:
Login failed for user 'spotlight'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]

After:
Login failed for user 'spotlight'. Reason: Password did not match that for the login provided. %CLIENT: <local machine>%