[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=13609485#comment-13609485 ] 

Pranav K edited comment on TEIID-5363 at 7/24/18 1:36 AM:
----------------------------------------------------------

While debugging the query that I catch at SimpleDBConnectionImpl.performSelect is -> select name from test-hyph, without the ` ` backticks, and hence the error I guess. If I modify the selectExpression during debugging to have the backticks and let the flow continue, it works fine and returns the query.


was (Author: pranavk):
While debugging the query that I catch at SimpleDBConnectionImpl.performSelect is -> select name from test-hyph, without the ` ` backticks. That's what you wanted to know right?

> 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)