Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6075C4947 for ; Tue, 31 May 2011 16:07:28 +0000 (UTC) Received: (qmail 11521 invoked by uid 500); 31 May 2011 16:07:28 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 11464 invoked by uid 500); 31 May 2011 16:07:28 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 11457 invoked by uid 99); 31 May 2011 16:07:28 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 May 2011 16:07:28 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [148.87.113.121] (HELO rcsinet10.oracle.com) (148.87.113.121) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 May 2011 16:07:18 +0000 Received: from acsinet21.oracle.com (acsinet21.oracle.com [141.146.126.237]) by rcsinet10.oracle.com (Switch-3.4.2/Switch-3.4.2) with ESMTP id p4VG6s9W018258 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Tue, 31 May 2011 16:06:56 GMT Received: from acsmt358.oracle.com (acsmt358.oracle.com [141.146.40.158]) by acsinet21.oracle.com (8.14.4+Sun/8.14.4) with ESMTP id p4VG6r6e024433 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Tue, 31 May 2011 16:06:53 GMT Received: from abhmt017.oracle.com (abhmt017.oracle.com [141.146.116.26]) by acsmt358.oracle.com (8.12.11.20060308/8.12.11) with ESMTP id p4VG6mmU007916 for ; Tue, 31 May 2011 11:06:48 -0500 Received: from richard-hillegas-computer.local (/10.159.7.120) by default (Oracle Beehive Gateway v4.0) with ESMTP ; Tue, 31 May 2011 09:06:47 -0700 Message-ID: <4DE5120B.5060108@oracle.com> Date: Tue, 31 May 2011 09:06:35 -0700 From: Rick Hillegas User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.2.13) Gecko/20101207 Thunderbird/3.1.7 MIME-Version: 1.0 To: derby-dev@db.apache.org Subject: Re: Question on a new reserved word maybe? References: <97EB699F861AD841B5908C7CA9C95656016090C6B7CA@VSERVER1.canoga.com> In-Reply-To: <97EB699F861AD841B5908C7CA9C95656016090C6B7CA@VSERVER1.canoga.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Source-IP: acsinet21.oracle.com [141.146.126.237] X-Auth-Type: Internal IP X-CT-RefId: str=0001.0A090208.4DE51220.00BE:SCFMA922111,ss=1,fgs=0 X-Virus-Checked: Checked by ClamAV on apache.org 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 >