[
https://issues.apache.org/jira/browse/NIFI-8172?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Matt Burgess reassigned NIFI-8172:
----------------------------------
Assignee: Matt Burgess
> 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
>
> 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)
