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

[Steven Hawkins (JIRA)]

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

Steven Hawkins closed TEIID-2639.
---------------------------------


    
> 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