You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@nifi.apache.org by "eric twilegar (JIRA)" <ji...@apache.org> on 2018/09/19 16:27:00 UTC

[jira] [Created] (NIFI-5608) PutDatabaseRecord will remove _s in update keys if translate columns is true

eric twilegar created NIFI-5608:
-----------------------------------

             Summary: PutDatabaseRecord will remove _s in update keys if translate columns is true
                 Key: NIFI-5608
                 URL: https://issues.apache.org/jira/browse/NIFI-5608
             Project: Apache NiFi
          Issue Type: Bug
            Reporter: eric twilegar


I had a table where the columns names where all defined lower case.

In the nifi records it was mixed case and sort of all over the place.

translate was working well, but then i added a column with an "_" in it.

So a column like my_id which was part of the primary key and so was used the as the WHERE clause in the update statement. So the where clause was "WHERE myid = 5" vs "WHERE my_id =5"



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)