[ https://issues.jboss.org/browse/TEIID-3112?page=com.atlassian.jira.plugin... ] Matus Makovy reopened TEIID-3112: --------------------------------- Today I tried to reproduce other bug(originaly reported for Teiid Designer) with DV 6.2 (GA), but I got this error: ??Didn't understand relationship 'Opportunitys' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names?? when trying to submit this query: ?? 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?? This should be fixed in dv6.2, am I right ? -- This message was sent by Atlassian JIRA (v6.4.11#64026)