Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1233040

Summary: Transformation editor does not save the code, "create virtual procedure"
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Hisao Furuichi <hfuruich>
Component: ToolingAssignee: Barry LaFond <blafond>
Status: CLOSED CURRENTRELEASE QA Contact: Andrej Smigala <asmigala>
Severity: urgent Docs Contact:
Priority: urgent    
Version: 6.1.0CC: asmigala, atangrin, blafond, drieden, vhalbert
Target Milestone: ---Keywords: Reopened
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-11-17 18:08:53 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:
Attachments:
Description Flags
reproducer none

Description Hisao Furuichi 2015-06-18 06:45:41 UTC 
Created attachment 1040279 [details]
reproducer

Description of problem:
Transformation editor does not save the code, "create virtual procedure"

Version-Release number of selected component (if applicable):
JBDS 8.1.0.GA with Teiid Designer 9.0.1.Final-v20150211-1407-B643

Steps to Reproduce:
1. import attached teiid project
2. Double Click ErrorProject -> model -> ProcedureModel.xmi -> TestProcedure
3. Double Click the Arrow icon with 'T' charactor (Open Transformation editor)
4. Edit as follows

[Before]
BEGIN
	SELECT * FROM ViewModel.TestView3;
END

[After]
/*+ cache(ttl:36000000)*/ CREATE VIRTUAL PROCEDURE
BEGIN
	SELECT * FROM ViewModel.TestView3;
END

Actual results:
Editor does not save the modified content

Expected results:
Editor saves the modified content

Additional information: 
- Official documents introduces the chaced virtual procedure function
 https://access.redhat.com/documentation/en-US/Red_Hat_JBoss_Data_Virtualization/6/html/Administration_and_Configuration_Guide/chap-Caching.html#Cached_Virtual_Procedure_Definition

- It works with JBDS 7.1.1.GA with Teiid Designer 8.3.4.Final-v20140912-1304-B264
Comment 1 Hisao Furuichi 2015-06-19 05:19:05 UTC 
My coworker found a workaround, but it's manually editing xmi file.
Although this workaround is valid, it's too risky because user might destroy the xmi file easily.

Please consider this ticket as urgent, and fix it as soon as possible. 
Many thx for your help
Comment 2 Barry LaFond 2015-07-16 18:54:31 UTC 
The fix for this involves updating our TeiidParser source and enabling the cache hints for procedure queries.  Not enough time in 9.0.3 release to get this done.
Comment 3 JBoss JIRA Server 2015-09-09 13:48:55 UTC 
Paul Richardson <p.g.richardson.uk> updated the status of jira TEIIDDES-2562 to Closed
Comment 4 Andrej Smigala 2015-10-03 07:43:22 UTC 
Barry, why is this bz closed as NOTABUG? There are changes in the code [1] and it has not been verified by QE.

[1] https://github.com/Teiid-Designer/teiid-designer/commit/34ca848eb8c07b9bb76f260f823c60b7ce5f1614
Comment 5 JBoss JIRA Server 2015-10-13 14:07:09 UTC 
Barry LaFond <blafond> updated the status of jira TEIIDDES-2562 to Reopened
Comment 6 Andrej Smigala 2015-10-13 14:08:13 UTC 
There was some confusion as to what the problem was. Turns out is IS a bug and (the cache hint gets removed in 9.0.3), and it IS fixed in 9.0.4 (it is not removed in 9.0.4).

The relevant commit is here: https://github.com/phantomjinx/teiid-designer/commit/34ca848eb8c07b9bb76f260f823c60b7ce5f1614
Comment 7 JBoss JIRA Server 2015-10-13 14:10:28 UTC 
Andrej Šmigala <asmigala> updated the status of jira TEIIDDES-2562 to Closed
Comment 10 Red Hat Bugzilla 2023-09-14 03:00:51 UTC 
The needinfo request[s] on this closed bug have been removed as they have been unresolved for 1000 days