Sample Parts and Books transformation SQL has meaningless AS statements which simply duplicate original statement ----------------------------------------------------------------------------------------------------------------- Key: TEIIDDES-21 URL: https://jira.jboss.org/jira/browse/TEIIDDES-21 Project: Teiid Designer Issue Type: Bug Components: Validation Affects Versions: 6.0.0 Environment: Windowns running Designer in Eclipse IDE Reporter: Warren Gibson Assignee: Dan Florian Priority: Critical Fix For: 6.0.0 Add Existing Model Project Set Parts example Opened SupplierInfo transformation and the model immediately shows a red X. The transformation SQL looks strange with an AS which simply repeats the original SQL: SELECT PartSupplier_SourceB.SUPPLIER_PARTS.SUPPLIER_ID AS PartSupplier_SourceB.SUPPLIER_PARTS.SUPPLIER_ID, PartSupplier_SourceB.SUPPLIER_PARTS.PART_ID AS PartSupplier_SourceB.SUPPLIER_PARTS.PART_ID, PartSupplier_SourceB.SUPPLIER_PARTS.QUANTITY AS PartSupplier_SourceB.SUPPLIER_PARTS.QUANTITY, PartSupplier_SourceB.SUPPLIER_PARTS.SHIPPER_ID AS PartSupplier_SourceB.SUPPLIER_PARTS.SHIPPER_ID, PartsSupplier_SourceA.SUPPLIER.SUPPLIER_NAME AS PartsSupplier_SourceA.SUPPLIER.SUPPLIER_NAME, PartsSupplier_SourceA.SUPPLIER.SUPPLIER_STATUS AS PartsSupplier_SourceA.SUPPLIER.SUPPLIER_STATUS, PartsSupplier_SourceA.SUPPLIER.SUPPLIER_CITY AS PartsSupplier_SourceA.SUPPLIER.SUPPLIER_CITY, PartsSupplier_SourceA.SUPPLIER.SUPPLIER_STATE AS PartsSupplier_SourceA.SUPPLIER.SUPPLIER_STATE FROM PartSupplier_SourceB.SUPPLIER_PARTS, PartsSupplier_SourceA.SUPPLIER WHERE PartSupplier_SourceB.SUPPLIER_PARTS.SUPPLIER_ID = PartsSupplier_SourceA.SUPPLIER.SUPPLIER_ID I then added Books from the examples and the same thing happened with bookListingDocument.