From derby-dev-return-2398-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Thu Mar 03 21:07:50 2005 Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 91165 invoked from network); 3 Mar 2005 21:07:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 3 Mar 2005 21:07:50 -0000 Received: (qmail 5749 invoked by uid 500); 3 Mar 2005 21:07:50 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 5515 invoked by uid 500); 3 Mar 2005 21:07:49 -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: "Derby Development" Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 5502 invoked by uid 99); 3 Mar 2005 21:07:49 -0000 X-ASF-Spam-Status: No, hits=0.1 required=10.0 tests=FORGED_RCVD_HELO X-Spam-Check-By: apache.org Received-SPF: neutral (hermes.apache.org: local policy) Received: from adsl-209-233-18-245.dsl.snfc21.pacbell.net (HELO buttons.boynes.com) (209.233.18.245) by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 03 Mar 2005 13:07:48 -0800 Received: from [192.168.37.168] (unknown [192.168.37.168]) by buttons.boynes.com (Postfix) with ESMTP id 5729111C4D for ; Thu, 3 Mar 2005 13:07:45 -0800 (PST) Message-ID: <42277C96.2040805@apache.org> Date: Thu, 03 Mar 2005 13:07:34 -0800 From: Jeremy Boynes User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Development Subject: Re: DB2 mode vs. Cloudscape mode References: <20050303203321.GA16736@atum01.norway.sun.com> <42277A5B.9090406@Sourcery.Org> In-Reply-To: <42277A5B.9090406@Sourcery.Org> X-Enigmail-Version: 0.86.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Satheesh Bandaram wrote: > Yes, you are right... The references to "DB2 mode" is from the past, leftover > comments. There is no distinction between the two. > Did Cloudscape support UNIQUE on possibly null columns? If so, is this a restriction that we can easily remove or is there something deep in the index code that would make this problematic? Also, can anyone think of an issue with making the NOT NULL implicit in a PRIMARY KEY specification (per spec but unlike DB2)? -- Jeremy