[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=12563900#comment-12563900 ] 

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

I've debugged through some similar queries (I don't have the objects in the original SQL) and found that results are coming back null.  Not sure what the issue is yet, but it doesn't appear to be an issue with our handling of the result. 

> 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