[teiid-issues] [JBoss JIRA] (TEIID-3358) Issues with entity set names

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13046632#comment-13046632 ] 

Steven Hawkins commented on TEIID-3358:
---------------------------------------

Updated the sql generation logic to use fully qualified names.  I'm not sure what to do about the link formation.  For example:

<link rel="self" title="Customers" href="Customers"/><entry><id>http://localhost:8081/odata/northwind/Customers('12')</id>

But we'd like to see the qualified Customer:

http://localhost:8081/odata/northwind/nw.Customers('12')



> Issues with entity set names
> ----------------------------
>
>                 Key: TEIID-3358
>                 URL: https://issues.jboss.org/browse/TEIID-3358
>             Project: Teiid
>          Issue Type: Bug
>          Components: OData
>    Affects Versions: 8.7
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.11
>
>
> The entity set name used for sql generation should be the fully qualified name.  If there is for example two table with the same names in schemas visible to odata, but one of the tables does not have a key, then an ambiguous name exception will be thrown if an odata url is used with only the base table name.
> It also appears that the URI link in the results metadata uses the non-qualified table name, which will have issues in the scenario above.
> We may also need to document or add an additional check for ambiguity as the OData4j findEdmEntitySet logic will return the first matching entity, which is generally against our approach to resolving.



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)