Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-8172

PutDatabaseRecord ignores schema name when getting primary keys

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 1.13.0
    • Extensions
    • None

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              mattyb149 Matt Burgess
              mattyb149 Matt Burgess
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 0.5h
                  0.5h