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)

Reply via email to