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

Details

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

    Description

      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)

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: