db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-923) Remove stale reserved words from Derby. I found many reserved words not really used in Derby.
Date Tue, 07 Feb 2006 10:10:04 GMT
    [ http://issues.apache.org/jira/browse/DERBY-923?page=comments#action_12365416 ] 

Bernt M. Johnsen commented on DERBY-923:
----------------------------------------

You're right. I used the 99-spec (and missed that INSENSITIVE, OVERLAPS and TRANSLATE were
non-reserved). I made a map of these key words which is attached. I suggest:
1) The unused words that are no longer keywords should be removed (SQLCODE and SQLERROR).
2) The unused words that have become non-reserved in the 2003 spec should be removed
3) The unused reserved words should be carefully investigated before they are removed to ensure
we don't craee problems in the forseeable future by removing them.
4) If the number of reserved words is a performance problem in the parser, we should investigate
that. In a proper lexer/parser it should not be a problem.

> 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
>  Attachments: stale-reserved-words.ods
>
> 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


Mime
View raw message