[teiid-issues] [JBoss JIRA] (TEIID-2594) Designer support for global temporary tables

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-2594:
----------------------------------

    Affects Version/s:     (was: 7.7)
          Description: 
Teiid has added support for a global temporary tables - they share a common definition, but each session has their own instance.  Internally this is modeled as a virtual table (without a transformation) with a table type of "TemporaryTable" (int code 6).  If you provided matching index metadata we would recognize the entry as a global temporary table.

Alternatively extension metadata could be used.

  was: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.


    
> Designer support for global temporary tables
> --------------------------------------------
>
>                 Key: TEIID-2594
>                 URL: https://issues.jboss.org/browse/TEIID-2594
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>            Reporter: Mark Addleman
>            Assignee: Steven Hawkins
>             Fix For: 8.5
>
>
> Teiid has added support for a global temporary tables - they share a common definition, but each session has their own instance.  Internally this is modeled as a virtual table (without a transformation) with a table type of "TemporaryTable" (int code 6).  If you provided matching index metadata we would recognize the entry as a global temporary table.
> Alternatively extension metadata could be used.

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