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

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-1005:
----------------------------------

       Affects: [Documentation (Ref Guide, User Guide, etc.), Release Notes]
    Complexity: High


Also the connector SQLReservedWords and engine ReservedWords classes should be merged.  

The input variable group should also be changed to inputs (which is consistent with the plural variables group name).  For the 7.0 release input will still be supported but its use will be deprecated.

The system schema should be changed to a non-reserved word such as sys.  We should also rename tables that conflict with names from the 6.x system vdb including:

virtualdatabases
datatypes
keys
procedures
procedureparams
referencekeycolumns 

> 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