[NIFI-3749] CaptureChangeMySQL should filter Query and XID events by database regex

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Fix Version/s: 1.2.0
• Component/s: Extensions
• Assignee: Matt Burgess
• Reporter: Koji Kawamura
• Created: 27/Apr/17 01:25
• Updated: 28/Apr/17 04:21
• Resolved: 28/Apr/17 04:21

Description

Although Query events including BEGIN/COMMIT and DDL statements do not have corresponding TableMap event, they still have 'database' name. So, it's possible to apply 'database' filter regex to filter out unnecessary events.

Currently, Queries executed against a database which is not in interest can generate FlowFiles, and it can cause unexpected behavior.

When we fix this, we should be careful about XID event and 'inTransaction' flag as XID event only has transaction id, we may need to add checking 'skipTable', too.

Also, we need to pass database to DDLEventInfo.tableInfo to write database name into outgoing FlowFile.

Finally, Begin/CommitTransactionEventInfo currently don't have database property or TableInfo in it. Adding database property to these class might be a right approach.

Issue Links

• links to: GitHub Pull Request #1708