[ https://issues.apache.org/jira/browse/NIFI-10252?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17570405#comment-17570405 ]
Eduardo Mota Fontes commented on NIFI-10252: -------------------------------------------- Now it has a unit test. :) > 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: 40m > 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)