[
https://issues.apache.org/jira/browse/NIFI-5608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16623489#comment-16623489
]
Pierre Villard commented on NIFI-5608:
--------------------------------------
Had a quick look and seems to be on purpose [1]. [~mattyb149] ?
[1]
https://github.com/apache/nifi/blob/master/nifi-nar-bundles/nifi-standard-bundle/nifi-standard-processors/src/main/java/org/apache/nifi/processors/standard/PutDatabaseRecord.java#L980
> 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)
