[teiid-issues] [JBoss JIRA] (TEIID-2067) Global temporary tables

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-2067:
----------------------------------

    Fix Version/s: 8.5
      Component/s: Query Engine


Moving into 8.5 to support Oracle/ANSI style global temporary tables.  Via DDL (but not at runtime) you can use from any schema:

create global temporary table ...

and the session specific temporary table will be created at access time.  This will effectively provide support for passing results into virtual procedures using a well-defined table.

Internally this leverages the session table store and the metadata record will be marked as a virtual temporary table (as opposed to a physical temporary table, which maps to a foreign table brought in temporarily).

To support this from Designer would require additional metadata.
                
> Global temporary tables
> -----------------------
>
>                 Key: TEIID-2067
>                 URL: https://issues.jboss.org/browse/TEIID-2067
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 7.7
>            Reporter: Mark Addleman
>            Assignee: Steven Hawkins
>             Fix For: 8.5
>
>
> Currently, temp tables are scoped to the teiid session (eg, jdbc connection) that created them. I would like temp tables visible to all sessions.  It is acceptable and even desirable that temp tables use an external database a la external materialization.

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