[teiid-issues] [JBoss JIRA] Commented: (TEIID-1005) Update reserved words

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-1005:
---------------------------------------

On second thought, it doesn't seem necessary to rename the sys tables.  Any qualified reference (as would be stored in a vdb) would still work fine.

> Update reserved words
> ---------------------
>
>                 Key: TEIID-1005
>                 URL: https://jira.jboss.org/jira/browse/TEIID-1005
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 7.0
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 7.0
>
>
> Our reserved word haven't changed significantly in 2 major release.  As we implement features (or even look ahead to SQL/MED, etc.) having the keywords already reserved will prevent user problems down the road.
> The proposal is to add tinyint, the SQL 2003, SQL/MED, and SQL/XML reserved word sets.
> Initial changes should include adding SQL type alias to byte->tinyint, short->smallint, long->bigint, bigdecimal->decimal, string->varchar and to allow call along with exec and execute to call a stored procedure.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira