[teiid-issues] [JBoss JIRA] (TEIID-5856) Teiid generate wrong request to salesforce

[Steven Hawkins (Jira)]

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

Steven Hawkins commented on TEIID-5856:
---------------------------------------

> It is one request to salesforce. But i think references generation do not working in teiid now 

I don't know what you mean by references.

> But need one 

Generally the salesforce translator will handle a single level of inner or left outer join as you expect.  The one requirement is that there is a foreign key between the two tables - which should be inferred from the salesforce metadata.  

In this case you are performing a self-join of Product_License__c - there currently is no support for self-joins.  That can certainly be captured as an issue/enhancement request.

> I think do not working self references generation only. If i try to use SQL
> Generated SOQL is
> SELECT Account.BillingCountry__c, Account.Name FROM Contact LIMIT 1

I don't follow you.  Are you saying that is the SOQL teiid is generating in that example or that is what you expect to be generated?

That SOQL looks correct for the SQL query - it's just a child-to-parent query https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships_query_using.htm#sforce_api_calls_soql_relationships_query_using

> Another example:
> wrong plan

You'll have to clarify what you mean by wrong.  Note that a limitation of the current salesforce translator is that only a single level of the relationship can be queried together.  Introducing three entities will cause the pushdown to be split.  Here again you can capture that as an enhancement request if you want.


> Teiid generate wrong request to salesforce
> ------------------------------------------
>
>                 Key: TEIID-5856
>                 URL: https://issues.jboss.org/browse/TEIID-5856
>             Project: Teiid
>          Issue Type: Bug
>          Components: Salesforce Connector
>         Environment: spring-boot teiid salesforce-connector
>            Reporter: Renat Eskenin
>            Assignee: Steven Hawkins
>            Priority: Major
>
> When i call request to salesforce teiid get very long wrong request and then OOM, because teiid request all data in salesforce object.



--
This message was sent by Atlassian Jira
(v7.13.8#713008)