[
https://issues.apache.org/jira/browse/NIFI-8193?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17278100#comment-17278100
]
Peter Turcsanyi commented on NIFI-8193:
---------------------------------------
PutSQL can reorder FlowFiles while grouping the input FlowFiles with the same
statement within a batch (grouping is done in order to handle the same
statements together more effectively).
Eg. in a "Delete - Insert - Delete - Insert" scenario all deletes come first
(supposed the 2 delete statements are identical)
in case "Insert - Delete - Insert -Delete", all inserts come first (supposed
the 2 insert statements are identical)
The reordering of the FlowFiles may change the business logic and can lead to
unexpected result.
Fix PutSQL to group FlowFiles only if it can be done without reordering them.
Eg. Delete - Insert - Insert - Delete: the 2 inserts can be grouped, the 2
deletes cannot
> PutSQL can reorder FlowFiles
> ----------------------------
>
> Key: NIFI-8193
> URL: https://issues.apache.org/jira/browse/NIFI-8193
> Project: Apache NiFi
> Issue Type: Bug
> Components: Extensions
> Reporter: Peter Turcsanyi
> Assignee: Peter Turcsanyi
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
