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

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-4644:
----------------------------------
    Fix Version/s: 9.2


> 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)