[teiid-issues] [JBoss JIRA] (TEIID-2012) Errors in Column Name Validation

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy commented on TEIID-2012:
-------------------------------------

"value" is reserved word. For all the reserved words see [http://anonsvn.jboss.org/repos/teiid/trunk/api/src/main/java/org/teiid/language/SQLConstants.java]

For table names and column names only restriction is it can not contain period (.) in them. If the table/column name contains any reserved words or special characters then it MUST be enclosed in the quotes ("), then it will be allowed in the parser. Teiid will not add these quotes, as it will not know which is reserved word vs name, the client needs to add them.
                
> Errors in Column Name Validation 
> ---------------------------------
>
>                 Key: TEIID-2012
>                 URL: https://issues.jboss.org/browse/TEIID-2012
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 7.7
>            Reporter: Ted Jones
>            Assignee: Steven Hawkins
>             Fix For: 7.7.1
>
>
> When generating columns names in Designer with ":" in them, a parse error is thrown in the transformation. Also, using the keyword "value" in a transformation for a column name errors until "" are added to it. The "" should be added by the Teiid validator. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira