Bug 1160157

Summary: Teiid Designer:Error with virtual procedure inserting into global temporary table
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Jan Stastny <jstastny>
Component: ToolingAssignee: Barry LaFond <blafond>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.1.0CC: asmigala, atangrin, dlesage, felias, vhalbert
Target Milestone: ER4   
Target Release: 6.1.0   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
When the Transformation Editor's content was saved, it displayed an error under the editor's text area. This was fixed by making the RecordFactory discover if the TableRecord was a temp table and setting the property on the record so the Resolver could successfully resolve the SQL.
 Story Points: ---
Clone Of: Environment:
Last Closed: 2015-11-17 18:07:59 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Jan Stastny 2014-11-04 07:59:30 UTC 
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).

Teiid Designer version:
8.6.0

Steps to reproduce:
1. Create a view model
2. Create a global temporary table in the model from step #1
3. Try to create a procedure in the same model, in the transformation editor insert query similar to: INSERT INTO <ModelName>.<GlobalTempTableName>(<Column>,..) VALUES (<Value1>,...), save the editor content.
Comment 1 JBoss JIRA Server 2014-11-06 15:24:31 UTC 
Barry LaFond <blafond> updated the status of jira TEIIDDES-2381 to Resolved