[ 
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)

Reply via email to