[ https://issues.apache.org/jira/browse/NIFI-7983?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17226877#comment-17226877 ]
Pierre Villard commented on NIFI-7983: -------------------------------------- What schema do you use? It sounds like you're not giving the same column name across your queries. > Several SELECTs does not return correct values > ---------------------------------------------- > > Key: NIFI-7983 > URL: https://issues.apache.org/jira/browse/NIFI-7983 > Project: Apache NiFi > Issue Type: Bug > Affects Versions: 1.12.1 > Reporter: Michal Šunka > Priority: Blocker > Attachments: NiFi_SELECTs.jpg > > > If in ExecuteSQLRecord processor I use multiple SELECTs as in the following > code (note, it all is in single instance of processor), the results are > weird. First SELECT (1, 'Yeees') comes through okay as it should, but second > and third seems to be processed (additional flowfiles are created), but these > are _empty_. > {code:java} > SELECT 1 as 'Yeees' > SELECT 0 as 'Noooooo' > DECLARE @q int > SET @q = 0 > SELECT @q AS 'qqq' > {code} > > The use case is to call stored procedure returning resultset and then select > the returnCode: > {code:java} > DECLARE @retCode int > EXEC @retCode = stored_procedure_giving_resultset > > SELECT @retCode AS 'retCode_run' > {code} > I am using NiFi 1.12.1, DB is SAP ASE 16.0, db driver is jConnect (TM) for > JDBC(TM)/16.0 SP02 PL06 (Build 27337)/P/EBF26829/JDK 1.6.0/jdbcmain/OPT/Wed > Mar 15 03:15:38 PDT 2017 and trivially configured JSON recordset writer. -- This message was sent by Atlassian Jira (v8.3.4#803005)