[teiid-issues] [JBoss JIRA] (TEIID-4644) anonymous block dynamic issues

Steven Hawkins (JIRA) issues at jboss.org
Thu Jan 26 10:25:00 EST 2017


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

Work on TEIID-4644 started by Steven Hawkins.
---------------------------------------------
> anonymous block dynamic issues
> ------------------------------
>
>                 Key: TEIID-4644
>                 URL: https://issues.jboss.org/browse/TEIID-4644
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 9.2
>
>
> Using execute immediate 'begin ... end'
> Has several issues.  First any variable references such as rowcount will be rewritten in the outer scope and not evaluated as part of the procedure.  Also the anonymous block cannot be used with targeting an into as the statement we create is insert into select ... from (begin ... end) .. - which is not valid, however the exception message does not make this clear.
> So we either need to improve these issues or disallow using anonymous blocks as dynamic sql.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)


More information about the teiid-issues mailing list