Problems with model created via import from Salesforce when using JOIN query ---------------------------------------------------------------------------- Key: TEIIDDES-2500 URL: https://issues.jboss.org/browse/TEIIDDES-2500 Project: Teiid Designer Issue Type: Bug Affects Versions: 9.0.1 Reporter: Matus Makovy Assignee: Mark Drilling Fix For: 9.0.4, 9.2 Attachments: log, salesdynamic-vdb.xml, SalesforceTD.zip Discovered this issue when trying to verify TEIID-3112 I am trying to execute this query on VDB created via import from SalesForce in Teiid Designer. {quote} select distinct YEAR("Opportunity"."CloseDate") as "Opportunity_CloseDate1" from "SalesForceSource".salesforce.Campaign AS "Campaign" LEFT OUTER JOIN "SalesForceSource".salesforce.Opportunity AS "Opportunity" ON Campaign."Id" = Opportunity."CampaignId" order by YEAR("Opportunity"."CloseDate") ASC LIMIT 0 , 32 {quote} And I get this exception: {quote} org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidException: Invalid QName in mapping: sf:INVALID_TYPE {quote} Log attached With dynamic VDB created manually or with import using Teiid Connection Importer via Designer everything works. Project from Designer + dynamic VDB attached