You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by Rick Hillegas <Ri...@Sun.COM> on 2007/12/05 22:40:28 UTC

reserved keywords

55 of Derby's reserved keywords are not reserved keywords in the ANSI 
2003 standard. These include keywords like "key" and "collation", which 
are non-reserved keywords in ANSI 2003. Keeping these as reserved 
keywords creates migration problems when people try to port their 
applications from other databases to Derby. Is there any reason that 
these 55 reserved keywords should not be moved to the non-reserved 
keyword list?

Thanks,
-Rick

Re: reserved keywords

Posted by Thomas Nielsen <Th...@Sun.COM>.

Rick Hillegas wrote:
> 55 of Derby's reserved keywords are not reserved keywords in the ANSI 
> 2003 standard. These include keywords like "key" and "collation", 
> which are non-reserved keywords in ANSI 2003. Keeping these as 
> reserved keywords creates migration problems when people try to port 
> their applications from other databases to Derby. Is there any reason 
> that these 55 reserved keywords should not be moved to the 
> non-reserved keyword list?
You *may* end up with some look-ahead problems in the SQL parser if 
reserved keywords are moved to non-reserved keywords... Depends on 
wether moved keywords are used in any lookahead or not.

Thomas