I think I found the problem.
The code below in PutDatabaseRecord, line 1213, consider that Update Key is
always in the first position and that's not true.
} else if (i == 0) {
// Set the WHERE clause based on the Update Key values
sqlBuilder.append(" WHERE ");
}
On Wed, Jul 20, 2022 at 8:42 AM Eduardo Fontes <[email protected]>
wrote:
> Hi all,
>
> I fired a Jira for this issue in 1.16.3.
> [NIFI-10252] Processor PutDatabaseRecord generating invalid SQL - ASF JIRA
> (apache.org) <https://issues.apache.org/jira/browse/NIFI-10252>
>
> It is generating UPDATE SQL statement without WHERE keyword.
>
> Thanks. Best regards.
> Eduardo Fontes
>
