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)
