[JBoss JIRA] (TEIIDDES-1612) Extra Transformation nested mappings created for simple SELECT transformation
10:43 a.m.
[
https://issues.jboss.org/browse/TEIIDDES-1612?page=com.atlassian.jira.plu...
]
Barry LaFond updated TEIIDDES-1612:
-----------------------------------
Description:
Created a simple PARTS transformation and ended up with extra column mappings in
transformation mapping root. Below is XMI segments from a correct 7.8 generated model and
the latest 8.1 Designer version.
Use the following steps to replicate the this issue for both 7.8 and 8.1 Designer
* Import the attached model project set (zip)
* Open PartsViews.PartsInfo transformation editor
* Paste the following SQL and click "Validate"
** SELECT * FROM PARTS
*DESIGNER 7.8 PARTS TRANSFORMATION*
{code:xml}
<transformation:TransformationContainer
xmi:uuid="mmuuid:89b583e1-e6b7-4283-be29-24e4f0455e8c">
<transformationMappings
xsi:type="transformation:SqlTransformationMappingRoot"
xmi:uuid="mmuuid:f03d3a01-d558-40be-b2bb-ffb5f7aeefd3"
outputs="mmuuid/12e1b573-7e75-4f51-8a8c-651d69da13e9"
target="mmuuid/12e1b573-7e75-4f51-8a8c-651d69da13e9">
<helper xsi:type="transformation:SqlTransformation"
xmi:uuid="mmuuid:43e8a59f-fed6-433a-9c61-54945908dc42">
<nested xsi:type="transformation:SqlTransformation"
xmi:uuid="mmuuid:a110b2a5-1e8b-4db4-958a-a0f724f8f7d6" selectSql="SELECT *
FROM PARTS"/>
<aliases xmi:uuid="mmuuid:c968c6cc-8ba5-451e-b019-b3349942ca5a"
alias="PARTS">
<aliasedObject
href="PartsSupplier.xmi#mmuuid/d4ea0540-d7a9-4346-ae27-dcb72b7c33e6"/>
</aliases>
</helper>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:b16d05f4-007d-44c7-b757-aa906529de3e"
outputs="mmuuid/31e4e23b-b485-4c03-b286-37929ccbc6cf">
<inputs
href="PartsSupplier.xmi#mmuuid/ba980e0a-6e5f-466b-9e15-9896359c640a"/>
</nested>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:62dd2443-2645-4253-865d-4bcdd1e5cd57"
outputs="mmuuid/cbc42fa2-4756-4331-a5cb-aa516652a8f5">
<inputs
href="PartsSupplier.xmi#mmuuid/1a4b789f-fb2b-4399-8876-43f4309fc402"/>
</nested>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:ffd15dbb-7d8b-4a06-9161-9176fdff42ed"
outputs="mmuuid/9e021667-6be4-491f-9cd2-0e7652d159d8">
<inputs
href="PartsSupplier.xmi#mmuuid/971ff0ca-5f87-4414-a534-40b05f648fe9"/>
</nested>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:dcc6cb92-a245-4b2b-83cd-4545144a5cad"
outputs="mmuuid/b9f763f6-9f79-4de1-984e-6932a02c3263">
<inputs
href="PartsSupplier.xmi#mmuuid/baa98663-8d22-43d0-a6bc-7feca47827b5"/>
</nested>
<inputs
href="PartsSupplier.xmi#mmuuid/d4ea0540-d7a9-4346-ae27-dcb72b7c33e6"/>
</transformationMappings>
</transformation:TransformationContainer>
{code}
*DESIGNER 8.1 ALPHA 1 PARTS TRANSFORMATION*
{code:xml}
<transformation:TransformationContainer
xmi:uuid="mmuuid:faa98ced-0d3a-40a7-afde-37352988a466">
<transformationMappings
xsi:type="transformation:SqlTransformationMappingRoot"
xmi:uuid="mmuuid:39f8ced6-cc17-4e2d-9d2c-dfa006d58ead"
outputs="mmuuid/fa1e3689-242e-4f9b-b1ef-f598be02d3bf"
target="mmuuid/fa1e3689-242e-4f9b-b1ef-f598be02d3bf">
<helper xsi:type="transformation:SqlTransformation"
xmi:uuid="mmuuid:6e4ead08-bd8c-4719-b283-d976c9574b00">
<nested xsi:type="transformation:SqlTransformation"
xmi:uuid="mmuuid:ebea36b9-e6d8-4564-bece-9d3556a45091" selectSql="SELECT *
FROM PartsSupplier.PARTS"/>
<aliases xmi:uuid="mmuuid:9bb6640e-4ec7-4e97-9e39-261ddf670b92"
alias="PARTS">
<aliasedObject
href="PartsSupplier.xmi#mmuuid/a8a006a7-f161-4f3f-9a93-0e82d07842d6"/>
</aliases>
</helper>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:cc9d1ffc-1c50-45f3-8bde-e47445461b51"
outputs="mmuuid/2a85e933-dfe5-46ca-aec1-619cc2623cc0">
<inputs
href="PartsSupplier.xmi#mmuuid/a82fa733-bce0-4b20-bb2c-3a8108c091ec"/>
</nested>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:522e21d2-897b-47ea-b303-09ef300856f0"
outputs="mmuuid/0d15c3f6-5309-4245-8fb2-38384b4d8c37">
<inputs
href="PartsSupplier.xmi#mmuuid/dde8eecd-48b8-4646-8a74-d285aef420b2"/>
<inputs
href="PartsSupplier.xmi#mmuuid/a82fa733-bce0-4b20-bb2c-3a8108c091ec"/>
</nested>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:2e20a65b-3415-4be7-bc57-5e955b6577e0"
outputs="mmuuid/1fbf99b0-d787-4978-b7c3-a63e0fda8d75">
<inputs
href="PartsSupplier.xmi#mmuuid/dde8eecd-48b8-4646-8a74-d285aef420b2"/>
<inputs
href="PartsSupplier.xmi#mmuuid/d26aae8c-c727-4f1d-ba9f-c99b52190a31"/>
<inputs
href="PartsSupplier.xmi#mmuuid/a82fa733-bce0-4b20-bb2c-3a8108c091ec"/>
</nested>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:23fd17a2-a69f-485b-b4db-28788c4c3aa5"
outputs="mmuuid/08109639-899d-4239-a174-6bd35405f021">
<inputs
href="PartsSupplier.xmi#mmuuid/dde8eecd-48b8-4646-8a74-d285aef420b2"/>
<inputs
href="PartsSupplier.xmi#mmuuid/d26aae8c-c727-4f1d-ba9f-c99b52190a31"/>
<inputs
href="PartsSupplier.xmi#mmuuid/753efe1d-ef28-4389-8d24-4fa14c7dd917"/>
<inputs
href="PartsSupplier.xmi#mmuuid/a82fa733-bce0-4b20-bb2c-3a8108c091ec"/>
</nested>
<inputs
href="PartsSupplier.xmi#mmuuid/a8a006a7-f161-4f3f-9a93-0e82d07842d6"/>
</transformationMappings>
</transformation:TransformationContainer>
{code}
was:
Created a simple PARTS transformation and ended up with extra column mappings in
transformation mapping root. Below is XMI segments from a correct 7.8 generated model and
the latest 8.1 Designer version.
*DESIGNER 7.8 PARTS TRANSFORMATION*
{code:xml}
<transformation:TransformationContainer
xmi:uuid="mmuuid:faa98ced-0d3a-40a7-afde-37352988a466">
<transformationMappings
xsi:type="transformation:SqlTransformationMappingRoot"
xmi:uuid="mmuuid:d9def113-e28c-4e17-b1fd-b2ea73d853c6"
outputs="mmuuid/e463aa86-95c6-4c51-917a-f8d992e9eb07"
target="mmuuid/e463aa86-95c6-4c51-917a-f8d992e9eb07">
<helper xsi:type="transformation:SqlTransformation"
xmi:uuid="mmuuid:426c1504-5843-46c4-a65b-638a81b8d920">
<nested xsi:type="transformation:SqlTransformation"
xmi:uuid="mmuuid:fef73d6a-ab79-440c-9ab6-3815eaf67737" selectSql="SELECT
PartsSupplierA.PARTS.PART_ID AS ID, PartsSupplierA.PARTS.PART_NAME AS NAME,
PartsSupplierA.PARTS.PART_COLOR AS COLOR, PartsSupplierA.PARTS.PART_WEIGHT AS WEIGHT FROM
PartsSupplierA.PARTS"/>
<aliases xmi:uuid="mmuuid:06fd8567-3a11-4831-ab41-ca63f486e48b"
alias="PARTS">
<aliasedObject
href="PartsSupplierA.xmi#mmuuid/a8a006a7-f161-4f3f-9a93-0e82d07842d6"/>
</aliases>
</helper>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:668d1ee1-2fab-40cd-8b05-1b6db9474ab4"
outputs="mmuuid/1769ef9d-d6d4-44be-af35-5ef090e1a297">
<inputs
href="PartsSupplierA.xmi#mmuuid/a82fa733-bce0-4b20-bb2c-3a8108c091ec"/>
</nested>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:3d02e876-80b8-4d35-9eab-440cbc5ba29f"
outputs="mmuuid/a905b1d1-859c-4219-a5ac-80159327448a">
<inputs
href="PartsSupplierA.xmi#mmuuid/dde8eecd-48b8-4646-8a74-d285aef420b2"/>
</nested>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:30966f7a-7e68-4f26-9ff9-67f55da39efd"
outputs="mmuuid/1e2023dc-17ee-4c06-9882-f206f6b285dc">
<inputs
href="PartsSupplierA.xmi#mmuuid/d26aae8c-c727-4f1d-ba9f-c99b52190a31"/>
</nested>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:65d8a48a-2fe8-49ac-9732-459ec02ed2d5"
outputs="mmuuid/39ee0028-1e2b-4d37-abc3-50b47233737c">
<inputs
href="PartsSupplierA.xmi#mmuuid/753efe1d-ef28-4389-8d24-4fa14c7dd917"/>
</nested>
<inputs
href="PartsSupplierA.xmi#mmuuid/a8a006a7-f161-4f3f-9a93-0e82d07842d6"/>
</transformationMappings>
</transformation:TransformationContainer>
{code}
*DESIGNER 8.1 ALPHA 1 PARTS TRANSFORMATION*
{code:xml}
<transformation:TransformationContainer
xmi:uuid="mmuuid:faa98ced-0d3a-40a7-afde-37352988a466">
<transformationMappings
xsi:type="transformation:SqlTransformationMappingRoot"
xmi:uuid="mmuuid:39f8ced6-cc17-4e2d-9d2c-dfa006d58ead"
outputs="mmuuid/fa1e3689-242e-4f9b-b1ef-f598be02d3bf"
target="mmuuid/fa1e3689-242e-4f9b-b1ef-f598be02d3bf">
<helper xsi:type="transformation:SqlTransformation"
xmi:uuid="mmuuid:6e4ead08-bd8c-4719-b283-d976c9574b00">
<nested xsi:type="transformation:SqlTransformation"
xmi:uuid="mmuuid:ebea36b9-e6d8-4564-bece-9d3556a45091" selectSql="SELECT *
FROM PartsSupplierA.PARTS"/>
<aliases xmi:uuid="mmuuid:9bb6640e-4ec7-4e97-9e39-261ddf670b92"
alias="PARTS">
<aliasedObject
href="../other_sources/PartsSupplierA.xmi#mmuuid/a8a006a7-f161-4f3f-9a93-0e82d07842d6"/>
</aliases>
</helper>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:cc9d1ffc-1c50-45f3-8bde-e47445461b51"
outputs="mmuuid/2a85e933-dfe5-46ca-aec1-619cc2623cc0">
<inputs
href="../other_sources/PartsSupplierA.xmi#mmuuid/a82fa733-bce0-4b20-bb2c-3a8108c091ec"/>
</nested>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:522e21d2-897b-47ea-b303-09ef300856f0"
outputs="mmuuid/0d15c3f6-5309-4245-8fb2-38384b4d8c37">
<inputs
href="../other_sources/PartsSupplierA.xmi#mmuuid/dde8eecd-48b8-4646-8a74-d285aef420b2"/>
<inputs
href="../other_sources/PartsSupplierA.xmi#mmuuid/a82fa733-bce0-4b20-bb2c-3a8108c091ec"/>
</nested>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:2e20a65b-3415-4be7-bc57-5e955b6577e0"
outputs="mmuuid/1fbf99b0-d787-4978-b7c3-a63e0fda8d75">
<inputs
href="../other_sources/PartsSupplierA.xmi#mmuuid/dde8eecd-48b8-4646-8a74-d285aef420b2"/>
<inputs
href="../other_sources/PartsSupplierA.xmi#mmuuid/d26aae8c-c727-4f1d-ba9f-c99b52190a31"/>
<inputs
href="../other_sources/PartsSupplierA.xmi#mmuuid/a82fa733-bce0-4b20-bb2c-3a8108c091ec"/>
</nested>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:23fd17a2-a69f-485b-b4db-28788c4c3aa5"
outputs="mmuuid/08109639-899d-4239-a174-6bd35405f021">
<inputs
href="../other_sources/PartsSupplierA.xmi#mmuuid/dde8eecd-48b8-4646-8a74-d285aef420b2"/>
<inputs
href="../other_sources/PartsSupplierA.xmi#mmuuid/d26aae8c-c727-4f1d-ba9f-c99b52190a31"/>
<inputs
href="../other_sources/PartsSupplierA.xmi#mmuuid/753efe1d-ef28-4389-8d24-4fa14c7dd917"/>
<inputs
href="../other_sources/PartsSupplierA.xmi#mmuuid/a82fa733-bce0-4b20-bb2c-3a8108c091ec"/>
</nested>
<inputs
href="../other_sources/PartsSupplierA.xmi#mmuuid/a8a006a7-f161-4f3f-9a93-0e82d07842d6"/>
</transformationMappings>
</transformation:TransformationContainer>
{code}
Extra Transformation nested mappings created for simple SELECT
transformation
-----------------------------------------------------------------------------
Key: TEIIDDES-1612
URL: https://issues.jboss.org/browse/TEIIDDES-1612
Project: Teiid Designer
Issue Type: Bug
Components: Transformations
Affects Versions: 8.1
Reporter: Barry LaFond
Assignee: Paul Richardson
Fix For: 8.1
Attachments: PartsMPS.zip
Created a simple PARTS transformation and ended up with extra column mappings in
transformation mapping root. Below is XMI segments from a correct 7.8 generated model and
the latest 8.1 Designer version.
Use the following steps to replicate the this issue for both 7.8 and 8.1 Designer
* Import the attached model project set (zip)
* Open PartsViews.PartsInfo transformation editor
* Paste the following SQL and click "Validate"
** SELECT * FROM PARTS
*DESIGNER 7.8 PARTS TRANSFORMATION*
{code:xml}
<transformation:TransformationContainer
xmi:uuid="mmuuid:89b583e1-e6b7-4283-be29-24e4f0455e8c">
<transformationMappings
xsi:type="transformation:SqlTransformationMappingRoot"
xmi:uuid="mmuuid:f03d3a01-d558-40be-b2bb-ffb5f7aeefd3"
outputs="mmuuid/12e1b573-7e75-4f51-8a8c-651d69da13e9"
target="mmuuid/12e1b573-7e75-4f51-8a8c-651d69da13e9">
<helper xsi:type="transformation:SqlTransformation"
xmi:uuid="mmuuid:43e8a59f-fed6-433a-9c61-54945908dc42">
<nested xsi:type="transformation:SqlTransformation"
xmi:uuid="mmuuid:a110b2a5-1e8b-4db4-958a-a0f724f8f7d6" selectSql="SELECT *
FROM PARTS"/>
<aliases xmi:uuid="mmuuid:c968c6cc-8ba5-451e-b019-b3349942ca5a"
alias="PARTS">
<aliasedObject
href="PartsSupplier.xmi#mmuuid/d4ea0540-d7a9-4346-ae27-dcb72b7c33e6"/>
</aliases>
</helper>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:b16d05f4-007d-44c7-b757-aa906529de3e"
outputs="mmuuid/31e4e23b-b485-4c03-b286-37929ccbc6cf">
<inputs
href="PartsSupplier.xmi#mmuuid/ba980e0a-6e5f-466b-9e15-9896359c640a"/>
</nested>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:62dd2443-2645-4253-865d-4bcdd1e5cd57"
outputs="mmuuid/cbc42fa2-4756-4331-a5cb-aa516652a8f5">
<inputs
href="PartsSupplier.xmi#mmuuid/1a4b789f-fb2b-4399-8876-43f4309fc402"/>
</nested>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:ffd15dbb-7d8b-4a06-9161-9176fdff42ed"
outputs="mmuuid/9e021667-6be4-491f-9cd2-0e7652d159d8">
<inputs
href="PartsSupplier.xmi#mmuuid/971ff0ca-5f87-4414-a534-40b05f648fe9"/>
</nested>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:dcc6cb92-a245-4b2b-83cd-4545144a5cad"
outputs="mmuuid/b9f763f6-9f79-4de1-984e-6932a02c3263">
<inputs
href="PartsSupplier.xmi#mmuuid/baa98663-8d22-43d0-a6bc-7feca47827b5"/>
</nested>
<inputs
href="PartsSupplier.xmi#mmuuid/d4ea0540-d7a9-4346-ae27-dcb72b7c33e6"/>
</transformationMappings>
</transformation:TransformationContainer>
{code}
*DESIGNER 8.1 ALPHA 1 PARTS TRANSFORMATION*
{code:xml}
<transformation:TransformationContainer
xmi:uuid="mmuuid:faa98ced-0d3a-40a7-afde-37352988a466">
<transformationMappings
xsi:type="transformation:SqlTransformationMappingRoot"
xmi:uuid="mmuuid:39f8ced6-cc17-4e2d-9d2c-dfa006d58ead"
outputs="mmuuid/fa1e3689-242e-4f9b-b1ef-f598be02d3bf"
target="mmuuid/fa1e3689-242e-4f9b-b1ef-f598be02d3bf">
<helper xsi:type="transformation:SqlTransformation"
xmi:uuid="mmuuid:6e4ead08-bd8c-4719-b283-d976c9574b00">
<nested xsi:type="transformation:SqlTransformation"
xmi:uuid="mmuuid:ebea36b9-e6d8-4564-bece-9d3556a45091" selectSql="SELECT *
FROM PartsSupplier.PARTS"/>
<aliases xmi:uuid="mmuuid:9bb6640e-4ec7-4e97-9e39-261ddf670b92"
alias="PARTS">
<aliasedObject
href="PartsSupplier.xmi#mmuuid/a8a006a7-f161-4f3f-9a93-0e82d07842d6"/>
</aliases>
</helper>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:cc9d1ffc-1c50-45f3-8bde-e47445461b51"
outputs="mmuuid/2a85e933-dfe5-46ca-aec1-619cc2623cc0">
<inputs
href="PartsSupplier.xmi#mmuuid/a82fa733-bce0-4b20-bb2c-3a8108c091ec"/>
</nested>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:522e21d2-897b-47ea-b303-09ef300856f0"
outputs="mmuuid/0d15c3f6-5309-4245-8fb2-38384b4d8c37">
<inputs
href="PartsSupplier.xmi#mmuuid/dde8eecd-48b8-4646-8a74-d285aef420b2"/>
<inputs
href="PartsSupplier.xmi#mmuuid/a82fa733-bce0-4b20-bb2c-3a8108c091ec"/>
</nested>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:2e20a65b-3415-4be7-bc57-5e955b6577e0"
outputs="mmuuid/1fbf99b0-d787-4978-b7c3-a63e0fda8d75">
<inputs
href="PartsSupplier.xmi#mmuuid/dde8eecd-48b8-4646-8a74-d285aef420b2"/>
<inputs
href="PartsSupplier.xmi#mmuuid/d26aae8c-c727-4f1d-ba9f-c99b52190a31"/>
<inputs
href="PartsSupplier.xmi#mmuuid/a82fa733-bce0-4b20-bb2c-3a8108c091ec"/>
</nested>
<nested xsi:type="transformation:TransformationMapping"
xmi:uuid="mmuuid:23fd17a2-a69f-485b-b4db-28788c4c3aa5"
outputs="mmuuid/08109639-899d-4239-a174-6bd35405f021">
<inputs
href="PartsSupplier.xmi#mmuuid/dde8eecd-48b8-4646-8a74-d285aef420b2"/>
<inputs
href="PartsSupplier.xmi#mmuuid/d26aae8c-c727-4f1d-ba9f-c99b52190a31"/>
<inputs
href="PartsSupplier.xmi#mmuuid/753efe1d-ef28-4389-8d24-4fa14c7dd917"/>
<inputs
href="PartsSupplier.xmi#mmuuid/a82fa733-bce0-4b20-bb2c-3a8108c091ec"/>
</nested>
<inputs
href="PartsSupplier.xmi#mmuuid/a8a006a7-f161-4f3f-9a93-0e82d07842d6"/>
</transformationMappings>
</transformation:TransformationContainer>
{code}
--
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
4798
days inactive
4798
days old
teiid-designer-issues@lists.jboss.org
0 comments
1 participants
participants (1)
-
Barry LaFond (JIRA)