TEIID-4947: Error with Salesforce translator if criteria on outer join on a...

Activity

CR-86 0

Keyboard shortcuts  
  • Summarize the review outcomes (optional)
     
    #permalink

    Details

    Warning: no files are visible, they have all been filtered.
    Participant Role Time Spent Comments Latest Comment
    Author      
    Moderator 6m    
    Total   6m 0  
    #permalink

    Objectives

    Running a left outer join between a parent and child custom table in salesforce results in an error:

    select a.id, a.name, a.LastModifiedDate, b.Order_Recipe_Steps_c, b.name
    from MPRS_Salesforce.Media_Prep_Order_Recipe_Steps
    c a left outer join "MPRS_Salesforce"."Recipe_Step_Detailc" b
    on (a.id = b.Order_Recipe_Steps
    c)
    where b.LastModifiedDate >= parsetimestamp('2016-05-04 15:01:03.0', 'yyyy-MM-dd hh:mm:ss.s')

    Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 MPRS_Salesforce: com.sforce.soap.partner.InvalidSObjectFault: INVALID_TYPE:
    Recipe_Step_Detail
    c.Catalog_Itemc FROM Recipe_Step_Detailcs) FROM Media_Prep_Order_Recipe_Stepsc
    ^
    ERROR at Row:1:Column:1137
    Didn't understand relationship 'Recipe_Step_Detail
    cs' 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 o...

    Branches in review

    #permalink

    Issues Raised From Comments

    Key Summary State Assignee
    #permalink

    General Comments

    There are no general comments on this review.
    /build/kits/.../teiid/teiid-releasenotes.html Changed
    /connectors/.../visitors/JoinQueryVisitor.java Changed
    /connectors/.../visitors/JoinQueryVisitor.java Changed
    Open in IDE #permalink
    /connectors/.../visitors/TestVisitors.java Changed
    /connectors/.../visitors/TestVisitors.java Added
    Open in IDE #permalink
    /connectors/.../visitors/TestVisitors.java Added
    Open in IDE #permalink
    /connectors/.../visitors/TestVisitors.java Changed
    Open in IDE #permalink
    /connectors/.../visitors/TestVisitors.java Added
    Open in IDE #permalink
    /connectors/salesforce/.../resources/sf.ddl Changed
    Open in IDE #permalink
    /connectors/salesforce/.../resources/sf.ddl Added
    Open in IDE #permalink
    /connectors/salesforce/.../resources/sf.ddl Added
    Open in IDE #permalink
    /connectors/salesforce/.../resources/sf.ddl Changed
    Open in IDE #permalink
    /connectors/salesforce/.../resources/sf.ddl Added
    Open in IDE #permalink
    /connectors/.../visitors/JoinQueryVisitor.java Changed
    Open in IDE #permalink
    /connectors/.../visitors/JoinQueryVisitor.java Changed
    Open in IDE #permalink
    /connectors/.../visitors/JoinQueryVisitor.java Changed
    Open in IDE #permalink

    Review updated: Reload | Ignore | Collapse

    You cannot reload the review while writing a comment.

    Log time against