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

Pranav K commented on TEIID-5363:
---------------------------------

I updated to 10.3.2 after which I could create the source model, deploy the VDB atop that. But I am getting that similar error when I try to run a 'select * from <tableNameContainingHyphen>' query on the VDB. I am using Teiid embedded here and querying using the TeiidDriver (not that that makes a difference in this case). Are you getting this too?
Stacktrace:

[CONNECTOR] Connector worker process failed for atomic-request=0KTrLms0orhj.0.1.0
org.teiid.translator.TranslatorException: The specified query expression syntax is not valid. (Service: AmazonSimpleDB; Status Code: 400; Error Code: InvalidQueryExpression; Request ID: a1cd638d-9563-746f-a51a-fbd1c6e244fd)
        at org.teiid.resource.adapter.simpledb.SimpleDBConnectionImpl.performSelect(SimpleDBConnectionImpl.java:151)
        at com.testapp.simpledb.SimpleDBMetadataConnection.performSelect(SimpleDBMetadataConnection.java:100)
        at org.teiid.translator.simpledb.SimpleDBQueryExecution.executeDirect(SimpleDBQueryExecution.java:77)
        at org.teiid.translator.simpledb.SimpleDBQueryExecution.execute(SimpleDBQueryExecution.java:69)
        at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:358)

Caused by: com.amazonaws.services.simpledb.model.InvalidQueryExpressionException: The specified query expression syntax is not valid. (Service: AmazonSimpleDB; Status Code: 400; Error Code: InvalidQueryExpression; Request ID: a1cd638d-9563-746f-a51a-fbd1c6e244fd)
        at com.amazonaws.http.AmazonHttpClient.handleErrorResponse(AmazonHttpClient.java:1305)
        at com.amazonaws.http.AmazonHttpClient.executeOneRequest(AmazonHttpClient.java:852)
        at com.amazonaws.http.AmazonHttpClient.executeHelper(AmazonHttpClient.java:630)
        at com.amazonaws.http.AmazonHttpClient.doExecute(AmazonHttpClient.java:405)
        at com.amazonaws.http.AmazonHttpClient.executeWithTimer(AmazonHttpClient.java:367)
        at com.amazonaws.http.AmazonHttpClient.execute(AmazonHttpClient.java:318)
        at com.amazonaws.services.simpledb.AmazonSimpleDBClient.doInvoke(AmazonSimpleDBClient.java:1039)
        at com.amazonaws.services.simpledb.AmazonSimpleDBClient.invoke(AmazonSimpleDBClient.java:1009)
        at com.amazonaws.services.simpledb.AmazonSimpleDBClient.select(AmazonSimpleDBClient.java:958)
        at org.teiid.resource.adapter.simpledb.SimpleDBConnectionImpl.performSelect(SimpleDBConnectionImpl.java:149)

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