db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: create table parse error
Date Thu, 14 Aug 2008 15:09:28 GMT
Kathey Marsden wrote:
> Timothy J. Wisniewski wrote:
>> Hi,
>>
>> If I issue the command with ij
>>
>> create table testing (open int not null);
>>
>> I get the error
>>
>> ERROR 42X01: Syntax error: Encountered "open" at line 1, column 23.
>>
>>   
> open and close are documented as reserved words at :
> http://db.apache.org/derby/docs/10.4/ref/rrefkeywords29722.html
> So I think it's not a bug.
>
> Kathey
>
>
Just to confirm what Kathey says: Open is a reserved word according to 
the 2003 SQL Standard, part 2, section 5.2. I believe Derby's behavior 
is correct.

Regards,
-Rick

Mime
View raw message