[teiid-issues] [JBoss JIRA] (TEIID-3553) Odata - if table name is ambiguous, teiid returns result from first table

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy commented on TEIID-3553:
-------------------------------------

Yes, the ambiguity only exists in V2, because in V2, the $metadata can define multiple "schema" objects, and entity containers and only one of them can be set as default. When the schema name is not available it can be run against the default one.  But in Teiid's implementation we have no default entity container is set, so it required that user uses the fully qualified name to access the entities.

In V4, there is only one schema and entity container for $metadata, but you can define references to other $metadata schemas in $metadata and use them with their fully qualified name in defining the relationships etc.

I would categorize this as invalid usage.

> Odata - if table name is ambiguous, teiid returns result from first table
> -------------------------------------------------------------------------
>
>                 Key: TEIID-3553
>                 URL: https://issues.jboss.org/browse/TEIID-3553
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: OData
>    Affects Versions: 8.7.1.6_2
>            Reporter: Juraj Duráni
>            Assignee: Steven Hawkins
>
> If table name is ambiguous, teiid returns data from first matching table. I expect, that it should return error message similar to exception which is thrown via JDBC.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)