[jira] [Assigned] (NIFI-4217) CaptureChangeMySQL DDL lowercases table names

["Matt Burgess (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/NIFI-4217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Matt Burgess reassigned NIFI-4217:
----------------------------------

    Assignee: Matt Burgess

> CaptureChangeMySQL DDL lowercases table names
> ---------------------------------------------
>
>                 Key: NIFI-4217
>                 URL: https://issues.apache.org/jira/browse/NIFI-4217
>             Project: Apache NiFi
>          Issue Type: Bug
>          Components: Extensions
>            Reporter: Matt Burgess
>            Assignee: Matt Burgess
>
> 1. Create a flow to read a database say "db"
> 2. Start the flow
> 3. Create a table "ChangeMysqlCapture" 
> 4. Check the contents of the ChangeMysqlCapture output FF
> Result : The query is completely in lower case
> Example : 
> {code:javascript}
> CREATE TABLE ChangeDataCapture_suaqvkrnlw
> ( uuid int NOT NULL AUTO_INCREMENT PRIMARY KEY,
>   varcharc VARCHAR(255),
>   charc char(50)
> );
> {code}
> Contents of the Flow file
> {code:js}
> {"type":"ddl","timestamp":1500536076000,"binlog_filename":"mysql-bin.000001","binlog_position":351,"database":"nifiqe","table_name":null,"table_id":null,"query":"create table changedatacapture_pvkweznqmo\n( uuid int not null auto_increment primary key,\n varcharc varchar(255),\n charc char(50)\n)"}
> {code}
> The entire query is in lower case as can be found here
> 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#L804



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)