[ https://issues.apache.org/jira/browse/NIFI-8172?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Joe Witt updated NIFI-8172: --------------------------- Fix Version/s: (was: 1.14.0) 1.13.0 > PutDatabaseRecord ignores schema name when getting primary keys > --------------------------------------------------------------- > > Key: NIFI-8172 > URL: https://issues.apache.org/jira/browse/NIFI-8172 > Project: Apache NiFi > Issue Type: Bug > Components: Extensions > Reporter: Matt Burgess > Assignee: Matt Burgess > Priority: Major > Fix For: 1.13.0 > > Time Spent: 0.5h > Remaining Estimate: 0h > > When retrieving the primary keys from the database metadata for UPDATE/UPSERT > operations, the schema name/pattern is not passed to the getPrimaryKeys() > method. > This can be illustrated with two schemas having a table of the same name but > different primary key columns. The method will return both primary key > columns where only the column for the specified schema should be returned. > NOTE: The database driver itself may choose to ignore the schema name and > return all matching columns, but all NiFi can do is pass in the schema name > and the rest is up to the driver. -- This message was sent by Atlassian Jira (v8.3.4#803005)