Bug #90595 enhance dragnet conditions to support IN clause
Submitted: 24 Apr 2018 7:50 Modified: 25 Apr 2018 7:18
Reporter: Simon Mudd (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Logging Severity:S4 (Feature request)
Version:8.0.11 OS:Any
Assigned to: CPU Architecture:Any
Tags: dragnet, filter conditions, filtering, logging

[24 Apr 2018 7:50] Simon Mudd
Description:
I couldn't find a category for the dragnet filter? Might be worth adding one?

I already want to filter out several types of messages so have a rule of the form:

dragnet.log_error_filter_rules='IF err_code == 10927 or err_code == 10914 or err_code == 10926 then drop.'

It looks to me that as I find more conditions this is going to make the entry quite long.
I'd like to suggest that you add an "IN clause" so I can do:

dragnet.log_error_filter_rules='IF err_code IN (10927, 10914, 10926) then drop.'

This is easier to read and works better with longer lists.

How to repeat:
See above.

Suggested fix:
Add an IN clause to the condition options described in https://dev.mysql.com/doc/refman/8.0/en/error-log-filtering.html
[25 Apr 2018 7:18] MySQL Verification Team
Hello Simon,

Thank you for the report and feature request!

Thanks,
Umesh