[ https://issues.apache.org/jira/browse/NIFI-10289?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eduardo Mota Fontes updated NIFI-10289: --------------------------------------- Fix Version/s: 1.18.0 Status: Patch Available (was: Open) > 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 > Priority: Major > Fix For: 1.18.0 > > Time Spent: 10m > 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)