[ https://issues.apache.org/jira/browse/NIFI-5342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tanapol Nearunchorn updated NIFI-5342: -------------------------------------- Description: CaptureChangeMySQL didn't escape database name as you can see: [https://github.com/apache/nifi/blob/master/nifi-nar-bundles/nifi-cdc/nifi-cdc-mysql-bundle/nifi-cdc-mysql-processors/src/main/java/org/apache/nifi/cdc/mysql/processors/CaptureChangeMySQL.java#L1003] And also with the line 1004, which query from a table. It can cause problems when there is database or table name that contains a reserved keyword. was: CaptureChangeMySQL didn't escape database name as you can see: [https://github.com/apache/nifi/blob/master/nifi-nar-bundles/nifi-cdc/nifi-cdc-mysql-bundle/nifi-cdc-mysql-processors/src/main/java/org/apache/nifi/cdc/mysql/processors/CaptureChangeMySQL.java#L1003] It cause problem when there using with database that contains reserved keyword. > CaptureChangeMySQL didn't escape database name > ---------------------------------------------- > > Key: NIFI-5342 > URL: https://issues.apache.org/jira/browse/NIFI-5342 > Project: Apache NiFi > Issue Type: Bug > Components: Core Framework > Affects Versions: 1.6.0 > Reporter: Tanapol Nearunchorn > Priority: Major > > CaptureChangeMySQL didn't escape database name as you can see: > [https://github.com/apache/nifi/blob/master/nifi-nar-bundles/nifi-cdc/nifi-cdc-mysql-bundle/nifi-cdc-mysql-processors/src/main/java/org/apache/nifi/cdc/mysql/processors/CaptureChangeMySQL.java#L1003] > > And also with the line 1004, which query from a table. > It can cause problems when there is database or table name that contains a > reserved keyword. -- This message was sent by Atlassian JIRA (v7.6.3#76005)