[
https://issues.jboss.org/browse/TEIID-2067?page=com.atlassian.jira.plugin...
]
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