[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2040) Create WS action results in SQL transformation validation errors
[
https://issues.jboss.org/browse/TEIIDDES-2040?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-2040:
----------------------------------------
I captured the BEFORE and AFTER transformation info for one operation below. Note the
"nested" mapping with referenced input. We'll need to track down what logic
is resolving/reconciling/setting these values by opening the t-editor.
SQL after Create Web Service:
{code:xml}
<transformationMappings
xsi:type="transformation:SqlTransformationMappingRoot"
xmi:uuid="mmuuid:bcb7929b-7d70-4567-94a6-379bb9fff442"
outputs="mmuuid/7d7f17bd-a415-4023-882b-fd0c54464a38"
target="mmuuid/7d7f17bd-a415-4023-882b-fd0c54464a38">
<helper xsi:type="transformation:SqlTransformation"
xmi:uuid="mmuuid:f9a235d7-f072-4078-b01c-98bb2b5a39ac">
<nested xsi:type="transformation:SqlTransformation"
xmi:uuid="mmuuid:e5c11537-55e8-4889-8771-a2986b57d58a" selectSql="CREATE
VIRTUAL PROCEDURE BEGIN DECLARE string VARIABLES.IN_exampleVar ;VARIABLES.IN_exampleVar =
xPathValue(null, '//*[local-name()="exampleName"]');SELECT *
FROM AAA_View.SHIP_VIA_OutputView; END"/>
</helper>
{code}
SQL After d-clicking, opening t-editor and validation fixed
{code:xml}
<transformationMappings
xsi:type="transformation:SqlTransformationMappingRoot"
xmi:uuid="mmuuid:bcb7929b-7d70-4567-94a6-379bb9fff442"
outputs="mmuuid/7d7f17bd-a415-4023-882b-fd0c54464a38"
target="mmuuid/7d7f17bd-a415-4023-882b-fd0c54464a38">
<helper xsi:type="transformation:SqlTransformation"
xmi:uuid="mmuuid:f9a235d7-f072-4078-b01c-98bb2b5a39ac">
<nested xsi:type="transformation:SqlTransformation"
xmi:uuid="mmuuid:e5c11537-55e8-4889-8771-a2986b57d58a" selectSql="CREATE
VIRTUAL PROCEDURE BEGIN DECLARE string VARIABLES.IN_exampleVar ;VARIABLES.IN_exampleVar =
xPathValue(null, '//*[local-name()="exampleName"]');SELECT *
FROM AAA_View.SHIP_VIA_OutputView; END"/>
<aliases xmi:uuid="mmuuid:a8fa3afb-1d55-4a4f-98f5-e5ab987f2ad4"
alias="SHIP_VIA_OutputView">
<aliasedObject
href="AAA_View.xmi#mmuuid/a46365c7-621b-4905-bc5f-fe40e3b42026"/>
</aliases>
</helper>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:1ceedbca-a363-491b-9a48-0eff07d78a04"
outputs="mmuuid/a8c4a2a8-fe48-4754-b155-8ba049114ce5"/>
<inputs
href="AAA_View.xmi#mmuuid/a46365c7-621b-4905-bc5f-fe40e3b42026"/>
</transformationMappings>
{code}
Create WS action results in SQL transformation validation errors
----------------------------------------------------------------
Key: TEIIDDES-2040
URL: https://issues.jboss.org/browse/TEIIDDES-2040
Project: Teiid Designer
Issue Type: Bug
Components: Validation, Web Services Support
Affects Versions: 8.3
Reporter: Barry LaFond
Assignee: Mark Drilling
Fix For: 8.4, 8.3.2
1) Create/Import a simple Source Model (Parts Supplier Oracle)
2) Select model, right-click select Modeling > Create Web Service
3) Resulting WS model will have operations with SQL validation errors
4) Double-clicking each operation to open it's t-Editor will tweak the SQL and fix
the error
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira