[teiid-issues] [JBoss JIRA] (TEIID-5363) SimpleDB connector not quoting table names in internal Select queries

[Pranav K (JIRA)]

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

Pranav K edited comment on TEIID-5363 at 7/23/18 2:47 AM:
----------------------------------------------------------

You mean the query to the VDB? No, the exact query to the VDB is -> select * from "test_simple"."test-hyph".

The query to the VDB would be always be a standard SQL I assume, and the final translated query be of the form that you mention (here test-simple is the source model atop simple db). Running this query is when I get the error mentioned above. 
Running select `col` from `ta-ble` would anyway result in a Teiid query parsing error right?


was (Author: pranavk):
You mean the query to the VDB? No, the exact query to the VDB is -> select * from "test_simple"."test-hyph".

The query to the VDB would be always be a standard SQL I assume, and the final translated query be of the form that you mention (here test-simple is the source model atop simple db). Running this query is when I get the error mentioned above. 

> SimpleDB connector not quoting table names in internal Select queries
> ---------------------------------------------------------------------
>
>                 Key: TEIID-5363
>                 URL: https://issues.jboss.org/browse/TEIID-5363
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>            Reporter: Pranav K
>            Assignee: Steven Hawkins
>             Fix For: 11.0, 10.3.2
>
>
> Facing an issue while querying the Simple DB connector for a specific type of tables - the tables that contain a hyphen in the name.
> According to the SimpleDB documentation: 
> Attribute and domain names may appear without quotes if they contain only letters, numbers, underscores (_), or dollar symbols ($) and do not start with a number. You must quote all other attribute and domain names with the backtick (`).
> (https://docs.aws.amazon.com/AmazonSimpleDB/latest/DeveloperGuide/QuotingRulesSelect.html)



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