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

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.