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
