[jira] [Created] (NIFI-8043) PutDatabaseRecord Postgres Upsert On Conflict keys not quoted

["Daniel Cheung (Jira)" <ji...@apache.org>]

Daniel Cheung created NIFI-8043:
-----------------------------------

             Summary: PutDatabaseRecord Postgres Upsert On Conflict keys not quoted
                 Key: NIFI-8043
                 URL: https://issues.apache.org/jira/browse/NIFI-8043
             Project: Apache NiFi
          Issue Type: Bug
          Components: Extensions
    Affects Versions: 1.12.0
            Reporter: Daniel Cheung


Given that "Quote column identifiers" is enabled, one would expect the column names inside the conflict clause be quoted as well. However, they didn't seem to have been quoted, because my table's column names contain upper and lowercases and the flowfile is routed to the failure relationship of the PutDatabaseRecord processor with the DB error: {{ERROR: column "camelcase" does not exist}}.

SQL in question, simplified from what I saw.

{{INSERT INTO "public"."my_table"("camelCase", "txt")}}
 {{VALUES ("test", "test")}}
 {{ON CONFLICT (CAMELCASE)}}
 {{DO UPDATE SET ("camelCase", "txt") = (}}
 {{    EXCLUDED."camelCase",}}
 {{    EXCLUDED."txt"}}
 {{)}}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)