[
https://issues.apache.org/jira/browse/NIFI-7983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Handermann reassigned NIFI-7983:
--------------------------------------
Assignee: David Handermann
> 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
> Assignee: David Handermann
> 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)
