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

Thu Jul 18 10:00:26 EDT 2013

    [ https://issues.jboss.org/browse/TEIID-2067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12790743#comment-12790743 ] 

Steven Hawkins commented on TEIID-2067:
---------------------------------------

Based upon our current metadata system this could be implemented as explicitly declared global temporary tables (just like any other schema object) and Teiid would maintain the associated semantics - the table definition is globally available but that each session would have separate data.

>From the request however it seems that what your looking for is really just the ability to create "real" tables that have their definition and data available to all sessions. This could fall under TEIID-2578 or a related issue.

> Global temporary tables
> -----------------------
>
>                 Key: TEIID-2067
>                 URL: https://issues.jboss.org/browse/TEIID-2067
>             Project: Teiid
>          Issue Type: Feature Request
>    Affects Versions: 7.7
>            Reporter: Mark Addleman
>            Assignee: Steven Hawkins
>
> 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