Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: neutral (athena.apache.org: local policy)
From: "Bergquist, Brett" <BBergquist@canoga.com>
To: "derby-dev@db.apache.org" <derby-dev@db.apache.org>
Date: Tue, 31 May 2011 09:23:01 -0700
Subject: RE: Question on a new reserved word maybe?
Thread-Topic: Question on a new reserved word maybe?
Thread-Index: AcwfrVbIya2h46fUSoe+AMA91NzVxQAAXsTA
Message-ID: <97EB699F861AD841B5908C7CA9C95656016090C6B7F1@VSERVER1.canoga.com>
References: <97EB699F861AD841B5908C7CA9C95656016090C6B7CA@VSERVER1.canoga.com>
 <4DE5120B.5060108@oracle.com>
In-Reply-To: <4DE5120B.5060108@oracle.com>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

Thanks for getting back.  Unfortunately, I now have to go and change anothe=
r software package that is hard to build to work around this.  But better t=
han 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]=20
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=20
> DDL statement that used to work in Derby 10.5.3.1 no longer works and=20
> complains about a syntax error . Here is the statement:
>
> create table JIDataType ( id bigint not null, type smallint, maxLength=20
> integer, decimals integer, regularExpr varchar(255), minValue=20
> varchar(255) for bit data, maxValue varchar(255) for bit data,=20
> 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=20
> that in the documentation.
>
> Thanks for any help.
>
> Brett
>