You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@nifi.apache.org by "Matt Burgess (Jira)" <ji...@apache.org> on 2023/06/13 22:00:00 UTC

[jira] [Created] (NIFI-11682) Update keys not quoted in PutDatabaseRecord

Matt Burgess created NIFI-11682:
-----------------------------------

             Summary: Update keys not quoted in PutDatabaseRecord
                 Key: NIFI-11682
                 URL: https://issues.apache.org/jira/browse/NIFI-11682
             Project: Apache NiFi
          Issue Type: Bug
          Components: Extensions
            Reporter: Matt Burgess
             Fix For: 1.latest, 2.latest


When update keys are used in PutDatabaseRecord (either by declaring them in the Update Keys property or being auto-determined from the database metadata), they are not being quoted correctly when 'Quote Column Identifiers' is set to 'true'. This happens for Upsert, Update, and Insert Ignore statements.

This was fixed for Upsert in NIFI-8043 but a regression was introduced via NIFI-9607 when the quoting was removed inadvertently. Testing has revealed this issue exists for Upsert, Update, and Insert Ignore statements, so should be fixed for all of them.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)