Bug 1220749 - Saving View Model with syntax error in Transformation breaks it completely
Summary: Saving View Model with syntax error in Transformation breaks it completely
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Tooling
Version: 6.2.0
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: ---
: ---
Assignee: Barry LaFond
QA Contact: Andrej Smigala
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-05-12 10:44 UTC by Andrej Smigala
Modified: 2015-11-17 18:06 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-11-17 18:06:31 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIIDDES-2517 0 Major Closed Saving View Model with syntax error in Transformation breaks it completely 2016-08-09 05:28:12 UTC

Description Andrej Smigala 2015-05-12 10:44:12 UTC
Saving a view model when there is a syntax error in the transformation can sometimes make it completely broken.

Steps to reproduce:
1. create a new view model
2. add a new table t1 to it, with a column c1
3. set the transformation to
       SELECT 'c1' as c1;
4. add two backslashes to the beginning of the transformation
5. try saving the model (error about wrong syntax error pops up)
6. try saving again
7. remove the backslashes, try saving again (the same error pops up)
8. close the model, answer No to Save resource dialog
9. open the model again, try opening the transformation – the model is broken


Going through the steps to reproduce, it appears after the first save, the invalid transformation is not saved to the file, but after saving for the second time, it is. Designer should ideally prevent invalid SQL to be saved to the model.

Workaround is to open the model in XML editor and fix the transformation manually.

Comment 2 Barry LaFond 2015-05-18 13:10:50 UTC
recommend push to next patch, 9.0.3

Comment 3 JBoss JIRA Server 2015-09-03 13:06:44 UTC
Barry LaFond <blafond> updated the status of jira TEIIDDES-2517 to Resolved

Comment 4 JBoss JIRA Server 2015-10-02 11:39:37 UTC
Matus Makovy <mmakovy> updated the status of jira TEIIDDES-2517 to Closed


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