db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bergquist, Brett" <BBergqu...@canoga.com>
Subject RE: Question on a new reserved word maybe?
Date Tue, 31 May 2011 16:23:01 GMT
Thanks for getting back.  Unfortunately, I now have to go and change another software package
that is hard to build to work around this.  But better than have it deployed to the field
and then find it ;)

The new automatic indexing feature is so important, there is no going back!

Brett

-----Original Message-----
From: Rick Hillegas [mailto:rick.hillegas@oracle.com] 
Sent: Tuesday, May 31, 2011 12:07 PM
To: derby-dev@db.apache.org
Subject: Re: Question on a new reserved word maybe?

I have logged DERBY-5254 to track this issue.

Thanks again for finding it,
-Rick

On 5/31/11 8:15 AM, Bergquist, Brett wrote:
>
> We had been using Derby 10.5.3.1 and just upgrade to 10.8.2.1 and a 
> DDL statement that used to work in Derby 10.5.3.1 no longer works and 
> complains about a syntax error . Here is the statement:
>
> create table JIDataType ( id bigint not null, type smallint, maxLength 
> integer, decimals integer, regularExpr varchar(255), minValue 
> varchar(255) for bit data, maxValue varchar(255) for bit data, 
> strictMin smallint, strictMax smallint, primary key (id) )
>
> and here is the error:
>
> Error: Syntax error: Encountered "minValue" at line 1, column 125.
>
> SQLState: 42X01
>
> ErrorCode: -1
>
> So did "minValue" become a reserved word? I cannot find anything like 
> that in the documentation.
>
> Thanks for any help.
>
> Brett
>




Mime
View raw message