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

[Steve Hawkins (JIRA)]

     [ https://jira.jboss.org/browse/TEIID-1005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Hawkins resolved TEIID-1005.
----------------------------------

    Resolution: Done


All sql 2003 reserved words are now reserved words for Teiid.

> Update reserved words
> ---------------------
>
>                 Key: TEIID-1005
>                 URL: https://jira.jboss.org/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/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira