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:25:25 GMT
What would the procedure be to apply the change necessary and build my own build of derby 10.8.2.1
with this fix?  It may not be possible to change the product that relies on this keyword (an
old version of Jasper Server).

-----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