Matt Burgess created NIFI-8172:
----------------------------------
Summary: 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
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)
