Return-Path: Delivered-To: apmail-db-jdo-dev-archive@www.apache.org Received: (qmail 70382 invoked from network); 2 Aug 2005 08:27:01 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 2 Aug 2005 08:27:01 -0000 Received: (qmail 10762 invoked by uid 500); 2 Aug 2005 08:27:01 -0000 Mailing-List: contact jdo-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: jdo-dev@db.apache.org Delivered-To: mailing list jdo-dev@db.apache.org Received: (qmail 10748 invoked by uid 99); 2 Aug 2005 08:27:01 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Aug 2005 01:27:01 -0700 X-ASF-Spam-Status: No, hits=0.9 required=10.0 tests=UPPERCASE_50_75 X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [81.174.133.99] (HELO roobarb.ajsoft.net) (81.174.133.99) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Aug 2005 01:26:51 -0700 Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by roobarb.ajsoft.net (Postfix) with ESMTP id 63AB211123 for ; Tue, 2 Aug 2005 09:26:52 +0100 (BST) From: Andy Jefferson To: jdo-dev@db.apache.org Subject: Patches for schema.sql : INTEGER -> CHAR(1) Date: Tue, 2 Aug 2005 09:26:50 +0100 User-Agent: KMail/1.7.2 Organization: JPOX MIME-Version: 1.0 Content-Type: Multipart/Mixed; boundary="Boundary-00=_K5y7CsjgBnh2Aee" Message-Id: <200508020926.50506.andy@jpox.org> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N --Boundary-00=_K5y7CsjgBnh2Aee Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Attached are patches for datastore and application identity schemas to fix issues with incorrect schemas for table ALLTYPES, and PCPOINTSINGLEFIELDCHAR. -- Andy --Boundary-00=_K5y7CsjgBnh2Aee Content-Type: text/x-diff; charset="iso-8859-1"; name="application_identity_schema.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="application_identity_schema.patch" Index: /home/andy/work/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql =================================================================== --- /home/andy/work/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql (revision 226966) +++ /home/andy/work/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql (working copy) @@ -81,7 +81,7 @@ ); CREATE TABLE PCPointSingleFieldChar ( - ID INTEGER NOT NULL, + ID CHAR(1) NOT NULL, X INTEGER NOT NULL, Y INTEGER, CONSTRAINT PCPNT_SFC_PK PRIMARY KEY (ID) @@ -859,7 +859,7 @@ ID INTEGER NOT NULL, PRIMITIVEBOOLEAN CHAR(1) CHECK (PRIMITIVEBOOLEAN IN ('Y','N')), PRIMITIVEBYTE SMALLINT, - PRIMITIVECHAR INTEGER, + PRIMITIVECHAR CHAR(1), PRIMITIVEDOUBLE DOUBLE, PRIMITIVEFLOAT FLOAT, PRIMITIVEINT INTEGER, @@ -867,7 +867,7 @@ PRIMITIVESHORT SMALLINT, BOOLEANVAL CHAR(1) CHECK (BOOLEANVAL IN ('Y','N')), BYTEVAL SMALLINT, - CHARACTERVAL INTEGER, + CHARACTERVAL CHAR(1), DOUBLEVAL DOUBLE, FLOATVAL FLOAT, INTEGERVAL INTEGER, --Boundary-00=_K5y7CsjgBnh2Aee Content-Type: text/x-diff; charset="iso-8859-1"; name="datastore_identity_schema.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="datastore_identity_schema.patch" Index: /home/andy/work/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql =================================================================== --- /home/andy/work/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql (revision 226966) +++ /home/andy/work/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql (working copy) @@ -809,7 +809,7 @@ ID INTEGER, PRIMITIVEBOOLEAN CHAR(1)CHECK (PRIMITIVEBOOLEAN IN ('Y','N')), PRIMITIVEBYTE SMALLINT, - PRIMITIVECHAR INTEGER, + PRIMITIVECHAR CHAR(1), PRIMITIVEDOUBLE DOUBLE, PRIMITIVEFLOAT FLOAT, PRIMITIVEINT INTEGER, @@ -817,7 +817,7 @@ PRIMITIVESHORT SMALLINT, BOOLEANVAL CHAR(1)CHECK (BOOLEANVAL IN ('Y','N')), BYTEVAL SMALLINT, - CHARACTERVAL INTEGER, + CHARACTERVAL CHAR(1), DOUBLEVAL DOUBLE, FLOATVAL FLOAT, INTEGERVAL INTEGER, --Boundary-00=_K5y7CsjgBnh2Aee--