[
https://issues.apache.org/jira/browse/NIFI-8172?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17279954#comment-17279954
]
ASF subversion and git services commented on NIFI-8172:
-------------------------------------------------------
Commit b77dbd503099addb760e2d1f4b1249a90839cd97 in nifi's branch
refs/heads/main from Matt Burgess
[ https://gitbox.apache.org/repos/asf?p=nifi.git;h=b77dbd5 ]
NIFI-8172: Provide schema name to getPrimaryKeys call in PutDatabaseRecord
Signed-off-by: Pierre Villard <[email protected]>
This closes #4782.
> 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
> Time Spent: 20m
> 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)
