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

[John Doyle (JIRA)]

    [ https://jira.jboss.org/browse/TEIID-1362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12564076#comment-12564076 ] 

John Doyle commented on TEIID-1362:
-----------------------------------

Digging deeper I found that the data is in the result from SF.

> 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=Content/sforce_api_calls_soql_relationships.htm
>  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.

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira