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:[email protected]] Sent: Tuesday, May 31, 2011 12:07 PM To: [email protected] 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 >
