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

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy commented on TEIID-2639:
-------------------------------------

Shouldn't higher level scoped temp tables visible in nested levels in named procedures?
                
> 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.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