[teiid-issues] [JBoss JIRA] (TEIID-3439) Add support for aliases with .

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-3439:
---------------------------------------

Looking at this again for 11.  For the tableau issue the workaround is have table names that do not contain . which can be achieved by importing without any qualification (meaning that multiple source schemas may need to be in muliple Teiid schemas).  

It looks like I can get this working in Teiid proper for table aliases, but there are quite a few bad side effects to reduce.  Due to our lax naming you could do:

select pm1.g1.e1 from tbl as "pm1.g1"

and it would be ambiguous with a direct reference to pm1.g1.

Adding support for column aliases with . is not possible at this point.

> Add support for aliases with .
> ------------------------------
>
>                 Key: TEIID-3439
>                 URL: https://issues.jboss.org/browse/TEIID-3439
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>            Reporter: Steven Hawkins
>             Fix For: 11.0
>
>
> We currently don't allow column or table aliases to contain '.'. This is allowable given a quoted identifier is used.  However an early design decision of metamatrix was to relax the rules of naming so that queries against the engine could use quoting (on not) similar to whatever was expected by a given database rather than the engine structure.  A lot of resolving and parsing logic will need to change unfortunately to fix this.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)