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

Steven Hawkins created TEIID-2639:
-------------------------------------

             Summary: 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