[teiid-issues] [JBoss JIRA] (TEIID-4754) Wrong result with bidirectional relationship

[RH Bugzilla Integration (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4754?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

RH Bugzilla Integration updated TEIID-4754:
-------------------------------------------
    Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1440762, https://bugzilla.redhat.com/show_bug.cgi?id=1440939
        Bugzilla Update: Perform


> Wrong result with bidirectional relationship
> --------------------------------------------
>
>                 Key: TEIID-4754
>                 URL: https://issues.jboss.org/browse/TEIID-4754
>             Project: Teiid
>          Issue Type: Bug
>          Components: OData
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 9.2, 9.1.4
>
>
> From the forum post, two tables that relate to each other:
> EmployeeMasterEntity (PK EmployeeID, FK Departments)
> OrganizationalUnitEntity (PK OrganizationalUnitID, FK Managers)
> With data like:
> EmployeeMasterEntity
> EmployeeID                       Department
> 1                                       10000001 
> 2                                       10000002 
> 3                                       10000001 
>  
> OrganizationalUnitEntity
> OrganizationaUnitID           UnitManager
> 10000001                          1
> 10000002                          2
> 10000003                          2
> Will not return the correct results for a query such as:
> http://localhost:8080/odata4/TestOdata.1/InterlemView/EmployeeMasterEntity(3)/Departments?$format=json
> This is due to using the wrong relationship for the navigation.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)