[NIFI-6483] 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)

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.9.2
• Component/s: Configuration
• Environment: error when update data in a table (SQL server, MySQL, Postgresql) (it is running well with insert and update operations)
• Flags: Important
• Assignee: HondaWei
• Reporter: thuy le
• Created: 24/Jul/19 12:59
• Updated: 30/Aug/19 13:44

Description

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)

 

 

With Delete they do correct

 

 

with Update: They automatic change Primarykey from product_key to PRODUCTKEY (_I tested with _PutSQL and PutDatabaseRecord it have the same issue)