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