[teiid-issues] [JBoss JIRA] (TEIID-3439) Add support for aliases with .
[
https://issues.jboss.org/browse/TEIID-3439?page=com.atlassian.jira.plugin...
]
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)