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

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

Actually there is something else, the data is coming up as blank. Only the standard itemName field is coming populated in the output. 

A little further ahead in the query execution flow when SimpleDBQueryExecution.next() is called, it calls buildRow that further calls createAttributeMap; here the map does not contain quoted values (it does not unquote while checking) therefore the map lookup on line 113 [row.add(SimpleDBDataTypeManager.convertFromSimpleDBType(valueMap.get(columnName), expectedColumnTypes[i]))] fails, and hence no data is returned.

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