[ http://issues.apache.org/jira/browse/DERBY-923?page=comments#action_12365332 ]
Satheesh Bandaram commented on DERBY-923: ----------------------------------------- My SQL spec copy (SQL 2003) lists more of these as not reserved words... I find 21 of the above listed words as not reserved... like GO, ASSERTION, COLLATION. Many databases treat SQL reserved words as non-reserved, causing porting issues to Derby. Derby has been converting some of these reserved words to non-reserved words as the need arises. It is good to develop a clear direction. My SQL spec (SQL 2003) lists 288 reserved words, Derby currently has 206. Only 151 are common between Derby and SQL spec. Derby has 55 reserved words that are not considered reserved by SQL spec. > Remove stale reserved words from Derby. I found many reserved words not > really used in Derby. > --------------------------------------------------------------------------------------------- > > Key: DERBY-923 > URL: http://issues.apache.org/jira/browse/DERBY-923 > Project: Derby > Type: Sub-task > Components: SQL > Environment: Generic > Reporter: Satheesh Bandaram > Priority: Minor > > There may be use for some of these in the future, but from first look all > these don't seem to be used. Any ideas on what should be done? > Removing these from Derby parser would also speed up query parsing time. > ALLOCATE > ARE > ASSERTION > CASCADED > COLLATE > COLLATION > CONNECT > CORRESPONDING > DISCONNECT > DEALLOCATE > DEFERRABLE > DEFERRED > DESCRIBE > DIAGNOSTICS > END-EXEC > EXCEPTION > FIRST > FOUND > FULL > GO > GOTO > IMMEDIATE > INDICATOR > INITIALLY > INSENSITIVE > MATCH > NATURAL > OPTION > OVERLAPS > PAD > PARTIAL > PREPARE > PRIOR > RELATIVE > SCROLL > SPACE > SQLCODE > SQLERROR > SQLSTATE > SYSTEM_USER > TIMEZONE_HOUR > TIMEZONE_MINUTE > TRANSLATE > TRANSLATION > WHENEVER > WRITE -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
