[teiid-issues] [JBoss JIRA] (TEIID-5589) NavigationProperty not working with Teiid odata, results in TEIID16053

[Christoph John (Jira)]

Christoph John created TEIID-5589:
-------------------------------------

             Summary: NavigationProperty not working with Teiid odata, results in  TEIID16053 
                 Key: TEIID-5589
                 URL: https://issues.jboss.org/browse/TEIID-5589
             Project: Teiid
          Issue Type: Bug
    Affects Versions: 11.2.1
            Reporter: Christoph John
            Assignee: Steven Hawkins
         Attachments: metadata.xml

Teiid throws an error in case it tries to follow an odata Navigation property. I tried this by using $expand and also by directly following a path. Two examples below are shown below. My $metaddata.xml file is attached.
I do not understand the error message. However, what is not clear to me is the assignment which is mentioned there g1.uuidUser = g0.fkProfile 

Just for your awareness, uuidUser and fkProfile are different columns of different types that should not be compared in anyway. Maybe this is a hint what is going wrong. I would the relevant NavigationProperty expect to be

<NavigationProperty Name="fkProfileInProfile" Type="my_nutri_diary.Account" Nullable="false">
<ReferentialConstraint Property="fkProfile" ReferencedProperty="idProfile"/>

http://localhost:8080/odata4/vdb/my_nutri_diary/Profile(38)?$expand=fkProfileInProfile
http://localhost:8080/odata4/vdb/my_nutri_diary/Profile(38)/fkProfileInProfile

<error xmlns="http://docs.oasis-open.org/odata/ns/metadata">
<code>TEIID31172</code>
<message>
TEIID31172 Could not resolve expressions being compared to a common type excluding character conversions: g1.uuidUser = g0.fkProfile
</message>
</error>



--
This message was sent by Atlassian Jira
(v7.12.1#712002)