[ https://issues.apache.org/jira/browse/NIFI-6483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16919545#comment-16919545 ]
HondaWei edited comment on NIFI-6483 at 8/30/19 1:44 PM: --------------------------------------------------------- I traced the code, it failed if your column name in record schema is the lower case even though set "Translate Field Names" to false. I think it will work well if you set column name in upper case in record schema and set "Translate Field Names" to false. was (Author: hondawei): 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 > Assignee: HondaWei > 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)