[
https://issues.jboss.org/browse/TEIID-2993?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2993:
---------------------------------------
we added auto-double-quoting to the names
Are you referring to quoting to the name in source?
BTW... querying this works fine
That seems wrong. You've likely included the quotes in the Teiid table name, which is
not what you want.
basically it falls back on NIS if name can't be found
No. We always prefer to use the NIS. Only if the NIS is not set do we attempt to use the
Teiid name as the source name.
Any ideas on how to clean this up?
It looks like there may already be several invalid assumptions afoot. So we'll need
some more discovery to determine what needs to be done.
Adding source table with quoted name results in wrong generated SQL
statement
-----------------------------------------------------------------------------
Key: TEIID-2993
URL:
https://issues.jboss.org/browse/TEIID-2993
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 6.0.0
Reporter: Paul Richardson
Assignee: Steven Hawkins
Cloned from TEIIDDES-2152:
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.
Confirmed that this does go right back to the Teiid parser. To confirm, the following
test was included in
src/test/java/org/teiid/query/parser/TestParser.java
{code}
@Test
public void testQuotedSQLString() {
String sql = "SELECT * FROM \"My.Quoted.Table\""; //$NON-NLS-1$
String expected = "SELECT * FROM \"MY.QUOTED.TABLE\"";
//$NON-NLS-1$
helpTest(sql, expected, null);
}
{code}
Test fails with a comparison error with the parser returning the SQL in item 3 above.
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)