Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: neutral (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=sbcglobal.net;
  h=Received:X-YMail-OSG:X-Yahoo-Newman-Property:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding;
  b=oIeLN5Vd4vV8ZnO9I7+mAVsY5S+z96IIXIoCpnX1InHR23dYwQE6Dg4TzR4dsh3p/T8BM2r8oSAy8Lt7D7A9Hvl/gHG1xY3XGLQCr7FoQrCbRb2jxRuR/DaVELOI7l8V6pl7PQbDJMMOrWCW3qJRYnLqyciHqDGgax/ZXWRAucw=
  ;
Message-ID: <47C5C773.4010808@sbcglobal.net>
Date: Wed, 27 Feb 2008 12:26:27 -0800
From: Mike Matrigali <mikem_app@sbcglobal.net>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
To: derby-dev@db.apache.org
Subject: Re: [jira] Commented: (DERBY-3330) provide support for unique
 constraint
 over nullable columns
References: <714104446.1204139751209.JavaMail.jira@brutus>
In-Reply-To: <714104446.1204139751209.JavaMail.jira@brutus>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

I thought from functional spec and ongoing discussion that behavior of 
unique constraint on non-nullable columns would be unchanged.  So this
constraint should still be backed by a unique index.

Anurag Shekhar (JIRA) wrote:
>     [ https://issues.apache.org/jira/browse/DERBY-3330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12573032#action_12573032 ] 
> 
> Anurag Shekhar commented on DERBY-3330:
> ---------------------------------------
> 
> dml019 test group by clause of unique constraint. When unique constraint 
> was backed by unique index, distinct scan  was used but after making it non 
> unique constraint this was not the case so the results are not ordered. 
> 
> I have checked the test suite from nist web site and it mandates only 
> number of rows and not their sequence. 
> 
>> provide support for unique constraint over nullable columns
>> -----------------------------------------------------------
>>
>>                 Key: DERBY-3330
>>                 URL: https://issues.apache.org/jira/browse/DERBY-3330
>>             Project: Derby
>>          Issue Type: New Feature
>>          Components: Store
>>    Affects Versions: 10.4.0.0
>>         Environment: all
>>            Reporter: Anurag Shekhar
>>            Assignee: Anurag Shekhar
>>         Attachments: BTreeController.diff, derby-3330-testcase.diff, derby-3330.diff, derby-3330v2.diff, derby-3330v3.diff, derby-3330v4.diff, derby-3330v5.diff, derby-3330v6.diff, derby-3330v7.diff, derby-3330v8.diff, derby-3330v9.diff, FunctionalSpec_DERBY-3330-V2.html, FunctionalSpec_DERBY-3330.html, UniqueConstraint_Implementation.html, UniqueConstraint_Implementation_V2.html, UniqueConstraint_Implementation_V3.html
>>
>>
>> Allow unique constraint over nullable field. Right now derby support unique constraint only over not null columns.
>