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

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

Matt Burgess created NIFI-4217:
----------------------------------

             Summary: 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


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)