[ https://issues.jboss.org/browse/TEIID-5589?page=com.atlassian.jira.plugin... ] Christoph John updated TEIID-5589: ---------------------------------- Description: 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 are shown below. My $metaddata.xml file is attached, and also a single record from the Account table in which the relevant comparison seems to happen. the uuidUser property you can find here. 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=fkPro... http://localhost:8080/odata4/vdb/my_nutri_diary/Profile(38)/fkProfileInPr... <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> was: 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 are shown below. My $metaddata.xml file is attached, and also a single record from the Account table in which the relevant comparison seems to be happen. the uuidUser property you can find here. 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=fkPro... http://localhost:8080/odata4/vdb/my_nutri_diary/Profile(38)/fkProfileInPr... <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)