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

[Johnathon Lee (JIRA)]

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

Johnathon Lee updated TEIID-4754:
---------------------------------
    Fix Version/s: 8.12.11.6_3


> 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, 8.12.x-6.4, 8.12.11.6_3
>
>
> 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)