[
https://issues.jboss.org/browse/TEIIDDES-2381?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-2381:
----------------------------------------
[~shawkins] How does your GroupSymbol & resolver framework handle a *Global Temporary
Table* ? Just treats it like any other *Temp Table* ?
I ran this in debug and explicitely set the isTempTable value to *true* and the query
validated.
Note I used the simple use-case from your docs:
{code}
BEGIN
INSERT INTO TestViewModel.VT (A, B) VALUES (0, 1);
END
{code}
results in error: *ERROR: TEIID30065 Error parsing query plan transformation for
TestViewModel.VT*
Error with virtual procedure inserting into global temporary table
------------------------------------------------------------------
Key: TEIIDDES-2381
URL:
https://issues.jboss.org/browse/TEIIDDES-2381
Project: Teiid Designer
Issue Type: Bug
Components: Transformations
Affects Versions: 8.6
Reporter: Jan Stastny
I have a view model (called IPView) with global temporary table (called
global_temp_table), then I have virtual procedure in the same model where I try to insert
data into the global temporary table. When the Transformation Editor's content is
saved, it displays an error under the editor's text area. The error has following
message:
ERROR: TEIID30065 Error parsing query plan transformation for IPView.global_temp_table
This error does not give the user any hint what went wrong (what he did wrong).
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)