From derby-dev-return-88049-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Tue May 31 15:15:42 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 47B464E16 for ; Tue, 31 May 2011 15:15:42 +0000 (UTC) Received: (qmail 3933 invoked by uid 500); 31 May 2011 15:15:42 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 3915 invoked by uid 500); 31 May 2011 15:15:42 -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 3906 invoked by uid 99); 31 May 2011 15:15:42 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 May 2011 15:15:42 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [213.199.154.142] (HELO DB3EHSOBE004.bigfish.com) (213.199.154.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 May 2011 15:15:34 +0000 Received: from mail58-db3-R.bigfish.com (10.3.81.240) by DB3EHSOBE004.bigfish.com (10.3.84.24) with Microsoft SMTP Server id 14.1.225.22; Tue, 31 May 2011 15:15:11 +0000 Received: from mail58-db3 (localhost.localdomain [127.0.0.1]) by mail58-db3-R.bigfish.com (Postfix) with ESMTP id D4451401B1 for ; Tue, 31 May 2011 15:15:11 +0000 (UTC) X-SpamScore: 0 X-BigFish: VPS0(zzzz1202hzz8275bh8275dhz2dh2a8h668h839h65h) X-Spam-TCS-SCL: 4:0 X-Forefront-Antispam-Report: CIP:74.62.37.82;KIP:(null);UIP:(null);IPVD:NLI;H:CPHUB1.canoga.com;RD:rrcs-74-62-37-82.west.biz.rr.com;EFVD:NLI Received: from mail58-db3 (localhost.localdomain [127.0.0.1]) by mail58-db3 (MessageSwitch) id 1306854911322381_15610; Tue, 31 May 2011 15:15:11 +0000 (UTC) Received: from DB3EHSMHS006.bigfish.com (unknown [10.3.81.248]) by mail58-db3.bigfish.com (Postfix) with ESMTP id 49BFA1B5804B for ; Tue, 31 May 2011 15:15:11 +0000 (UTC) Received: from CPHUB1.canoga.com (74.62.37.82) by DB3EHSMHS006.bigfish.com (10.3.87.106) with Microsoft SMTP Server (TLS) id 14.1.225.22; Tue, 31 May 2011 15:15:08 +0000 Received: from vserver1.canoga.com ([169.254.2.6]) by CPHUB1.canoga.com ([172.16.1.93]) with mapi; Tue, 31 May 2011 08:18:35 -0700 From: "Bergquist, Brett" To: "derby-dev@db.apache.org" Date: Tue, 31 May 2011 08:15:08 -0700 Subject: Question on a new reserved word maybe? Thread-Topic: Question on a new reserved word maybe? Thread-Index: AcwfpYdBQ+mqb7VFR7e8C2lG2px45w== Message-ID: <97EB699F861AD841B5908C7CA9C95656016090C6B7CA@VSERVER1.canoga.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US x-tm-as-product-ver: SMEX-8.0.0.1307-6.500.1024-18170.005 x-tm-as-result: No-2.558500-0.000000-31 x-tm-as-user-approved-sender: Yes x-tm-as-user-blocked-sender: No Content-Type: multipart/alternative; boundary="_000_97EB699F861AD841B5908C7CA9C95656016090C6B7CAVSERVER1can_" MIME-Version: 1.0 X-OriginatorOrg: canoga.com --_000_97EB699F861AD841B5908C7CA9C95656016090C6B7CAVSERVER1can_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable We had been using Derby 10.5.3.1 and just upgrade to 10.8.2.1 and a DDL sta= tement that used to work in Derby 10.5.3.1 no longer works and complains ab= out a syntax error . Here is the statement: create table JIDataType ( id bigint not null, type smallint, maxLength inte= ger, 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 --_000_97EB699F861AD841B5908C7CA9C95656016090C6B7CAVSERVER1can_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

We had been usin= g 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 err= or .  Here is the statement:

&= nbsp;

create table JIDataType ( id bigint not= null, type smallint, maxLength integer, decimals integer, regularExpr varc= har(255), minValue varchar(255) for bit data, maxValue varchar(255) for bit= data, strictMin smallint, strictMax smallint, primary key (id) )

 

and her= e is the error:

 

Error: Syntax error: Encountered "minValue" at = line 1, column 125.

SQLState:  42X0= 1

ErrorCode: -1

 

So did “minVal= ue” become a reserved word?  I cannot find anything like that in= the documentation.

 

Thanks for any help.

 

Brett

= --_000_97EB699F861AD841B5908C7CA9C95656016090C6B7CAVSERVER1can_--