Barry LaFond created TEIIDDES-1612: -------------------------------------- Summary: 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 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} -- 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