[
https://issues.apache.org/jira/browse/NIFI-6483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16919545#comment-16919545
]
HondaWei commented on NIFI-6483:
--------------------------------
I traced the code, it still failed even though set "Translate Field Names" to
false due to case-sensitive comparison of column name comparison.
> Apache Nifi (version 1.9.2) error when update data in a table (SQL server,
> MySQL, Postgresql) (it is running well with insert and update operations)
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: NIFI-6483
> URL: https://issues.apache.org/jira/browse/NIFI-6483
> Project: Apache NiFi
> Issue Type: Bug
> Components: Configuration
> Affects Versions: 1.9.2
> Environment: error when update data in a table (SQL server, MySQL,
> Postgresql) (it is running well with insert and update operations)
> Reporter: thuy le
> Priority: Major
> Attachments: image-2019-07-25-11-32-19-469.png
>
>
> Apache Nifi (version 1.9.2) error when update data in a table (SQL server,
> MySQL, Postgresql) (it is running well with insert and update operations)
>
> !https://community.hortonworks.com/storage/attachments/110025-1563909312644.png|width=736,height=242!
>
> _With Delete they do correct_
> !https://community.hortonworks.com/storage/attachments/110007-1563910599280.png|width=932,height=127!
> !https://community.hortonworks.com/storage/attachments/110013-1563910653675.png|width=828,height=156!
>
>
> *+with Update+*_: They automatic change Primarykey from_ *product_key* _to
> PRODUCTKEY (_I tested with *_PutSQL_* and *_PutDatabaseRecord_* it have the
> same issue)
> !https://community.hortonworks.com/storage/attachments/110006-1563910561236.png|width=703,height=94!!https://community.hortonworks.com/storage/attachments/110005-1563910541777.png|width=605,height=83!
--
This message was sent by Atlassian Jira
(v8.3.2#803003)
