db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Satheesh Bandaram (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 Mon, 06 Feb 2006 19:48:58 GMT
    [ 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


Mime
View raw message