[teiid-issues] [JBoss JIRA] (TEIID-2639) Internally generated and user submitted anonymous blocks can't access temp tables from the surrounding scope

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12812335#comment-12812335 ] 

RH Bugzilla Integration commented on TEIID-2639:
------------------------------------------------

Van Halbert <vhalbert at redhat.com> changed the Status of [bug 1000623|https://bugzilla.redhat.com/show_bug.cgi?id=1000623] from MODIFIED to ON_QA
                
> Internally generated and user submitted anonymous blocks can't access temp tables from the surrounding scope
> ------------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-2639
>                 URL: https://issues.jboss.org/browse/TEIID-2639
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.7
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.4.1, 8.5
>
>
> While the blocks are resolved against the surrounding scope, when executed the procedure plan shields them from seeing the higher level scopes just as when a real procedure is executed.  This results in temporary table 'temp' not found exceptions, for example with a non-simple view v and the delete:
> delete from v where e2 = (select max(e2) from temp as z where e3 = z.e3)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira