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

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-4754:
-------------------------------------

             Summary: 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)