[
https://issues.jboss.org/browse/TEIIDDES-2725?page=com.atlassian.jira.plu...
]
Ted Jones resolved TEIIDDES-2725.
---------------------------------
Resolution: Cannot Reproduce Bug
Confirmed correct transformation generation with latest bits:
BEGIN
DECLARE STRING VARIABLES.qp =
QUERYSTRING('https://******redhat.com/**/******';,
ViewModel.test.query AS query, ViewModel.test.newSearch AS newSearch);
SELECT A.totalCount AS totalCount FROM (EXEC SourceModel.invokeHttp(action =>
'GET', endpoint => VARIABLES.qp, stream => 'TRUE')) AS f,
XMLTABLE(XMLNAMESPACES(DEFAULT 'http://www.redhat.com/gss/strata'),
'/cases' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS totalCount string PATH
'totalCount/text()') AS A;
END
Transformation sql is not correct when using REST import with URL
attributes
----------------------------------------------------------------------------
Key: TEIIDDES-2725
URL:
https://issues.jboss.org/browse/TEIIDDES-2725
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export, Patch Release
Affects Versions: 9.0.4
Reporter: Matus Makovy
Assignee: Ted Jones
Fix For: 9.2.1
Attachments: Screen Shot 2015-11-12 at 14.55.52.png, Screen Shot 2015-11-12 at
15.22.59.png
When you use connection parameters in REST connection profile definition, the resulting
transformation SQL generated during import from this CP is malformed.
ViewModel.getCases.query AS query, *+|| '/' || ViewModel.getCases.query+*
ViewModel.getCases.newSearch AS newSearch *+|| '/' ||
ViewModel.getCases.newSearch+*
SQL without the bold/underlined parts works. (I mean underlined/bold parts in this bug
Description, not in screenshot)
See attached screenshots
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)