[teiid-issues] [JBoss JIRA] Resolved: (TEIID-46) Fully-qualified names should not be required when referencing virtual procedures that have unique unqualified names

Tue Nov 24 14:59:37 EST 2009

     [ https://jira.jboss.org/jira/browse/TEIID-46?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-46.
---------------------------------

    Resolution: Done

This was fixed for Teiid in the CompositeMetadataStore, which will work for user level queries.  Similar logic would need to be added to the designer's TransformationMetadata to allow partial name resolving at design time.

> Fully-qualified names should not be required when referencing virtual procedures that have unique unqualified names
> -------------------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-46
>                 URL: https://jira.jboss.org/jira/browse/TEIID-46
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.0
>            Reporter: Michael Walker
>            Assignee: Steven Hawkins
>            Priority: Minor
>             Fix For: 7.0
>
>
> This problem occurs in our transformation editor, and also occurs with real-time queries (e.g. from QueryBuilder/SQLExplorer, or any client).
> If you reference a non-qualified table name, e.g. "myTable", in a query, we'll attempt to resolve it if it is a unique name.
> Strangely, we don't do the same thing for virtual procedures, even if they are unique. Instead, you must use the fully-qualified name. There should be no disparity. This is a usability defect.
> This also happens to greatly extend the size of virtual procedure code, making it harder to read and debug.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira