[teiid-issues] [JBoss JIRA] (TEIID-5482) Dynamic SQL: Executing Dynamic SQL Throws an Error

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-5482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins reopened TEIID-5482:
-----------------------------------


This is actually an issue with TEIID-4507 - that was an incomplete fix that worked only for embedded connections.  Switching to remote you get the exception you are seeing.  For some reason squirrel does not log the stacktraces by default, but turning on their debug logging shows an array index out of bounds exception coming from the client.

> Dynamic SQL: Executing Dynamic SQL Throws an Error
> --------------------------------------------------
>
>                 Key: TEIID-5482
>                 URL: https://issues.jboss.org/browse/TEIID-5482
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 11.1
>         Environment: teiid-11.1.0 (from 01.09.2018) on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final)
>            Reporter: dalex dalex
>            Assignee: Steven Hawkins
>         Attachments: TEIID_5482_stacktrace.jpg
>
>
> When running the following query:
> {code:sql}
> BEGIN
>        declare clob sql_query = 'select 1';
>        execute immediate sql_query;
> END ;;
> {code}
> in result set can see only:
> {code:noformat}
> Error: 0
> SQLState:  38000
> ErrorCode: 0
> {code}
> but running the following query just adding the "as cnt string":
> {code:sql}
> BEGIN
>        declare clob sql_query = 'select 1';
>        execute immediate sql_query as cnt string;
> END ;;
> {code}
> can see correct "1" in result set. I don't know if it's a correct behavior, maybe it's related to how SQuirrel handles result set.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)