[ http://issues.apache.org/jira/browse/DERBY-923?page=comments#action_12365253 ]
Bernt M. Johnsen commented on DERBY-923: ---------------------------------------- Out of these words, all are (according to SQL 2003) reserved words with the exception of SQLERROR. The standard says that a regular identifier cannot be equal to a reserved word. (Regular identifiers ar case insensitive and not quoted). I think it would be unwise to remove them (and thus allow them as regular identifiers). They're not "stale", the are just not (yet) used by Derby. > 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
