[teiid-issues] [JBoss JIRA] Commented: (TEIID-1362) salesforce push down queries won't get resolved correctly

salesforce push down queries won't get resolved correctly --------------------------------------------------------- Key: TEIID-1362 URL: https://jira.jboss.org/browse/TEIID-1362 Project: Teiid Issue Type: Bug Components: Salesforce Connector Affects Versions: 7.2 Environment: Teiid 7.2 final on JBoss EAP 5.1 with sun java 1.6.0_20 Reporter: Wanja Pernath Assignee: John Doyle GIVEN: select a.name, b.sumary from Opp a OUTER JOIN OLI b ON a.id = b.foreignId JoinQueryVisitor of SFDC translator correctly creates: select a.name, (select b.summary from OLI b) from Opp a As of SFDC docs: http://www.salesforce.com/us/developer/docs/api/index_Left.htm#StartTopic... you get a result set of for example: "opp #1", [b] QueryResult for row #1 "opp #2", [b] QueryResult for row #2 Which must be transformed into something like this (EXPECTED) "opp #1", 100 "opp #1", 150 "opp #1", 43000 "opp #2", 10000 "opp #2", 100 etc. Right now, it gets transformed into something like (CURRENT) "opp #1", null "opp #2", null "opp #3", null etc.