[ https://issues.apache.org/jira/browse/NIFI-10252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eduardo Mota Fontes updated NIFI-10252: --------------------------------------- Fix Version/s: 1.17.0 Status: Patch Available (was: Open) > Processor PutDatabaseRecord generating invalid SQL > -------------------------------------------------- > > Key: NIFI-10252 > URL: https://issues.apache.org/jira/browse/NIFI-10252 > Project: Apache NiFi > Issue Type: Bug > Components: Extensions > Affects Versions: 1.16.3 > Reporter: Eduardo Mota Fontes > Assignee: Eduardo Mota Fontes > Priority: Major > Fix For: 1.17.0 > > Time Spent: 10m > Remaining Estimate: 0h > > Processor PutDatabaseRecord is generating invalid SQL statement when UPDATE > statement type for ORACLE. > It seems lack of WHERE keyword. > > I'm getting this SQL: > {code:sql} > UPDATE "Z6RI_USUARIO_GRUPO_PERFIL"SET "USUARIO_NOME" = ?, "GRUPO_NOME" = ?, > "USUARIO_GRUPO_PERFIL_NOME" = ?, "USUARIO_GRUPO_DATAEXPIRACAO" = ?, > "PERFIL_CODIGO" = ?"GRUPO_CODIGO" = ? AND "USUARIO_CODIGO" = ?{code} > Should be: > {code:sql} > UPDATE "Z6RI_USUARIO_GRUPO_PERFIL"SET "USUARIO_NOME" = ?, "GRUPO_NOME" = ?, > "USUARIO_GRUPO_PERFIL_NOME" = ?, "USUARIO_GRUPO_DATAEXPIRACAO" = ?, > "PERFIL_CODIGO" = ? WHERE "GRUPO_CODIGO" = ? AND "USUARIO_CODIGO" = ?{code} -- This message was sent by Atlassian Jira (v8.20.10#820010)