[
https://issues.jboss.org/browse/TEIIDDES-2152?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-2152:
----------------------------------------
We've relaxed the name validation in Designer to allow '.' delimiter, so the
need to d-quote these names has gone away.
However, if a user does d-quote a name with '.' delimiter, there are issues with
the v8.Teiid8ParserTokenManager, v8.Teiid8Parser classes.
1) Creating a table with name "aaa.bbb" and add as source table, the generated
SQL == SELECT * FROM MyModel."""aaa"."bbb"""
- Should generate SELECT * FROM MyModel."aaa.bbb"
2) Creating a table with name "aaa.bbb.ccc" and add as source table, the
generated SQL == SELECT * FROM
MyModel."""aaa".bbb."ccc"""
- Should generate SELECT * FROM MyModel."aaa.bbb.ccc"
3) Creating a table with name "aaa.bbb.ccc.ddd" and add as source table, the
generated SQL == SELECT * FROM
MyModel."""aaa".bbb.ccc."ddd"""
- Should generate SELECT * FROM MyModel."aaa.bbb.ccc.ddd"
The parser/resolver framework should not add all of the extra d-quotes
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
Security Level: Public(Everyone can see)
Components: Transformations
Affects Versions: 8.5
Reporter: Barry LaFond
Assignee: Paul Richardson
Fix For: 8.3.4, 8.6, 8.5.1
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.6#6264)