[
https://issues.jboss.org/browse/TEIIDDES-2152?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-2152:
----------------------------------------
Basic naming rules which include '.' delimeter (Teiid runtime)
* column and schema names can NOT included the '.' delimiter
* Table names can include '.' delimiters, but more than one '.' is
discouraged and not expected.
Adding source table with quoted name results in wrong generated SQL
statement
-----------------------------------------------------------------------------
Key: TEIIDDES-2152
URL:
https://issues.jboss.org/browse/TEIIDDES-2152
Project: Teiid Designer
Issue Type: Bug
Components: Transformations
Affects Versions: 8.5
Reporter: Barry LaFond
Assignee: Paul Richardson
Fix For: 8.5
1) Created source model with simple table named "My.Quoted.Table" (including
quotes
2) Created simple virtual table and pasted: SELECT * FROM "My.Quoted.Table"
3) Parser returned a command resulting in the SQL: SELECT * FROM
My.Quoted."Table"
Parser should be able to handle quoted names properly. In this case the SQL should have
been valid as is.
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)