[teiid-issues] [JBoss JIRA] (TEIID-5482) Dynamic SQL: Executing Dynamic SQL Throws an Error
[
https://issues.jboss.org/browse/TEIID-5482?page=com.atlassian.jira.plugin...
]
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)