[
https://issues.apache.org/jira/browse/NIFI-10635?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17616610#comment-17616610
]
Matt Burgess commented on NIFI-10635:
-------------------------------------
Verified this is an issue in Postgres as well, reported in StackOverflow:
https://stackoverflow.com/questions/73888542/apache-nifi-fail-inserting-using-putdatabaserecord-in-a-table-with-a-enum-colu
> Enum in Avro schema not working in PutDatabaseRecord
> ----------------------------------------------------
>
> Key: NIFI-10635
> URL: https://issues.apache.org/jira/browse/NIFI-10635
> Project: Apache NiFi
> Issue Type: Bug
> Components: Core Framework
> Affects Versions: 1.13.0
> Reporter: Jonathan Keller
> Priority: Major
>
> There appears to be a regression in the PutDatabaseRecord processor with
> 1.13.0 (works in 1.12.1)
> I have an Avro schema for a record which contained enum fields. After
> upgrading, a processor which had been working was failing on errors, stating
> it could not find the record type. The field in question is defined as below.
> The files which were erroring out were the exact same files, and no changes
> had been made to the schema or the CSV reader controller between the tests.
> I was also able to successfully move the flow.xml.gz file back to the older
> version of NiFi and the PutDatabaseRecord processor was able to work again to
> insert the database records.
> {noformat}
> {
> "name": "PER_ORG",
> "type": {
> "type": "enum",
> "name": "PerOrgFlag",
> "symbols": [
> "EMP",
> "CWR"
> ]
> }
> }
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
