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

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)