From derby-dev-return-88105-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Wed Jun 1 15:59:11 2011 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 8A7446658 for ; Wed, 1 Jun 2011 15:59:11 +0000 (UTC) Received: (qmail 23395 invoked by uid 500); 1 Jun 2011 15:59:11 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 23370 invoked by uid 500); 1 Jun 2011 15:59:11 -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 23363 invoked by uid 99); 1 Jun 2011 15:59:11 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Jun 2011 15:59:11 +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; Wed, 01 Jun 2011 15:59:00 +0000 Received: from acsinet22.oracle.com (acsinet22.oracle.com [141.146.126.238]) by rcsinet10.oracle.com (Switch-3.4.2/Switch-3.4.2) with ESMTP id p51Fwbpe007088 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Wed, 1 Jun 2011 15:58:39 GMT Received: from acsmt357.oracle.com (acsmt357.oracle.com [141.146.40.157]) by acsinet22.oracle.com (8.14.4+Sun/8.14.4) with ESMTP id p51Fwbin002595 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Wed, 1 Jun 2011 15:58:37 GMT Received: from abhmt012.oracle.com (abhmt012.oracle.com [141.146.116.21]) by acsmt357.oracle.com (8.12.11.20060308/8.12.11) with ESMTP id p51FwWga014332 for ; Wed, 1 Jun 2011 10:58:32 -0500 Received: from richard-hillegas-computer.local (/10.159.5.63) by default (Oracle Beehive Gateway v4.0) with ESMTP ; Wed, 01 Jun 2011 08:58:30 -0700 Message-ID: <4DE66199.7010300@oracle.com> Date: Wed, 01 Jun 2011 08:58:17 -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> <4DE5120B.5060108@oracle.com> <97EB699F861AD841B5908C7CA9C95656016090C6B7F2@VSERVER1.canoga.com> <4DE525C6.3070500@oracle.com> <97EB699F861AD841B5908C7CA9C95656016090C6B837@VSERVER1.canoga.com> <4DE63AA7.1030604@oracle.com> <97EB699F861AD841B5908C7CA9C95656016090C6B8F8@VSERVER1.canoga.com> In-Reply-To: <97EB699F861AD841B5908C7CA9C95656016090C6B8F8@VSERVER1.canoga.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Source-IP: acsinet22.oracle.com [141.146.126.238] X-Auth-Type: Internal IP X-CT-RefId: str=0001.0A090204.4DE661AF.0127:SCFMA922111,ss=1,fgs=0 X-Virus-Checked: Checked by ClamAV on apache.org On 6/1/11 6:32 AM, Bergquist, Brett wrote: > Thanks Rick. I will try to build using the instructions given. This will give me good experience to build Derby and maybe contribute something over the next few months. Let us know if you have suggestions for how to improve the build. First impressions are very useful here. > I am looking into the replication area and have a few ideas for some improvements that I could use. Good to hear! Thanks, -Rick > -----Original Message----- > From: Rick Hillegas [mailto:rick.hillegas@oracle.com] > Sent: Wednesday, June 01, 2011 9:12 AM > To: derby-dev@db.apache.org > Subject: Re: Question on a new reserved word maybe? > > Hi Brett, > > This bug is fixed now in all branches back through 10.6. If you build > the head of the 10.8 branch, you should be able to test-drive the fix. > > Regards, > -Rick > > On 5/31/11 10:32 AM, Bergquist, Brett wrote: >> Thanks. >> >> -----Original Message----- >> From: Rick Hillegas [mailto:rick.hillegas@oracle.com] >> Sent: Tuesday, May 31, 2011 1:31 PM >> To: derby-dev@db.apache.org >> Subject: Re: Question on a new reserved word maybe? >> >> Hi Brett, >> >> I will port the fix to the 10.8 branch. Then you just need to build the >> product jars according to the instructions here: >> http://db.apache.org/derby/dev/derby_source.html#How+to+build+Derby The >> real core of the process is documented here: >> http://svn.apache.org/viewvc/db/derby/code/trunk/BUILDING.html?view=co >> >> Hope this helps, >> -Rick >> >> On 5/31/11 9:25 AM, Bergquist, Brett wrote: >>> 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 >>>> >>> >> >> > > >