[jira] [Updated] (NIFI-7983) Several SELECTs does not return correct values
[ https://issues.apache.org/jira/browse/NIFI-7983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Matt Burgess updated NIFI-7983: --- Priority: Major (was: Blocker) > 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: Major > 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 'Noo' > 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)
[jira] [Updated] (NIFI-7983) Several SELECTs does not return correct values
[ https://issues.apache.org/jira/browse/NIFI-7983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Matt Burgess updated NIFI-7983: --- Affects Version/s: (was: 1.12.1) > 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 >Reporter: Michal Šunka >Priority: Major > 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 'Noo' > 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)
[jira] [Updated] (NIFI-7983) Several SELECTs does not return correct values
[ https://issues.apache.org/jira/browse/NIFI-7983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Michal Šunka updated NIFI-7983: --- Description: 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 'Noo' 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. was: 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 'Noo' 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 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. > 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 'Noo' > 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)
[jira] [Updated] (NIFI-7983) Several SELECTs does not return correct values
[ https://issues.apache.org/jira/browse/NIFI-7983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Michal Šunka updated NIFI-7983: --- Description: 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 'Noo' 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 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. was: 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 'Noo' 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. > 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 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 'Noo' > 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 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)