[teiid-issues] [JBoss JIRA] Updated: (TEIID-1005) Update reserved words
[
https://jira.jboss.org/jira/browse/TEIID-1005?page=com.atlassian.jira.plu...
]
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