[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2378) Virtual Procedure created via WS REST import option has errors

Virtual Procedure created via WS REST import option has errors -------------------------------------------------------------- Key: TEIIDDES-2378 URL: https://issues.jboss.org/browse/TEIIDDES-2378 Project: Teiid Designer Issue Type: Bug Components: Import/Export, Transformations, Validation Affects Versions: 8.6 Reporter: Barry LaFond Assignee: Barry LaFond Fix For: 9.0, 8.6.1 Creating a WS via google search URL (See TEIIDDES-2284) using the following connection profile info results in a transformation that has not been reconciled. {code:xml} <profile autoconnect="No" desc="" id="02b59450-4f06-11e4-abe2-af11d4a8f610" name="Google_Search" providerID="org.teiid.designer.datatools.profiles.ws.WSConnectionProfile"> <baseproperties> <property name="rest_param:output" value="Query:toolbar" /> <property name="responseType" value="XML" /> <property name="EndPoint" value="http://www.google.com/complete/search" /> <property name="rest_param:q" value="Query:receiver" /> </baseproperties> </profile> {code} Debugging found that the TransformationNewModelObjectHelper.helpCreate() method was resulting in a DEFAULT SQL TEMPLATE being applied when it shouldn't have been. Need to add an if check: *if( defineDefaultTableSQL )* and only apply the template if it was explicitly asked for.