Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2639

Internally generated and user submitted anonymous blocks can't access temp tables from the surrounding scope

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 8.4.1, 8.5
    • 7.7
    • Query Engine
    • None

      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)

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-shawkins Steven Hawkins
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: