[NIFI-5828] ExecuteSQL executesql.row.count meaning changes when Max Rows Per Flow File > 0

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 1.9.0
• Component/s: Extensions
• Labels: regression
• Environment: Linux, MSSQL 2016
• Assignee: Colin Dean
• Reporter: Colin Dean
• Created: 16/Nov/18 18:06
• Updated: 20/Nov/18 00:18
• Resolved: 19/Nov/18 05:21

Description

When Max Rows Per Flow File (esql-max-rows) is set greater than 0 to enable it, the executesql.row.count attribute on the resulting FlowFiles is not the number of rows in the result set but rather the number of rows in the FlowFile.

This is a deviation from documented behavior, which is "Contains the number of rows returned in the select query".

Issue Links

• is related to: NIFI-5831 Add attribute to ExecuteSQL output reflecting total row count when Max Rows Per Flowfile is set
• links to: GitHub Pull Request #3177