You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Michal Šunka (Jira)" <ji...@apache.org> on 2020/11/05 16:17:00 UTC
[jira] [Created] (NIFI-7983) Several SELECTs does not return
correct values
Michal Šunka created NIFI-7983:
----------------------------------
Summary: 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
Attachments: NiFi_SELECTs.jpg
If in ExecuteSQLRecord processor I use multiple SELECTs as in following (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 selecr the returncode:
{code:java}
DECLARE @retCode int
EXEC @retCode = stored_procedure_giving_resultset
SELECT @retCode AS 'retCode_run'
{code}
I am using NiFi 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)