[
https://issues.apache.org/jira/browse/NIFI-10289?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Joe Witt updated NIFI-10289:
----------------------------
Resolution: Fixed
Status: Resolved (was: Patch Available)
> PutDatabaseRecord generating incomplete Merge SQL when using
> Oracle12DatabaseAdapter
> ------------------------------------------------------------------------------------
>
> Key: NIFI-10289
> URL: https://issues.apache.org/jira/browse/NIFI-10289
> 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.18.0
>
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> Processor PutDatabaseRecord is generating incomplete SQL statement when MERGE
> statement type for ORACLE12+.
> It isn't considering all Update Keys.
> I'm getting this SQL:
> {code:sql}
> MERGE INTO table USING (SELECT ? CASO, ? REFERENCIA_NOME, ?
> CASO_REFERENCIA_INDICA, 1 REFERENCIA_CODIGO FROM DUAL) n ON (table.CASO =
> n.CASO) WHEN NOT MATCHED THEN INSERT (CASO, REFERENCIA_NOME,
> CASO_REFERENCIA_INDICA, REFERENCIA_CODIGO) VALUES (n.CASO, n.REFERENCIA_NOME,
> n.CASO_REFERENCIA_INDICA, n.REFERENCIA_CODIGO) WHEN MATCHED THEN UPDATE SET
> table.REFERENCIA_NOME = n.REFERENCIA_NOME, table.CASO_REFERENCIA_INDICA =
> n.CASO_REFERENCIA_INDICA, table.REFERENCIA_CODIGO = n.REFERENCIA_CODIGO{code}
> Should be:
> {code:sql}
> MERGE INTO table USING (SELECT ? CASO, ? REFERENCIA_NOME, ?
> CASO_REFERENCIA_INDICA, 1 REFERENCIA_CODIGO FROM DUAL) n ON (table.CASO =
> n.CASO AND table.REFERENCIA_CODIGO = n.REFERENCIA_CODIGO) WHEN NOT MATCHED
> THEN INSERT (CASO, REFERENCIA_NOME, CASO_REFERENCIA_INDICA,
> REFERENCIA_CODIGO) VALUES (n.CASO, n.REFERENCIA_NOME,
> n.CASO_REFERENCIA_INDICA, n.REFERENCIA_CODIGO) WHEN MATCHED THEN UPDATE SET
> table.REFERENCIA_NOME = n.REFERENCIA_NOME, table.CASO_REFERENCIA_INDICA =
> n.CASO_REFERENCIA_INDICA{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
