Bug 1160157 - Teiid Designer:Error with virtual procedure inserting into global temporary table
Summary: Teiid Designer:Error with virtual procedure inserting into global temporary t...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Tooling
Version: 6.1.0
Hardware: x86_64
OS: Linux
unspecified
unspecified
Target Milestone: ER4
: 6.1.0
Assignee: Barry LaFond
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-11-04 07:59 UTC by Jan Stastny
Modified: 2015-11-17 18:07 UTC (History)
5 users (show)

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.
Clone Of:
Environment:
Last Closed: 2015-11-17 18:07:59 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIIDDES-2381 0 Major Resolved Error with virtual procedure inserting into global temporary table 2018-08-02 14:12:14 UTC

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


Note You need to log in before you can comment on or make changes to this bug.