[jira] [Commented] (NIFI-8172) PutDatabaseRecord ignores schema name when getting primary keys

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ 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 <pi...@gmail.com>

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)