[
https://issues.jboss.org/browse/TEIIDDES-2050?page=com.atlassian.jira.plu...
]
Ramesh Reddy commented on TEIIDDES-2050:
----------------------------------------
TEIIDDES-1794 defines how to handle GLOBAL TEMP Table.
For LOCAL/FOREIGN temp tables, the designer needs to support resolving logic when
statements like below exist in any procedure block
{code}
BEGIN
CREATE LOCAL TEMPORARY TABLE name ...;
CREATE FOREIGN TEMPORARY TABLE name ... ON schema
INSERT INTO #name (column, ...) VALUES (value, ...)
INSERT INTO #name [(column, ...)] select c1, c2 from t
END
{code}
Full Temp Table support in Designer
-----------------------------------
Key: TEIIDDES-2050
URL:
https://issues.jboss.org/browse/TEIIDDES-2050
Project: Teiid Designer
Issue Type: Feature Request
Components: Modeling
Reporter: Barry LaFond
Assignee: Barry LaFond
Fix For: Future
Per TEIIDDES-1794 there are more areas Designer needs to add support for temporary
tables:
... the full array of temp table stuff we currently support is:
* Teiid global temporary table (a virtual entry - which from an engine perspective can be
on any model type)
* Teiid temporary table (not a schema entry in the design time metadata, scoped to a
session/block)
* Teiid temporary table backed by a physical table (not a schema entry in the design time
metadata, scoped to a session/block - the physical table could be a temporary one)
Eventually we would also like to have an ease of use path to simply create a teiid
temporary table and have the backing table created on a source automatically - similar to
the data shipment join temporary table creation.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)