[ https://jira.jboss.org/jira/browse/TEIID-1005?page=com.atlassian.jira.plu... ] Steven Hawkins updated TEIID-1005: ---------------------------------- Environment: (was: 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.) Description: 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

[ https://jira.jboss.org/jira/browse/TEIID-1005?page=com.atlassian.jira.plu... ] 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. -- 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

[ https://jira.jboss.org/browse/TEIID-1005?page=com.atlassian.jira.plugin.s... ] Steve Hawkins resolved TEIID-1005. ---------------------------------- Resolution: Done All sql 2003 reserved words are now reserved words for Teiid. -- 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