[jira] [Updated] (NIFI-8244) PutDatabaseRecord incorrect type resolution partial column

["Dorian Bugeja (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/NIFI-8244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dorian Bugeja updated NIFI-8244:
--------------------------------
    Summary: PutDatabaseRecord incorrect type resolution partial column  (was: PutDatabaseRecord incorrect type resolution partial column update)

> PutDatabaseRecord incorrect type resolution partial column
> ----------------------------------------------------------
>
>                 Key: NIFI-8244
>                 URL: https://issues.apache.org/jira/browse/NIFI-8244
>             Project: Apache NiFi
>          Issue Type: Bug
>          Components: Core Framework
>    Affects Versions: 1.13.0
>            Reporter: Dorian Bugeja
>            Priority: Major
>         Attachments: image-2021-02-20-02-18-10-670.png, image-2021-02-20-02-18-51-952.png, image-2021-02-20-02-26-24-986.png
>
>
> Record schema type resolution for PutDatabaseRecord is being performed using fieldIndexes computed in generateInsert/Update/Delete. Problem is that includedColumns is being populated with the index of the currentRecord (JSON for example) rather than the index of the table schema, which means that in the following example, `count` will be converted to String, as the second column in table is a String (Performing UPDATE in PutDatabaseRecord with Update key set to id)
> Table definition = 
> id INT,
> title VARCHAR,
> count INT
> Record Update
> {"id": 1, "count": 10}
> !image-2021-02-20-02-18-51-952.png!
> !image-2021-02-20-02-18-10-670.png!
> !image-2021-02-20-02-26-24-986.png!



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