[jira] [Created] (NIFI-3749) CaptureChangeMySQL should filter Query and XID events by database regex

["Koji Kawamura (JIRA)" <ji...@apache.org>]

Koji Kawamura created NIFI-3749:
-----------------------------------

             Summary: CaptureChangeMySQL should filter Query and XID events by database regex
                 Key: NIFI-3749
                 URL: https://issues.apache.org/jira/browse/NIFI-3749
             Project: Apache NiFi
          Issue Type: Bug
          Components: Extensions
    Affects Versions: 1.2.0
            Reporter: Koji Kawamura


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.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)