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

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

    [ https://issues.apache.org/jira/browse/NIFI-5608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16773375#comment-16773375 ] 

Matt Burgess commented on NIFI-5608:
------------------------------------

Not on purpose, copied from ConvertJSONToSQL, I think we can get rid of that.

> 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
>            Priority: Major
>
> 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)