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

execute immediate only checks immediate parent scope

    Details

      Description

      A procedure such as:

      begin
        create local temporary table t1 (e1 string);
        loop on (select 1 as a union all select 2) as c
        begin
          execute immediate 'select c.a' as e1 string into t1;
        end
       select * from t1;
      end
      

      should return two rows, but instead returns nothing because the execute immediate statement doesn't see the surrounding t1 temp table.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                shawkins Steven Hawkins
              • Votes:
                1 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: